Скачать с ютуб 2 Hour Masterclass on Power BI - Create a Sales Analytics Dashboard (free files 📁) в хорошем качестве

2 Hour Masterclass on Power BI - Create a Sales Analytics Dashboard (free 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=eyJrIj... Github link: https://github.com/chandoo-org/Power-... Mirror link: https://chandoo.org/wp/wp-content/upl... 📂 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) -    • Make an Incredible Finance KPI Dashbo...   Beginner to PRO lesson on Power BI (45 mins) -    • Beginner to PRO Data Analysis with Po...   HR Dashboard with Power BI (30 mins) -    • HR Data Analytics & Awesome Dashboard...   Dashboard re-design in Power BI -    • Power BI Dashboard Makeover - 5 Ideas   Netflix EDA with Power BI -    • End to End Data Analysis Project with...   SQL + Power BI - https://youtube.com/live/UQJAHUUFK-o?... 📘 DAX: How to use Calculated Groups in Power BI -    • How to set up and use Calculation Gro...   Beginner to PRO class on DAX -    • Learn Power Pivot & DAX for Power BI ...   📗 Power Query: How to make a calendar table -    • How to make the "perfect" CALENDAR TA...   Power Query in 15 mins -    • Learn Power Query & Automate Boring D...   Power Query masterclass (90 mins) -    • Power Query Tutorial - What is it, ho...   📙 Power BI Concepts: Dynamic Top 10 chart -    • How to make an interactive TOP 10 Cha...   When and how to use various Power BI charts -    • How to pick the "perfect" chart for y...   Power BI Free vs. Pro vs. Premium -    • Power BI: Free vs. Pro vs. Premium - ...   How to create tooltips in Power BI -    • How to create Tooltip Pages in Power ...   How to use Field Parameters in Power BI -    • Power BI Field Parameters - Why & how...   Star Schema in Power BI (explanation) -    • How to setup a Star Schema Data Model...   How to use Small Multiples in Power BI -    • How Jo uses Small Multiples to impres...   How to make a slicer panel -    • How to make a Show / Hide SLICER PANE...   What-if analysis with Power BI - https://youtube.com/live/jjT_yor0NuA?... 💥 Full course: 10 hours Power BI course - https://chandoo.org/wp/power-bi-course/ ~ #powerbi #course