Из-за периодической блокировки нашего сайта РКН сервисами, просим воспользоваться резервным адресом:
Загрузить через ClipSave.ruУ нас вы можете посмотреть бесплатно 2 Hour Masterclass on Power BI - Create a Sales Analytics Dashboard (free files 📁) или скачать в максимальном доступном качестве, которое было загружено на ютуб. Для скачивания выберите вариант из формы ниже:
Если кнопки скачивания не
загрузились
НАЖМИТЕ ЗДЕСЬ или обновите страницу
Если возникают проблемы со скачиванием, пожалуйста напишите в поддержку по адресу внизу
страницы.
Спасибо за использование сервиса savevideohd.ru
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