Paths
Microsoft Power BI for Analysts
Microsoft Power BI is a business intelligence suite designed to simplify the path from data to insights. This skill starts with the general end-to-end workflow using by Power BI,... Read more
What you will learn:
- The core functions and workflows of Power BI Desktop
- General mechanics of building visualizations and dashboards
- The interactions between Power BI Desktop and the Power BI service
- Most common use cases
- The basics of the DAX formula language
- The basics of the M language
- Best practices in dashboard and visualization development
- Best practices in data user management
Pre-requisites
- Data literacy
- Data analytics literacy
- Basic computer use
Beginner
Experience the workflow of creating your first simple Power BI report, and load and shape data for analysis in Power BI Desktop.
Building Your First Power BI Report
1h 37m
Description
Do you need to use Power BI and don’t know how to get started? In this course, Building Your First Power BI Report, you’ll learn how to access and explore data in a Power BI report. First, you’ll learn how to import an Excel workbook into Power BI and how to fix your data so that it is more usable for reporting. Next, you’ll discover the modeling capabilities available in Power BI to further enhance your data and improve the reporting experience. Finally, you’ll learn how to add data visualizations and static report elements to a report so that you can explore your data from multiple perspectives. When you’re finished with this course, you’ll have the skills and knowledge to create simple Power BI reports using your own data.
Table of contents
- Course Overview
- Preparing Data for Power BI
- Creating Data Models in Power BI
- Creating Reports
Power BI Data Import Playbook
1h 47m
Description
Every Power BI report starts with data, which can be housed in a multitude of ways. In this course, Power BI Data Import Playbook, you’ll learn fundamental skills for making and using connections to sources of data in your reports. First, you’ll explore how data importation fits within the context of building a simple end to end Power BI report. Then, you'll delve into other data sources starting with structured sources such as databases all the way through to unstructured ones including Excel and web data sources. Finally, you'll learn about data privacy and even get to discover how to create tables from thin air using DAX (Data Analysis Expressions). When you’re finished with this course, you’ll have the skills and knowledge of Power BI data importation needed to enable you to begin building insightful Power BI reports.
Table of contents
- Course Overview
- Understanding How Import Fits within the Power BI Model Production Process
- Connecting to Databases, Data Warehouses, SSAS Cubes, and Power BI Data Models Using Power BI
- Connecting to Databases through Direct Query
- Configuring Privacy Levels for Data Sources
- Connecting to Online Sources Using Power BI
- Connecting to SharePoint Data
- Connecting to Text and CSV Data Sources from Power BI
- Loading Data Using an R Script
- Importing Excel Data and Workbooks to Power BI
- Connecting to Web Data Sources from Power BI
- Storing and Connecting to Your Office 365 Data Files
- Using Blank Queries to Create Data Tables
- Entering Your Own Data by Hand
- Creating Tables from Thin Air
- Course Wrap Up
Power BI Data Preparation Playbook
2h 2m
Description
In order to model your data in Power BI, you need to clean it up first. In this course, Power BI Data Preparation Playbook, you will learn how to do so with Power Query. First, you’ll learn when Power Query is the right tool for the job, and how to navigate the Power Query editor. Next, you’ll explore how to add data transformation steps and access the underlying query code. Finally, you’ll discover how to fix errors and go even further using Python and R. By the end of this course, you'll feel completely comfortable using the Power Query Editor.
Table of contents
- Course Overview
- Choosing the Right Tool for the Right Job
- Navigating the Query Editor
- Adding and Removing Steps in Your Data Recipe
- Accessing the Underlying Query Code
- Fixing Errors in Your Workflow
- Extending the Query Editor with R and Python
Modeling Data in Power BI
4h 57m
Description
Data in its raw form is rarely useful for reporting and analysis. In this course, Modeling Data in Power BI, you'll learn how to use Power BI to transform raw data into meaningful insights. First, you'll learn how to gather data and apply transformations to easily blend multiple sources together, reduce the data to its most useful elements, and prepare the data for exploration. Next, you'll discover how to configure the model to support Power BI features for insightful visualizations, geospatial analysis, and natural language queries. Finally, you'll explore the basics of DAX, Power BI's expression language, to add calculations to your model. When you're finished with this course, you'll have the skills and knowledge of Power BI data modeling that you can use to build your own models that support a variety of analytical requirements and take full advantage of Power BI's capabilities.
Table of contents
- Course Overview
- Using the Query Editor to Prepare a Power BI Data Model
- Exploring Additional Techniques in the Power BI Query Editor
- Enhancing a Power BI Model with Relationships and Hierarchies
- Improving the Data Model for Reporting
- Using DAX to Enhance a Power BI Model
- Working with Dates and Time in Power BI
- Applying Evaluation Context
Intermediate
Develop complex calculated measures using DAX, and create and share more impactful reports and dashboards from your data.
Getting Started with DAX Formulas in Power BI, Power Pivot, and SSAS
2h 59m
Description
If you want to use Power BI, Power Pivot, or SSAS (tabular mode), you'll need to learn DAX. In this course, Getting Started with DAX Formulas in Power BI, Power Pivot, and SSAS, you'll learn the basics of the DAX language. First, you'll learn how DAX works and why it has such good performance. Next, you'll explore how to encapsulate business logic using calculated columns and measures. Finally, you'll discover a variety of ways to manipulate filters or analyze your data. When you're finished this course, you'll have the skills and knowledge of DAX to model and analyze your data with the DAX expression language.
Table of contents
- Course Overview
- Understanding What Makes DAX so Unique
- Planning Your Data Governance: Power BI, Power Pivot, or SSAS Tabular?
- Thinking in Columns, Not Rows
- Adding Business Logic with Calculated Columns and Measures
- Filtering Data Using CALCULATE
- Looping Over Data with Iterators
- Analyzing History with Time Intelligence
Effective Reporting with Power BI
2h 16m
Description
It has been said that "a picture is worth a thousand words". The question is as if the picture is saying what the author intends. In this course, Effective Reporting with Power BI, you will learn foundational knowledge for creating effective and engaging reports. First, you will learn how to integrate basic visualizations into a report. Next, you will discover how to enhance the visualizations to build compelling reports. Finally, you will explore how to create interactive reports and dashboards. When you're finished with this course, you will have the skills and knowledge in Power BI needed to communicate data stories through clear and compelling visualizations.
Table of contents
- Course Overview
- Guide Tour to Power BI Fundamentals
- Creating Basic Reports
- Creating Reports to Show Relationships
- Handling Unusual Data
- Implementing Key Performance Indicators
- Leveraging Interactivity in Reports
Creating Dashboards with Power BI
4h 5m
Description
So, you have cleaned your data, designed your data models, and built some reports. You’re now ready to deliver this content to users… but have you considered what dashboards have to offer? Power BI Dashboards are a unique and effective way of providing users quick and easy access to the data that is most important to them! This can be done in a way that not only enhances the reports that you have already written, but also improves the way that users interact with your reporting content. In this course, Creating Dashboards with Power BI, you will gain the ability to design, build, and deliver dashboard-based reporting solutions. First, you will understand the use-cases for dashboards, and learn how to make your report visualizations ‘dashboard ready’, whilst also learning some design principles that will help make your dashboards look clean, modern, and easy for users to read. Next, you will discover how you can go beyond standard report visualizations and enhance your dashboards with media tiles, including how you can even use custom web content to create integrations with sources outside of Power BI. Finally, you will explore how to manage and secure your dashboards, before going though the various options for sharing your new content with your users, including how to package your reports and dashboards into apps. When you're finished with this course, you will have the skills and knowledge to use Power BI Dashboards - and take your solutions all the way from initial concept, through to delivery, and beyond.
Table of contents
- Course Overview
- Creating Your First Dashboard
- Designing Dashboards for Users
- Building Dashboard Content
- Adding Media to Dashboards
- Applying Themes and Styles
- Managing Dashboards
- Understanding Data Security Behaviors in Dashboards
- Sharing and Collaborating with Dashboards
Deploying and Publishing Power BI Reports
1h 45m
Description
Power BI is an incredible business analytics tool. However, your reports are useless if you can't share them with others. In this course, Deploying and Publishing Power BI Reports, you'll cover all the different ways to efficiently publish and deploy your own Power BI reports. First, you'll learn about all the pieces that go into an app workspace. Next, you'll explore different ways to embed Power BI reports, such as in SharePoint Online or Microsoft Teams. Finally, you'll discover the best options for when you need to scale up the number of users to share with. By the end of this course, you'll have the necessary knowledge to make the right choice for deploying your Power BI reports.
Table of contents
- Course Overview
- Publishing Power BI Reports
- Sharing Reports and Dashboards
- Staging and Sharing with App Workspaces
- Embedding Reports in Intranets and Extranets
- Scaling up with Premium Capacity
- Embedding Reports in Custom Applications
- Deploying On-premises with Power BI Report Server
Common DAX Expressions and Scenarios Power BI Playbook
4h 10m
Description
As a data professional, have you ever wanted to produce an array of data objects using the DAX language? In this course, Common DAX Expressions and Scenarios Power BI Playbook, you will learn foundation skills in dimensional modelling and programming with the DAX Language in Power BI Desktop. First, you will learn the basic design principles. Next, you will discover how to write DAX code to implement the basic model framework. Finally, you will explore the DAX language and use it to extend and enhance the model. When you have completed this course, you will have the skills and knowledge needed to make your data available via a robust and flexible self service analytical interface. Software required: Power BI Desktop.
Table of contents
- Course Overview
- A Structured Approach to Power BI Design
- Creating New Text Attributes Product and Channel Dimensions
- Creating New Date Attributes Calendar and Customer Dimensions
- Creating Metrics from Aggregate Functions
- Including Calculated Metrics in a Chart or Table
- Filtering Metrics with Time Intelligent Functions
- Creating Attributes with Conditional Values
- Filtering Metrics with Conditional Values
- Applying Filter Functions
Advanced
Leverage advanced Power BI services like Quick Insights and Q&A, and apply powerful data-centric languages against your data.
Effective Quick Insights and Q&A in Power BI
3h 34m
Description
Have you ever wanted to provide a simple, self-service way for data consumers to query your data? What if they could just type a question or even just speak their question and have a useful chart or report 'magically' appear with the answer? In this course, Effective Quick Insights and Q&A in Power BI, you will gain the ability to optimize your Power BI datasets so that they will work seamlessly with the powerful Q&A and Quick Insights features. First, you will learn what these features are capable of doing when applied to a 'tidy and polished' dataset. Next, you will discover how to optimize your datasets so they will support these features. Finally, you will explore how to extend the Q&A feature to work with data stored not in the cloud, but inside your own on-premises data center. When you're finished with this course, you will have the skills and knowledge of data modeling needed to supercharge your Power BI datasets using both Q&A and Quick Insights.
Table of contents
- Course Overview
- Simplifying Data Queries with Q&A
- Simplifying Data Analysis with Quick Insights
- Optimizing Data for Q&A by Making Your Data Tidy and Polished
- Exploring Data with Q&A
- Mining Data with Minimal Effort Using Quick Insights
- Voicing Questions Using Cortana
- Enabling Q&A for an On-premises Dataset
- Migrating a Power BI Dataset to an SSAS Database
Querying and Shaping Data in Power BI Using M
2h 37m
Description
We all have to deal with semi-structured data that is scattered across multiple data sources. In this course, Querying and Shaping Data in Power BI Using M, you'll learn how the Power Query formula language known as M can automate data cleanup. First, you'll learn how to extract trapped data. Next, you'll discover how to massage and shape it. Finally, you'll explore how to work with text and date values. By the end of this course, you'll have a deeper understanding of the M language.
Table of contents
- Course Overview
- Meet M, a Macro Language for Data Prep
- Extracting Your Trapped Data
- Molding Your Data into the Right Shape
- Combining and Merging Multiple Data Sources
- Cleaning up Messy Text Values
- Manipulating Dates and Times
Leveraging Timely On-premises Data with Power BI
1h 23m
Description
Sometimes when using Power BI, you need to access fresh on-premises data. In this course, Leveraging Timely On-premises Data with Power BI, you'll learn how to implement and configure a data gateway. First, you'll discover what data gateways are. Next, you'll explore how to install and configure them. Finally, you'll learn alternate query modes for faster refreshes. When you're finished with this course, you'll have the knowledge to tie your Power BI reports to your on-premises data. Software required: Power BI Desktop.
Table of contents
- Course Overview
- Understanding How Power BI Works with On-premises Data
- Installing Data Gateways
- Administering Data Refreshes
- Enabling Real-time Data
Power BI Playbook: Securing Shared Data with Power BI
1h 7m
Description
Without the ability to effectively share and disseminate data in an organization, the true power of data analysis and visualization is left locked away. In this course, Power BI Playbook: Securing Shared Data with Power BI, you will gain fundamental knowledge to effectively share and secure data with Power BI. First, you will explore the security model and how Power BI secures data. Next, you will learn how to effectively share and distribute data. Finally, you will discover how to secure access to the shared data. When you are finished with this course, you will have the skills and knowledge needed to use Power BI the way it was meant to be used - to share data and empower your users.
Table of contents
- Course Overview
- An Overview of Power BI Security
- Granting and Denying Access to a Report
- Implementing Multi-factor Authentication for Power BI
- Securing Access to Content Using App Workspaces
- Implementing Row-level Security