1. Data transformations
Now that you have completed the added task your boss requested, it's time to focus on the original assignment.
2. Your accomplishments thus far
In the first chapter, you focused on combining and cleaning up the customer order data files. You removed duplicates, added additional data, and even produced a file of regional order counts that your boss requested to be added to the analysis.
3. Initial Insights
The regional order count exercise did offer some initial insights into the order data. The table shows that the SE region had the highest number of orders for every day except for Thursday. The data also suggests that there isn't any one day that stands out with unusually high or low activity and that no region appears to be significantly over or under performing the others.
4. The importance of documentation
You have also documented your workflow, an important step in the development process. By adding notes and possibly color-coding areas, you can better follow the flow of the process. This makes it easier for you and someone else looking at the workflow to understand what it is doing. Adding the extra assignment your boss gave you to a container allows you to collapse and disable it if that file does not need to be created every time you execute the process.
5. Reviewing the data
With the customer data ready for analysis, it is time to focus on the order details. The order details file contains information relating to the price, cost, and method of payment for each order. Each item is also categorized, which will be useful in your analysis.
6. Transforming data
DC Industries, like most companies, store their data in standardized formats. This means that to conduct an analysis, you'll often need to transform the data to meet the needs of your project. Alteryx is great for setting up a transformation process that can automatically reformat your data to meet your project needs.
7. Let's transform some data!
The order details file is going to need to be transformed so you can use it in your analysis. Let's get started with the transformation!