DATA
ANALYTICS
MASTER COURSE
6 MONTHS OF INSTRUCTOR-LED, JOB
GUARANTEE DATA ANALYTICS COURSE
Accredited By:
In Alignment With:
+91 9580 740 740 info@iimskills.com www.iimskills.com
COURSE HIGHLIGHTS
160+ 100%
HOURS LECTURES JOB GUARANTEE
100+ 1 MONTH
HOURS ASSIGNMENTS PAID INTERNSHIP
8+ LMS
LIVE PROJECTS LIFETIME ACCESS
10+ 10 GLOBAL
Case Studies ACCREDITED
CERTIFICATES
24*7 1:1
SUPPORT Mentorship
7+ JOB PORTAL
TOOLS COVERED EXCLUSIVE ACCESS
+91 9580 740 740 info@iimskills.com www.iimskills.com
JOB INTERVIEW SKILLS
While you focus on your technical skills, we ensure that you are getting industry-
ready with our interview & corporate cultural training program
LinkedIn
Mock
Profile
Interviews
Building
Preparation
Puzzles
Statistics and
Business Case Studies
in Critical Thinking Guesstimate
Problem-
Corporate Solving/Critical
Culture and
Thinking
Behavioral Skill
Guesstimate
Resume Learning
Building Hackathon How To
Learn
Communication
Skills
+91 9580 740 740 info@iimskills.com www.iimskills.com
TOOLS COVERED
550 HIRING PARTNERS
+91 9580 740 740 info@iimskills.com www.iimskills.com
GET TRAINED BY INDUSTRY EXPERTS
GAURAV SETHI VANTHANA BABURAO JATIN SAHNAN
Lead Project Manager Data Scientist Data Analyst Consultant
HIRUTHIGA KASTHURI RAJESHWARI KHAIRNAR
Subject Matter Expert
Data Scientist
( AI & Business Analytics )
+91 9580 740 740 info@iimskills.com www.iimskills.com
PAST PLACEMENTS
MUKTI SHARMA UDAY K NEHA SHARMA
Junior Analyst Junior Analyst Intern
Data Analyst Data Analyst Data Analyst
BHAWANA S PAYAL GUPTA ANUBHAV MANDOL
Junior Analyst Intern Junior Research Analyst
Data Analyst Research Analyst Data Analyst
SHIVANSHI KUMAR RAVI PANDEY
VAIBHAV SEHGAL ROHIT SHARMA NITISH RANA
Intern Junior Analyst Junior Analyst
Junior Data Scientist Data Analyst Business Intelligence Analyst
+91 9580 740 740 info@iimskills.com www.iimskills.com
8 DATA ANALYTICS PROJECTS
Get 4+ Data Analytics projects, and participate in
hackathons & group assignments to master the skill
PROJECT 1 PROJECT 2
Sales Performance Relational Database and
Analysis (KPI) Dashboard Preparation
For the Given Dataset create dashboard Prepare Relational Database in SQL Server and
created on Microsoft Excel 365. Clean Data and connect with Power BI, Use Primary Keys and
use Pivot chart and Pivot table to analyse the foreign keys to establish the database. Connect
performance. Find out any trends in the sale. your SQL server with power BI. Extract and
Transform your Data using Power query editor.
Prepare basic dashboard in Power BI.
Skills required: Excel Skills required: Advanced excel,
SQL, Power BI
PROJECT 3 PROJECT 4
Retail Sales Data with Seasonal HR Analytics Employee
Trends & Marketing (Kaggle) Attrition & Performance
This dataset provides detailed insights into retail Download the Data set from Kaggle. For the given
sales, featuring a range of factors that influence main table and lookup date create a Data model
sales performance. It includes records on sales and analyse the data.
revenue, units sold, discount percentages,
marketing spend, and the impact of seasonal
trends and holidays.
Skills required: Python & Power BI Skills required: Power BI or Tableau
Also, Get 4 Notable (optional) Portfolio Building
Projects With Top MNCs Via Forage
+91 9580 740 740 info@iimskills.com www.iimskills.com
EXCLUSIVE BENEFITS
Monthly Webinars With Project
Hackathons
Industry Leaders Presentation Guidance
Live Doubt Weekly Group/ Corporate
1:1 Mentorship
Solving Sessions Individual Projects Behavioural Skills
+91 9580 740 740 info@iimskills.com www.iimskills.com
DEDICATED PLACEMENT SERVICES FOR YOU
Workshops on Attend Mock
Workplace Interviews
Behaviour
Premium
Job Portal
Build A Rocking Communication
Portfolio And Aptitude
Training
+91 9580 740 740 info@iimskills.com www.iimskills.com
OUR COURSE/ INTERNSHIP CERTIFICATIONS
+91 9580 740 740 info@iimskills.com www.iimskills.com
4 CAPSTONE PROJECT CERTIFICATIONS
+91 9580 740 740 info@iimskills.com www.iimskills.com
COURSE ADVANTAGES
100% Money-Back
Easy EMI Guarantee
Pay in 12 interest-free EMI If you do not like our course,
You can claim a 100%
money return after you
first session
Certification Fee
Price includes exam and COURSE
COURSE Group Discount
certification fees for IIM SKILLS & 10% group discount on 3 or
PG certification fee for Lisburn ADVANTAGES
ADVANTAGES more registrations
University.
Key Metrics For Job Complimentary
Mandatory participation in
every group project/hackathon Access
activity provided by the trainers to social media training for
and mandatory attendance of personal branding
minimum 90% is required
+91 9580 740 740 info@iimskills.com www.iimskills.com
AVERAGE SALARY
POSITION AVERAGE SALARY
Business Analyst INR 273K-1M
Senior Data Analyst INR 455K-2M
Data Analyst INR 346K-2M
Data Scientist INR 609K- 2M
+91 9580 740 740 info@iimskills.com www.iimskills.com
COURSE CURRICULUM
FOUNDATION TO DATA ANALYTICS
Introduction to Linear Algebra, Matrices Operations, Introduction to Statistics, Measures of central
tendencies, Measures of variance, Measures of frequency, What are analytics and data Science?,
Business Analytics vs. Data Analytics vs. Data Science, Common Terms in Analytics, Analytics vs. Data
warehousing, OLAP, MIS Reporting, Types of data (Structured vs. Unstructured vs. Semi-Structured),
Relevance of Analytics in industry and need of the hour, Critical success drivers, Overview of analytics
tools & their popularity, Analytics Methodology & problem-solving framework, Stages of Analytics.
DATA ANALYTICS USING SQL
Basics RDBMS Concepts
Data Types in SQL
Example of Database design
Types of relationship. (Primary key & Foreign Key)
Utilising The Object Explorer
What is SQL – A Quick Introduction
Installing MS SQL Server for Windows OS
Introduction to SQL Server Management Studio
Understanding basic Database concepts, Getting started
Data Based Objects Creation
Types of relationship (Primary key & Foreign key)
Drop & Truncate statements – Uses & Differences
Alter Table & Alter Column statements
Data Manipulation
Merging Data, Union and Union All – Use & Constraints
Intersect and Except statements
Table Joins – Inner Join, Left Join, Right Join, Full Join
Sub-queries
Optimizing your work
+91 9580 740 740 info@iimskills.com www.iimskills.com
DATA ANALYTICS USING ADVANCED EXCEL
Introduction to Data Handling
Introduction to Excel Environment
Formatting and Conditional Formatting
Data Sorting
Filtering and Data Validation
Understanding of Name Ranges
Data Visualisation in Excel
Overview of chart types – column and bar charts‘ line and area charts, pie charts, doughnut charts, scatter plots
How to select right chart for your data
Chart formatting
Creating and customizing advance charts – thermometer charts, waterfall charts, population pyramids.
Data Manipulation using Functions
Descriptive functions: sum, count, min, max, average, counta, countblank
Logical functions: IF, and, or, not, Relational operators > >= < <= !=
Nesting of functions
Date and Time functions: today, now, month, year, day, weekday, networkdays, weeknum, time, minute, hour
Text functions: left, right, mid, find, length, replace, substitute, trim, rank, rank.avg, upper, lower, proper
Array functions: sumif, sumifs, countif, countifs, sumproduct
Use and application of lookup functions in excel: Vlookup, Hlookup
Limitations of lookup functions
Using Index, Match, Offset
concept of reverse vlookup
Data Analysis and Reporting
Data Analysis using Pivot Tables – use of row and column shelf, values and filters
Difference between data layering and cross tabulation
summary reports
advantages and limitations
Change aggregation types and summarisation
Creating groups and bins in pivot data
Concept of calculated fields, usage and limitations, Changing report layouts – Outline, compact and tabular
forms, Show and hide grand totals and subtotals
Creating summary reports using pivot tables
Overview of Dashboards
What is dashboard & Excel dashboard
Adding icons and images to dashboards
Making dashboards dynamic
Create Dashboards in Excel
Using Pivot controls
Concept of pivot cache and its use in creating interactive dashboards in excel
Pivot table design elements – concept of slicers and timelines
Designing sample dashboard using Pivot Controls
Design principles for including charts in dashboards – do’s and don’t’s
+91 9580 740 740 info@iimskills.com www.iimskills.com
DATA ANALYTICS USING VBA
Introducing VBA
What is Logic?
What Is VBA?
Introduction to Macro Recordings, IDE
Key Components of Programming language
Essential VBA Language Elements
Keywords & Syntax
Programming statements
Variables & Data types
Comments
Operators
Working with Range Objects
How VBA Works with Excel
Working In the Visual Basic Editor
Introducing the Excel Object Model
Using the Excel Macro Recorder
VBA Sub and Function Procedures
Programming constructs in VBA
Control Structures
Looping Structures
The With- End with Block
Functions & Procedures in VBA - Modularizing your programs
Worksheet & workbook functions
Automatic Procedures and Events
Arrays
Objects & Memory Management in VBA
The NEW and SET Key words
Destroying Objects - The Nothing Keyword
Communicating with Your Users
Simple Dialog Boxes
User Form Basics
Using User Form Controls
Add-ins
Accessing Your Macros through the User Interface
Retrieve information through Excel from Access Database using VBA
Others
A look at some commonly used code snippets
Error Handling
Controlling accessibility of your code - Access specifier
Code Reusability - Adding references and components to your code
+91 9580 740 740 info@iimskills.com www.iimskills.com
DATA ANALYTICS USING POWER BI
Introducing Power BI
Introduction to Power BI
Installing Power BI Desktop (Signup for PowerBI)
Various Options in Power BI Desktop
Views in Power BI Desktop
ETL vs ELT
Data Preparation and Modelling
Connect and Retrieve data from different sources (csv, excel, etc.)
Query editor in Power BI
Power Query for cleaning the data
Power Query Functions – Text, Date, Numeric, Power Query Conditional Columns, Clean & transform data
with Query Editor
Work with relationships and cardinality
Combining data – Merging & Appending
Types of Relationships (1:1, 1, Many:1)
Data Analysis Expressions
Introduction to DAX
Calculated tables
Columns & Measures
Time Intelligence in DAX
Frequently Used DAX functions in Real-time (Calendar Functions, Filter Functions, Information Functions,
Text Functions, Logical Functions, Math functions, etc.)
Reports Development, Introduction to work with Power BI visuals
Reports Development in Power BI
Working with Different Visuals/Charts
Formatting Options in Reports
Use a slicer to filter visualizations
Working with Filters (Page Level, Include/Exclude, Report Level, Cross report Filter)
Download & use Custom Visuals from the gallery
Add an R or Python visual
Work with key performance indicators
+91 9580 740 740 info@iimskills.com www.iimskills.com
DATA ANALYTICS USING PYTHON
Python Essentials (Core)
Overview of Python – Starting with Python
Why Python for data science?
Anaconda vs. Python
Introduction to installation of Python
Introduction to Python IDE’s (Jupyter, Ipython)
Concept of Packages – Important packages
Installing & loading Packages & Name Spaces
Data Types & Data objects/structures (strings, Tuples, Lists, Dictionaries)
List and Dictionary Comprehensions
Variable & Value Labels – Date & Time Values
Basic Operations – Mathematical/string/date
Control flow & conditional statements
Debugging & Code profiling
Python Built-in Functions (Text, Numeric, Date)
User defined functions – Lambda functions
Concept of apply functions
Python – Objects – OOPs concepts
How to create & call class and modules?
Overview of Pandas
What is pandas
its functions & methods
Pandas Data Structures (Series & Data Frames)
Creating Data Structures (Data import – reading into pandas)
Operations With NumPy (Numerical Python)
What is NumPy?
Overview of functions & methods in NumPy
Data structures in NumPy
Creating arrays and initializing
Reading arrays from files
Special initializing functions
Slicing and indexing
Reshaping arrays
Combining arrays
NumPy Maths
+91 9580 740 740 info@iimskills.com www.iimskills.com
Data Cleaning and Transformation
Understand the data
Sub Setting / Filtering / Slicing Data
Using [] brackets
Using indexing or referring with column names/rows
Using functions
Dropping rows & columns
Mutation of table (Adding/deleting columns)
Renaming columns or rows
Sorting (by data/values, index)
By one column or multiple columns
Ascending or Descending
Type conversions
Setting index
Handling duplicates /missing/Outliers
Creating dummies from categorical data (using get_dummies())
Applying functions to all the variables in a data frame (broadcasting)
Data Visualization with Python
Introduction to Data Visualization
Plotting with Matplotlib
Plotting with Seaborn
Visualizing geospatial Data (Folium Package – Maps with Marker)
Waffle Charts
WordCloud
Regression Plots
Data Analysis using Python
Exploratory data analysis
Descriptive statistics
Frequency Tables,
and summarization
Uni-variate Analysis (Distribution of data & Graphical Analysis)
Bi-Variate Analysis (Cross Tabs, Distributions & Relationships, Graphical Analysis)
Linear Regression using SkLearn
Accuracy Metrics (RMSE & MSE)
Text Cleaning using Regex
Sentiment Analysis using TextBlob
+91 9580 740 740 info@iimskills.com www.iimskills.com
R FOR DATA ANALYTICS
Data Importing/Exporting
Introduction R/R-Studio – GUI
Concept of Packages – Useful Packages (Base & Other packages)
Data Structure & Data Types (Vectors, Matrices, Factors, Data frames, and Lists)
Importing Data from various sources
Exporting Data to various formats
Viewing Data (Viewing partial data and full data)
Variable & Value Labels – Date Values
Data Manipulation
Creating New Variables (Calculations & Binning)
Dummy variable creation
Applying transformations
Handling duplicates/missing data
Sorting and Filtering
Sub-setting (Rows/Columns)
Appending (Row/column appending)
Merging/Joining (Left, right, inner, full, outer)
Data type conversions
Renaming & Reshaping
Control Structures (if, if else)
Loops (Conditional, iterative loops)
Aggregation/Summarization
Data Analysis using R
Introduction to exploratory data analysis
Descriptive statistics
Frequency Tables
and summarization
Uni-variate Analysis (Distribution of data)
Bivariate Analysis (Cross Tabs, Distributions & Relationships)
Data Visualization with R
Basic Visualization Tools
Bar Charts/Histograms/Pie Charts
Scatter Plots
Line Plots and Regression Plots
Word Clouds
Box Plots
Visualization using ggplot
Statistical Methods & Hypothesis Testing using R
Descriptive vs. Inferential Statistics, What is a probability distribution?
Important distributions (discrete & continuous distributions)
Deep dive of normal distributions and properties (Central Limit Theorem)
Concept of Hypothesis Testing
Statistical Methods – Z/T-Tests, ANOVA, Correlation and Chi-square
Linear Regression using R
Introduction – Applications
Assumptions of Linear Regression
Building Linear Regression Model
Understanding standard metrics
Interpretation of Results
+91 9580 740 740 info@iimskills.com www.iimskills.com
DATA ANALYTICS USING TABLEAU
Introduction to Tableau
What is Tableau?
Tableau Architecture
Connecting to Data & Introduction to data source concepts
Understanding the Tableau workspace
Dimensions and Measures
Data Types & Default Properties
Shelves & Marks Card
Using Show Me
Saving and Sharing your work-overview
Data Handling & Summaries
Date Aggregations and Date parts
Cross tab & Tabular charts
Totals & Subtotals
Different Types of Charts and visualizations
Creating Filters and Parameters
Individual Axes, Blended Axes, Dual Axes & Combination chart
Trend Lines, Reference Lines, Forecasting
Creating Dashboards and Data Stories
Building Maps
Explain latitude and longitude
Default location/Edit locations
Building geographical maps
Table Calculations
Percent of Total, Running / Cumulative calculations
Introduction to LOD (Level of Detail) Expressions
User applications of Table calculations
Calculated Field
Basic Functions (String, Date, Numbers, etc)
Usage of Logical conditions
DATA ANALYTICS USING ALTERYX
Overview of the alteryx course and fundamental concepts, using the select tool to rename fields, change
the data type, understanding the user environment and alteryx settings, remove from data set,
understanding alteryx designer, connect to data sources, alteryx designer interface, set data field types,
user and workflow settings, remove and rename fields, filtering data/data processing, blending/join data
from different sources, filtering using string data, find customer with 10 or more transactions, input data,
dynamic rename, text to columns, transpose, identify common data fields, see how all records fit the
filter, data cleansing, impute values, random sample.
+91 9580 740 740 info@iimskills.com www.iimskills.com
COURSE TIMINGS
WEEKDAY BATCH WEEKEND BATCH
8:00 PM - 10:00 PM IST 10:00 AM - 1:00 PM IST
Tuesday, Wednesday Saturday and
and Thursday Sunday
COURSE FEE
SELF PACED PROGRAM MASTER PROGRAM POST GRADUATE PROGRAM
One Year LMS Access Lifetime LMS Access Lifetime LMS Access
Course Completion Certificate Master Certification from IIM SKILLS PG Certification from Lisburn University
Job Support 1 Year Unlimited Interviews Access 100% Placement Guarantee
Placement Portal Access Group Mentorship 1:1 Mentorship
Mentorship Placement Portal Access Placement Portal Access
LinkedIn Profile Optimization Weekly Group Doubt Solving Weekly Group Doubt Solving
Mock Interview Preparation LinkedIn Profile Optimization LinkedIn Profile Optimization
Internship Mock Interview Preparation
Mock Interview Preparation
Access to Interview Prep Training Paid Internship
Paid Internship
Global Placement Support Access to Interview Prep Training
Access to Interview Prep Training
Hackathons Global Placement Support
Global Placement Guarantee
WhatsApp Group Hackathons
Hackathons
Work From Home WhatsApp Group
WhatsApp Group
Social Media Training For Social Media Training For
Personal Branding Personal Branding Social Media Training For
Personal Branding
INR 24,900 + 18% GST INR 49,900 + 18% GST INR 1,49,900 + 18% GST
ENROL NOW ENROL NOW ENROL NOW
HEAD OFFICE: IIM SKILLS, 308, 3rd Floor, BRANCH OFFICE: IIM SKILLS, Ofis Square Tower,
HB Twin Tower, Netaji Subhash Place, First Floor A-1, Near Sector-16, Block A, Noida
Pitam Pura, Delhi-110034 Sector 3, Noida, Uttar Pradesh-201301
+91 9580 740 740 info@iimskills.com www.iimskills.com
