<?xml version="1.0"?>
<AlteryxDocument yxmdVer="2022.3">
  <Nodes>
    <Node ToolID="57">
      <GuiSettings Plugin="AlteryxGuiToolkit.TextBox.TextBox">
        <Position x="42" y="90" width="396" height="72" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <Text>Since the Gross Revenue dataset were separated according to years (2019-2022) we import and combine it by using wildcards (*Gross Revenue.xlsx) in Input Data tool. Next, we clean the data by removing records with null value and removing leading and trailing whitespace. We also summarize the clean data by movie by using summarize tool.</Text>
          <Font name="Arial" size="8.25" style="0" />
          <TextColor name="Black" />
          <FillColor r="255" g="128" b="128" />
          <Shape shape="0" />
          <Justification Justification="1" />
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText />
          <Left value="False" />
        </Annotation>
      </Properties>
    </Node>
    <Node ToolID="58">
      <GuiSettings Plugin="AlteryxGuiToolkit.TextBox.TextBox">
        <Position x="42" y="6" width="1440" height="40" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <Text><![CDATA[PROJECT 1
]]></Text>
          <Font name="Showcard Gothic" size="14.25" style="0" />
          <TextColor name="Black" />
          <FillColor r="255" g="128" b="192" />
          <Shape shape="0" />
          <Justification Justification="1" />
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText />
          <Left value="False" />
        </Annotation>
      </Properties>
    </Node>
    <Node ToolID="59">
      <GuiSettings Plugin="AlteryxGuiToolkit.TextBox.TextBox">
        <Position x="618" y="90" width="384" height="60" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <Text>Count the amount of  movie repeated in the dataset using summarize tool. Next, count the movie which are more than 1 using filter tool  and save it into excel file using output data tool.</Text>
          <Font name="Arial" size="8.25" style="0" />
          <TextColor name="Black" />
          <FillColor r="255" g="128" b="128" />
          <Shape shape="0" />
          <Justification Justification="1" />
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText />
          <Left value="False" />
        </Annotation>
      </Properties>
    </Node>
    <Node ToolID="60">
      <GuiSettings Plugin="AlteryxGuiToolkit.TextBox.TextBox">
        <Position x="450" y="570" width="348" height="60" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <Text><![CDATA[Add Distributor dataset using Input Data tool and replace the distributor name in GR dataset (Distributor field) with distributor name in Distributor dataset (Index field) using Find Replace tool. The name should follow Distributor dataset. ]]></Text>
          <Font name="Arial" size="8.25" style="0" />
          <TextColor name="Black" />
          <FillColor r="255" g="128" b="128" />
          <Shape shape="0" />
          <Justification Justification="1" />
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText />
          <Left value="False" />
        </Annotation>
      </Properties>
    </Node>
    <Node ToolID="61">
      <GuiSettings Plugin="AlteryxGuiToolkit.TextBox.TextBox">
        <Position x="42" y="54" width="1440" height="24" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <Text><![CDATA[MADINA SURAYA BINTI ZHARIN (A20EC0203), ADRINA ASYIQIN ]]></Text>
          <Font name="Times New Roman" size="14.25" style="0" />
          <TextColor name="Black" />
          <FillColor r="255" g="255" b="128" />
          <Shape shape="0" />
          <Justification Justification="1" />
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText />
          <Left value="False" />
        </Annotation>
      </Properties>
    </Node>
    <Node ToolID="19">
      <GuiSettings Plugin="AlteryxGuiToolkit.ToolContainer.ToolContainer">
        <Position x="617" y="161" width="389" height="180" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <Caption><![CDATA[Question b ]]></Caption>
          <Style TextColor="#314c4a" FillColor="#ecf2f2" BorderColor="#314c4a" Transparency="25" Margin="25" />
          <Disabled value="True" />
          <Folded value="False" />
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText />
          <Left value="False" />
        </Annotation>
      </Properties>
      <ChildNodes>
        <Node ToolID="11">
          <GuiSettings Plugin="AlteryxSpatialPluginsGui.Summarize.Summarize">
            <Position x="642" y="221" />
          </GuiSettings>
          <Properties>
            <Configuration>
              <SummarizeFields>
                <SummarizeField field="Movie" action="GroupBy" rename="Movie" />
                <SummarizeField field="Movie" action="Count" rename="Count_Movie" />
              </SummarizeFields>
            </Configuration>
            <Annotation DisplayMode="0">
              <Name />
              <AnnotationText><![CDATA[Count Movie by Movie
]]></AnnotationText>
              <DefaultAnnotationText />
              <Left value="False" />
            </Annotation>
          </Properties>
          <EngineSettings EngineDll="AlteryxSpatialPluginsEngine.dll" EngineDllEntryPoint="AlteryxSummarize" />
        </Node>
        <Node ToolID="12">
          <GuiSettings Plugin="AlteryxBasePluginsGui.Filter.Filter">
            <Position x="750" y="222" />
          </GuiSettings>
          <Properties>
            <Configuration>
              <Mode>Simple</Mode>
              <Simple>
                <Operator>&gt;</Operator>
                <Field>Count_Movie</Field>
                <Operands>
                  <IgnoreTimeInDateTime>True</IgnoreTimeInDateTime>
                  <DateType>fixed</DateType>
                  <PeriodDate>2023-01-01 22:22:44</PeriodDate>
                  <PeriodType>
                  </PeriodType>
                  <PeriodCount>0</PeriodCount>
                  <Operand>1</Operand>
                  <StartDate>2023-01-01 22:22:44</StartDate>
                  <EndDate>2023-01-01 22:22:44</EndDate>
                </Operands>
              </Simple>
            </Configuration>
            <Annotation DisplayMode="0">
              <Name />
              <DefaultAnnotationText>[Count_Movie] &gt; 1</DefaultAnnotationText>
              <Left value="False" />
            </Annotation>
          </Properties>
          <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxFilter" />
        </Node>
        <Node ToolID="13">
          <GuiSettings Plugin="AlteryxBasePluginsGui.DbFileOutput.DbFileOutput">
            <Position x="894" y="210" />
          </GuiSettings>
          <Properties>
            <Configuration>
              <File MaxRecords="" FileFormat="25">C:\Users\USER\OneDrive - Universiti Teknologi Malaysia (UTM)\Degree in DATA ENGINEERING\Semester 5\SECP3213 - 01 Business Intelligence\Project\Duplicate Movie.xlsx|||Sheet1</File>
              <Passwords />
              <Disable>False</Disable>
              <FormatSpecificOptions>
                <PreserveFormat>False</PreserveFormat>
                <SkipFieldNames>False</SkipFieldNames>
                <OutputOption>RemoveFile</OutputOption>
              </FormatSpecificOptions>
              <MultiFile value="False" />
            </Configuration>
            <Annotation DisplayMode="0">
              <Name />
              <DefaultAnnotationText>Duplicate Movie.xlsx
Query=Sheet1</DefaultAnnotationText>
              <Left value="False" />
            </Annotation>
          </Properties>
          <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxDbFileOutput" />
        </Node>
      </ChildNodes>
    </Node>
    <Node ToolID="48">
      <GuiSettings Plugin="AlteryxGuiToolkit.ToolContainer.ToolContainer">
        <Position x="41" y="437" width="259" height="285" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <Caption>Question f</Caption>
          <Style TextColor="#314c4a" FillColor="#ecf2f2" BorderColor="#314c4a" Transparency="25" Margin="25" />
          <Disabled value="False" />
          <Folded value="False" />
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText />
          <Left value="False" />
        </Annotation>
      </Properties>
      <ChildNodes>
        <Node ToolID="44">
          <GuiSettings Plugin="AlteryxSpatialPluginsGui.Summarize.Summarize">
            <Position x="66" y="606" />
          </GuiSettings>
          <Properties>
            <Configuration>
              <SummarizeFields>
                <SummarizeField field="Tickets Sold" action="Avg" rename="Avg_Tickets Sold" />
              </SummarizeFields>
            </Configuration>
            <Annotation DisplayMode="0">
              <Name />
              <AnnotationText><![CDATA[Average Ticket Solds
]]></AnnotationText>
              <DefaultAnnotationText />
              <Left value="False" />
            </Annotation>
          </Properties>
          <EngineSettings EngineDll="AlteryxSpatialPluginsEngine.dll" EngineDllEntryPoint="AlteryxSummarize" />
        </Node>
        <Node ToolID="46">
          <GuiSettings Plugin="AlteryxBasePluginsGui.Filter.Filter">
            <Position x="66" y="498" />
          </GuiSettings>
          <Properties>
            <Configuration>
              <Mode>Simple</Mode>
              <Simple>
                <Operator>&gt;</Operator>
                <Field>Tickets Sold</Field>
                <Operands>
                  <IgnoreTimeInDateTime>True</IgnoreTimeInDateTime>
                  <DateType>fixed</DateType>
                  <PeriodDate>2023-01-02 00:28:47</PeriodDate>
                  <PeriodType>
                  </PeriodType>
                  <PeriodCount>0</PeriodCount>
                  <Operand>1304062.78301302</Operand>
                  <StartDate>2023-01-02 00:28:47</StartDate>
                  <EndDate>2023-01-02 00:28:47</EndDate>
                </Operands>
              </Simple>
            </Configuration>
            <Annotation DisplayMode="0">
              <Name />
              <DefaultAnnotationText>[Tickets Sold] &gt; 1304062.78301302</DefaultAnnotationText>
              <Left value="False" />
            </Annotation>
          </Properties>
          <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxFilter" />
        </Node>
        <Node ToolID="47">
          <GuiSettings Plugin="AlteryxBasePluginsGui.DbFileOutput.DbFileOutput">
            <Position x="174" y="486" />
          </GuiSettings>
          <Properties>
            <Configuration>
              <File MaxRecords="" FileFormat="0">C:\Users\USER\OneDrive - Universiti Teknologi Malaysia (UTM)\Degree in DATA ENGINEERING\Semester 5\SECP3213 - 01 Business Intelligence\Project\Ticket more than Avg Sold.csv</File>
              <Passwords />
              <Disable>False</Disable>
              <FormatSpecificOptions>
                <LineEndStyle>CRLF</LineEndStyle>
                <Delimeter>,</Delimeter>
                <ForceQuotes>False</ForceQuotes>
                <HeaderRow>True</HeaderRow>
                <CodePage>28591</CodePage>
                <WriteBOM>True</WriteBOM>
              </FormatSpecificOptions>
              <MultiFile value="False" />
            </Configuration>
            <Annotation DisplayMode="0">
              <Name />
              <DefaultAnnotationText>Ticket more than Avg Sold.csv</DefaultAnnotationText>
              <Left value="False" />
            </Annotation>
          </Properties>
          <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxDbFileOutput" />
        </Node>
      </ChildNodes>
    </Node>
    <Node ToolID="56">
      <GuiSettings Plugin="AlteryxGuiToolkit.ToolContainer.ToolContainer">
        <Position x="41" y="173" width="397" height="240" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <Caption>Question a</Caption>
          <Style TextColor="#314c4a" FillColor="#ecf2f2" BorderColor="#314c4a" Transparency="25" Margin="25" />
          <Disabled value="False" />
          <Folded value="False" />
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText />
          <Left value="False" />
        </Annotation>
      </Properties>
      <ChildNodes>
        <Node ToolID="2">
          <GuiSettings Plugin="AlteryxBasePluginsGui.DbFileInput.DbFileInput">
            <Position x="66" y="282" />
          </GuiSettings>
          <Properties>
            <Configuration>
              <Passwords />
              <File OutputFileName="" RecordLimit="" SearchSubDirs="False" FileFormat="25">C:\Users\USER\OneDrive - Universiti Teknologi Malaysia (UTM)\Degree in DATA ENGINEERING\Semester 5\SECP3213 - 01 Business Intelligence\Project\*Gross Revenue.xlsx|||`Sheet1$`</File>
              <FormatSpecificOptions>
                <FirstRowData>False</FirstRowData>
                <ImportLine>1</ImportLine>
              </FormatSpecificOptions>
            </Configuration>
            <Annotation DisplayMode="0">
              <Name />
              <DefaultAnnotationText>*Gross Revenue.xlsx
Query=`Sheet1$`</DefaultAnnotationText>
              <Left value="False" />
            </Annotation>
            <MetaInfo connection="Output">
              <RecordInfo>
                <Field name="Rank" source="File: C:\Users\USER\OneDrive - Universiti Teknologi Malaysia (UTM)\Degree in DATA ENGINEERING\Semester 5\SECP3213 - 01 Business Intelligence\Project\2019 Gross Revenue.xlsx|||`Sheet1$`" type="Double" />
                <Field name="Movie" size="255" source="File: C:\Users\USER\OneDrive - Universiti Teknologi Malaysia (UTM)\Degree in DATA ENGINEERING\Semester 5\SECP3213 - 01 Business Intelligence\Project\2019 Gross Revenue.xlsx|||`Sheet1$`" type="V_WString" />
                <Field name="Release Date" source="File: C:\Users\USER\OneDrive - Universiti Teknologi Malaysia (UTM)\Degree in DATA ENGINEERING\Semester 5\SECP3213 - 01 Business Intelligence\Project\2019 Gross Revenue.xlsx|||`Sheet1$`" type="Date" />
                <Field name="Distributor" size="255" source="File: C:\Users\USER\OneDrive - Universiti Teknologi Malaysia (UTM)\Degree in DATA ENGINEERING\Semester 5\SECP3213 - 01 Business Intelligence\Project\2019 Gross Revenue.xlsx|||`Sheet1$`" type="V_WString" />
                <Field name="Genre" size="255" source="File: C:\Users\USER\OneDrive - Universiti Teknologi Malaysia (UTM)\Degree in DATA ENGINEERING\Semester 5\SECP3213 - 01 Business Intelligence\Project\2019 Gross Revenue.xlsx|||`Sheet1$`" type="V_String" />
                <Field name="Gross Revenue" source="File: C:\Users\USER\OneDrive - Universiti Teknologi Malaysia (UTM)\Degree in DATA ENGINEERING\Semester 5\SECP3213 - 01 Business Intelligence\Project\2019 Gross Revenue.xlsx|||`Sheet1$`" type="Double" />
                <Field name="Tickets Sold" source="File: C:\Users\USER\OneDrive - Universiti Teknologi Malaysia (UTM)\Degree in DATA ENGINEERING\Semester 5\SECP3213 - 01 Business Intelligence\Project\2019 Gross Revenue.xlsx|||`Sheet1$`" type="Double" />
              </RecordInfo>
            </MetaInfo>
          </Properties>
          <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxDbFileInput" />
        </Node>
        <Node ToolID="9">
          <GuiSettings>
            <Position x="198" y="282" />
          </GuiSettings>
          <Properties>
            <Configuration>
              <Value name="Check Box (135)">True</Value>
              <Value name="Check Box (136)">False</Value>
              <Value name="List Box (11)">"Rank","Movie","Release Date","Distributor","Genre","Gross Revenue","Tickets Sold"</Value>
              <Value name="Check Box (84)">False</Value>
              <Value name="Check Box (117)">False</Value>
              <Value name="Check Box (15)">True</Value>
              <Value name="Check Box (109)">False</Value>
              <Value name="Check Box (122)">False</Value>
              <Value name="Check Box (53)">False</Value>
              <Value name="Check Box (58)">False</Value>
              <Value name="Check Box (70)">False</Value>
              <Value name="Check Box (77)">False</Value>
              <Value name="Drop Down (81)">title</Value>
            </Configuration>
            <Annotation DisplayMode="0">
              <Name />
              <AnnotationText>Data Cleansing</AnnotationText>
              <DefaultAnnotationText />
              <Left value="False" />
            </Annotation>
          </Properties>
          <EngineSettings Macro="Cleanse.yxmc" />
        </Node>
        <Node ToolID="55">
          <GuiSettings Plugin="AlteryxSpatialPluginsGui.Summarize.Summarize">
            <Position x="342" y="222" />
          </GuiSettings>
          <Properties>
            <Configuration>
              <SummarizeFields>
                <SummarizeField field="Movie" action="GroupBy" rename="Movie" />
                <SummarizeField field="Gross Revenue" action="Sum" rename="Sum Gross Revenue by Movie" />
              </SummarizeFields>
            </Configuration>
            <Annotation DisplayMode="0">
              <Name />
              <AnnotationText>Revenue by Movie</AnnotationText>
              <DefaultAnnotationText />
              <Left value="False" />
            </Annotation>
          </Properties>
          <EngineSettings EngineDll="AlteryxSpatialPluginsEngine.dll" EngineDllEntryPoint="AlteryxSummarize" />
        </Node>
      </ChildNodes>
    </Node>
    <Node ToolID="54">
      <GuiSettings Plugin="AlteryxGuiToolkit.ToolContainer.ToolContainer">
        <Position x="497" y="653" width="385" height="276" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <Caption>Question g</Caption>
          <Style TextColor="#314c4a" FillColor="#ecf2f2" BorderColor="#314c4a" Transparency="25" Margin="25" />
          <Disabled value="False" />
          <Folded value="False" />
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText />
          <Left value="False" />
        </Annotation>
      </Properties>
      <ChildNodes>
        <Node ToolID="49">
          <GuiSettings Plugin="AlteryxBasePluginsGui.DateTime.DateTime">
            <Position x="522" y="798" />
          </GuiSettings>
          <Properties>
            <Configuration>
              <IsFrom value="True" />
              <InputFieldName>Release Date</InputFieldName>
              <Language>English</Language>
              <Format>MM</Format>
              <OutputFieldName>Release Month</OutputFieldName>
            </Configuration>
            <Annotation DisplayMode="0">
              <Name />
              <AnnotationText>Convert Release Date To:
Custom (Month)</AnnotationText>
              <DefaultAnnotationText>Convert Release Date To:
Custom</DefaultAnnotationText>
              <Left value="False" />
            </Annotation>
          </Properties>
          <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxDateTime" />
        </Node>
        <Node ToolID="50">
          <GuiSettings Plugin="AlteryxSpatialPluginsGui.Summarize.Summarize">
            <Position x="654" y="798" />
          </GuiSettings>
          <Properties>
            <Configuration>
              <SummarizeFields>
                <SummarizeField field="Release Month" action="GroupBy" rename="Release Month" />
                <SummarizeField field="Gross Revenue" action="Sum" rename="Sum Gross Revenue by Month" />
              </SummarizeFields>
            </Configuration>
            <Annotation DisplayMode="0">
              <Name />
              <AnnotationText>Summarize by Month</AnnotationText>
              <DefaultAnnotationText />
              <Left value="False" />
            </Annotation>
          </Properties>
          <EngineSettings EngineDll="AlteryxSpatialPluginsEngine.dll" EngineDllEntryPoint="AlteryxSummarize" />
        </Node>
        <Node ToolID="51">
          <GuiSettings Plugin="AlteryxSpatialPluginsGui.Summarize.Summarize">
            <Position x="642" y="702" />
          </GuiSettings>
          <Properties>
            <Configuration>
              <SummarizeFields>
                <SummarizeField field="Release Year" action="GroupBy" rename="Release Year" />
                <SummarizeField field="Gross Revenue" action="Sum" rename="Sum Gross Revenue by Year" />
              </SummarizeFields>
            </Configuration>
            <Annotation DisplayMode="0">
              <Name />
              <AnnotationText>Summarize by Year</AnnotationText>
              <DefaultAnnotationText />
              <Left value="False" />
            </Annotation>
          </Properties>
          <EngineSettings EngineDll="AlteryxSpatialPluginsEngine.dll" EngineDllEntryPoint="AlteryxSummarize" />
        </Node>
        <Node ToolID="52">
          <GuiSettings Plugin="AlteryxBasePluginsGui.DbFileOutput.DbFileOutput">
            <Position x="786" y="798" />
          </GuiSettings>
          <Properties>
            <Configuration>
              <File MaxRecords="" FileFormat="0">C:\Users\USER\OneDrive - Universiti Teknologi Malaysia (UTM)\Degree in DATA ENGINEERING\Semester 5\SECP3213 - 01 Business Intelligence\Project\Revenue by Month.csv</File>
              <Passwords />
              <Disable>False</Disable>
              <FormatSpecificOptions>
                <LineEndStyle>CRLF</LineEndStyle>
                <Delimeter>,</Delimeter>
                <ForceQuotes>False</ForceQuotes>
                <HeaderRow>True</HeaderRow>
                <CodePage>28591</CodePage>
                <WriteBOM>True</WriteBOM>
              </FormatSpecificOptions>
              <MultiFile value="False" />
            </Configuration>
            <Annotation DisplayMode="0">
              <Name />
              <DefaultAnnotationText>Revenue by Month.csv</DefaultAnnotationText>
              <Left value="False" />
            </Annotation>
          </Properties>
          <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxDbFileOutput" />
        </Node>
        <Node ToolID="53">
          <GuiSettings Plugin="AlteryxBasePluginsGui.DbFileOutput.DbFileOutput">
            <Position x="774" y="702" />
          </GuiSettings>
          <Properties>
            <Configuration>
              <File MaxRecords="" FileFormat="0">C:\Users\USER\OneDrive - Universiti Teknologi Malaysia (UTM)\Degree in DATA ENGINEERING\Semester 5\SECP3213 - 01 Business Intelligence\Project\Revenue by Year.csv</File>
              <Passwords />
              <Disable>False</Disable>
              <FormatSpecificOptions>
                <LineEndStyle>CRLF</LineEndStyle>
                <Delimeter>,</Delimeter>
                <ForceQuotes>False</ForceQuotes>
                <HeaderRow>True</HeaderRow>
                <CodePage>28591</CodePage>
                <WriteBOM>True</WriteBOM>
              </FormatSpecificOptions>
              <MultiFile value="False" />
            </Configuration>
            <Annotation DisplayMode="0">
              <Name />
              <DefaultAnnotationText>Revenue by Year.csv</DefaultAnnotationText>
              <Left value="False" />
            </Annotation>
          </Properties>
          <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxDbFileOutput" />
        </Node>
        <Node ToolID="21">
          <GuiSettings Plugin="AlteryxBasePluginsGui.DateTime.DateTime">
            <Position x="522" y="702" />
          </GuiSettings>
          <Properties>
            <Configuration>
              <IsFrom value="True" />
              <InputFieldName>Release Date</InputFieldName>
              <Language>English</Language>
              <Format />
              <OutputFieldName>Release Year</OutputFieldName>
            </Configuration>
            <Annotation DisplayMode="0">
              <Name />
              <AnnotationText>Convert Release Date To:
Custom (Year)</AnnotationText>
              <DefaultAnnotationText>Convert Release Date To:
Custom</DefaultAnnotationText>
              <Left value="False" />
            </Annotation>
          </Properties>
          <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxDateTime" />
        </Node>
      </ChildNodes>
    </Node>
    <Node ToolID="36">
      <GuiSettings Plugin="AlteryxGuiToolkit.ToolContainer.ToolContainer">
        <Position x="1061" y="389" width="415" height="249" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <Caption>Question e(i)</Caption>
          <Style TextColor="#314c4a" FillColor="#ecf2f2" BorderColor="#314c4a" Transparency="25" Margin="25" />
          <Disabled value="False" />
          <Folded value="False" />
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText />
          <Left value="False" />
        </Annotation>
      </Properties>
      <ChildNodes>
        <Node ToolID="32">
          <GuiSettings Plugin="AlteryxSpatialPluginsGui.Summarize.Summarize">
            <Position x="1086" y="522" />
          </GuiSettings>
          <Properties>
            <Configuration>
              <SummarizeFields>
                <SummarizeField field="Gross Revenue" action="Sum" rename="Total Gross Revenue" />
              </SummarizeFields>
            </Configuration>
            <Annotation DisplayMode="0">
              <Name />
              <AnnotationText>Total Sum Gross Revenue</AnnotationText>
              <DefaultAnnotationText />
              <Left value="False" />
            </Annotation>
          </Properties>
          <EngineSettings EngineDll="AlteryxSpatialPluginsEngine.dll" EngineDllEntryPoint="AlteryxSummarize" />
        </Node>
        <Node ToolID="34">
          <GuiSettings Plugin="AlteryxBasePluginsGui.Formula.Formula">
            <Position x="1158" y="438" />
          </GuiSettings>
          <Properties>
            <Configuration>
              <FormulaFields>
                <FormulaField expression="Round(([Total Gross Revenue by Distributor]/19276385308)*100, 0.001)" field="Percentage Total Gross Revenue by Distributor (%)" size="8" type="Double" />
              </FormulaFields>
            </Configuration>
            <Annotation DisplayMode="0">
              <Name />
              <DefaultAnnotationText>Percentage Total Gross Revenue by Distributor (%) = Round(([Total Gross Revenue ...</DefaultAnnotationText>
              <Left value="False" />
            </Annotation>
          </Properties>
          <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxFormula" />
        </Node>
        <Node ToolID="35">
          <GuiSettings Plugin="AlteryxBasePluginsGui.DbFileOutput.DbFileOutput">
            <Position x="1350" y="438" />
          </GuiSettings>
          <Properties>
            <Configuration>
              <File MaxRecords="" FileFormat="25">C:\Users\USER\OneDrive - Universiti Teknologi Malaysia (UTM)\Degree in DATA ENGINEERING\Semester 5\SECP3213 - 01 Business Intelligence\Project\Distributor Gross Revenue.xlsx|||Sheet1</File>
              <Passwords />
              <Disable>False</Disable>
              <FormatSpecificOptions>
                <PreserveFormat>False</PreserveFormat>
                <SkipFieldNames>False</SkipFieldNames>
                <OutputOption>RemoveFile</OutputOption>
              </FormatSpecificOptions>
              <MultiFile value="False" />
            </Configuration>
            <Annotation DisplayMode="0">
              <Name />
              <DefaultAnnotationText>Distributor Gross Revenue.xlsx
Query=Sheet1</DefaultAnnotationText>
              <Left value="False" />
            </Annotation>
          </Properties>
          <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxDbFileOutput" />
        </Node>
      </ChildNodes>
    </Node>
    <Node ToolID="41">
      <GuiSettings Plugin="AlteryxGuiToolkit.ToolContainer.ToolContainer">
        <Position x="1265" y="665" width="541" height="195" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <Caption>Question e(ii)</Caption>
          <Style TextColor="#314c4a" FillColor="#ecf2f2" BorderColor="#314c4a" Transparency="25" Margin="25" />
          <Disabled value="False" />
          <Folded value="False" />
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText />
          <Left value="False" />
        </Annotation>
      </Properties>
      <ChildNodes>
        <Node ToolID="37">
          <GuiSettings Plugin="AlteryxBasePluginsGui.Sample.Sample">
            <Position x="1434" y="714" />
          </GuiSettings>
          <Properties>
            <Configuration>
              <Mode>First</Mode>
              <N>20</N>
              <GroupFields orderChanged="False" />
            </Configuration>
            <Annotation DisplayMode="0">
              <Name />
              <DefaultAnnotationText>First 20 rows</DefaultAnnotationText>
              <Left value="False" />
            </Annotation>
          </Properties>
          <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxSample" />
        </Node>
        <Node ToolID="38">
          <GuiSettings Plugin="AlteryxBasePluginsGui.Sort.Sort">
            <Position x="1290" y="714" />
          </GuiSettings>
          <Properties>
            <Configuration>
              <SortInfo locale="1033">
                <Field field="Percentage Total Gross Revenue by Distributor (%)" order="Descending" />
              </SortInfo>
            </Configuration>
            <Annotation DisplayMode="0">
              <Name />
              <DefaultAnnotationText>Percentage Total Gross Revenue by Distributor (%) - Descending</DefaultAnnotationText>
              <Left value="False" />
            </Annotation>
          </Properties>
          <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxSort" />
        </Node>
        <Node ToolID="39">
          <GuiSettings Plugin="PortfolioPluginsGui.ComposerTable.PortfolioComposerTable">
            <Position x="1590" y="714" />
          </GuiSettings>
          <Properties>
            <Configuration>
              <TableMode>Basic</TableMode>
              <GroupingFields orderChanged="False" />
              <Width>100%</Width>
              <ShowHeader value="True" />
              <ShowBarGraph value="False" />
              <TableFields orderChanged="False">
                <Field name="Distributor" selected="True" Alignment="Left" />
                <Field name="Total Gross Revenue by Distributor" selected="True" Alignment="Right" />
                <Field name="Percentage Total Gross Revenue by Distributor (%)" selected="True" Alignment="Right" />
                <Field name="*Unknown" selected="True" Alignment="Right" />
              </TableFields>
              <TableStyles>
                <Style Name="Data" Font="Arial" Size="8" TextColor="#000000" BackColor="#ffffff" AltColor="#f0f0f0" RowGroup="1" />
                <Style Name="Header" Font="Arial" Size="10" TextColor="#000000" BackColor="#dbdbdb" />
                <Style Name="Borders" Width="1" DataColor="#000000" HeaderColor="#000000" RowBorder="None" BasicColBorder="Default (Use Per Column Setting)" />
                <Style Name="Table" CellPadding="0" ColumnPadding="0" TableBorder="true" Width="1" BorderColor="#000000" />
              </TableStyles>
              <StyleRules />
            </Configuration>
            <Annotation DisplayMode="0">
              <Name />
              <DefaultAnnotationText>Basic Table</DefaultAnnotationText>
              <Left value="False" />
            </Annotation>
          </Properties>
          <EngineSettings EngineDll="PortfolioPluginsEngine.dll" EngineDllEntryPoint="AlteryxPortfolioComposerTablePlugin" />
        </Node>
        <Node ToolID="40">
          <GuiSettings Plugin="PortfolioPluginsGui.ComposerRender.PortfolioComposerRender">
            <Position x="1722" y="714" />
          </GuiSettings>
          <Properties>
            <Configuration>
              <TempFileType />
              <OutputFile>C:\Users\USER\OneDrive - Universiti Teknologi Malaysia (UTM)\Degree in DATA ENGINEERING\Semester 5\SECP3213 - 01 Business Intelligence\Project\Top 20 Distributor Gross Revenue.pdf</OutputFile>
              <BatchMode value="False" />
              <DataField>Table</DataField>
              <Separator>Continuous</Separator>
              <EmbedDependencies value="False" />
              <ShowHeader value="False" />
              <ShowFooter value="False" />
              <PortraitMode value="False" />
              <PaperType Width="595" Height="841" Left="36" Right="36" Top="36" Bottom="36" />
              <DefaultStyles>
                <Style Name="TextStyle" FontName="Arial" FontSize="14" Justify="Left" ForeColor="#000000" Locale="1033" />
              </DefaultStyles>
              <PNGResolution>1</PNGResolution>
              <PNGLargerAction>squeeze</PNGLargerAction>
              <PNGLargerThanPageChoice>warning</PNGLargerThanPageChoice>
              <PNGTransparentBG value="False" />
              <PNGBackColor value="#ffffff" />
            </Configuration>
            <Annotation DisplayMode="0">
              <Name />
              <DefaultAnnotationText />
              <Left value="False" />
            </Annotation>
            <Dependencies>
              <Implicit />
            </Dependencies>
          </Properties>
          <EngineSettings EngineDll="PortfolioPluginsEngine.dll" EngineDllEntryPoint="AlteryxPortfolioComposerRenderPlugin" />
        </Node>
      </ChildNodes>
    </Node>
    <Node ToolID="20">
      <GuiSettings Plugin="AlteryxGuiToolkit.ToolContainer.ToolContainer">
        <Position x="857" y="389" width="155" height="165" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <Caption><![CDATA[Question d ]]></Caption>
          <Style TextColor="#314c4a" FillColor="#ecf2f2" BorderColor="#314c4a" Transparency="25" Margin="25" />
          <Disabled value="False" />
          <Folded value="False" />
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText />
          <Left value="False" />
        </Annotation>
      </Properties>
      <ChildNodes>
        <Node ToolID="18">
          <GuiSettings Plugin="AlteryxSpatialPluginsGui.Summarize.Summarize">
            <Position x="882" y="438" />
          </GuiSettings>
          <Properties>
            <Configuration>
              <SummarizeFields>
                <SummarizeField field="Distributor" action="GroupBy" rename="Distributor" />
                <SummarizeField field="Gross Revenue" action="Sum" rename="Total Gross Revenue by Distributor" />
              </SummarizeFields>
            </Configuration>
            <Annotation DisplayMode="0">
              <Name />
              <AnnotationText><![CDATA[Gross Revenue by Distributor
]]></AnnotationText>
              <DefaultAnnotationText />
              <Left value="False" />
            </Annotation>
          </Properties>
          <EngineSettings EngineDll="AlteryxSpatialPluginsEngine.dll" EngineDllEntryPoint="AlteryxSummarize" />
        </Node>
      </ChildNodes>
    </Node>
    <Node ToolID="17">
      <GuiSettings Plugin="AlteryxGuiToolkit.ToolContainer.ToolContainer">
        <Position x="449" y="389" width="343" height="177" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <Caption><![CDATA[Question c ]]></Caption>
          <Style TextColor="#314c4a" FillColor="#ecf2f2" BorderColor="#314c4a" Transparency="25" Margin="25" />
          <Disabled value="False" />
          <Folded value="False" />
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText />
          <Left value="False" />
        </Annotation>
      </Properties>
      <ChildNodes>
        <Node ToolID="15">
          <GuiSettings Plugin="AlteryxBasePluginsGui.DbFileInput.DbFileInput">
            <Position x="474" y="450" />
          </GuiSettings>
          <Properties>
            <Configuration>
              <Passwords />
              <File OutputFileName="" RecordLimit="" SearchSubDirs="False" FileFormat="25">C:\Users\USER\OneDrive - Universiti Teknologi Malaysia (UTM)\Degree in DATA ENGINEERING\Semester 5\SECP3213 - 01 Business Intelligence\Project\Distributor.xlsx|||`Sheet1$`</File>
              <FormatSpecificOptions>
                <FirstRowData>False</FirstRowData>
                <ImportLine>1</ImportLine>
              </FormatSpecificOptions>
            </Configuration>
            <Annotation DisplayMode="0">
              <Name />
              <DefaultAnnotationText>Distributor.xlsx
Query=`Sheet1$`</DefaultAnnotationText>
              <Left value="False" />
            </Annotation>
            <MetaInfo connection="Output">
              <RecordInfo>
                <Field name="Index" size="255" source="File: C:\Users\USER\OneDrive - Universiti Teknologi Malaysia (UTM)\Degree in DATA ENGINEERING\Semester 5\SECP3213 - 01 Business Intelligence\Project\Distributor.xlsx|||`Sheet1$`" type="V_WString" />
                <Field name="Total Movies" source="File: C:\Users\USER\OneDrive - Universiti Teknologi Malaysia (UTM)\Degree in DATA ENGINEERING\Semester 5\SECP3213 - 01 Business Intelligence\Project\Distributor.xlsx|||`Sheet1$`" type="Double" />
                <Field name="Average Production Budget" source="File: C:\Users\USER\OneDrive - Universiti Teknologi Malaysia (UTM)\Degree in DATA ENGINEERING\Semester 5\SECP3213 - 01 Business Intelligence\Project\Distributor.xlsx|||`Sheet1$`" type="Double" />
                <Field name="Combined Worldwide Box Office" source="File: C:\Users\USER\OneDrive - Universiti Teknologi Malaysia (UTM)\Degree in DATA ENGINEERING\Semester 5\SECP3213 - 01 Business Intelligence\Project\Distributor.xlsx|||`Sheet1$`" type="Double" />
                <Field name="No. 1 Movie" size="255" source="File: C:\Users\USER\OneDrive - Universiti Teknologi Malaysia (UTM)\Degree in DATA ENGINEERING\Semester 5\SECP3213 - 01 Business Intelligence\Project\Distributor.xlsx|||`Sheet1$`" type="V_WString" />
              </RecordInfo>
            </MetaInfo>
          </Properties>
          <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxDbFileInput" />
        </Node>
        <Node ToolID="16">
          <GuiSettings Plugin="AlteryxBasePluginsGui.FindReplace.FindReplace">
            <Position x="690" y="438" />
          </GuiSettings>
          <Properties>
            <Configuration>
              <FieldFind>Distributor</FieldFind>
              <FieldSearch>Index</FieldSearch>
              <ReplaceFoundField>Index</ReplaceFoundField>
              <FindMode>FindAny</FindMode>
              <NoCase value="False" />
              <MatchWholeWord value="False" />
              <ReplaceMode>Replace</ReplaceMode>
              <ReplaceMultipleFound value="True" />
              <ReplaceAppendFields />
            </Configuration>
            <Annotation DisplayMode="0">
              <Name />
              <AnnotationText>Find Replace</AnnotationText>
              <DefaultAnnotationText />
              <Left value="False" />
            </Annotation>
          </Properties>
          <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxFindReplace" />
        </Node>
      </ChildNodes>
    </Node>
  </Nodes>
  <Connections>
    <Connection>
      <Origin ToolID="11" Connection="Output" />
      <Destination ToolID="12" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="12" Connection="True" />
      <Destination ToolID="13" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="46" Connection="True" />
      <Destination ToolID="47" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="2" Connection="Output" />
      <Destination ToolID="9" Connection="Input2" />
    </Connection>
    <Connection>
      <Origin ToolID="9" Connection="Output26" />
      <Destination ToolID="11" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="9" Connection="Output26" />
      <Destination ToolID="16" Connection="Targets" />
    </Connection>
    <Connection>
      <Origin ToolID="15" Connection="Output" />
      <Destination ToolID="16" Connection="Source" />
    </Connection>
    <Connection>
      <Origin ToolID="9" Connection="Output26" />
      <Destination ToolID="21" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="9" Connection="Output26" />
      <Destination ToolID="44" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="9" Connection="Output26" />
      <Destination ToolID="46" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="9" Connection="Output26" />
      <Destination ToolID="49" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="9" Connection="Output26" />
      <Destination ToolID="55" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="49" Connection="Output" />
      <Destination ToolID="50" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="50" Connection="Output" />
      <Destination ToolID="52" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="51" Connection="Output" />
      <Destination ToolID="53" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="21" Connection="Output" />
      <Destination ToolID="51" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="34" Connection="Output" />
      <Destination ToolID="35" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="34" Connection="Output" />
      <Destination ToolID="38" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="37" Connection="Output" />
      <Destination ToolID="39" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="38" Connection="Output" />
      <Destination ToolID="37" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="39" Connection="Output" />
      <Destination ToolID="40" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="18" Connection="Output" />
      <Destination ToolID="34" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="16" Connection="Output" />
      <Destination ToolID="18" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="16" Connection="Output" />
      <Destination ToolID="32" Connection="Input" />
    </Connection>
  </Connections>
  <Properties>
    <Memory default="True" />
    <GlobalRecordLimit value="0" />
    <TempFiles default="True" />
    <Annotation on="True" includeToolName="False" />
    <ConvErrorLimit value="10" />
    <ConvErrorLimit_Stop value="False" />
    <CancelOnError value="False" />
    <DisableBrowse value="False" />
    <EnablePerformanceProfiling value="False" />
    <RunWithE2 value="True" />
    <PredictiveToolsCodePage value="1252" />
    <DisableAllOutput value="False" />
    <ShowAllMacroMessages value="False" />
    <ShowConnectionStatusIsOn value="True" />
    <ShowConnectionStatusOnlyWhenRunning value="True" />
    <ZoomLevel value="0" />
    <LayoutType>Horizontal</LayoutType>
    <MetaInfo>
      <NameIsFileName value="True" />
      <Name>Project 1</Name>
      <Description />
      <RootToolName />
      <ToolVersion />
      <ToolInDb value="False" />
      <CategoryName />
      <SearchTags />
      <Author />
      <Company />
      <Copyright />
      <DescriptionLink actual="" displayed="" />
      <Example>
        <Description />
        <File />
      </Example>
      <WorkflowId value="676d8ad1-17ec-477a-8102-7786966b6ecb" />
      <Telemetry>
        <PreviousWorkflowId value="d4a05c9c-d434-4c9c-9cb9-677e758060dc" />
        <OriginWorkflowId value="fe884f75-9606-491a-9629-3715401b9ee2" />
      </Telemetry>
    </MetaInfo>
    <Events>
      <Enabled value="True" />
    </Events>
  </Properties>
</AlteryxDocument>