Analytic

Techniques
using
Excel &
Power BI

In exclusive association with

21,347+ Participants | 10,000+ Brands | 1200+ Trainings | 45+ Countries

[Since 2009]

Training partner for

Course Highlights
Who is this Course for

People from all functional areas like HR, Marketing, Sales, Supply Chain, Customer Satisfaction, Logistics, Accounting & Finance,
Operations, Trading, Administration, Purchase & Production, Manufacturing, Research & Development

Salient Features

3 Hrs/Week Live 15 Days of Active Q/A Forum Class Labs/Home Assignment

Instructor-Led Online Sessions Project Work (10 hours/Week Learning Time)

Govt. of India Placement Support Personalised Training Program Lifetime Access to

(Vskills Certified Course) Updated Content and
Videos

Industry and Top Data Analytics Specialize in Industry’s Top

Academia Faculty Tools Covered Excel & Power Bi Excel & Power Bi
Advisors

Course Advisors
Manas Garg
Manas Garg heads the Analytics for Marketing at Paypal. Architect
He takes Data Driven Decisions for Marketing Success.

Shweta Gupta Shweta Gupta has 19+ years of Technology Leadership

Vice President, Tech. experience. She holds a patent and number of publications in
ACM, IEEE and IBM journals like Redbook and
developerWorks.

Vishal Mishra
Vishal is a Technology Influencer and CEO of Right Relevance. CEO & Co-Founder
(A platform used by millions for content & influencer discovery)
Course Instructors

RUSHABH SHAH

Rushabh Shah is the Founder & CEO of DLTC.co and Blogger

at ExcelRush.com. His strengths are data & business analysis.
To share his knowledge and experience of working with various
businesses areas, he has trained 1300+ working professionals
and students in Excel Advanced & others.

Course Curriculum
This Excel and Power BI course is thoughtfully designed for people with different functions that own data
like Sales, Marketing, Customer Acquisition, Customer Satisfaction, Operations, Supply-Chain, Logistics,
Finance, Trading; and would like to leverage their data for action driven insights. The 2017 European Data
Science Salary Survey, puts Excel just under 70% as the most used tool by analysts, and this will possibly
span in most markets. The curriculum allows learners to enhance their analytical skills and make a
transition into the analytics industry with high-in-demand skillsets of Advanced Excel, Business Intelligence
or Visualization tools PowerBI and SQL. It is designed in a way that in a few weeks the program, learners
be prepared to devise solutions for real time problems in the industry.

INTRODUCTION TO ANALYTICS TECHNIQUES

Overview of the Analytics Techniques

BI Landscape
Data Warehousing

FUNDAMENTALS OF EXCEL

Introduction Useful Functions

GUI Distributions
Cell Referencing Probability
Freeze Panes Bayes Theorem
Sum Function Hypothesis Testing

Sorting & Filtering Duplicates

Multi-level Sort Remove Duplicates

Custom Filter
 DATA CLEANING AND WORKING WITH CONDITIONS USING EXCEL

Working with Text Working with Conditions

Concatenate Conditional Formatting
Left, Right, Upper, Lower Logical Operations
IF, AND, OR, Nested IF

Date Functions

Splitting
Creating Dates

DATA MANIPULATION USING ADVANCED EXCEL

Fetching & Comparing Data Sets Named Ranges

$ Referencing Name Box

Vlookup & Hlookup Indirect Function
Match & Index

DATA ANALYSIS & VISUALIZATION USING ADVANCED EXCEL

What-if-Analysis Solver Plug-in

Goal Seek Solver Plug-in
Data Table
Scenario Manager

Pivot Tables Charts

Dimensions & Measures Various Charts

Multi-layer Pivot Table Pivot Charts
Summarize Values by Show Values as Combo Charts
Group Sparklines

INTRODUCTION TO STATISTICS & APPLICATION IN EXCEL

Descriptive Statistics
Inferential Statistics
Regression
Anova
Correlation
Covariance
Histogram
Factor Analysis & Principal Component Analysis
Random Number Generation
Exponential Smoothing
 INTRODUCTION TO MS SQL & MS ACCESS

Core Database Concepts Using SQL with a RDBMS

Relational Database Concepts SQL Joins

Data Types Sub-Queries
Tables Case Operator
Using SQL with R
Using SQL with Other Platforms (HIVE, Python)

SQL Queries and Views

Queries Views
Select, Insert, Update, Delete Creating & Updating

POWER BI - INTRODUCTION

Calculated Columns & Measures Power BI Components

Calculated Columns Old v/s New Technologies

Measures Power BI Desktop
Power BI Service
Power BI Mobile

Dashboard Clean & Transform Data

Dashboard using Pivot Tables, Slicers, Timeline Query Editor

Advanced Methods
Pivoted data / Unpivoted Data

Importing Data
From Excel
From Access, Folder, other sources

Modeling
Relationships
Calculated Columns & Measures
Calculated Tables
Time-based Data

Excel Tables

Why use Tables

Referencing Syntax
Formulas
Named Ranges
 POWER BI - BUILDING DASHBOARDS, MANIPULATING DATA
USING DAX, IMPORTING DATA FROM MULTIPLE SOURCES

DAX Functions Power BI Mobile

Introduction to DAX Installing the App
Data Types Viewing Dashboards
Calculated Columns & Measures Viewing Reports
DAX Functions Sharing
Relating Excel Functions with DAX Functions
Variables
Tables Referencing
Filtering

Visualizations

Create Simple Visualizations

Combination Charts
Slicers
Map Visualizations
Tables & Matrix
Scatter Charts
Waterfall & Funnel Charts
Gauges & Single Number
Cards
Styling the Visualizations
Categories with no Data

Introduction to Power BI Service

Sign up for Power BI Service

Parts of the Power BI Service
Datasets
Reports
Dashboards

Publishing

Publish from Power BI Desktop to Service

Power BI and Excel

Import an Excel Table in Power BI Service Directly

Dashboards
Pinning the Required Reports from across Reports
Ask Questions on your Data
Focus Mode
Edit Tile Details
Capstone Project (2 Weeks)
The Capstone project is the culminating assignment that will allow you to have an integrated
experience of the program. The approach to this project is to think, define, design, and work your
way to your solution, in such a way that you apply several aspects of your learning.

In the project you will be the ‘Indian Premier League Statistician’, solving the project using
different features & functions to arrive at your answers. This project will allow to demonstrate
sound application of analytic techniques on a very interesting dataset.

Tools

Duration 13 Weeks

Fee Rs. 24,900+GST

Batch Options Weekend

Interested? Contact Us!

+91-84680-02880 info@digitalvidya.com

www.digitalvidya.com

Attend a Free Orientation Session: http://www.digitalvidya.com/data-analytics-course