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
In this course, Getting Started with Power BI, you will gain a fundamental understanding of the capabilities of Power BI.
You'll start out with seeing how you can quickly and easily gather data from a variety of sources, and then cleanse and transform that data with just a few clicks.
Next, you'll also learn how you can enhance the results by integrating disparate data sources and adding simple calculations. Then, you'll learn how to explore your data with visualizations and simple dashboards.
Finally, you'll learn what steps are necessary to keep your data up-to-date.
By the end of this Power BI tutorial, 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 1m
- Getting Acquainted with Power BI 1m
- Creating Datasets from Data Models and Data Files 1m
- Demo: Getting Started with Power BI 2m
- Using Quick Insights to Explore a Dataset 2m
- Demo: Using Quick Insights 4m
- Viewing Reports 1m
- Demo: Viewing Reports in Power BI 4m
- Exploring a Dashboard 1m
- Demo: Exploring a Dashboard 4m
- History of Power BI 3m
- Choosing a Development Tool 0m
- Using Excel 1m
- Demo: Using Excel 2016 3m
- Using Power BI Desktop 1m
- Demo: Using Power BI Desktop 1m
- Summary 1m
- Getting Data 1m
- Databases 3m
- Demo: Getting Data from Databases Using Power BI Desktop 2m
- Demo: Getting Data from Databases (Excel) 2m
- Files 0m
- Demo: Getting Data from Files Using Power BI Desktop 3m
- Demo: Getting Data from Files Using Excel 1m
- Web and Other Sources 1m
- Demo: Getting Data from the Web 2m
- Azure and Software as a Service 1m
- Manual Entry 0m
- Demo: Adding Data Manually Using Power BI 1m
- Demo: Adding Data Manually Using Excel 1m
- Summary 1m
- Transforming Data 1m
- Renaming Queries 0m
- Demo: Renaming Queries 2m
- Combining Queries: Append 1m
- Demo: Appending Queries Using Power BI 3m
- Demo: Appending Queries Using Excel 1m
- Fixing Metadata 1m
- Demo: Fixing Metadata Using Power BI 3m
- Demo: Fixing Metadata (Excel) 1m
- Filtering Rows 0m
- Demo: Filtering Rows 1m
- Eliminating Columns 0m
- Demo: Eliminating Columns 3m
- Combining Queries: Merge 1m
- Demo: Merging Queries 4m
- Adding a Column 1m
- Demo: Adding Columns by Splitting Text 2m
- Demo: Adding Columns by Splitting XML 3m
- Demo: Adding Columns for Sorting 3m
- Summary 1m
- Modeling Data for Analysis 1m
- Creating Relationships 2m
- Demo: Creating Relationships Using Power BI Desktop 6m
- Demo: Creating Relationships Using Excel 3m
- Defining New Columns 1m
- Concatenating Columns 1m
- Demo: Concatenating Columns Using Power BI Desktop 5m
- Demo: Concatenating Columns Using Excel 2m
- Performing a Lookup to a Related Table 1m
- Demo: Using the Related Function 2m
- Translating a Value 1m
- Demo: Using the If Function 5m
- Adding a Date Table 1m
- Demo: Adding a Date Table in Power BI Desktop 4m
- Demo: Adding a Date Table in Excel 2016 0m
- Summary 1m
- Enhancing Data Models 1m
- Defining Hierarchies 0m
- Demo: Defining Hierarchies in Power BI Desktop 1m
- Demo: Defining Hierarchies in Excel 1m
- Configuring Properties 1m
- Demo: Configuring Properties in Power BI Desktop 2m
- Demo: Configuring Properties in Excel 1m
- Demo: Configuring Properties: Data Categories 1m
- Demo: Configuring Properties: Formatting & Default Summarization 1m
- Defining New Measures 1m
- Demo: Defining Customer Count & Pct of Total Customers 6m
- Demo: Defining Total Sales & Previous Year Sales 5m
- Summary 1m
- Visualizing Data 1m
- Adding Visuals 2m
- Demo: Adding a Table, Clustered Column Chart, & Bar Chart 5m
- Demo: Adding a Map, Card, and Matrix 4m
- Demo: Adding a New Page, Column Chart, Filled Map, and KPI 3m
- Demo: Adding Visuals Using Excel 5m
- Filtering 1m
- Demo: Filtering In Power BI Desktop 2m
- Demo: Filtering in Excel Power View 2m
- Slicer Filtering 0m
- Demo: Slicer Filtering in Power BI Desktop 1m
- Demo: Slicer Filtering in Excel Power View 1m
- Highlighting 1m
- Demo: Highlighting 2m
- Setting Properties 0m
- Demo: Setting Properties in Power BI Desktop 3m
- Demo: Setting Properties in Excel Power View 1m
- Drilling Within a Hiearchy 0m
- Demo: Drilling in Power BI Desktop 3m
- Demo: Drilling in Excel Power View 2m
- Summary 1m
Course FAQ
Power BI is Microsoft's business analytics service that provides interactive data visualizations and business intelligence (BI) capabilities. Run reports and build custom dashboards to get insights based on your company's data.
Some features of Power BI include:
- Delivering insights at scale
- Works with Azure data and analytics
- Hundreds of data visualizations
- Built-in AI capabilities
- Prebuilt & custom data connectors
- Data loss prevention capabilities
This Power BI tutorial will introduce you to Power BI, covering such topics as:
- Viewing reports in Power BI
- Getting data from databases, files, and the web
- Cleaning and transforming data
- Working with queries, rows, and columns
- Modeling data for analysis
- Creating relationships using Power BI Desktop
- Enhancing, visualizing, and refreshing the data
- Much more
Anyone who wants to learn Power BI for effective data analysis and visualization. If you want to acquire, transform, and enhance data and produce helpful reports and dashboards, then this Power BI tutorial is perfect for you.
Nope! You don't need to have any programming or other special skills before taking this course. If you've ever worked in a spreadsheet to some extent, then you're ready for this basic Power BI tutorial.