DATA ANALYTICS

MASTER COURSE
In Alignment With :

6 Months Comprehensive Program

7Certifications
7 Live Projects
2 Months Internship Opportunities with

Master Certification 100% Tools Driven Training 24*7 Support

Earn industry's most trusted Learn to leverage high-end Get round-the-clock support
Master's Certification in Data tools and technology to process from the IIM SKILLS team, ruling
Analysis from IIM SKILLS. Data Analytics efficiently. out all your worries and doubts

Lifetime support Practical Learning Resume & Interview

GET STARTED Learn from the best in the Preparation
Enjoy the all-time benefit of
free access to complete industry with a 100% focus on Additional support from team
resource material and practical acquisition. Become members to build customised
recordings via LMS. job-ready by the end of the resumes and prepare for the
course. interview.

Contact Us: +91 9580740740 www.iimskills.com info@iimskills.com

 Well-Researched & Curated Offerings

6 Months of Live Training

( 160 Hours Lectures )

Internship Opportunities With Accenture, TCS,

PWC and Quantium

Preparation For Master Certifications in Alignment With

IIM SKILLS (Govt of India) Microsoft & Google

Data
Analytics 7 Certifications: 3 Course Completion + 4 Internship
Completion
Master
Course

7+ Live Projects | 10+ Case Studies

Master 7+ Tools Like Excel, SQL, Power BI, Python,

Tableau, R and Alteryx

Mock Interview Preparation, LinkedIn Profile

Building & Community Support

Contact Us: +91 9580740740 www.iimskills.com info@iimskills.com

 Course
Tools Curriculum Highlight
Covered

EXCEL TABLEAU POWER BI PYTHON

SQL R ALTERYX

Course Curriculum Highlight

Course Curriculum Highlight

1 Data Analytics Using Advance Excel

2 Data Analytics Using VBA

3 Data Analytics Using SQL

4 Data Analytics Using Power BI

5 Data Analytics Using Python

6 Data Analytics Using Tableau

7 R For Data Science

8 Data Analytics Using Alteryx

Contact Us: +91 9580740740 www.iimskills.com info@iimskills.com

+91-9580740740 www.iimskills.com info@iimskills.com
 Multi-Dimensional Practical
Learning Journey

01 Assignments
Test your classroom learning and curriculum knowledge
through 100+ Hours assignments across modules

02 Case Studies
Get practical exposure by working on three industry
relevant case studies

03 Capstone Project
Hone the real world-application of Data Analytics
skills and build your portfolio by working on Four
capstone projects

04 Internship Opportunities
Build your profile by working with our partner firms on
four promising internship roles

05 Placement Support
Access to a plethora of job opportunities with 500+
Hiring Partners through our proprietary job portal

Contact Us: +91 9580740740 www.iimskills.com info@iimskills.com

 This Course
This CourseSuits BestBest
Suits for for

This wholesome Data Analysis Course by IIM SKILLS experts is customized to match the tastes
and minds of people belonging to fresher, mid-level, and senior-level positions in the industry.
Without any foundations, this course is a first-rate fit for anyone eyeing a career in the world
of data analytics. While the best candidates for taking the Data Analysis Course are aspiring
professionals from different educational backgrounds who have an analytical mindset.
However, at IIM SKILLS, we believe that anyone can and should pursue a course that wants to
make a breakthrough in their career maze with this data analysis course.

Generally speaking, the Data Analysis Course is suitably meant for you if you are someone
from these fields:

Fresh Graduates IT Professionals Sales Professionals

Fresh graduates should consider a IT professionals should consider a Sales professionals can benefit from
Data Analytics Course to boost their Data Analytics Course to diversify a Data Analytics Course to enhance
employability, expand career their skills, stay relevant in the tech sales strategies, identify trends, and
opportunities, and develop valuable industry, and explore new career improve customer engagement,
skills. opportunities. leading to increased sales and
revenue.

Banking and Finance Supply Chain Network

UG/PG Students
Professionals Managers

Banking and finance professionals Fresh UG/PG students should pursue Supply chain network managers
should pursue a Data Analytics a Data Analytics Course to gain should consider a Data Analytics
Course to gain insights for better valuable skills, enhance Course to optimize logistics, reduce
decision-making, improve customer employability, and prepare for data- costs, and improve efficiency by
experiences, and stay competitive. driven industries. leveraging data-driven insights.

Marketing Managers

Marketing managers can benefit

from a Data Analytics Course by
learning to leverage data for
targeted campaigns, improving ROI,
and staying ahead in the digital
age.

Contact Us:
Contact Us: +91 9580740740
+91 9580740740
www.iimskills.com
www.iimskills.com
info@iimskills.com
info@iimskills.com
 This Course
Trained SuitsExperts
By Industry Best for

Gaurav Sethi Vanthana Baburao Jatin Sahnan

Lead Project Manager Data Scientist Data Analyst Consultant

500+
500+ Hiring
Hiring
Technicals Partners
ofPartners
Financial Modeling

Absolutdata

Contact Us: +91 9580740740 www.iimskills.com info@iimskills.com

 Cerifications

Course Certifications

Internship Certifications

Contact Us: +91 9580740740 www.iimskills.com info@iimskills.com

 Strong Record of Career Empowerment

Contact Us: +91 9580740740 www.iimskills.com info@iimskills.com

 Internship Opportunities

What You'll Do:

Read and analyze a client project brief to understand the client and business problem, identify the
requirements that need to be delivered, and identify which tasks you need to focus on as a data analyst
Identify which datasets will be required to answer the client’s business question
Clean the datasets and merge them to prepare the data for analysis
Determine the answer to the client’s business question
Choose the data visualizations that best support the story you want to tell to the client
Create a PowerPoint presentation that reports on the client’s content performance

What You'll Learn:

What are the responsibilities of a Data Analyst at Accenture
What is a typical project team structure
How to review a client project brief
How to clean, model and analyze data to create valuable insights for the client
How to connect the business and the data, and how to communicate relevant and engaging insights in
a presentation

Skills You will Learn and Practice:

Teamwork Storytelling
Strategy Data Visualization
Project Planning Presentations
Data Understanding Communication
Data Modeling Public Speaking
Data Analysis

Tools & Technologies used:

Excel, Power point, Power BI or any visualization tool

Contact Us: +91 9580740740

+91-9580740740
www.iimskills.com
www.iimskills.com info@iimskills.com
info@iimskills.com
 Internship Opportunities

What You'll Do:

Write questions that you think will be important and relevant to the CEO and CMO
Identify the visual that would explain the data and insights in the simplest possible manner
Create the visuals around the questions the CEO and CMO requested

What You'll Learn:

How to think from the perspective of business leaders to analyse data more effectively
How to prepare for a meeting with senior leaders
How to choose visuals to communicate information effectively
How to visualize data analysis to help executives with effective decision-making
How to use Tableau or PowerBI software
How to present effectively to senior leadership

Skills You will Learn and Practice:

Teamwork Storytelling
Strategy Data Visualization
Project Planning Presentations
Data Understanding Communication
Data Modeling Public Speaking
Data Analysis

Tools & Technologies used:

Excel, Power point, Power BI or any visualization tool

Contact Us: +91 9580740740

+91-9580740740
www.iimskills.com
www.iimskills.com info@iimskills.com
info@iimskills.com
 Internship Opportunities

What You'll Do:

Watch videos on digital upskilling and the journey of driving a digital mindset.
Reflect on the provided self-reflection question and respond in the text field.
Create a dashboard in Power BI for visualizing relevant KPIs and metrics in the dataset provided.
Utilize the resources provided, including podcasts and articles, to enhance your understanding of data
visualization and upskilling.
Respond to the client's request by providing a well-designed Power BI dashboard reflecting the requested
KPIs.
Create a dashboard using the defined KPIs to reflect customer demographics and insights.
Write a concise email to the engagement partner explaining your findings and providing suggestions for
necessary changes based on the dashboard you've created.
Create visualizations to represent HR data, particularly focusing on gender-related KPIs.
Identify and discuss potential root causes for the slow progress in achieving gender balance at the
executive management level.

What You'll Learn:

The importance of digital transformation and upskilling in today's business landscape.
The purpose and goals of the Digital Accelerator program.
The importance of upskilling in the digital age and its role in the workplace.
The concept of becoming a "Digital Accelerator" and the skills associated with it.
How to create a Power BI dashboard for visualizing key performance indicators (KPIs) and metrics.
How to define key performance indicators (KPIs) related to customer retention.
How to create a dashboard that visualizes customer demographics and insights.
How to define key performance indicators (KPIs) related to gender balance and diversity.
How to create visualizations that represent HR data effectively.
The imperatives of diversity and inclusion in the corporate world.

Skills You will Learn and Practice:

Self-Reflection Insights and Actions

Defining KPIs Calculating Measures
Power BI Dashboard Insight and Actions
Power BI

Tools used:

POWER BI

Contact Us: +91 9580740740

+91-9580740740
www.iimskills.com
www.iimskills.com info@iimskills.com
info@iimskills.com
 Internship Opportunities

What You'll Do:

Analyse transaction and customer data to identify trends and inconsistencies.
Develop metrics and examine sales drivers to gain insights into overall sales performance.
Create visualizations and prepare findings to formulate a clear recommendation for the client's strategy.
Define metrics to select control stores.
Analyse trial stores against controls.
Use the Pyramid Principles framework for structuring the report.
Submit a report that incorporates data visualizations, key insights, and recommendations.
Use R/Python for data analysis and visualization summarise findings and provide recommendations.

What You'll Learn:

Understand how to examine and clean transaction and customer data.
Learn to identify customer segments based on purchasing behavior.
Gain experience in creating charts and graphs to present data insights.
Learn how to derive commercial recommendations from data analysis.
Understand experimentation and uplift testing, comparing trial and control stores.
Learn control store selection based on defined metrics.
Gain experience in data visualization.
Perform statistical analysis to assess sales differences and formulate recommendations.
Gain experience in preparing a client report based on data analysis.
Understand the "Pyramid Principles" framework for report structure.
Practice creating data visualizations and key callouts.
Develop skills in translating data into actionable insights and recommendations.

Skills You will Learn and Practice:

Data validation Commercial thinking
Data visualisation Statistical testing
Data wrangling Presentation skills
Programming Communication skills
Data analysis

Tools used:

PYTHON

Contact Us: +91 9580740740

+91-9580740740 www.iimskills.com
www.iimskills.com info@iimskills.com
info@iimskills.com
 Hands On Projects

Excel

Project- 1 Project- 2
Data interpretation using advance Excel Data visualisation in Excel using pivot tables
formulas and charts

VBA

Project- 1 Project- 2
Macro creation of a table using Input Box Automation of opening and copying content
method from Excel using VBA programming

SQL

Project- 1 Project- 2 Project- 3

Write a SQL query to calculate Write a SQL query to find those Write a SQL query to identify
total purchase amount of all employees whose salaries are employees who do not have a
orders less than 6000 department number

Python Power BI

Project Project
Adopting Data manipulation techniques and Using the given marketing data, prepare a
providing various visualizations using the given data visualization with icons of your choice that help to see
frame with the help of Python libraries like Pandas, for which country the bonus and contractual penalty
Numpy, Matplotlip etc conditions are met.

Contact Us: +91 9580740740 www.iimskills.com info@iimskills.com

 Hands On Projects

Tableau

Project- 1 Project- 2
Create a Dashboard showing using COVID Using Netflix data, FInd interesting insights
data to project the number of cases and about the availability in different countries,
deaths and project any insights from the Actors & Directors and compare the insights
visuals with any other related Data.

Project- 1 Project- 2 Project- 3

Write an R program to create a Write a R program to get the Write a R program to create a
data frame from four given statistical summary and factor corresponding to a height
vectors. nature of the data of a given of women data set, which
data frame contains height and weights for
a sample of women.

Alteryx

Project- 1 Project- 2
Manipulation of Date/time field for the given Using Dataset from HR department, create a
Dataset using Alteryx multilevel hierarchy for employee-manager
Data relationship by using iterative macros in
Alteryx

Contact Us: +91 9580740740 www.iimskills.com info@iimskills.com

 Industry Relevant Practical Curriculum

Data Analytics
MSUsing
Excel Advance Excel

Introduction to Excel Environment

Formatting and Conditional Formatting
Introduction to Data Handling
Data Sorting, Filtering, and Data Validation
Understanding of Name Ranges

Overview of chart types - column and bar charts, line and

area charts, pie charts, doughnut charts, scatter plots
How to select the right chart for your data
Data Visualisation in Excel Chart formatting
Creating and customizing advanced charts - thermometer
charts, waterfall charts, population pyramids

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 summarization
Data Analysis and Reporting 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

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,
Data Manipulation using weekday, networkdays, weeknum, time, minute, hour
Text functions: left, right, mid, find, length, replace,
Functions
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

What is a dashboard & Excel dashboard

Overview of Dashboards Adding icons and images to dashboards
Making dashboards dynamic

Contact Us: +91 9580740740 www.iimskills.com info@iimskills.com

 Industry Relevant Practical Curriculum

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
Create Dashboards in Excel timelines
Designing a sample dashboard using Pivot Controls
Design principles for including charts in dashboards - do's
and don’t's

Data Analytics Using VBA

What is Logic?
Introduction to VBA What Is VBA?
Introduction to Macro Recordings, IDE

Working In the Visual Basic Editor

Introducing the Excel Object Model
How VBA Works with Excel Using the Excel Macro Recorder
VBA Sub and Function Procedures

Key Components of Programming language:

Essential VBA Language Elements
Keywords & Syntax
Key Components Programming statements
Variables & Data types
Comments
Operators
Working with Range Objects

Simple Dialog Boxes

User Form Basics
Communicating with Your Using User Form Controls
Add-ins
Users Accessing Your Macros through the User Interface
Retrieve information through Excel from Access Database
using VBA

Control Structures
Programming Constructs Looping Structures
The With- End with Block

Contact Us: +91 9580740740 www.iimskills.com info@iimskills.com

 Industry Relevant Practical Curriculum

Objects & Memory Management in VBA:

Objects & Memory
The NEW and SET Keywords
Management Destroying Objects - The Nothing Keyword

Functions & Procedures in VBA - Modularizing your

programs:
Functions & Procedures Worksheet & workbook functions
Automatic Procedures and Events
Arrays

A look at some commonly used code snippets

Error Handling
Other Skills Controlling accessibility of your code - Access specifier
Code Reusability - Adding references and components to
your code

Data Analytics Using SQL

Schema - Meta Data - ER Diagram

Looking at an example of Database design
Data Integrity Constraints & types of Relationships (Primary
Basics RDBMS Concepts and foreign key)
Basic concepts – Queries, Data types & NULL Values,
Operators and Comments in SQL

What is SQL - A Quick Introduction

Installing MS SQL Server for Windows OS
Utilizing the Object Explorer Introduction to SQL Server Management Studio
Understanding basic database concepts
Getting started

Data based objects creation (DDL Commands):

Creating, Modifying and deleting Databases and Tables
Data Based Objects Creation Drop & Truncate statements - Uses & Differences
Alter Table & alter Column statements
Import and Export wizard to get the data in SQL server from
excel files or delimited files

SQL Server Integration Services

Understanding the Basics of SSIS
SQL Server Integration Understanding Packages
Creating Packages to integrate
Creating Project using SSIS

Contact Us: +91 9580740740 www.iimskills.com info@iimskills.com

 Industry Relevant Practical Curriculum

Basics of SSRS
Creating Parameters
SQL Server Reporting Services Understanding Visualisation
Creating Visualisation using SSRS

Data manipulation (DML Commands):

Insert, Update & Delete statements
Select statement – Subsetting, Filters, Sorting. Removing
Duplicates, grouping and aggregations, etc
Data Manipulation Where, Group By, Order by & Having clauses
SQL Functions – Number, Text, Date, etc
SQL Keywords – Top, Distinct, Null, etc
SQL Operators - Relational (single-valued and multi-
valued), Logical (and, or, not), Use of wildcard operators
and wildcard characters, etc

Accessing data from Multiple Tables using SELECT

Append and Joins
Union and Union All – Use & constraints
Intersect and Except statements
Other Skills Table Joins - inner join, left join, right join, full join
Cross joins/cartesian products, self joins, natural joins, etc
Inline views and sub-queries
Optimizing your work

Contact Us: +91 9580740740 www.iimskills.com info@iimskills.com

 Industry Relevant Practical Curriculum

Data Analytics Using Power BI

Introduction to Power BI
Installing Power BI Desktop (Signup for PowerBI)
Various Options in Power BI Desktop
Introduction Power BI Views in Power BI Desktop
Template Apps
Task pipeline when your working on a project

Introduction to DAX
Calculated tables, Columns & Measures
Time Intelligence in DAX
Data Analysis Expressions Frequently Used DAX functions in Real-time (Calendar
Functions, Filter Functions, Information functions, Text
Functions, Logical Functions, Math functions, Parent & Child
functions etc..)

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
Data Preparation & Modelling Power Query Conditional Columns
Clean and transform data with Query Editor
Define data granularity
Combining data – Merging & Appending
Fill Down in Power BI, Grouping, Transpose, Unpivot, Data
Types, Replace errors and values

Reports Development (Visuals in Power BI):

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
Reports Development
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
Project to Implement the Learning

Keep and Remove rows, Add Remove and Go To Columns:

Work with relationships and cardinality
Rows and Columns Types of Relationships (1:1, 1: Many, Many:1)
Optimizing for performance
PBIDS Files

Contact Us: +91 9580740740 www.iimskills.com info@iimskills.com

 Industry Relevant Practical Curriculum

Data Analytics Using Python

Introduction to Statistics
Measures of central tendencies
Measures of variance Measures of frequency
Introduction to Basic Statistics Measures of Rank
Basics of Probability, distributions
Conditional Probability (Bayes Theorem)

Introduction to Mathematical foundations:

Introduction to Linear Algebra
Matrices Operations
Introduction to Calculus
Mathematical foundations Derivatives & Integration
Maxima, minima
The area under the curve
Theory of optimization

Introduction to Analytics & Data Science:

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-
Analytics & Data Science
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

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
NumPy, SciPy, sci-kit-learn, Pandas, matplotlib, etc
Installing & and loading Packages & and name Spaces
Data Types & Data objects/structures (strings, Tuples, Lists,
Dictionaries)
Python Essentials (Core) List and Dictionary Comprehensions
Variable & Value Labels – Date & Time Values
Basic Operations – Mathematical/string/date
Control flow & and conditional statements
Debugging and code profiling
Python Built-in Functions (Text, numeric, date, utility functions)
User-defined functions – Lambda functions
Concept of applying functions
Python – Objects – OOPs concepts
How to create & call class and modules?

Contact Us: +91 9580740740 www.iimskills.com info@iimskills.com

 Industry Relevant Practical Curriculum

Data Analytics Using Python

What are Pandas, their functions & methods

Pandas Data Structures (Series & Data Frames)
Overview of Pandas Creating Data Structures (Data Import – reading into
Pandas)

What is NumPy?
Overview of functions & methods in NumPy
Data structures in NumPy
Creating arrays and initializing
Reading arrays from files
Operations with NumPy Special initializing functions
Slicing and indexing
Reshaping arrays
Combining arrays
NumPy Maths

Exploratory data analysis

Descriptive statistics, Frequency Tables, and summarization
Uni-variate Analysis (Distribution of data & Graphical
Data Analysis using Python
Analysis)
Bi-Variate Analysis(Cross Tabs, Distributions &
Relationships, Graphical Analysis)

Introduction to Data Visualization

Introduction to Matplotlib
Data Visualization with Python Basic Plotting with Matplotlib
Line Plots

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
Cleansing Data with Python 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 manipulation tools(Operators, Functions, Packages,
control structures, Loops, arrays etc.)

Contact Us: +91 9580740740 www.iimskills.com info@iimskills.com

 Industry Relevant Practical Curriculum

Data Analytics Using Python

Waffle Charts
Advanced Visualization Tools Word Clouds
Seaborn and Regression Plots

Area Plots
Histograms
Bar Charts
Basic Visualization Tools Pie Charts
Box Plots
Scatter Plots
Bubble Plots

Statistical Methods & Hypothesis Testing:

Descriptive vs. Inferential Statistics
What is a probability distribution?
Important distributions (discrete & continuous
Statistical Methods distributions)
Deep dive of normal distributions and properties
and Hypothesis Concept of sampling & and types of sampling
Concept of standard error and central limit theorem
Concept of Hypothesis Testing
Statistical Methods - Z/T-Tests (One sample, independent,
paired), ANOVA, Correlation and Chisquare

Introduction to Folium
Visualizing Geospatial Data Maps with Markers
Choropleth Maps

Contact Us: +91 9580740740 www.iimskills.com info@iimskills.com

 Industry Relevant Practical Curriculum

Data Analytics Using Tableau

What is Tableau? What does the Tableau product suite

comprise? How Does Tableau Work?
Tableau Architecture
Connecting to Data & Introduction to data source concepts
Understanding the Tableau workspace
Getting Started Dimensions and Measures
Data Types & Default Properties
Tour of Shelves & Marks Card
Using Show Me
Saving and Sharing your work-overview

Date Aggregations and Date parts

Cross tab & Tabular charts
Data Handling & Summaries Totals & Subtotals
Bar Charts & Stacked Bars
Line Graphs with Date & Without Date

Building Advanced Reports/ Map

Explain latitude and longitude
Building Reports/ Map Default location/Edit locations
Building geographical maps
Using Map layers

Explain the scope and direction

Percent of Total, Running / Cumulative calculations
Table Calculations Introduction to LOD (Level of Detail) Expressions
User applications of Table calculations

Working with aggregate versus disaggregate data

Explain - #Number of Rows
Calculated Fields Basic Functions (String, Date, Numbers, etc)
Usage of Logical conditions

Tree maps Context filters

Scatter Plots Sets
Edit axis In/Out Sets
Parts of Views Grouping
Sorting Bins/Histograms
Data Handling & Summaries Trend lines Hierarchies
Reference Lines View data
Forecasting Actions (across sheets)
Filters
Individual Axes, Blended Axes, Dual Axes & Combination chart
Drilling up/down – drill through

Contact Us: +91 9580740740 www.iimskills.com info@iimskills.com

 Industry Relevant Practical Curriculum

R For Data Science

Introduction R/R-Studio - GUI

Concept of Packages - Useful Packages (Base & Other
packages)
Data Structure & Data Types (Vectors, Matrices, Factors,
Data frames, and Lists)
Data Importing/Exporting Importing Data from various sources
Exporting Data to various formats
Viewing Data (Viewing partial data and full data)
Variable & Value Labels – Date Values

Creating New Variables (calculations and binning)

Dummy variable creation
Applying transformations
Handling duplicates/missing's
Sorting and Filtering
Data Manipulation Subsetting (Rows/Columns)
Appending (Row/column appending)
Merging/Joining (Left, right, inner, full, outer)
Data type conversions
Renaming
Formatting

Reshaping data
Sampling
Operators
Control Structures (if, if else)
Loops (Conditional, iterative loops)
Data Manipulation Apply functions
Arrays
R Built-in Functions
Text, Numeric, Date, utility
R User-Defined Functions
Aggregation/Summarization

Basic Visualization Tools

Bar Charts/Histograms/Pie Charts
Scatter Plots
Line Plots and Regression
Specialized Visualization Tools
Word Clouds/ Radar Charts
Data Visualization with R Waffle Charts/ Box Plots
How to create Maps
Creating Maps in R
How to build interactive web pages
Introduction to Shiny
Creating and Customizing Shiny Apps
Additional Shiny Features

Contact Us: +91 9580740740 www.iimskills.com info@iimskills.com

 Industry Relevant Practical Curriculum

R For Data Science

Introduction exploratory data analysis

Descriptive statistics, Frequency Tables, and summarization
Data Analysis Uni-variate Analysis (Distribution of data)
Bivariate Analysis(Cross Tabs, Distributions & Relationships)

R and Relational Databases

Connecting to Relational Databases using RJDBC and RODBC
Using R with Databases Database Design and Querying Data
Modifying Data and Using Stored Procedures
In-Database Analytics with R

Basic Statistics - Measures of Central Tendencies and

Variance
Introduction to Statistics Building blocks - Probability Distributions – Normal
distribution - Central Limit Theorem
Inferential Statistics -Sampling - Concept of Hypothesis

Statistical Methods - Z/t-tests (One sample, independent,

Testing paired), Anova, Correlations and Chisquare

Linear Regression: Solving regression problems:

Introduction - Applications
Assumptions of Linear Regression
Building Linear Regression Model
Understanding standard metrics (Variable significance, R-
Linear Regression square/Adjusted R-square, Global hypothesis, etc)
Assess the overall effectiveness of the model
Validation of Models (Re-running vs. Scoring)
Standard Business Outputs (Decile Analysis, Error
distribution (histogram), Model equation, drivers, etc.)
Interpretation of Results - Business Validation -
Implementation on new data

Contact Us: +91 9580740740 www.iimskills.com info@iimskills.com

 Industry Relevant Practical Curriculum

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 the data set
Understanding Alteryx Designer
Connect to data sources
Alteryx designer Interface
Set data field types
User and Workflow settings
Remove and rename fields
Alteryx Filtering Data/Data processing
S Blending/Join Data from Different Sources
Filtering Using String Data
Find a 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

Contact Us: +91 9580740740 www.iimskills.com info@iimskills.com

 DATA ANALYTICS MASTER COURSE
Weekend Batch

Every Saturday & Sunday | 10 AM to 1 PM

Course Fee :
INR 49,900 + GST

Reach Us
Call: +91-9580740740 | Email: info@iimskills.com

Office Address:
IIM SKILLS, 302, 3rd Floor,
H B Twin Tower, Max Hospital Building,
Netaji Subhash Place, Pitam Pura, New Delhi, Delhi-110034