FREE Power BI Course 🎁 - FREE Adv. Masterclass on Power BI - Create a Sales Analytics Dashboard (with files 📁)

The best way to learn Power BI is by doing an end-to-end portfolio project. In this video, we are going to do just that. Create a super awesome sales analytics dashboard and publish your work to GitHub. Right from data modelling to creating interactive dashboard, everything is clearly and neatly explained. 👩‍💻 What you will learn: =================== 1) How to design a dashboard in Power BI? 2) Data modelling with Power BI and star schema development 3) Identifying measures and KPIs for sales analytics 4) Creating measures and setting up a dedicated measure table 5) Time intelligence calculations in Power BI - MoM changes 6) Using the "new" card visual and reference labels 7) Fixing problems with DAX measures 8) Using Field parameters to create a dynamic trend chart 9) "Group" feature of Power BI to make histograms 10) Working with ZOOM SLIDER 11) Gauge chart to see Profit and LBS % 12) Table design in Power BI 13) Conditional formatting for tables 14) Bookmarks 15) Fixing problems with bookmarks - data / filter preservation 16) Setting up tooltips for country breakdown 17) Slicer panel set up in Power BI 18) Publishing the dashboard to Power BI service 19) Setting Github portfolio page 📁 DEMO +Sample data file: ======================== Live Demo: https://app.powerbi.com/view?r=eyJrIjoiNWJiNDQ4YTQtNWIxNi00NmE5LTk1MWEtNmNkZGUyM2U4ZmEwIiwidCI6IjUzNTA4ZDUyLWQxYjAtNDliMC1iNGJhLTM1MzNjMTI0OWEwMSJ9 Github link: https://github.com/chandoo-org/Power-BI/blob/main/ac-sample-data.xlsx Mirror link: https://chandoo.org/wp/wp-content/uploads/2024/07/ac-sample-data.xlsx Icons & Files: https://github.com/chandoo-org/Power-BI/ 📂 Completed Power BI file + Video download ====================================== You can get the complete Power BI file, full HD video and more than 10 hours of Power BI lessons in my online Power BI course. Sign up here: 👉 https://chandoo.org/wp/power-bi-course/ ⏱ Video Timestamps: =================== 0:00 - Introduction and what to expect 1:00 - Set up of our data and business situation 2:14 - Awesome Chocolates Data Model 3:00 - Data load to Power BI 5:43 - Star Schema creation in Power BI 6:40 - Defining the DAX measures 17:43 - Using the Calendar table to make "time intelligence" measures 27:22 - Wireframe design for our dashboard 31:55 - Dashboard page design and theme in Power BI 33:42 - KPI cards for the Power BI sales analytics dashboard 36:25 - Fixing the MoM calculation DAX 41:52 - Adding reference labels for the KPI cards 44:26 - Formatting the KPI section 48:56 - Profit % Gauge Chart 52:05 - Dynamic Trend Analysis Chart (with Field Parameters) 59:11 - Shipment Analysis (histogram + zoom slider) 1:05:45 - Sales Person Performance - Table design 1:23:30 - Product Performance Table 1:25:35 - Bookmark for Product vs. People view 1:34:27 - Filter panel design 1:39:28 - Tooltip design 1:44:16 - Final version (with two options!) 1:47:36 - Creating a portfolio on Github to share your project 1:53:58 - Congratulations on completing the Power BI project ~ 📺 MORE POWER BI ⚡ =================== 📚 Dashboards: Finance Dashboard in Power BI (20 mins) - https://youtu.be/i3AR0gt9SHA Beginner to PRO lesson on Power BI (45 mins) - https://youtu.be/uwe8C7K8fXY HR Dashboard with Power BI (30 mins) - https://youtu.be/5KaIU-9EF-0 Dashboard re-design in Power BI - https://youtu.be/XadqG2SrVSc Netflix EDA with Power BI - https://youtu.be/iGUqad1eNtQ SQL + Power BI - https://youtube.com/live/UQJAHUUFK-o?feature=share 📘 DAX: How to use Calculated Groups in Power BI - https://youtu.be/WnLtC3udzSQ Beginner to PRO class on DAX - https://youtu.be/PQ5lALdFHCU 📗 Power Query: How to make a calendar table - https://youtu.be/wN1ok8JDzrI Power Query in 15 mins - https://youtu.be/UAFExySaSPY Power Query masterclass (90 mins) - https://youtu.be/PiFAa_jjaEI 📙 Power BI Concepts: Dynamic Top 10 chart - https://youtu.be/uQV5MP_THfA When and how to use various Power BI charts - https://youtu.be/5jrsrSDEMxE Power BI Free vs. Pro vs. Premium - https://youtu.be/6tTJkA3Cv_w How to create tooltips in Power BI - https://youtu.be/npaQ42K1sTs How to use Field Parameters in Power BI - https://youtu.be/IR62y8Q_k-o Star Schema in Power BI (explanation) - https://youtu.be/1CgG0t59WcM How to use Small Multiples in Power BI - https://youtu.be/Jzu2wfyYF9I How to make a slicer panel - https://youtu.be/luVczt-NQ6M What-if analysis with Power BI - https://youtube.com/live/jjT_yor0NuA?feature=share 💥 Full course: 10 hours Power BI course - https://chandoo.org/wp/power-bi-course/ ~ #powerbi #course