Power BI           

Overview

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 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.

Course Content   
  • Overview of Power BI Desktop

  • Data Sources in Power BI Desktop

  • Connecting to a data Source

  • Query Editor in Power BI

  • Clean and Transform your data with Query Editor

  • Combining Data - Merging and Appending

  • Cleaning irregularly formatted data

  • Views in Power BI Desktop

  • Modeling Data

  • Manage Data Relationship

  • Cross Filter Direction

  • Create calculated tables and measures

  • Optimizing Data Models

  • Data Analysis Expressions (DAX)

  • Data Visualization

  • Introduction to Power BI Service

  • Dashboard vs. Reports

  • Quick Insights in Power BI

  • Creating and Configuring Dashboards

  • Power BI embedded

  • Direct Connectivity

  • Power BI Report Servers

  • Advanced Analytics in Power BI using R & Python

1/5