Power BI and types of analytics

DP-900 · Analytics workloads on Azure · Updated

Understand the four analytics types, the Power BI workflow of datasets, reports and dashboards, and the basics of data modelling and charts.

This lesson is part of full DP-900 access

The first 2 DP-900 lessons are free. Full access opens every lesson with its practice questions, and the exam-style DP-900 question bank.

In this lesson
  • Four types of analytics
  • Power BI building blocks
  • Data modelling
  • Choosing a visual
  • Exam traps
  • Practice questions

Get full access Try the free practice exam Log in

DP-900 course outline

All 8 lessons · Course overview
  1. Structured, semi-structured and unstructured dataCore data concepts Free
  2. Data roles, OLTP and analytical workloadsCore data concepts Free
  3. ACID, SQL statement types and relational objectsRelational data on Azure Full access
  4. Azure SQL family and open-source databasesRelational data on Azure Full access
  5. NoSQL data store typesNon-relational data on Azure Full access
  6. Azure Cosmos DB and Azure StorageNon-relational data on Azure Full access
  7. Analytics services on Azure and Microsoft FabricAnalytics workloads on Azure Full access
  8. Power BI and types of analyticsAnalytics workloads on Azure Full access