Advanced search

M20778 Analyzing Data with Power BI Print

This 3-day instructor led course is intended for anyone responsible to perform data analysis and reporting using Power BI. The course includes data import and transformation, data model creation and modification, use of DAX language for computing, visualization creation, publication, configuration and use of the Power BI service, including the Power BI Mobile application. The course uses Power BI Desktop, PowerBI.com and Power BI Report Server.

Accredited course for Continuing Education of Pedagogical Staff

Course length: 3 days

Dates

DatePlaceLanguagePrice (without VAT)Availability
01/27/2020 - 01/29/2020 Prague cs 21 000 CZK Free date
03/09/2020 - 03/11/2020 Prague cs 21 000 CZK Free date
04/06/2020 - 04/08/2020 Prague cs 21 000 CZK Free date
05/04/2020 - 05/06/2020 Prague cs 21 000 CZK Free date
05/25/2020 - 05/27/2020 Prague cs 21 000 CZK Free date
PDF to download Expand allCollapse all
  • Students will be able to

    • Perform Power BI desktop data transformation.
    • 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.
    • Connect directly to data stores.
    • Describe the Power BI developer API.
    • Describe the Power BI mobile app.
    • Install and use Power BI Server
  • Course requirements

    • Basic knowledge of the Microsoft Windows operating system
    • Basic knowledge of Microsoft Excel
    • Working knowledge of relational databases
  • This course is intended for

    • This course is intended for anyone responsible for analyzing data.
    • The course will likely be attended to report creators who are interested in alternative methods of presenting data using Power BI.
  • Literature

    All participants will get original Microsoft student materials.

  • Hardware

    Classrooms are equipped with high-performance computers with Internet access and the possibility of wireless connection.

  • Syllabus

    Module 1: Power BI Desktop Data Transformations

    • Lesson 1: What is Power BI?
    • Lesson 2: Power BI data
    • Lesson 3: Transformations
    • Lab: Import Data to Power BI

    Module 2: Power BI Desktop Modeling

    • Lesson 1: Optimizing data models
    • Lesson 2: Calculations
    • Lesson 3: Hierarchies
    • Lab: Manage Power BI data

    Module 3: Power BI Desktop Visualization

    • Lesson 1: Visualizing your data
    • Lesson 2: Working with multiple visualizations
    • Lab: Create reports with visualizations

    Module 4: Power BI Service and Power BI Server

    • Lesson 1: Working with the Power BI service
    • Lesson 2: Configuring a dashboard
    • Lesson 3: Viewing a Power BI Dashboard
    • Lesson 4: Power BI Server
    • Lab: Implementing the Power BI service

    Module 5: Working with Excel

    • Lesson 1: Importing data from excel
    • Lesson 2: Analyzing data in Excel
    • Lab: Working with Excel

    Module 6: Organization Content Packs, Security, and groups

    • Lesson 1: Collaboration
    • Lesson 2: Content packs
    • Lab: Working with Organization Content Packs

    Module 7: Direct Connectivity

    • Lesson 1: Cloud data
    • Lesson 2: Connecting to analysis services
    • Lab: Direct Connectivity

    Module 8: Developer API

    • Lesson 1: The developer API
    • Lesson 2: Custom visuals
    • Lab: Using the developer API

    Module 9: Power BI mobile app

    • Lesson 1: The Power BI mobile app
    • Lesson 2: Using the Power BI mobile app
    • Lesson 3: Power BI embedded
  • Dependencies

    Business Intelligence

    Business Intelligence

    SQL Server

    SQL Server
OKsystem a.s.
We use cookies to optimize site functionality and deliver best results based on your interests.