Microsoft Power BI Training & Certification Course

  • Overview
  • Course Content
  • Drop us a Query

Multisoft Systems is offering Microsoft Power BI Training & Certification Course for Business Analysts, Reporting Professionals, and Business Intelligence Developers. This hands-on course is designed to impart the knowledge of combining the functionality of Power View, PowerPivot, Power Query, and Power BI into graphs, charts, KPIs, reports, and other visualizations for use in their business.

We have designed this course to give detailed knowledge on how to filter data, load data, merge datasets, perform data cleaning, navigate the Power Query interface, use KPIs, utilize power view reports, and work with tables. Go for this course if you have a working knowledge of Microsoft Excel.

In its successful completion, you will learn:
  • Create interactive visualizations to deliver business insights
  • Extract business intelligence by using DAX, M and Power Query
  • Share Datasets, Reports and Dashboards in the Power BI Service
  • Pre-format and import data from an Excel Report using Power Query and M
  • Add value with measures, calculated columns and calculated tables using DAX
  • Import data from relational databases and integrate with other data sources
  • Profile, shape and filter tables to prepare for analyses by fixing data issues
  • Integrate data from csv files and Excel Workbooks
  • Explore and extend a Power BI data model
  • How to Use Bing maps, Examine map data, and Utilize data sources?
Microsoft Power BI Online Training
  • 32 Hrs. Instructor-led Online Training
  • Recorded Videos After Training
  • Digital Learning Material
  • Course Completion Certificate
  • Lifetime e-Learning Access
  • 24x7 After Training Support
Target Audience
  • Business Analysts
  • Business Intelligence Developers
  • Reporting Professionals
Course Prerequisites
  • This is an introductory course and, as such, there are no prerequisites to attend this course. It may be useful for you to have some knowledge of your data so that you can apply the concepts you learn more effectively after the course has completed.
Certification
  • Multisoft Systems will provide you with a training completion certificate after completing the Course Power BI Training & Certification Course.

Chapter 1: Power BI Overview

  • Chapter 1: Power BI Overview
  • Visual analysis and visual analytics
  • Power BI Infrastructure
  • Loading Data
  • Introduction to Power BI Desktop
  • Hands-On Exercise 1.1 Loading and Visualizing data

Chapter 2: Transforming Data

  • Using Power Query to clean, transform and load data
  • Profiling your data
  • Resolve data quality issues
  • Apply user-friendly name to Queries, tables and columns
  • Import data from an Excel formatted report
  • Hands-On Exercise 2.1 Transforming Data with Power Query

Chapter 3: Creating a Data Model

  • Understand the role of the Data Model in Power BI
  • Create table relationships
  • Understand Cardinality and Cross Filtering
  • Discuss Star and Snowflake schema
  • Create a Date Dimension
  • Build a Data Model from multiple Data sources
  • Hands-On Exercise 3.1 Creating a Data Model
  • Hands-On Exercise 3.2 Creating a Star and Snowflake schemas

Chapter 4: Visualizing your Data

  • Discuss Report settings
  • Choosing the right visualizations
  • Creating, formatting and styling your reports
  • Using Hierarchies and Drilldown
  • Utilising Slicers and Filters
  • Adding Custom Visualizations
  • Hands-On Exercise 4.1 Creating Reports Part 1
  • Hands-On Exercise 4.2 Creating Reports Part 2
  • Hands-On Exercise 4.3 Creating Reports Part 3

Chapter 5: Introduction to DAX, Calculated Columns and Measures

  • Gain an Introduction to DAX
  • Differentiate between Calculated Columns and Measures
  • Create Calculated Columns
  • Create Measures
  • Understand Filter and Row context
  • Understand the power of the Calculate function
  • Hands-on Exercise 5.1 Introduction to DAX
  • Hands-on Exercise 5.1 Intermediate Level DAX

Chapter 6: Collaboration and Sharing (Publishing Reports and Creating Dashboards)

  • Discuss the Power BI Service and Power BI Server
  • Understand the main components of the Power BI Service
  • Publish a Power BI Project to the Power BI Service
  • Share Reports
  • Build and Share Dashboards
  • Hands-On Exercise 6.1 Collaboration and Sharing in the Power BI Service

Partners

A Few Things You'll Love!

What our Students Speak

+

Multisoft
Online

Multisoft
Hi there 👋

How can I help you?
1:40
×
Chat with Us