Exam DA-100: Analyzing Data with Microsoft Power BI

Documentation

Homepage

Overview

Overview

Data Analysts enable businesses to maximize the value of their data assets by using Microsoft Power BI. As a subject matter expert, Data Analysts are responsible for designing and building scalable data models, cleaning and transforming data, and enabling advanced analytic capabilities that provide meaningful business value through easy-to-comprehend data visualizations. Data Analysts also collaborate with key stakeholders across verticals to deliver relevant insights based on identified business requirements.

The Data Analyst should have a fundamental understanding of data repositories and data processing both on-premises and in the cloud.

Skills Measured

  • Prepare the data (20-25%)
  • Model the data (25-30%)
  • Visualize the data (20-25%)
  • Analyze the data (10-15%)
  • Deploy and maintain deliverables (10-15%)

Getting Started

Getting Started

  1. 6/23/2020, Trainings
    DA-100 Skills Outline

Learning Paths

Prepare data for analysis
Published: 6/30/2020, Length: 3:26:00

You will explore Power Query as you learn to extract data from different data sources and choose a storage mode and connectivity type. You will learn to profile, clean, and load data into Power BI in preparation for modeling your data.

Levels: Intermediate

Roles: Data Analyst

Modules

Model data in Power BI
Published: 6/30/2020, Length: 5:31:00

Success with Power BI begins with a great data model. In this module, you will learn how to design a data model that is intuitive, high-performing, and simple to maintain. You will learn about using DAX language to create measures. Those measures will help you create a wide variety of analytic solutions. Additionally, you’ll learn how to improve performance with your Power Query data retrieval tasks.

Levels: Intermediate

Roles: Data Analyst

Modules

Visualize data in Power BI
Published: 6/30/2020, Length: 5:05:00

Power BI has extraordinary visuals that can be used on Power BI reports and dashboards. In this module, you will learn when to use which visual to solve which problem. You will also learn report design and report formatting. Additionally, you will learn how to use report navigation to tell a compelling, data-driven story in Power BI. Dashboards will help your users target report visuals to meet their specific needs. Paginated reports help you create pixel-perfect report artifacts like sales invoices, purchase orders, medical records, transaction statements, and much more.

Levels: Intermediate

Roles: Data Analyst

Modules

Manage workspaces and datasets in Power BI
Published: 6/30/2020, Length: 1:10:00

Once you have created your Power BI data sets and reports, it’s time to deploy them so the users can take advantage of all of your hard work. In this Learning Path, you will learn how to create workspaces in the Power BI service. You will deploy your Power BI artifacts here and share them to your users. You will also learn how to connect Power BI reports to on-premise data sources. Your users will appreciate seeing the latest data in your reports, so you will configure automatic refresh for your Power BI datasets. Row-level security allows you to create one report, but have users be restricted to see only the data that applies to them. This targets data to users, without having to create multiple reports.

Levels: Intermediate

Roles: Data Analyst

Modules

Data analysis in Power BI
Published: 6/30/2020, Length: 1:52:00

Report authors can use additional features to enhance their reports for analytical insights in their data with features like Q&A and exporting. In this module, you will closely examine your data and Power BI reports and then extract value with deeper analysis. Additionally, you will learn how to sort data and how to present the report in a cohesive manner. You will learn how to get a statistical summary for your data and export data from Power BI. You will also apply and perform advanced analytics on the report for deeper and more meaningful data insights.

Levels: Intermediate

Roles: Data Analyst

Modules

Get started with Microsoft data analytics
Published: 6/30/2020, Length: 1:10:00

Businesses need data analysis more than ever. In this learning path, you will learn about the life and journey of a data analyst, the skills, tasks, and processes they go through in order to tell a story with data so trusted business decisions can be made. You will learn how the suite of Power BI tools and services are used by a data analyst to tell a compelling story through reports and dashboards, and the need to true BI in the enterprise.

Levels: Intermediate

Roles: Data Analyst

Modules