Summary
Keywords
Full Transcript
Do you want to use SQL with Power BI to take your data analysis to next level? Join me on this free & live masterclass to learn how to set up SQL queries as data source, how to parameterize them in your Power BI report. We will be using the FREE Awesome Chocolates Dataset for this live stream. Download the dataset .SQL file from below link. https://chandoo.org/wp/learn-sql-for-data-analysis/ ⏱ In this video: ============= 0:00 - Introduction and hellos 5:04 - Agenda slides 8:37 - Where to download the sample data (SQL files) 16:10 - Introduction to SQL 30:15 - How to get SQL data into Power BI? 44:37 - Creating a simple Power BI report 1:04:00 - How to parameterize the query? 1:22:56 - How to show the parameter values on the Power BI report? (product codes etc.) 1:30:30 - How to parametrize dates? 1:39:47 - How to show "last updated date" on the Power BI report? 1:44:30 - Other questions & Closing remarks 💡💻 LEARN MORE: ================ SQL - Full course - https://youtu.be/l8DCPaHc5TQ Power Pivot - https://youtu.be/PQ5lALdFHCU Power Query - https://youtu.be/PiFAa_jjaEI Power BI - https://youtu.be/uwe8C7K8fXY + Full course - https://chandoo.org/wp/power-bi-course/ #SQL #PowerBI #realtimeproject
Continue this lesson in the app
Install CourseHive on Android or iOS to keep learning while you move.
