© 2018 Daxel. Proudly created with Wix.com

TRAINING

 
Power BI - Introduction

Master the Power BI Service environment and create an interactive report with Power BI Desktop

Power BI Service

  • Interact with data and reports

  • Build dashboards

  • Share within the organization

 

Power BI Desktop

  • Transform imported data

  • Define relationships

  • Create measures

  • Create interactive visualizations

Power BI Introduction Course Outline

 

 

600$ 1 day workshop (9h-16h)

Where: 123 Slater street, Ottawa ON  K1P 5G4

Groups are limited to 6 participants to ensure a personalized quality training.

Power bi Introduction solution EN - Clic
 
Power BI - Intermediate

Master the Power BI Service environment and create an interactive report with Power BI Desktop.

Broaden your skills with Power Query and DAX language to build more complex data models.

 

Day 1

Introduction Course content

Day 2

Build queries with Power Query Editor

  • Connect to multiple data sources

  • Refine, transform, merge and append data

  • Generate a date table

 

Create and use measures

  • Explore DAX functions: COUNT, COUNTBLANK, SUM, SUMX, FILTER, CALCULATE, ALL, DIVIDE, IF, USERELATIONSHIP, TOTALYTD, FORMAT and others

  • Use variables and parameters

 

1000$ 2-day training (9AM - 4PM)

Where: 123 Slater street, Ottawa ON  K1P 5G4

Groups are limited to 6 participants to ensure a personalized quality training.

 
Excel / Power Pivot

Create data models and realize powerful analysis

Morning – Power Pivot, that easy

  • Import data sources (Power Query)

  • Create reports and visualizations (Power Pivot, Power View)

 

Afternoon – Power Pivot, the reality

  • Connect to data sources

  • Clean and model data (Power Query)

  • Create measures and more complex reports (Power Pivot)

 

600$ day training (9AM - 4PM)


Where: 123 Slater street, Ottawa ON  K1P 5G4

Groups are limited to 6 participants to ensure a personalized quality training.

 
Customized Training and Coaching

A private training session customized to your business reality

Day 1 - The basic in Power BI or Excel / Power Pivot

  • Manage data through a data model

  • Create indicators and visualizations

  • Apply the notions to fictive data models

 

Day 2 – Your data, your analysis

  • Import and model your data

  • Create visualizations and indicators relevant to your field

Groups are limited to 6 participants to ensure a personalized quality training.

Training can be divided into 4 half days for optimized learning.