Learning Path 1: Exercise 1: General

[Shaikmunnisa]

An input data tool contains 100 records,each representing unique customers transaction information.The customer ID and customer  segment provide basic information about the customer.The transactions that customer has made over the past year.

In this exercise drop the columns "weekly sales"and store volume.Then find the 5 customers with the highest average transactions in the "south" region.the results window should match the final state input data tool.

[Shaikmunnisa]

<?xml version="1.0"?>
<AlteryxDocument yxmdVer="2020.1">
<Nodes>
<Node ToolID="9">
<GuiSettings Plugin="AlteryxGuiToolkit.TextBox.TextBox">
<Position x="54" y="318" width="84" height="96" />
</GuiSettings>
<Properties>
<Configuration>
<Text>Initial State</Text>
<Font name="Arial" size="8.25" style="0" />
<TextColor name="Black" />
<FillColor name="White" />
<Shape shape="0" />
<Justification Justification="4" />
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText />
<Left value="False" />
</Annotation>
</Properties>
</Node>
<Node ToolID="1">
<GuiSettings Plugin="AlteryxBasePluginsGui.DbFileInput.DbFileInput">
<Position x="66" y="342" />
</GuiSettings>
<Properties>
<Configuration>
<Passwords />
<File OutputFileName="" FileFormat="19" SearchSubDirs="False" RecordLimit="">Start 1.yxdb</File>
<FormatSpecificOptions />
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText>Start 1.yxdb</DefaultAnnotationText>
<Left value="False" />
</Annotation>
<MetaInfo connection="Output">
<RecordInfo>
<Field name="Customer_ID" size="255" source="File: " type="V_String" />
<Field name="Store_Number" size="255" source="File: " type="V_String" />
<Field name="Customer_Segment" size="255" source="File: " type="V_String" />
<Field name="Region" size="255" source="File: " type="V_String" />
<Field name="TransInYear" source="Formula: Round(([TransactionsPerYear]*50), 1)" type="Int16" />
<Field name="Weekly Sales" source="Formula: round(([FinUniversity]*[Income]),.01)" type="Double" />
<Field name="Store Volume" source="File: " type="Double" />
</RecordInfo>
</MetaInfo>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxDbFileInput" />
</Node>
<Node ToolID="7">
<GuiSettings Plugin="AlteryxGuiToolkit.TextBox.TextBox">
<Position x="78" y="54" width="408" height="72" />
</GuiSettings>
<Properties>
<Configuration>
<Text>Practice Exercise 1</Text>
<Font name="Montserrat ExtraBold" size="21.75" style="1" />
<TextColor name="White" />
<FillColor r="13" g="35" b="69" />
<Shape shape="0" />
<Justification Justification="4" />
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText />
<Left value="False" />
</Annotation>
</Properties>
</Node>
<Node ToolID="6">
<GuiSettings Plugin="AlteryxGuiToolkit.TextBox.TextBox">
<Position x="78" y="102" width="408" height="60" />
</GuiSettings>
<Properties>
<Configuration>
<Text>Find the five customers with the highest number of transactions in the Southern region and remove the "Weekly Sales" and "Store Volume" columns.</Text>
<Font name="Montserrat" size="11.25" style="0" />
<TextColor name="White" />
<FillColor r="13" g="35" b="69" />
<Shape shape="0" />
<Justification Justification="4" />
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText />
<Left value="False" />
</Annotation>
</Properties>
</Node>
<Node ToolID="8">
<GuiSettings Plugin="AlteryxGuiToolkit.TextBox.TextBox">
<Position x="78" y="186" width="492" height="108" />
</GuiSettings>
<Properties>
…

[Shaikmunnisa]

This sounds like an examination question. The Community generally avoids any direct help in situations like this. If there's a particular step you're stuck on or tool that isn't working like it should, let us know and we'll do what we can to guide you in the right direction.

[Shaikmunnisa]

An Input Data tool contains 100 records, each representing a unique customer's transaction information. The Customer ID (a unique identifier for each customer) and Customer Segment provide basic information about the customer. The transactions column represents the average number of transactions that customer has made over the past year.

In this exercise, drop the columns "Weekly Sales" and "Store Volume". Then find the 5 customers with the highest average transactions in the "South" region. Your results window should match the Final State Input Data tool.

[Shaikmunnisa]

An Input Data tool contains 100 records, each representing a unique customer's transaction information. The Customer ID (a unique identifier for each customer) and Customer Segment provide basic information about the customer. The transactions column represents the average number of transactions that customer has made over the past year.

In this exercise, drop the columns "Weekly Sales" and "Store Volume". Then find the 5 customers with the highest average transactions in the "South" region. Your results window should match the Final State Input Data tool.

Start 1 .yxdb
(Region)="south"
Annual transactions-Desecnding
First 5
Final state - Exercise 1.yxdb

[Shaikmunnisa]

Start 1 .yxdb
(Region)="south"
Annual transactions-Desecnding
First 5
Final state - Exercise 1.yxdb

[jw825192]

Solution to practice exercise 1

[Huda_Asar]

Please find the attached answers to practice exercise-1

[bas_v]

My submission: