# 22|POWERBI – Marketing (Luka) Magic **URL:** \ **Category:** Challenges\ **Tags:** beginner, powerbi, managerial, marketing\ **Created:** [February 27, 2023, 10:14pm UTC](https://www.techhub.training/t/22-powerbi-marketing-luka-magic/176 "2023-02-27T22:14:22Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Boston](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/boston/32/75_2.png) [@Boston](https://www.techhub.training/u/Boston)\ **Post date:** [February 27, 2023, 10:14pm UTC](https://www.techhub.training/t/22-powerbi-marketing-luka-magic/176/1 "2023-02-27T22:14:22Z")
_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](https://www.techhub.training/t/information-about-software-used-on-techhub-training/138). **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](https://byu.box.com/shared/static/emgrjglass7ri9cxtn49zi0imicey92b) - [Challenge22\_Data\_Dictionary.docx](https://byu.box.com/shared/static/0n0icwkuy6xr6wmnj8rg15hr5brtkgxg) **Solution** > **Solution Image** > > ![Challenge22_Solution](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/1X/3a1ae8dcc9885418f51f7ea3a1f42ca14681fd57.jpeg) _Solution Video:_ [Challenge 22|POWERBI – Marketing (Luka) Magic](https://youtu.be/EAQnUDVrGR0) ---
**Author:** ![Mark](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/mark/32/80_2.png) [@Mark](https://www.techhub.training/u/Mark)\ **Post date:** [February 28, 2023, 3:10am UTC](https://www.techhub.training/t/22-powerbi-marketing-luka-magic/176/2 "2023-02-28T03:10:40Z")
Here is my visualization: ![image](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/1X/01397e62aaf0b5490aac50db4d0561a455b42be9.png) It appears that my viz matches the solution. Good beginner challenge! ---
**Author:** ![Mark](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/mark/32/80_2.png) [@Mark](https://www.techhub.training/u/Mark)\ **Post date:** [February 28, 2023, 3:17am UTC](https://www.techhub.training/t/22-powerbi-marketing-luka-magic/176/3 "2023-02-28T03:17:45Z")
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. ---
**Author:** ![Spencer](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/spencer/32/107_2.png) [@Spencer](https://www.techhub.training/u/Spencer)\ **Post date:** [March 1, 2023, 2:11am UTC](https://www.techhub.training/t/22-powerbi-marketing-luka-magic/176/4 "2023-03-01T02:11:08Z")
I like the incorporation of multiple types of visualizations. The clustered column chart is particularly useful. Here is my solution: ![Marketing_Luka_Magic](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/1X/a212e5e12cea19ce8384bff65454c1cfb59068b7.jpeg) [Marketing\_Luka\_Magic.pbix](https://www.techhub.training/uploads/short-url/y4fPT0X1I5dCyKort7imWClbrTk.pbix) (123.8 KB) ---
**Author:** ![DylanKing](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/dylanking/32/25_2.png) [@DylanKing](https://www.techhub.training/u/DylanKing)\ **Post date:** [April 14, 2023, 1:59am UTC](https://www.techhub.training/t/22-powerbi-marketing-luka-magic/176/5 "2023-04-14T01:59:33Z")
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: ![Luka Magic Challenge Screenshot](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/1X/9187cffedeef0b3776fd34175a178d4f3f682a33.png) ---
**Author:** ![Kylie\_Larsen](https://avatars.discourse-cdn.com/v4/letter/k/8edcca/32.png) [@Kylie\_Larsen](https://www.techhub.training/u/Kylie_Larsen)\ **Post date:** [April 18, 2023, 6:46pm UTC](https://www.techhub.training/t/22-powerbi-marketing-luka-magic/176/6 "2023-04-18T18:46:18Z")
Here is my viz: ![Screenshot 2023-04-18 124934](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/1X/8b1734c9e2c6202f4b1b9f5caf713bf19ef119ff.png) I enjoyed doing this challenge, thanks for the practice! [Luka Magic Viz.pbix](https://www.techhub.training/uploads/short-url/sHIlhJgv19uj6n1hrW9WCqRcvHN.pbix) (115.4 KB) ---
**Author:** ![MitchFrei](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/mitchfrei/32/312_2.png) [@MitchFrei](https://www.techhub.training/u/MitchFrei)\ **Post date:** [April 25, 2023, 3:51pm UTC](https://www.techhub.training/t/22-powerbi-marketing-luka-magic/176/7 "2023-04-25T15:51:56Z")
Very fun challenge! ![image](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/1X/a66b168c30db4df73f1eb44b5dcb8c8f5da08118.png) 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? ---
**Author:** ![Alexander\_Trinh](https://avatars.discourse-cdn.com/v4/letter/a/13edae/32.png) [@Alexander\_Trinh](https://www.techhub.training/u/Alexander_Trinh)\ **Post date:** [June 28, 2024, 4:00pm UTC](https://www.techhub.training/t/22-powerbi-marketing-luka-magic/176/8 "2024-06-28T16:00:56Z")
Very fun challenge! Here’s my visualization ![image](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/8/8cac2b5b0b32107a4aa1b7657e29962730a18ad4.png) ---
**Author:** ![Ian\_Shores](https://avatars.discourse-cdn.com/v4/letter/i/b2d939/32.png) [@Ian\_Shores](https://www.techhub.training/u/Ian_Shores)\ **Post date:** [June 28, 2024, 8:18pm UTC](https://www.techhub.training/t/22-powerbi-marketing-luka-magic/176/9 "2024-06-28T20:18:29Z")
Here’s my final version! ![PowerBI Challenge](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/8/8db30bcb4cabb716d97ecb1beef9b4e057890945.jpeg)