The role of Power Query
Complementary tools to Power Query

Excel and csv sources
Importing an Access database

Data transformation
Splitting a column
modifying data types and transposing
Refreshing data relative to the source
Inserting or deleting rows and / or columns
Aggregating data in a column
Using the Filter, sorting and grouping of lines
Create a parameterized function in M ​​language

Merge and add
« Uncross » lists of data

Workshop: importing, transforming and combining data from external sources

Understanding PowerPivot as a Tool
Benefits and Features
Different Versions of PowerPivot
Data to Use with PowerPivot
Description of the PowerPivot Tab in Excel
Using the PowerPivot Manager
Configuring the Import of External Data
Managing the Data Imported from the PowerPivot interface

Creation of pivot tables connected to the PowerPivot
Handling of a pivot table
Use of a pivot table under the table tool
Management of the pivot table options

Using sorting and filtering
Using segments for filters
Using calculations in the PivotTable
Setting up measures (functions, ratio, spreads, progress, charts)
Using grouping and defining value slices

Lab: Generate Pivot Tables with PowerPivot from External Sources

Loading PowerPivot tables from Excel
Access to relational databases: SQL Server, Access, ODBC etc.
Managing connections and updates
Using the Diagram view
Creating relationships between tables
Managing PowerPivot settings on multi tables
Designing the display and creating perspectives
Managing multi table data from PowerPivot

DAX functions, Excel functions and calculation in the pivot table
Design calculated fields
Implement intelligent date management
Formatting data

Comparison of two workbooks
Analysis of a workbook (Structure, formula, cells, ranges, warning)
Display of links between workbooks, worksheets and cells
Clean up excess formatting to decrease file size and increase their execution speed
Password management

Introducing the tool
Converting a table to a graph
Inserting new views
Choosing a theme
Presenting data with mosaics
Creating multi-view reports
Loading data from heterogeneous sources and organizing them among themselves

Presentation of Power Map
Modifying the appearance of the map
Adding a scene
Exploitation of geographic and temporal data
Exporting the Power Map map to a video or to another application

Workshop: Presentation of data geographically

Understanding the different Power BI modules
Acquiring data with Power Query (CSV, Excel, Access)
Using Power Pivot for connecting to data and
Creating relationships
Using Power View for adding visuals
Using PowerMap for a cartographic presentation
Publication and distribution of reports