Data Analysts Build a Power BI Solution in 30 minutes

Data Analysts Build a Power BI Solution in 30 minutes - DevDash (Ep. 3)

Рет қаралды 2,541

Күн бұрын

In this episode of DevDash, we pit two talented data analysts against each other to see who can create the best Power BI solution in just 30 minutes. Watch as Jonathan and Greg from Pragmatic Works tackle a coffee shop dataset, incorporating interactive buttons and showcasing best practices. Learn how to enhance your Power BI skills, create stunning interactive reports, and get insights into effective data visualization techniques.
Next step on your journey:
👉 On-Demand Learning - Start With The FREE Community Plan: prag.works/odl-trial-yt
🔗Pragmatic Works On-Demand Learning Packages: pragmaticworks.com/pricing/
🔗Pragmatic Works Boot Camps: pragmaticworks.com/boot-camps/
🔗Pragmatic Works Hackathons: pragmaticworks.com/private-tr...
🔗Pragmatic Works Virtual Mentoring: pragmaticworks.com/virtual-me...
🔗Pragmatic Works Enterprise Private Training: pragmaticworks.com/private-tr...
🔗Pragmatic Works Blog: blog.pragmaticworks.com/
Let's connect:
✔️Twitter: prag.works/yt-twitter
✔️Facebook: prag.works/yt-fb
✔️Instagram: prag.works/yt-insta
✔️LinkedIn: prag.works/yt-li
✔️Discord: prag.works/yt-discord
Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: (904) 638-5743
Email: training@pragmaticworks.com
#pragmaticworks #powerbi #dataanalyst
0:00 - Intro
0:37 - Challenge Overview and Rules
1:46 - Contestants Begin the Power BI Challenge
3:00 - Jonathan and Greg Discuss Best Practices
4:38 - Date Tables, Data Modeling, and Importance
6:14 - Creating and Importing a Date Table
6:54 - Progress Update and Data Preparation
7:38 - Star Schema Explanation
9:47 - Creating Measures, Data Modeling, and Initial Visuals
10:28 - Challenge Midpoint Progress
11:19 - Importance and Use of Buttons in Power BI
12:49 - Implementing Button Challenges
13:22 - Troubleshooting Data Issues
14:02 - Preparing for Final Submissions
17:20 - Jonathan Presents His Power BI Solution
22:33 - Greg Presents His Power BI Solution
26:13 - Winner Announcement and Closing Remarks

Пікірлер: 6

@hahaylayp 15 күн бұрын

This is comforting. Maybe I should show this to clients that expect a fully completed dashboard in such a short time. I see a lot of "this should only take 30 mins for an expert" in gig ads these days. Thats not even enough time to familiarize yourself with the data. My vote is on Jon on this challenge because of how he preps

@avarielhr 18 күн бұрын

Nice challenge guys! Thank you for the duel. I'm certain I'd take at least 2 hours to finish it. 😅 Two things to notice. Jonathan's visual has an area chart. The categories are actually additional, so basically, each location is close in number of Total Sales (differences not to big), not the Lower Manhattan outperforming the other two by far. Right? Greg has a point when not using a pie chart with so many categories, so a tree map is more suitable. But also, a tree map should be more hierarchical. Several big categories and then subcategories within them to really show those ratios. It is not working for me this way. But anyway, Jonathan's visual was more appealing to me, and also I like Greg's aggregations (totals, averages).

@PragmaticWorks 18 күн бұрын

Glad you enjoyed it!