Events

Cd003 - Power BI, design dashboards

Communication
Innovation
Standard
Self-confidence
Design
Organization
Data
IT

mon. 8 Mar.

tue. 9 Mar.

wed. 10 Mar.

thu. 11 Mar.

Power BI, Microsoft's Data Visualization solution, allows you to create rich and interactive dashboards thanks to the multiple graphic elements it offers.
educational goals

Connect, query and combine heterogeneous data sources
Model and prepare your data
Create and format reports with Power BI Desktop
Designing measures with the DAX language
Explore Power BI Online services

Introduction
Get the data

Extract, transform, and load data into Power BI.
Use flat files, Excel, relational databases, SSAS sources, Web.
Choose columns, choose rows, filter, sort and remove duplicates.

Transform data

Clean and complete the datasets.
Split columns, format and set data type, assemble and merge tables.
Create calculated columns. Stack and merge queries.

Define the data model

Use the Diagram View to define relationships between tables.
Design measures with statistical functions.
DAX functions to design sophisticated measurements: CALCULATE, ALL, ALLEXCEPT, FILTER, RANKX etc.
Use DAX Time Intelligence functions.

Power BI report design

Creation of reports, pages, dashboards.
Display data: Table, Matrix, Map.
Use data and formatting settings.
Insert visual elements. Use cartographic visualizations.
Import visual elements (.pbviz) from the gallery: gauges, images etc.
Add filtering tools, segments, KPIs. Layout for screen or smartphone.

Power BI Online service overview

Presentation of the features of the Power BI service, storage, presentation, sharing.
Pin visualizations to a dashboard.
Overview of report design with the Power BI service.
What datasets in Power BI?