Data Analysis Training with Power BI: 3 Days

Data Analysis Training Course with Power BI Data Analysis Training with Power BI
By TED Integrated
Microsoft® Power BI:

Data Analysis with Microsoft® Power BI

“Get a good understanding of data analysis with Microsoft Power BI”

By TED Integrated


PSMB Certified Training Provider
Request for In-house TrainingRequest for In-house Training
Register for Public Training Public program not yet available
Register for Public TrainingRegister for Public Training
Email Customer Service training@ted.com.my Contact Customer Service +603-2386-7788
Course Title:
Data Analysis with Microsoft® Power BI
Training Category:
Information Technology
Target Audience:
The course is suitable for SQL Server report creators who are interested in having alternative methods of presenting data in their organization.
Duration:
3 Days
For In-house Training
Request for Quotation Request for Quotation
For Other Inquiries
Contact TED Integrated
Contact customer service +603-2386-7788
Email customer service training@ted.com.my
Delivery Methods
  • Language: English
  • PowerPoint Presentation
  • Workshop
  • Presentation Handouts
  • Reading Materials
  • Lecture
  • Certificate of Participation
Ad by Google
*Terms & Conditions

Course Introduction ›

The main purpose of this 3-day course is to provide participants a good understanding of data analysis with Microsoft Power BI. The course includes creating visualizations, the Power BI Service and Mobile App.

Course Objectives ›

Upon completion of this 3-day Power BI training, participants should 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

Prerequisites ›

  • Excellent knowledge of relational databases and reporting.
  • Familiarity with Microsoft Office applications, particularly Excel.

Course Outline ›

DAY 1

Module 1: Introduction to Self-Service BI Solutions

Lessons

  • Introduction to business intelligence
  • Introduction to data analysis
  • Introduction to data visualization
  • Overview of self-service BI
  • Considerations for self-service BI
  • Microsoft tools for self-service BI

Lab: Exploring an Enterprise BI solution

  • Viewing reports
  • Creating a Power BI report
  • Creating a Power BI dashboard

After completing this module, you should be able to:

  • Describe the trends in BI
  • Describe the process of data analysis in Power BI
  • Use the key visualizations in Power BI
  • Describe the rationale for self-service BI
  • Describe considerations for self-service BI
  • Understand how you can use Microsoft products to implement a BI solution

Module 2: Introducing Power BI

Lessons

  • Power BI
  • The Power BI service

Lab: Creating a Power BI dashboard

  • Connecting to Power BI data
  • Create a Power BI dashboard

After completing this module, you will be able to:

  • Develop reports using the Power BI Desktop app
  • Use report items to create dashboards on the Power BI portal
  • Understand the components of the Power BI service including licensing and tenant management

Module 3: Power BI

Lessons

  • Using Excel as a data source for Power BI
  • The Power BI data model
  • Using databases as a data source for Power BI
  • The Power BI service

Lab: Importing data into Power BI

  • Importing Excel files into Power BI
  • Viewing reports from Excel files

After completing this module, you will be able to:

  • Describe the data model and know how to optimize data within the model.
  • Connect to Excel files and import data
  • Use on-premises and cloud Microsoft SQL Server databases as a data source, along with the R script data connector
  • Take advantage of the features of the Power BI service by using Q&A to ask questions in natural query language, and create content packs and groups
DAY 2

Module 4: Shaping and Combining Data

Lessons

  • Power BI desktop queries
  • Shaping data
  • Combining data

Lab: Shaping and combining data

  • Shape power BI data
  • Combine Power BI data

After completing this module, you will be able to:

  • Perform a range of query editing skills in Power BI
  • Shape data, using formatting and transformations
  • Combine data together from tables in your dataset

Module 5: Modelling data

Lessons

  • Relationships
  • DAX queries
  • Calculations and measures

Lab: Modelling Data

  • Create relationships
  • Calculations

After completing this module, you should be able to:

  • Describe relationships between data tables
  • Understand the DAX syntax, and use DAX functions to enhance your dataset
  • Create calculated columns, calculated tables and measures

Module 6: Interactive Data Visualizations

Lessons

  • Creating Power BI reports
  • Managing a Power BI solution

Lab: Creating a Power BI report

  • Connecting to Power BI data
  • Building Power BI reports
  • Creating a Power BI dashboard

After completing this module, you should be able to:

  • Use Power Bi desktop to create interactive data visualizations
  • Manage a power BI solution
DAY 3

Module 7: Direct Connectivity

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, you will be able to:

  • Use Power BI direct connectivity to access data in Azure SQL data warehouse, in addition to big data sources such as Hadoop
  • Use Power BI with SQL Server Analysis Services data, including Analysis services modles running in multidimentional mode

Module 8: Developer API

Lessons

  • The developer API
  • Custom visuals

Lab: Using the developer API

  • Using custom visuals

After completing this module, you will be able to:

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

Module 9: Power BI mobile app

Lessons

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

After completing this module, you 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

Contact us now ›

  • Course content customization
  • In-house training request
  • Available public program
  • Consultation services
  • Other inquiries
Contact Customer ServiceCall : +603-2386-7788
Email Customer Service E-mail : training@ted.com.my

Related Courses ›

Published by: ,
Contact Us

"Hi, I'm your Contact Assistant! I'll help you to reach the right party for the right information. Click me to get started!"

Contact Assistant