Getting Started with Power BI
This course teaches you the basic skills required for using Power BI to acquire and transform data, enhance the data for analysis, and produce reports and dashboards.
What you'll learn
Power BI is a fantastic tool from Microsoft that helps you understand your data with interactive, easy-to-use visualizations. In this course, Getting Started with Power BI, you'll gain a fundamental understanding of the capabilities of Power BI. First, you'll learn how to work with reports and dashboards to develop an understanding of the model and reports that you’ll be building throughout the course. Then, you’ll discover how to quickly and easily gather data from a variety of sources, and cleanse and transform that data with just a few clicks. Next, you'll explore how you can enhance the results by integrating disparate data sources and adding simple calculations. Finally, you'll learn how to enable data exploration with visualizations in reports and the necessary steps to keep your data up-to-date. By the end of this course, you'll have a firm understanding of the basic skills required for using Power BI to acquire and transform data, enhance the data for analysis, and produce reports and dashboards.
Table of contents
- Introducing Power BI 2m
- Introducing Globomantics Requirements 5m
- Power BI Key Ideas 4m
- Datasets, Data Models, and Data Files 2m
- Signing up for the Power BI Service 2m
- Uploading a PBIX File to the Power BI Service 2m
- Using Quick Insights 3m
- Viewing Reports 4m
- Dashboard Features 2m
- Exploring a Dashboard 3m
- Choosing a Development Tool 2m
- Power BI Desktop Workflow 2m
- Getting Familiar with Power BI Desktop 5m
- Using Excel for Power BI Development 4m
- Summary 1m
- Getting Data 2m
- Supported Data Sources 3m
- Accessing Data Sources 3m
- Globomantics Data Sources 3m
- Getting Data from Databases 5m
- Getting Data from Individual Files 4m
- Getting Data from a Group of Files 4m
- Getting Data from Individual Files in Power Query Editor 2m
- Getting Data from the Web and Manual Entry 3m
- Loading the Data Model 4m
- Getting Data into the Excel Data Model 7m
- Summary 1m
- Transforming Data 1m
- Renaming Queries 4m
- Appending Queries 5m
- Grouping Queries 2m
- Promoting Headers 3m
- Fixing Column Metadata 5m
- Filtering Rows 3m
- Eliminating Columns 5m
- Merging Queries 6m
- Adding Columns by Splitting Text 3m
- Adding Columns by Splitting XML 6m
- Adding Columns for Sorting 3m
- Disabling the Data Load for Selected Queries 2m
- Transforming Data in Excel 2m
- Summary 1m
- Modeling Data for Analysis 2m
- Reviewing Missing Relationships 5m
- Creating a Relationship 7m
- Creating More Relationships 4m
- Defining New Columns 1m
- Concatenating Columns 6m
- Performing a Lookup to a Related Table 3m
- Translating a Value 2m
- Using the If Function 6m
- Adding a Date Table 6m
- Modeling Data in Excel 4m
- Summary 1m
- Enhancing Data Models 2m
- Defining Hierarchies 4m
- Configuring Properties 2m
- Hiding Objects and Configuring the Sort by Columns 4m
- Configuring Data Categories, Formatting, and Default Summarization 3m
- Creating Measures 3m
- Defining the Customer Count Measure 3m
- Defining the Percent of Total Customers Measure 6m
- Defining the Total Sales Measure 2m
- Defining the Previous Year Sales Measure 5m
- Enhancing the Excel Data Model 4m
- Summary 1m
- Visualizing Data 1m
- Globomantics Requirements 2m
- Creating a Table 4m
- Creating a Clustered Column Chart 3m
- Creating a Bar Chart 2m
- Creating a Map 2m
- Creating a Card 1m
- Creating a Matrix 4m
- Globomantics Requirements 1m
- Creating and Adjusting a Clustered Column Chart 2m
- Creating a Filled Map 2m
- Creating a KPI 3m
- Filtering 4m
- Slicer Filtering 2m
- Highlighting 2m
- Setting Properties 7m
- Drilling within a Hierarchy 5m
- Visualizing Data in Excel Part 1 4m
- Visualizing Data in Excel Part 2 5m
- Summary 1m
About the author
Stacia Misner Varga is an instructor, author, and principal consultant of Data Inspirations. Her career spans more than 30 years, with a focus on improving business practices through technology. Since 2000, she has provided consulting and education services for Microsoft’s data platform and authored or co-authored many books covering this topic. In addition, Stacia has been a frequent speaker over the years at technology conferences worldwide.