Architecture & Technologies

Power BI

PowerBI

Duration

2 Days

Languages

French - English

Trainer(s)

Architecture & Technologies Consultant

Power BI is a suite of business analytics tools that delivers information from massive data across your organization. Astrakhan’s training program will help you to better understand the key benefits and analytical applications of Power BI, empower business teams and increase data feasibility, enhance the creativity and innovation of business teams, publish and share information, reduce the involvement of IT teams in business problems and be more efficient, optimize the creation and updating of dashboards and finally accelerate data-driven decisions.

Target audience

  • Business Teams
  • IT Teams

Prerequisites

  • The PowerBI application must be installed on the learners’ computers​

Fonctionnement

On site, in your offices

A distance via Teams

Workshops

Training Program

Introduction

  • Day 1: Objectives of the training

Overview

  • Power BI… What is it?
  • Quick overview of Power BI solutions
  • Overview of Power BI Desktop
  • Power BI DesktopSupport
  • Power BI use cases

Data Collection

  • Welcome to Power BI Desktop
  • Getting data
  • Connection to csv/Excel data sources
  • Connection to BOOST
  • Connection to BOOST data sources

Data processing – Cleaning and transformation of your data

  • Why process the collected data?
  • Data cleansing and transformation
  • More advanced data sources and transformations
  • Cleaning of unformatted data 

Data processing – Modeling

  • Presentation of data modeling
  • Management of the relationships between your data
  • Creation of calculated columns
  • Optimization of data models
  • Creation of calculated measures
  • Creation of calculated tables
  • Explore your temporal data

Conclusion

  • Summary of the training day
  • Key takeaways

Introduction

  • Day 2: Objectives of the training
  • Data visualization sequence – Summary

Visualizations

  • Presentation of visual elements in Power BI
  • Workshop “Create your first visualization”
  • Matrices and tables
  • Scatter plots, pie charts and tree maps
  • Gauges and single number cards
  • Segments, hierarchical axis and concatenation
  • Visualization of the map
  • Waterfall and funnel charts
  • Workshop “Create and customize simple visualizations”
  • Workshop “Combination charts”

Power BI and Microsoft tools

  • Overview of the use of Excel data in Power BI
  • Loading Excel data into Power BI
  • Workshop “Connection to an Excel spreadsheet on OneDrive Enterprise”

Reports and dashboards

  • Overview of dashboards and services
  • Quick overview
  • Workshop “Dashboard configuration”
  • Adding text boxes and image widgets
  • Workshop “Filters”

Reports and dashboards

  • Export to CSV and Excel
  • Workshop “Sharing dashboards with members of your organization”
  • Workshop “Web Publishing”
  • View visual elements and thumbnails in full screen mode
  • Edit thumbnail details and widgets
  • Manage your dashboard storage
  • Workshop “Installation and configuration of a personal portal“
  • Workshop “Creation of a group” 

Data Mining

  • Overview of the Power BI Data Mining service
  • Workshop “Asking questions about your data in natural language”
  • Create customized Q&A suggestions

Mobile applications

  • Power BI Report Server
  • Overview of mobile applications
  • Ask questions to Power BI mobile applications

Conclusion

  • Summary of the training day
  • Key takeaways
Request a quote