​Analyzing Data with Power BI (20778) 
Cours disponible en français ou en anglais - Training available in French or in English

Duration: 3 days 

Objectives : 
After completing this course, students will be able to:
  • Import data into Power BI
  • Describe Power BI desktop modelling
  • Create a Power BI desktop visualization
  • Implement the Power BI service
  • Describe how to connect to Excel data
  • Describe how to collaborate with Power BI data
  • Describe connectivity options using Power BI
  • Describe the Power BI developer API
  • Describe the Power BI mobile app
 
Course Details : 
Module 1 : Power BI Desktop Data Transformations
  • What is Power BI?
  • Power BI data
  • Transformations
    • Import Data to Power BI
    • Import data to Power BI desktop
    • Import data from CSV files
    • Import data from a less structured file
Module 2 : Power BI Desktop Modeling
  • Optimizing data models
  • Calculations
  • Hierarchies
    • Manage Power BI data
    • Manage table relationships
    • Last year comparison
    • Year to date
    • Market share
    • Optimize the data model
Module 3 : Power BI Desktop Visualization
  • Visualizing your data
  • Working with multiple visualizations
    • Create reports with visualizations
    • Cross-tabular reports
    • Part-to-Whole reports
    • Relationship reports
    • Trend reports
    • Rank reports
Module 4 : Power BI Service
  • Working with the Power BI service
  • Configuring a dashboard
  • Viewing a Power BI Dashboard
    • Implementing the Power BI service
    • Upload a Power BI report
    • Share a Power BI dashboard
    • Configure data refresh
Module 5 : Working with Excel
  • Importing data from excel
  • Analyzing data in Excel
    • Working with Excel
    • Uploading an Excel file with an Excel table
    • Uploading an Excel file with a data model
Module 6: Organization Content Packs, Security, and groups
  • Collaboration
  • Content packs
    • Working with Organization Content Packs
    • Create a content pack
    • Edit a content pack
    • Share a content pack
Module 7 : Direct Connectivity
  • Cloud data
  • Connecting to analysis services
    • Direct Connectivity
    • Direct connectivity from Power BI desktop
    • Direct connectivity from the Power BI service
Module 8 : Developer API
  • The developer API
  • Custom visuals
    • Using the developer API
    • Using custom visuals
Module 9 : Power BI mobile app
  • The Power BI mobile app
  • Using the Power BI mobile app
  • Power BI embedded

 
Requirements : 
In addition to their professional experience, students who attend this training should already have the
following technical knowledge:
  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Basic knowledge of data warehouse schema topology (including star and snowflake schemas).
  • Some exposure to basic programming concepts (such as looping and branching).
  • An awareness of key business priorities such as revenue, profitability, and financial accounting is
  • desirable.
  • Familiarity with Microsoft Office applications – particularly Excel.