Power BI Training

LIVE INSTRUCTOR LED TRAINING

Enrol Now

New Batch starts from 05th December 2020

Course brief

In this course, you'll start by setting up Power BI in your system. Then you'll learn about connecting and shaping data, followed by creating Data Model. Next you will learn how to add calculated fields with Data Analysis Expressions(DAX). You will then learn Visualizing Data with reports. By the end of the course student will be able to load data from different sources and create Data models and achieve expertise in business analytics.

TIMELINE
6 weeks
PREREQUISITES
Basics of Microsoft Excel
SKILL LEVEL
Advanced

₹11950

₹16500 28%

Why learn Power BI?

Microsoft Power BI is one of the advanced Data Modeling platforms. It uses real-time Power BI dashboard from multiple sources to present data. Competency in DAX and Power BI can give real value to your business. All the MNCs around the world prefer Power BI for Business Analytics.

Download Brochure

What you will learn

Lesson 1
Business Intelligence and Analytics
This lesson introduces participants to the concepts that comprise BI. Will be able to explore scenarios for using BI and how current trends affect the use of BI, along with project roles and data models.
  • Introduction to business intelligence
  • Introduction to data analysis
  • Introduction to data visualization
  • Overview of self-service BI
  • Considerations for self-service
Lesson 2
Introduction to Microsoft Power BI
This lesson will walk through the fundamental concepts of BI and Power BI Desktop. Participants will gain knowledge of query and file operations. Participants will learn how to connect multiple data sources to this tool and other concepts including tables, columns, and measures.
  • Power BI Desktop Installation
  • Building Blocks of Power BI
  • The architecture of Power BI
  • Salient Features of Power BI
  • Understand the components of Power BI Desktop
  • Report view
  • Data View
  • Data Model View
  • Pages
  • Visualization pane
  • Fields pane
  • Direct query versus Import data
  • Connecting to Common Data sources
Lesson 3
Power BI Data Visualization Introduction
In this lesson, participants will understand how to build simple(basic) visualization (reports) in with Power BI Desktop and publish in BI Service.
  • 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 at Glance
  • Publishing in Power BI Service
Lesson 4
Introduction to Power BI Query Editor
In this lesson, participants will understand how to prepare the data for Visualization Participants will learn various transformations to Clean and load data with the query editor.
  • Introduction to query editor
  • Features
  • Basic transformations
  • Changing data type
  • Applied Steps
  • Renaming steps
  • Delete Columns/Rows
  • De-Duplicate, Remove Null data
  • Add a column from examples
  • Text, Number and Date functions
  • Create a list
Lesson 5
Power BI Query Editor and Data Model
This lesson will cover advanced topics in Query Editor. Designing concepts of Data model such as the Dimension model, Star schema will be covered in detail in this module.
  • Un Pivot and Pivot
  • Advanced transformations
  • Combine queries –Merge and Append
  • Add custom columns
  • Setting up parameters
  • Dimension Modeling in Detail
  • Create a Dimension Table
  • Create Fact Table
  • Design Star-Schema
  • Manage Table Relationships
  • Model Enhancements
  • Create Calculated Columns
Lesson 6
Interactive Visualizations &Advanced Visualizations
In this lesson, participants will understand how the visualization of data is done and the creation of interactive reports with Power BI Desktop. Creating charts and dashboard will be understood. Also, learn about custom visuals.
  • Visualizing Data - Creating Interactive Reports
  • Adding Slicers for Filters
  • Visualizing Tabular Data
  • Visualizing Categorical Data
  • Visualizing Data Trends
  • Visualizing Categorical and Trend Data Together
  • Visualizing Geographical Data with Maps (Map Visualizations)
  • Card Gauge
  • Treemap Visuals
  • Visualizing Goal Tracking
  • Using Custom Visuals
  • Slicers & Timeline Slicers
  • Drill Down/Up
  • Hierarchies
  • Tables, Matrices, Formatting
Lesson 7
Introduction to Data Analysis Expressions (DAX)
This lesson will help participants learn the basics of DAX in Power BI Desktop. Understand DAX functions that are same or similar to Excel formulas Like Date, Text, Logical functions.
  • Concepts in DAX and relevance of DAX needed
  • DAX Syntax
  • Data Types in DAX and Calculation Types
  • DAX Measure Type –Column, Table, Measure
  • DAX Operators
  • DAX Quick measures
  • Running total, YTD, MTD, QTD, YOY, MOM, QOQ measures
Lesson 8
Advanced Data Analysis Expressions (DAX)
This lesson will help participants learn the advanced topics of DAX in Power BI Desktop. Participants will be learning advanced expressions and performing dynamic analysis using query context, row context, and filter context.
  • Why Advanced DAX
  • Iterator Functions (SUMX, RANKX)
  • Filter Context Overview and Examples
  • Date & Time Functions
  • Conditional & Logical Functions (IF/AND/OR)
Lesson 9
Power BI Service- Publish & Share
In this lesson, the participant will understand Power BI services offering which is a straightforward approach to report creation, and the ability to create and share dashboards without dependency on a report developer (IT Team). Various export options will be learnt and data gateways.
  • Why Advanced DAX
  • Iterator Functions (SUMX, RANKX)
  • Filter Context Overview and Examples
  • Date & Time Functions
  • Conditional & Logical Functions (IF/AND/OR)
  • Mostly used Text Functions
  • Joining Data with RELATED
  • Key Math & Stats Functions
  • COUNT Functions (COUNTA, DISTINCT COUNT, COUNT ROWS)
  • CALCULATE
  • CALCULATE & ALL
  • CALCULATE & FILTER
  • FILTER, FILTER and ALL, ALL EXCEPT
  • Time Intelligence Formulas
  • Rank Function
  • Row Context (Understanding Row Context and Context Transition)
  • DAX Best Practices in Power BI Desktop
Lesson 10
Power BI Service- Data refresh, Power BI Mobile
In this lesson, the participant will learn about setting up data gateways and data refresh. Also, learn about designing Power BI Mobile reports.
  • Data Refreshing
  • Refreshing Data Overview
  • Installing the Data Gateway
  • Scheduling a Data Refresh
  • Power BI Mobile Overview
  • Designing Reports and Dashboards for Mobile
  • Interacting with the Power BI Mobile App

FAQs

Can I attend this course online?

Yes. This course is completely online

Will I get a certificate after completing the course?

Yes. On successful completion of this course, we will be issuing you a Course Completion Certificate

Quick Enquiry
Successfully Submitted