Analyzing Data with Power BI (DA-100)

This course will discuss the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will also show how to access and process data from a range of data sources including both relational and non-relational data. This course will also explore how to implement proper security standards and policies across the Power BI spectrum including datasets and groups. The course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution. Finally, this course will show how to build paginated reports within the Power BI service and publish them to a workspace for inclusion within Power BI.


The audience for this course are data professionals and business intelligence professionals who want to learn how to accurately perform data analysis using Power BI. This course is also targeted toward those individuals who develop reports that visualize data from the data platform technologies that exist on both in the cloud and on-premises.


In addition to their professional experience, students who take this training should have technical knowledge equivalent to the information found in the Azure Fundamentals course.



  • The Power BI Portfolio
  • Identifying Tasks of the Data Analyst
  • Lab : Getting Started

Getting and Profiling Data

  • Data Sources
  • Storage Modes
  • Query Performance
  • Data Profiling
  • Lab : Preparing Data in Power BI Desktop

Cleaning and Transforming Data

  • User-Friendliness
  • Combining Queries
  • Data cleaning and transformation
  • Advanced capabilities
  • Configuring data loading and resolving errors
  • Lab : Loading Data in Power BI Desktop

Designing a Data Model

  • Data modeling basics
  • Measures and Dimensions
  • Model Performance
  • Lab : Data Modeling in Power BI Desktop

Developing a Data Model

  • Common data modeling techniques
  • Adding columns to support the data model
  • Row-level security
  • Q&A considerations
  • Lab : Advanced Data Modeling

Creating Model Calculations with DAX

  • Introduction to DAX
  • Creating tables and columns
  • Measures
  • The CALCULATE expression
  • Time-Intelligence functions
  • Lab : Using DAX in Power BI – Part 1
  • Lab : Using DAX in Power BI – Part 2

Optimizing Model Performance

  • Fine-tune the data model
  • Cardinality
  • Identifying performance issues

Creating Reports

  • Selecting a visualization
  • Configuring visualizations
  • Formatting pages
  • Enhancing the report
  • Lab : Designing a report in Power BI Desktop – Part 1

Enhancing Reports for Usability and Performance

  • Bookmarks and navigation
  • Designing cohesive pages and interactions
  • Improving reports
  • Lab : Designing a report in Power BI Desktop – Part 2

Creating Dashboards

  • Dashboard design
  • Real-time dashboards
  • Dashboard enhancements
  • Lab : Creating a Power BI Dashboard

Enhancing Reports and Applying Advanced Analytics

  • Navigation
  • Basic analysis
  • Grouping, binning, and clustering
  • Analysis over time
  • Advanced analysis
  • Lab : Data Analysis in Power BI Desktop

Managing and Sharing Power BI Assets

  • Dataset management
  • Enhancing datasets
  • Configure row-level security
  • Create and Manage workspaces
  • Enhancing datasets and reports in the workspace
  • Sharing and distributing content
  • Lab : Publishing and Sharing Power BI Content

Working with Paginated Reports in Power BI

  • Introduction to Paginated Reports
  • Data sources and datasets
  • Adding visual elements
  • Enhancing and publishing reports
  • Lab: Creating a Paginated report

26 — 29 Jul 2021

Laboral — 09:30h/17:30h

28 horas — 4 dias

Live Training - Inclui Exame



Your message was successful sent.



We use cookies to offer you a better browsing experience, analyse site traffic, presonalize content, and serve targeted ads. Read how we use cookies and how you can control them in our “Cookie Settings”.
By using our site, you consent to our use of cookies.

> Cookie Settings

√ Accept Cookies