Data transformations

Case Study: Analyzing Sales Data in Alteryx

Kim Hands

Alteryx Expert and Principal Consultant, AnalyticHands

Your accomplishments thus far

A diagram of the workflow created in Chapter 1

  • Combined customer files
  • Removed duplicate records
  • Added region and day of week
  • Produced regional counts file
Case Study: Analyzing Sales Data in Alteryx

Initial Insights

  • SE has the highest order count every day except Thursday.
  • No one day shows particularly high or low activity.
  • No one region appears to be significantly over/under performing the others.

A picture of the regional day of week table created at the end of Chapter 1

Case Study: Analyzing Sales Data in Alteryx

The importance of documentation

A diagram of the workflow created in Chapter 1 with container closed

Comments and Containers

  • Allows for a better understanding of the flow of data.
  • Makes it easier for others to understand the process.
  • Grants the ability to disable part of the workflow.
Case Study: Analyzing Sales Data in Alteryx

Reviewing the data

A diagram of the data files and how they are linked with Chapter 1 tasks highlighted

Case Study: Analyzing Sales Data in Alteryx

Transforming data

  • Data stored in standardized formats
  • Transformation is often necessary for analysis
  • Alteryx can automate the transformation process

Image of a transformation occurring to numbers

Case Study: Analyzing Sales Data in Alteryx

Let's transform some data!

Case Study: Analyzing Sales Data in Alteryx

Preparing Video For Download...