+91 9176633248

Courses

Batch starts on

Jul 07th

Powerful Business Intelligence for all.

Power BI - Data Analytics, Modeling & Advanced Reporting

30-hours Course | 30-Days Project Support | View Schedule View Schedule

Program Overview

TOTAL COURSE DURATION

30-hours, 12 Sessions

3-months | Only on Weekends

TRAINING SCHEDULE

Sunday, 07 Jul

5:30 PM - 8:00 PM

CERTIFICATE

BI Reporting Specialist

View Sample Certificate

PRE-REQUISITE

Advanced Excel Skills

Formulas & Pivots.

Both Online & Classroom is available.

*

All our classes are live, hands-on and with real-trainers.

Course Content Overview

Objective: Getting started with Power BI and leverage it’s full potential to develop compelling visualizations.

Building Blocks of Power BI

  • Visualizations
  • Datasets
  • Reports
  • Dashboards
  • Tiles

Building Your First Power BI Report

  • Connect to Data Sources in Power BI Desktop
  • Clean and Transform Your Data With the Query Editor
  • Create a report in Power BI Desktop
  • Publish the report in the Power BI service

Data Modeling with Power BI

  • Fundamentals of Modeling
  • How to Manage Your Data Relationships
  • Create Calculated Columns
  • Optimizing Data Models for Better Visuals
  • Create measures and work with time-based functions
  • Create Calculated Tables
  • Explore Time-Based Data

Visualizations

  • Create and Customize Simple Visualizations

Building compelling data visualizations

  • Identify metrics and pair them with appropriate data visuals
  • Using slicers
  • Creating Map Visualizations
  • Creating Tables and Matrixes
  • Creating Scatter Charts
  • Creating Waterfall and Funnel Charts
  • Using Gauges and Single Number Cards
  • Charting Options including Formatting with Colors, Shapes, Text Boxes, Images, etc.

Designing User-friendly reports

  • Customize themes
  • Create versatile layouts for your reports
  • Design principles to reduce noise and highlight data stories

Creating interactive reports for data exploration

  • Filtering & drilling for insights
  • Difference between filters & slicers
  • Filter pane for reporting needs

Exploring Data

  • Use Quick Insights in the Power BI service
  • Create and Configure A Dashboard
  • Share Dashboards with your organization
  • Display Visuals and Tiles Full-Screen 

Objective: To add analytical power to your Power BI model that is not available in the data as-is, using DAX.

Overview

  • What is DAX?
  • Data Types
  • Table-Valued Functions
  • Building a Calendar Table
  • Date and Time Functions
  • Filter Functions
  • Information Functions
  • Logical Functions
  • Mathematical and Trigonometric Functions
  • Statistical Functions
  • Text Functions
  • Time Intelligence Functions

Creating Advanced Dax Measures With Advanced Dax Functions

  • Calculate()
  • All()
  • Filter()
  • IF()
  • Switch()
  • SumX()

Evaluation Context

  • Filter Context
  • Row Context
  • Using RELATED in a Row Context
  • Filters and Relationships
  • USERELATIONSHIP

Hierarchies in DAX

Querying with DAX

Relationships

  • One-to-Many Relationships
  • Many-to-Many Relationships

Objective: To learn different methods to Transform Data before uploading it to the SQL Database.

Overview

  • Introduction
  • Loading & Refresh
  • Combine data from multiple data sources

Data Transformation

  • Editing Queries Created with Power Query
  • Editing Column Headers in Power Query
  • Splitting Column Data with Power Query
  • Sorting Data
  • Multi-Level Sorting
  • Filtering Data
  • Aggregate data from a column
  • Insert a custom column into a table
  • Merge columns
  • Remove columns
  • Remove rows with errors
  • Promote a row to column headers
  • Transforming Text Values
  • Replacing Data
  • Using the Fill command
  • Pivot and Unpivot Column
  • Transpose Query Data
  • Pivot Column Command in Action
  • Unpivot Columns Command
  • Grouping Data
  • Create a Duplicate Query
  • Group and Summarize Data
  • Advanced Data Grouping
  • Working with multiple sources in Power Query
  • Multiple Excel Tables
  • Expand a column containing an associated table
  • Understanding Table Relationships
  • Merging Queries

Loading Power Query Data to Destinations

  • Familiarity with the Load & Refresh Settings
  • Loading it to Workbook
  • Loading it to Data Model

Objective: Power Query and Power Pivot complement each other. Power Query is the recommended experience for discovering, connecting to, and importing data. Power Pivot is great for modeling the data you’ve imported.

INTRODUCTION TO POWERPIVOT

  • Limitation of Excel Functions
  • Limitation of Excel PivotTable
  • Why PowerPivot?
  • PowerPivot Features - Overview

POWERPIVOT ENVIRONMENT

  • Opening PowerPivot Environment
  • Understanding External Data Section
  • Understanding Formatting
  • PowerPivot Views
  • Understanding Measures

TAKING DATA INTO POWERPIVOT

  • From Excel
  • From MS Access
  • From Ms-SQL
  • From Custom Query
  • From Text Files
  • From Other Sources

CALCULATED COLUMNS

  • Calculated Columns
  • Entering Formulas
  • Using AutoComplete Feature
  • Renaming Columns
  • Understanding Tables

ADVANCED CALCULATED COLUMNS

  • Understanding Relationship Concept
  • JOIN TABLES
  • LEFT JOIN TABLES
  • RIGHT JOIN TABLES
  • Using UNION QUERIES

DATA VISUALIZATION USING

  • Power View
  • Charts, Score Cards and Dashboards
  • Slicers
  • Map Visualizations
  • Data Binding and Formatting

Objective: To perform advanced and complex data transformations not available in the Query Editor

Understanding M Programming Code

  • M LANGUAGE Specifications
  • Lexical Structure
  • Basic Concepts
  • Values
  • Types
  • Operators
  • Let
  • Conditionals
  • Functions
  • Error Handling
  • Creating Simple M Expressions
  • Creating Simple M Functions
  • Working with List, Record & Tables
  • Understanding Operators and Evaluation Methods
  • Data Types & Type Conversions

Working with M Functions

  • ACCESSING DATA FUNCTIONS - From Excel, SQL, CSV, Tab-Delimited, Webpage, XML, JSON, SharePoint, etc.
  • COMBINER FUNCTIONS
  • COMPARER FUNCTIONS
  • DATE FUNCTIONS
  • DATETIME FUNCTIONS
  • DURATION FUNCTIONS
  • LIST FUNCTIONS
  • LOGICAL FUNCTIONS
  • NUMBER FUNCTIONS
  • RECORD FUNCTIONS
  • REPLACER FUNCTIONS
  • SPLITTER FUNCTIONS
  • TABLE FUNCTIONS
  • TEXT FUNCTIONS
  • TIME FUNCTIONS
  • TYPE FUNCTIONS
  • VALUE FUNCTIONS

Objective: Get hands-on experience with advanced administration settings, permissions, Data refresh times etc.

Overview

  • Publishing Power BI Reports
  • Creating & Managing Workspaces and Its Access
  • Creating & Managing Dashboard and Its Access
  • Installing & Configuring Data gateway
  • Scheduling and configuring data refresh
  • Managing & Reusing Datasets
  • Scheduling Report Alerts
  • Setting up Row Level Permissions
  • Managing Users & Audit Log
  • Custom Branding Power BI For your Organization
  • Adding Custom Visuals for your Organization

Objective: It complements Power Pivots and Power BI better than any other DB.

INTRODUCTION TO MS-SQL

  • Creating a Database
  • Understanding Tables and Creating Tables
  • Inserting, Updating and Deleting Data
  • Querying Data
  • Filtering Data
  • Grouping Data
  • Ordering Data
  • Column Aliases
  • Table Aliases

UNDERSTANDING TRANSACT-SQL DATA TYPES

  • Dates
  • Strings
  • Numeric
  • BLOBs
  • Bits
  • UNIQUEIDENTIFIER
  • Cursor Variables
  • Timestamps

DDL INSIGHTS

  • CREATE TABLE
  • Dropping Objects
  • CREATE INDEX
  • TEMPORARY OBJECTS
  • Object Naming and Dependencies

SELECT STATEMENTS

  • Simple SELECTs
  • Calculated and Derived Fields
  • SELECT TOP / BOTTOM Records
  • Derived Tables
  • Joins
  • Predicates
  • Subqueries
  • Aggregate Functions
  • GROUP BY and HAVING
  • UNION
  • ORDER BY

Objective: To put our entire learning to use and arrive at the best possible BI solution -using the right combination of available technologies.

Overview

  • Case Study 1
  • Case Study 2
  • Case Study 3

Training Schedule

Session Date Time
Session 1 Sat, 06 Jul 05:30 PM - 08:00 PM
Session 2 Sat, 13 Jul 05:30 PM - 08:00 PM
Session 3 Sat, 20 Jul 05:30 PM - 08:00 PM
Session 4 Sat, 27 Jul 05:30 PM - 08:00 PM
Session 5 Sun, 07 Jul 11:00 AM to 1:30 PM
Session 6 Sun, 14 Jul 11:00 AM to 1:30 PM
Session 7 Sat, 21 Jul 11:00 AM to 1:30 PM
Session 8 Sun, 28 Jul 11:00 AM to 1:30 PM
Session 9 Sun, 04 Aug 11:00 AM to 1:30 PM
Session 10 Sun, 11 Aug 11:00 AM to 1:30 PM
Session 11 Sun, 18 Aug 11:00 AM to 1:30 PM
Session 12 Sun, 25 Aug 11:00 AM to 1:30 PM

Course Fee

INR 15000 (Initial Fees)

4000 / month (for 2-months)

CORPORATE
Training 5 or
more people?

Avail additional 10% Corporate Benefit*
on the total course fee for 5+ participants.
Get you team BI ready, today.

What is included?

  • 20 hours of Instructor-led training.
  • Power BI & Power Query Projects & related case studies.
  • 30-Days post training support (via Email).
  • BI Reporting Specialist Certificate
View Certificate

About the Trainer

Mr. Sami, MCT, MCSA Data Enthusiast & a Technophile

Mr. Sami, Microsoft Certified Trainer, with his qualifications in Finance, HR & Information Technology brings in 14 years of Industry experience. He has successfully trained 9500+ professionals by now, and the counting is still on.

He has undertaken assignments with the renowned IRS, The World Bank, Tata Chemicals, Buckman Laboratories, Standard Chartered, ING Barings and much more. His nature of going that Extra Mile has got him the startling popularity amongst the Excelgoodies prominent clients.

Classroom Gallery

Why Power BI skill is highly sought after?

Excelgoodies

INR 12,84,448

is the annual average salary of

Data Scientist using Power BI

Excelgoodies

2,50,000

Companies have

implemented Power BI

Excelgoodies

97%

Fortune 500 Companies use

Power BI

Excelgoodies

Top Leader

in Analytics & BI for 14th

Consecutive Year.

Source:

Excelgoodies Excelgoodies Excelgoodies

Few Real­world Use Cases of Power BI Reporting

Get a full picture across data sources in seconds. Click to drill down

Few Real­world Use Cases of Power BI Reporting

Get a full picture across data sources in seconds. Click to drill down

Resources from our Power Users.

Excelgoodies
Is Power Bi, the silent death of SSRS?

Well, the end-purpose of both tools is to help business users with high-end reporting. Where does the difference lie? The changing role of Business Users from just “receiving” the powerful…

Read More
Excelgoodies
7 Advanced DAX Functions to Supercharge Your Power BI Reports

Business intelligence (BI) reporting and automation are powerful tools that can significantly improve business processes by providing real-time insights, automating repetitive tasks, and reducing the risk of human error.

Read More
Excelgoodies
Creating Mobile-Friendly Reports with Power BI

Power BI is a powerful tool for creating reports that can be accessed on desktops, tablets, and mobile devices.

Read More
Excelgoodies
The Fast-Food Chain Data Story: Do’s & Don’ts of data storytelling.

Suppose you are a marketing analyst for a fast food chain, and your task is to create a data story to help the company understand the behavior of its customers

Read More

APPLICATION DEADLINE

Application Deadline

Registration Closes on
Wednesday, 03 Jul.

Registration Closes on Wed, 03 Jul.

View More Google Reviews

Google Reviews

Recommended Course (For Advanced Reporting Users Only)

Full Stack BI R
Reporting & Automation Course.

72 Sessions | 9-Specialist Certifications

You will learn to use the right and hybrid technology for end-to-end advanced power reporting.

Tools: Power BI, Power Pivot, VBA, Excel,
M-Programming, MS-SQL, SSIS, and many more.

Power BI

Micorsoft T-SQL

MS-SQL Integrated Services

Python

Microsoft Excel VBA

MS-Excel

Power Query