22|POWERBI – Marketing (Luka) Magic

[Boston]

BYU Student Author: @Boston
Reviewers: @Christian, @Marco
Estimated Time to Solve: 30 Minutes

We provide the solution to this challenge using:

• Power BI

Need a program? Click here.

Overview
You are a new intern at Luka Magic Co. and the CEO would like to know some information
regarding the current customer basis. They want to know if they should focus marketing
efforts on the website, catalog, or the stores. The CEO would also like to see the number of purchases made by each level of education. They would also like to see the purchase option most used by age. Make a dashboard that displays this information to aid the decision-making process. This will be shown to the company executives so make sure it looks professional! Boa sorte!

Instructions

1. Import the data
2. Make a horizontal bar chart and donut chart showing the breakdown of purchases by category (bottom left corner)
3. Make a vertical bar chart showing purchases by age (bottom right corner)
4. Cards (4) showing number of purchases by age (top right corner)
5. Text saying “Where should Luka Magic focus their marketing efforts?” (top left corner

Data Files

• Challenge22_Marketing_Analytics.csv
• Challenge22_Data_Dictionary.docx

Solution

Solution Image

Solution Video: Challenge 22|POWERBI – Marketing (Luka) Magic

[Mark]

Here is my visualization:

It appears that my viz matches the solution. Good beginner challenge!

[Mark]

Note on the post: The card instructions are incorrect. It asks for cards showing purchases by age, not by education level.

Also, the video would be more helpful if it walked through how the viz was created, not just showing the finished product. I am a beginner with PowerBI and I could follow, but a full walkthrough would be nice. For example, I don’t know how to get total purchases by age without a stacked bar chart (which stacks the three purchasing mediums) and I’d like to know how the author did so.

[Spencer]

I like the incorporation of multiple types of visualizations. The clustered column chart is particularly useful. Here is my solution:

Marketing_Luka_Magic.pbix (123.8 KB)

[DylanKing]

Great challenge! This was great practice for me with all the different types of visualizations possible on Power BI. This also was great practice creating a dashboard that shows a lot of information but is not overwhelming to the audience. Thanks for the practice! Here’s my solution:

[Kylie_Larsen]

Here is my viz:

I enjoyed doing this challenge, thanks for the practice!

Luka Magic Viz.pbix (115.4 KB)

[MitchFrei]

Very fun challenge!

For the Purchases by Age chart, I created a measure that sums Catalog Purchases, Web Purchases, and Store Purchases. Is that what you guys did?