Enterprise Database Systems
Data Analytics with Microsoft Power BI
Data Analytics using Power BI: Concepts
Data Analytics Using Power BI: Data Modeling and Visualization
Data Analytics Using Power BI: Data Sourcing and Preparation

Data Analytics using Power BI: Concepts

Course Number:
df_mpbi_a01_it_enus
Lesson Objectives

Data Analytics using Power BI: Concepts

  • start the course
  • describe the purpose of business intelligence
  • determine what data is telling you
  • describe how data visualizations can convey meaningful messages
  • use self-provisioning to work with Power BI
  • define Excel functionality related to Power BI
  • recognize Power BI capabilities
  • explain what the Power BI cloud service is used for
  • create a personal Power BI service account
  • explain what Power BI desktop is used for
  • install Power BI Desktop
  • use mobile device apps to interact with Power BI dashboards and reports
  • install the Power BI app on Windows 10
  • determine which region your Power BI tenancy exists in
  • recognize when to use Power BI groups
  • describe Power BI concepts and establish data sources

Overview/Description
Business intelligence boils down to knowing how to manage data to draw conclusions from otherwise meaningless information.

Target Audience
IT technicians and business analysts who need to analyze data utilizing Power BI

Data Analytics Using Power BI: Data Modeling and Visualization

Course Number:
df_mpbi_a03_it_enus
Lesson Objectives

Data Analytics Using Power BI: Data Modeling and Visualization

  • start the course
  • recognize when to use Data View in Power BI Desktop
  • recognize when to use Relationship View in Power BI Desktop
  • navigate through Desktop View in Power BI Desktop
  • navigate through Relationship View in Power BI Desktop
  • explain the purpose of DAX, including syntax
  • create a DAX measure formula
  • define how visualization can quickly convey messages from large datasets
  • explain how KPIs are used to measure progress
  • explain how to work with and create reports
  • create a report in Power BI
  • explain how dashboards can be used to monitor data at a glance
  • create a custom Power BI dashboard
  • share a Power BI dashboard with other users
  • filter visualizations using slicers
  • ensure data is in a form usable by Power BI for querying and visualization

Overview/Description
Data must sometimes be modeled for use in analytic software such as Power BI. This can reveal patterns and relationships that can be conveyed in a quick and compact form using visualizations.

Target Audience
IT technicians and business analysts who need to analyze data utilizing Power BI

Data Analytics Using Power BI: Data Sourcing and Preparation

Course Number:
df_mpbi_a02_it_enus
Lesson Objectives

Data Analytics Using Power BI: Data Sourcing and Preparation

  • start the course
  • describe where Power BI data comes from
  • recognize how Power BI can use data from files
  • recognize how Power BI can use data from databases
  • recognize how Power BI can use data from online sources
  • use Quick Insights in the Power BI Service to quickly generate interactive data visualizations
  • import a file data source into Power BI
  • import a database data source into Power BI
  • import a web URL data source into Power BI
  • recognize the purpose of the Power BI Gateway
  • configure the Power BI on-premises Gateway
  • describe why data in its raw form is sometimes not suitable for use with Power BI
  • determine when the use of queries is appropriate
  • recognize when data should be combined
  • explain how row values can be grouped together and how rows can be filtered out to remove unnecessary data
  • create an append query
  • create a merge query
  • filter out rows that are unnecessary
  • create a calculated column
  • ensure data is in a form usable by Power BI for querying and visualization

Overview/Description
Power BI can draw data from numerous file, database and web sources. Data must sometimes be transformed for use in analytic software such as Power BI.

Target Audience
IT technicians and business analysts who need to analyze data utilizing Power BI

Close Chat Live