by Manuel Lorenz, Maximilian Schwarzmüller | Released October 2018 | ISBN: 9781789959031

Learn how to use Microsoft's Power BI Tools, including Power BI Desktop, Power BI Service and PowerBI DeveloperAbout This VideoLearn to analyze data from different data sources and create your own datasetsImmerse yourself on Power BI and find out more about its advanced featuresIn DetailThis course will take you on a journey where you'll you will learn why Power BI offers you a comprehensive set of Business Intelligence tools for your data analysis goals and how to use these tools in the required way. Quickly structure your data, easily add calculations to it, and create and publish nice-looking charts in just a few minutes. You will learn about different tools in the Power BI universe, understand Power BI Desktop and its components, and lot more.The code bundle for this video course is available at https://github.com/PacktPublishing/Microsoft-Power-BI---A-Complete-Introduction Show and hide more

1. Chapter 1 : Getting Started
   • Welcome to this Course 00:02:40
   • Understanding the Power BI Tools 00:07:01
   • Initial Project 1/3: Installing Power BI Desktop and Connecting to Data 00:06:30
   • Initial Project 2/3: Working in the Query Editor 00:06:51
   • Initial Project 3/3: Working in the Data Model and Creating a Visualization 00:06:27
   • Course Outline 00:03:02
   • How to use the Attached Project Files 00:03:12
2. Chapter 2 : An Introduction to Power BI Desktop
   • An Overview of the Workflow in Power BI Desktop 00:02:37
   • Introducing the Different Views of the Data Model 00:07:10
   • Taking a r Look at the Query Editor Interface 00:04:07
   • Before we Dive Deeper: Recommended Settings 00:03:17
3. Chapter 3 : An Introduction to the Query Editor
   • Just to be sure: What is the Query Editor? 00:03:18
   • Connecting Power BI Desktop to our Data Sources 00:05:10
   • Editing Rows 00:09:55
   • Understanding Append Queries 00:06:07
   • Editing Columns 00:05:21
   • Replacing Values 00:03:14
   • Formatting Data 00:06:27
   • Pivoting and Unpivoting Columns 00:04:36
   • Splitting Columns 00:03:30
   • Creating a New Group for our Queries 00:01:30
   • What we Achieved until Now and How to Continue 00:00:49
   • Introducing the Star Schema 00:06:09
   • Duplicating and Referencing Queries 00:03:39
   • Creating the DIM Region Table 00:07:25
   • Entering Data Manually 00:04:04
   • Merging Queries 00:10:45
   • Finishing the DIM Region Table 00:09:21
   • Introducing the DIM AgeGroup Table 00:01:04
   • Creating an Index Column 00:03:57
   • Duplicating Columns and Extracting Information 00:05:49
   • Creating Conditional Columns 00:04:17
   • Creating the FACT Population Table 00:04:38
   • Performing Basic Mathematical Operations 00:01:54
   • Improving Performance and Loading Data into the Data Model 00:10:26
   • Module Summary 00:00:42
4. Chapter 4 : Working on our Data Model: Data & Relationship View
   • Module Introduction 00:00:47
   • Query Editor vs. Data Model 00:02:30
   • Introducing and Understanding Relationships 00:07:50
   • Editing Relationships 00:03:06
   • Understanding Cardinality 00:04:37
   • Cross Filter Selection and Many-To-Many Relationships 00:07:21
   • Active Properties 00:02:00
   • Understanding the differences between the M-Language and DAX 00:02:42
   • M vs. DAX applied: Calculated Columns 00:08:55
   • M vs. DAX: Conclusion 00:01:14
   • DAX - Basic information 00:08:11
   • DAX and Calculated Columns 00:08:43
   • Calculated Columns vs. Measures 00:01:11
   • Introducing DAX-Measures 00:04:50
   • DAX-Measures Continued 00:06:26
   • Categorizing Data 00:02:08
   • Module Summary 00:00:53
5. Chapter 5 : Working in the Report View to Visualize our Results
   • Module Introduction 00:01:02
   • Understanding the Interface of the Report View 00:11:21
   • Creating our First Visualizations 00:07:03
   • Editing Interactions and Adding Tooltips 00:06:54
   • Adding Color Saturation 00:02:26
   • Understanding Hierarchies and Adding Drill-Down 00:05:44
   • Formatting Charts and Sorting 00:09:40
   • Introducing Slicers 00:05:53
   • Adding Treemaps and Tables 00:08:51
   • Applying different Filter Types 00:06:34
   • Creating (Multi-Row) Cards 00:05:43
   • Understanding Combined Visualizations and Waterfalls 00:04:27
   • Module Summary 00:00:42
6. Chapter 6 : Power BI Service & Power BI Mobile - How to Continue?
   • Module Introduction 00:00:35
   • Continuing our Work and why we need Power BI Service 00:04:25
   • Comparing Power BI Free, Pro and Premium 00:02:45
   • Logging in to Power BI Service 00:01:15
   • Understanding the Interface 00:05:18
   • Importing our Data from Power BI Desktop to Power BI Service 00:05:16
   • Understanding the Dataset Menu 00:04:52
   • Working on Reports 00:07:02
   • Introducing Dashboards 00:04:00
   • Exploring our Workspace 00:04:28
   • Understanding Gateways 00:03:11
   • Comparing Personal and On-Premise Gateway and Installing a Gateway 00:04:56
   • Working alone or Collaborating with Colleagues 00:00:55
   • Collaborating in App Workspaces 00:04:25
   • Sharing the Results 00:00:55
   • Publishing the App 00:04:26
   • Content Packs from Online Services 00:06:21
   • Power BI Mobile: Installing and Understanding the Mobile App 00:11:28
   • One Last Thing: Excluding Datasets from Sharing 00:05:22
   • Module Summary 00:01:47
7. Chapter 7 : Other Data Sources
   • Module Introduction 00:01:22
   • Importing JSON Data 00:06:28
   • Importing Data from REST APIs 00:05:01
   • Preparation: Setting up a MySQL Server 00:08:09
   • Importing Data from a MySQL Server (and other SQL Servers) 00:06:38
   • Wrap Up 00:00:56
8. Chapter 8 : Creating Custom Visuals (Power BI for Developers)
   • Module Introduction 00:01:09
   • How do Custom Visuals Work? 00:04:15
   • Using Data Driven Documents (D3) 00:02:39
   • Creating and Using a Visual 00:08:20
   • Installing an IDE (Code Editor) 00:01:35
   • Understanding the visuals.ts File 00:04:56
   • Understanding the Project Structure 00:04:11
   • Installing d3.js (Data Driven Documents) 00:05:32
   • Adding a First Shape 00:05:32
   • Connecting Shapes to Data 00:08:14
   • Scaling Shapes 00:09:53
   • Managing Visual Capabilities to Allow Data Input 00:03:23
   • Starting the Data Extraction 00:04:56
   • Limiting the Data Input 00:01:36
   • Extracting Data 00:04:49
   • Displaying the User Data 00:02:35
   • Optimizing the Code 00:03:44
   • Adding Dynamic Coloring 00:03:54
   • Making Bars Selectable (Cross-Visual) 00:07:36
   • Adding X-Axis Labels 00:08:40
   • Adding Custom Visuals Settings 00:03:09
   • Extracting the Visual Configuration 00:09:48
   • Informing Power BI About the Custom Configuration 00:04:42
   • Next Steps 00:01:21
   • Packaging the Custom Visual 00:01:28
   • Wrap Up 00:01:05
9. Chapter 9 : Course Roundup
   • Congratulations 00:01:43
Show and hide more