From the course: Python in Excel: Working with pandas DataFrames
Unlock the full course today
Join today to access over 23,300 courses taught by industry experts.
Case study: Sales dashboard
From the course: Python in Excel: Working with pandas DataFrames
Case study: Sales dashboard
- [Instructor] Let's build a sales dashboard. We will use Power Query to load data into a data frame, and we will see how pivot tables work in Pandas. So here's what we're going to build. A dashboard that shows the total sales amount per store location, with the ability to change the year of the analysis. But let's start at the beginning. Within the exercise files, there's a folder called Sales Data. It contains the Excel files with our sales data, so it's one file per month, and we have files covering two years. Let's open this sample file from April 22. The data is from a fictitious mobile phone provider offering various plans. These plans are sold via physical store location throughout the US, as shown in column B. Other than that, we will need the transaction date and amount columns for our analysis. Remember, in the dashboard, we want to show how much each store sold in total per month. In the main exercise file, here on the dashboard sheet, we're going to add a table and chart…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.