Presentation of the Microsoft BI offer.
The Power BI Suite: Power BI Desktop, the Power BI service and Power BI Mobile applications.
Define the objectives of the analysis
Clarify the concepts of relational databases

Use flat files as a data source (Excel, CSV, Text)
Use a relational database as a source
Choose columns and rows to keep
Manage errors
Filter, sort and remove duplicates
Combine data tables with merge or addition
Split, merge
Create calculated columns
Workshop: Import data and make it usable by the data model

Format and define the data type, assemble and merge tables
Use the Diagram view to define relationships between tables
Design measures with statistical functions
Use the main DAX functions (SUM, COUNTA, RELATED, IF, etc.)
DAX functions to design elaborate measures (CALCULATE, ALL, FILTER, DISTINCT…)
Create a Calendar table
Create an empty table in the data model
Use the DAX Time Intelligence functions (DATESYTD, TODAY…)
Workshop: Create a data model and perform calculations

Create reports, pages, dashboards
Display data in Tables, Matrices, Maps and charts
Modify calculations on data in a matrix
Manage interactions between visual elements
Use data and formatting parameters
Insert visual elements
Operate cartographic visualizations
Import and use visual elements (gauges, images, etc.)
Add filtering tools, segments, KPIs
Layout for screen or smartphone
Workshop: Design a visual and interactive dashboard and format the data

Power BI service functionality
overview , storage, presentation, sharing Pin visualizations to a dashboard
Report design overview with the Power BI service
Publish the report to a PDF
Create a Power BI file as a template (.pbit)
Interact with Microsoft Teams
Workshop: creation of an online report then consultation, use and sharing of published reports