MOC 20778 - Analyzing Data with Power BI

Customized Onsite Training

3
Days
  • Customized Content
  • For Groups of 5+
  • Online or On-location
  • Expert Instructors

Live Online Training

$1,425.00
or 3 vouchers
  • Expert Instructors
  • Guaranteed to Run
  • 100% Free Re-take Option
  • 1-minute Video

Upcoming Classes

  • See More Classes

Please select a class.
Overview

The main purpose of this 3-day Analyzing Data with Power BI training class is to give students a good understanding of data analysis with Power BI. The course includes creating visualizations, the Power BI Service, and the Power BI Mobile App.

The course will likely be attended by SQL Server report creators who are interested in alternative methods of presenting data.

Goals
  1. Learn to perform Power BI desktop data transformation.
  2. Learn to describe Power BI desktop modelling.
  3. Learn to create a Power BI desktop visualization.
  4. Learn to implement the Power BI service.
  5. Learn to describe how to connect to Excel data.
  6. Learn to describe how to collaborate with Power BI data.
  7. Learn to connect directly to data stores.
  8. Learn to describe the Power BI developer API.
  9. Learn to describe the Power BI mobile app.
Outline
  1. Power BI Desktop Data Transformations
    1. What is Power BI?
    2. Power BI data
    3. Transformations
    4. Lab: Import Data to Power BI
      1. Import data to Power BI desktop
      2. Import data from CSV files
      3. Import data from a less structured file
  2. Power BI Desktop Modeling
    1. Optimizing data models
    2. Calculations
    3. Hierarchies
    4. Lab: Manage Power BI data
      1. Manage table relationships
      2. Last year comparison
      3. Year to date
      4. Market share
      5. Optimize the data model
  3. Power BI Desktop VisualizationAt the end of this module students will be able to create a Power BI desktop visualization.Lessons
    1. Visualizing your data
    2. Working with multiple visualizations
    3. Lab: Create reports with visualizations
      1. Cross-tabular reports
      2. Part-to-Whole reports
      3. Relationship reports
      4. Trend reports
      5. Rank reports
  4. Power BI Service
    1. Working with the Power BI service
    2. Configuring a dashboard
    3. Viewing a Power BI Dashboard
    4. Lab: Implementing the Power BI service
      1. Upload a Power BI report
      2. Share a Power BI dashboard
      3. Configure data refresh
  5. Working with Excel
    1. Importing data from excel
    2. Analyzing data in Excel
    3. Lab: Working with Excel
      1. Uploading an Excel file with an Excel table
      2. Uploading an Excel file with a data model
  6. Organization Content Packs, Security, and groups
    1. Collaboration
    2. Content packs
    3. Lab: Working with Organization Content Packs
      1. Create a content pack
      2. Edit a content pack
      3. Share a content pack
  7. Direct Connectivity
    1. Cloud data
    2. Connecting to analysis services
    3. Lab: Direct Connectivity
      1. Direct connectivity from Power BI desktop
      2. Direct connectivity from the Power BI service
  8. Developer API
    1. The developer API
    2. Custom visuals
    3. Lab: Using the developer API
      1. Using custom visuals
  9. Power BI mobile app
    1. The Power BI mobile app
    2. Using the Power BI mobile app
    3. Power BI embedded
Class Materials

Each student in our Live Online and our Onsite classes receives a comprehensive set of materials, including course notes and all the class examples.

Class Prerequisites

Experience in the following is required for this SharePoint class:

  • Excellent knowledge of relational databases and reporting.
  • Some basic knowledge of data warehouse schema topology (including star and snowflake schemas).
  • Some exposure to basic programming constructs (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.
Prerequisite Courses

Courses that can help you meet these prerequisites:

Preparing for Class

No cancelation for low enrollment

Certified Microsoft Partner

Registered Education Provider (R.E.P.)

GSA schedule pricing

80,130

Students who have taken Live Online Training

15,540

Organizations who trust Webucator for their training needs

100%

Satisfaction guarantee and retake option

9.38

Students rated our trainers 9.38 out of 10 based on 4,997 reviews

Excellent course content. Would recommend to anyone interested in learning Microsoft Project.

Brian Boelke, Zebra Technologies
Vernon Hills IL

Quality training with educated and informed instructors -- That's what I expected, and that's what I got.

Jeremy Johnson, Alaska Division of Retirement & Benefits
Juneau AK

The Introduction to HTML class was very informative and useful. The instructor was very thorough. The content was a lot, but just the right amount for an HTML beginner.

Jennifer McGee, Covidien
Mt. Laurel NJ

I would recommend Webucator for any of your online IT training needs as they are very thorough in their training.

James Morgan, West Virginia School of Osteopathic Medicine
Lewisburg WV

Contact Us or call 1-877-932-8228