From the course: Power BI Challenges: 15 Skills-Building Analytics Exercises for Data Professionals

Unlock the full course today

Join today to access over 24,900 courses taught by industry experts.

Solution

Solution - Power BI Tutorial

From the course: Power BI Challenges: 15 Skills-Building Analytics Exercises for Data Professionals

Start my 1-month free trial Buy for my team

Solution

“

(upbeat music) - [Instructor] How did it go? Here's how I would solve this challenge. The first thing I'd do is have a good look at the data to understand how the different fields relate to each other, what the products are, what the market sold. On relationships, I worked out the following, sales equals cost of goods sold plus profit. Gross sales is sales plus discounts. Units sold times by the sales price is gross sales. And the last one we know 'cause we made that ourselves, unit sold times by the manufacturing price is the cost of goods sold or COGS. Understanding the data intimately is a crucial first step before you start report building. A report is just a way of communicating data with your audience. You can't hope to communicate data effectively if you don't understand how the different parts relate. So I'm going to go back to table view. Now the brief was to show sales over time in a single visual, mindful…

Contents