by Reid Havens | Released October 2018 | ISBN: 9781789347104

Create insightful dashboards with the help of interactive reports and compelling visualizations to analyze your data more effectivelyAbout This VideoConnecting to, cleaning, and shaping your data using the Query EditorBuilding a multidimensional data model using Power BI DesktopUsing modern visualization techniques to build a report and dashboard for PowerBI.comIn DetailTell your data story with Power BI and reach millions of users with a single click on any kind of a device. Using Power BI, you can combine your data sources, create stunning visualizations, and embed your story on your website within seconds. The goal of this course is to teach you how to use raw data, monitor it, and visualize it in a form that will provide rich insights with the help of dashboards.You will start with a set of business requirements for an example project from a client. Initially, you will connect to a data file. You'll run through the process of connecting to your data, transform it, and then build the data model. This will help you understand and determine which DAX calculations are needed to meet the business requirements. Finally, you will build out an interactive and functional report and a detailed dashboard, and publish them on PowerBI.com. When it comes to learning Power BI, this course will ensure that you have the necessary tricks of the trade for effective insights and simplified visual analytics.The code bundle for this course is available at https://github.com/PacktPublishing/Learning-Microsoft-Power-BISpecial assignment labs and student files on every hands-on concept for better understanding Show and hide more

1. Chapter 1 : Project Requirements and Getting Data
   • The Course Overview 00:02:16
   • What Is the Flow of Report Development for a Business Analyst? 00:04:03
   • Reviewing Project Requirements and Determining Data Sources 00:03:54
   • Connecting to (Almost) Any Data Source with Power Query 00:05:32
   • Importing Data and Power Query Fundamentals 00:08:35
   • Connecting to a Folder as a Data Source 00:07:45
   • Table Types and Relational Data Modeling 00:05:31
2. Chapter 2 : Common Data Transformations
   • Common Data Transformations with Power Query 00:11:32
   • Intelligent Data Filtering with Power Query 00:07:45
   • Adding New Columns with Power Query 00:10:52
   • Merging Tables with Power Query 00:12:56
3. Chapter 3 : Data Modeling and Relationships
   • Creating Table Relationships in Power BI 00:09:34
   • Understanding the Data View in Power BI 00:05:04
   • Column Settings and Hierarchies In Power BI 00:08:24
4. Chapter 4 : Data Analytics with DAX Measures
   • Translating Report Requirements into DAX Measures 00:03:17
   • Report View Walkthrough 00:03:59
   • DAX Concepts and Fundamentals 00:02:44
   • Creating Basic DAX Measures 00:10:06
   • Creating a DAX Measures Table 00:05:00
   • Referencing DAX Measures 00:06:47
5. Chapter 5 : Data Visualization and Modern Reporting
   • Visual Cues and Chart Types 00:05:31
   • Creating Visualizations – Matrix Table 00:09:02
   • Creating Visualizations – Running Total Chart 00:11:36
   • Creating Visualizations – Column and Line Chart (Year-Over-Year Profits %) 00:13:34
   • Creating Visualizations – Conditional Formatting and Waterfall Charts 00:09:39
   • Creating Visualizations – Card Visualizations and Title Section 00:09:25
   • Slicers and Filter Settings 00:08:37
   • Formatting and Report Design 00:08:16
6. Chapter 6 : Report Publishing and the Power BI Service
   • Publishing a Report to the Power BI Service 00:04:09
   • Creating an App Workspace 00:04:56
   • Creating a Dashboard 00:07:11
   • Setting Up Scheduled Refreshes 00:05:57
   • Learning Microsoft Power BI: Course Completed 00:01:47
Show and hide more