Uddannelse

Kursuskalender

SQL 2016

Analyzing Data with Power BI

Module 1: Power BI Desktop Data Transformations

This module describes how to import fata into Power BI.

Lessons

  • What is Power BI?
  • Power BI data
  • Transformations

Lab : Import Data to Power BI

  • Import data to Power BI desktop
  • Import data from CSV files
  • Import data from a less structured file

After completing this module, students will be able to:

  • Describe what Power BI is and what it does.
  • Describe the types of data.
  • Perform data transformations.

Module 2: Power BI Desktop Modeling

This module introduces Power BI desktop modeling.

Lessons

  • Optimizing data models
  • Calculations
  • Hierarchies

Lab : Manage Power BI data

  • Manage table relationships
  • Last year comparison
  • Year to date
  • Market share
  • Optimize the data model

After completing this module, students will be able to:

  • Optimize data models.
  • Perform calculations with Power BI data.
  • Describe and create hierarchies.

Module 3: Power BI Desktop Visualization

At the end of this module students will be able to create a Power BI desktop visualization.

Lessons

  • Visualizing your data
  • Working with multiple visualizations

Lab : Create reports with visualizations

  • Cross-tabular reports
  • Part-to-Whole reports
  • Relationship reports
  • Trend reports
  • Rank reports

After completing this module, students will be able to:

  • Visualize data using Power BI
  • Work with multiple visualizations.

Module 4: Power BI Service

This module describes how to implement the Power BI service.

Lessons

  • Working with the Power BI service
  • Configuring a dashboard
  • Viewing a Power BI Dashboard

Lab : Implementing the Power BI service

  • Upload a Power BI report
  • Share a Power BI dashboard
  • Configure data refresh

After completing this module, students will be able to:

  • Work with the Power BI service.
  • Configure a Power BI dashboard.
  • View a Power BI dashboard.

Module 5: Working with Excel

This module describes how to connect to Excel as a source of data.

Lessons

  • Importing data from excel
  • Analyzing data in Excel

Lab : Working with Excel

  • Uploading an Excel file with an Excel table
  • Uploading an Excel file with a data model

After completing this module, students will be able to:

  • Import data from excel.
  • Analyze data in Excel.

Module 6: Organization Content Packs, Security, and groups

This module describes how to collaborate with Power BI data.

Lessons

  • Collaboration
  • Content packs

Lab : Working with Organization Content Packs

  • Create a content pack
  • Edit a content pack
  • Share a content pack

After completing this module, students will be able to:

  • Share data for collaborative purposes.
  • Create, edit, and share content packs.

Module 7: Direct Connectivity

This module describes various connectivity options using Power BI.

Lessons

  • Cloud data
  • Connecting to analysis services

Lab : Direct Connectivity

  • Direct connectivity from Power BI desktop
  • Direct connectivity from the Power BI service

After completing this module, students will be able to:

  • Access data in SQL Azure.
  • Connect to SQL Server Analysis Services.

Module 8: Developer API

This module describes the developer API within Power BI.

Lessons

  • The developer API
  • Custom visuals

Lab : Using the developer API

  • Using custom visuals

After completing this module, students will be able to:

  • Describe the developer API.
  • Use the developer API to create custom visuals.

Module 9: Power BI mobile app

This module describes the Power BI mobile app.

Lessons

  • The Power BI mobile app
  • Using the Power BI mobile app
  • Power BI embedded

After completing this module, students will be able to:

  • Describe the Power BI mobile app.
  • Download and use the Power BI mobile app.
  • Describe Power BI embedded and when you would want to use it.

Kursusnr.: SEG20778      Kursets varighed: 3.0 dage.      Pris: 9600,- kr.

Tilbage Tilmelding til onlinekursus på mail@segment.dk

Forside

Uddannelse

Konsulenter

Links

Om Segment

Kursusbetingelser

Referencer

Vores certificeringer

Vi tilbyder

Freelance konsulent

Gratis kursusdage hos Segment

Pearson Vue Test Center

Segment og de sociale medier…

SEGMENT ApS  -  Stamholmen 153, 5.  -  2650 Hvidovre  -  T 70 27 23 26  -  mail@segment.dk

Segment - en del af dit netværk