Master Paginated Reports In Power BI - Learn with the Nerds FULL COURSE скачать в хорошем качестве

Master Paginated Reports In Power BI - Learn with the Nerds FULL COURSE

In this tutorial, we take you through the new Get Data option in Paginated Reports, which gives you access to the Power Query Editor and all its power transformation capabilities. Whether you're working with complex datasets or need highly formatted reports, this walkthrough will show you how to connect your data sources effortlessly and build dynamic reports with precision. Download the files: https://prag.works/paginated-reports-... Get your certificate of completion: https://prag.works/paginated-reports-... Interested in subscribing to our on-demand library of nearly 200 courses? Save 50% on an annual subscription for a limited time: https://prag.works/2024-black-friday-yt 👉 On-Demand Learning - Start With The FREE Community Plan: https://prag.works/odl-trial-yt 🔗Pragmatic Works On-Demand Learning Packages: https://pragmaticworks.com/pricing/ 🔗Pragmatic Works Boot Camps: https://pragmaticworks.com/boot-camps/ 🔗Pragmatic Works Hackathons: https://pragmaticworks.com/private-tr... 🔗Pragmatic Works Virtual Mentoring: https://pragmaticworks.com/virtual-me... 🔗Pragmatic Works Enterprise Private Training: https://pragmaticworks.com/private-tr... 🔗Pragmatic Works Blog: http://blog.pragmaticworks.com/ 00:00 - Introduction to Paginated Reports 00:28 - Understanding Power BI Reporting Tools 01:28 - Exploring Paginated Reports 02:24 - Power BI Interactive vs. Paginated Reports 03:46 - The Need for Operational Reports 05:07 - Advantages of Paginated Reports 07:02 - Connecting to Data Sources 09:35 - Using Power Query Editor in Paginated Reports 11:19 - Renaming and Formatting Data 13:16 - Merging Data Tables 16:48 - Uploading Files to OneDrive 18:32 - Navigating the Power Query Editor 19:56 - Creating a New Data Set 21:17 - Cleaning and Transforming Data 24:35 - Adding Prefixes to Columns 25:31 - Formatting and Data Types 27:20 - Merging Sales Data 29:38 - Using Advanced Editor for Code 31:08 - Grouping and Summarizing Data 33:01 - Filtering Data for Salespersons 35:17 - Expanding Merged Data 38:09 - Creating Calculated Columns 40:58 - Combining Data for Reporting 44:13 - Aggregating Sales Amounts 47:04 - Merging Quota Data 49:59 - Grouping Data for Final Report 53:17 - Adding Variance Calculations 57:38 - Parameterizing Reports 01:02:24 - Setting Up Report Parameters 01:05:07 - Creating Dynamic Data Sets 01:09:35 - Implementing Single-Value Parameters 01:14:17 - Building the Report Layout 01:18:09 - Formatting and Totals 01:22:23 - Finalizing the Report 01:25:27 - Conclusion Let's connect: ✔️Discord: https://prag.works/yt-discord ✔️Facebook: https://prag.works/yt-fb ✔️Instagram: https://prag.works/yt-insta ✔️LinkedIn: https://prag.works/yt-li Pragmatic Works 7175 Hwy 17, Suite 2 Fleming Island, FL 32003 Phone: (904) 638-5743 Email: [email protected] #PragmaticWorks