+91 9176633248

Courses

Batch starts on

Mar 09th

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

40-hours, 16 Sessions

3-months | Only on Weekends

TRAINING SCHEDULE

Sunday, 10 Mar

08:30 AM - 11:00 AM

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 Sun, 10 Mar 08:30 AM - 11:00 AM
Session 2 Sun, 17 Mar 08:30 AM - 11:00 AM
Session 3 Sun, 24 Mar 08:30 AM - 11:00 AM
Session 4 Sun, 31 Mar 08:30 AM - 11:00 AM
Session 5 Sun, 07 Apr 08:30 AM - 11:00 AM
Session 6 Sun, 21 Apr 08:30 AM - 11:00 AM
Session 7 Sun, 28 Apr 08:30 AM - 11:00 AM
Session 8 Sun, 05 May 08:30 AM - 11:00 AM
Session 9 Sun, 12 May 08:30 AM - 11:00 AM
Session 10 Sun, 19 May 08:30 AM - 11:00 AM
Session 11 Sun, 26 May 08:30 AM - 11:00 AM
Session 12 Sun, 02 Jun 08:30 AM - 11:00 AM

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?

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.

Training Schedule

Session Date Time
Session 1 Sun, 10 March 08:30 AM - 11:00 AM
Session 2 Sun, 17 March 08:30 AM - 11:00 AM
Session 3 Sun, 24 March 08:30 AM - 11:00 AM
Session 4 Sun, 31 March 08:30 AM - 11:00 AM
Session 5 Sun, 07 April 08:30 AM - 11:00 AM
Session 6 Sun, 21 April 08:30 AM - 11:00 AM
Session 7 Sun, 28 April 08:30 AM - 11:00 AM
Session 8 Sun, 05 May 08:30 AM - 11:00 AM
Session 9 Sun, 12 May 08:30 AM - 11:00 AM
Session 10 Sun, 19 May 08:30 AM - 11:00 AM
Session 11 Sun, 26 May 08:30 AM - 11:00 AM
Session 12 Sun, 02 June 08:30 AM - 11:00 AM

System Requirements

  1. Power BI Desktop (Free & Downloadable at https://powerbi.microsoft.com/en-us/get-started/
  2. PowerPivot- Available with Office 365 subscriptions that include desktop versions of Excel for Windows. Also available with certain onetime office purchases. Refer https://support.office.com/en-us/article/where-is-power-pivot-aa64e217-4b6e-410b-8337-20b87e1c2a4b  for more information.

Connect with Us

Excelgoodies Software Private Limited

56, 1st & 2nd Floor, North Boag Road,

T. Nagar, Chennai - 600 017

Mr.Raj

Business Associate

Tel: +91 9176633248

Email: support@excelgoodies.com

`

Classroom Gallery

Why Power BI skill is highly sought after?

INR 12,84,448

is the annual average salary of

Data Scientist using Power BI

2,50,000

Companies have

implemented Power BI

97%

Fortune 500 Companies use

Power BI

Top Leader

in Analytics & BI for 14th

Consecutive Year.

Source:

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.

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
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
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
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, 06 Mar.

Registration Closes on Wed, 06 Mar.

Learner stories around the world!

Reviews

  • Trainer's Expertise
  • Course Structure
  • Course Content
  • Quality of Assignments
  • Certification Process

Scott A. Reifsynder

Chief Financial Officer

Nexterus

This class was extremely helpful in my knowledge and growth in these database, analysis and reporting tools. I really enjoyed the hands-on approach and got lots of “goodies” out of all the classes. Your approach, repetitiveness and patience is much appreciated and sincerely helped...

Josh Grenzsund

Director of Business Development

DOWL

This was a very good course where I learned high level concepts of data management (how it moves/should move) for business users, the concepts for querying and organizing data sets, the interaction and use of various tools/software, and detailed work with DAX and SQL expressions...

Frank Young

Business Analyst

It was indeed some good learning! Sessions were highly informative with loaded tips here and there by Sami on remembering concepts and implementing it back at work.

I really enjoyed Assignments session which truly boosted my confidence in Automation...

Karen Smith

Quantitative Analyst

Good sessions. Highly passionate trainer. Sami was quick enough to identify the skill sets and the knowledge of the participants to pace his training accordingly.

His way of simplifying the coding concepts was just spell bounding. He knew his students...

Cody K

Risk Reporting Developer

A well-structured program. The flow of training was carried out pretty well by the tutor. Enjoyed working with case studies and the concepts were taught in the simplest way

It made me much more confident to assume...

Learner stories around the world!

View More Google Reviews

Google Reviews

View More 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