Professional Program in Data Analytics

Outcome Driven, Practitioner Designed

This program is designed to build the core competencies i.e., the knowledge and skills required to perform the tasks required
for the Data Analyst job role at the entry level. As part of the learning journey, learners build the right attitude that sets them
up for seamlessly transitioning to this role, as well as making them aware of some of the best practices that professionals are
expected to adopt. The tough challenges that they encounter as part of the program and the capstone project help accelerate
their experience.

Progressively Builds Core Competencies

As part of our holistic approach to making them job-ready we ensure that learners are equipped, not just with technical
competencies, but also the complementary engineering & behavioral competencies.

This program gradually transforms learners with no data analytics background into job-ready Data Scientists at an entry level.

The first part of this program will help you build foundational skills in statistics, data analysis, data visualization, programming,
and Relational Database Management Systems (RDBMS). During this foundational phase you will learn how to apply common
statistical methods for data analysis using Excel. In the process, you will learn how to organize data in the form of tables, and
how to better visualize it using graphs and pivot tables. You will then be introduced to RDBMSs and learn how to work with
large and complex data sets. Then, you will learn to do programming using Python. Python has become a preferred
programming language in the world of analytics. You will further sharpen your analytical skills by using specific Python libraries
that have been designed to improve the productivity of data analysts. You will get an opportunity to programmatically store
and manipulate data in an RDBMS and analyze it using Python. At this stage you will be ready to do Exploratory Data Analysis
(EDA).

You will then be introduced to an advanced data visualization tool called Tableau. Using Tableau, you will be able to do visual
analytics and create interactive dashboards and be able to effectively tell stories using data – a critical skill in the modern
workplace. At the end of the program, you would be completing a capstone project to perform to demonstrate the EDA and
visualization skills using Tableau.

© NIIT – 2022-23 - StackRoute For internal use only Page 1 of 3

Program Structure
We emphasize, that doing this program is not just about
attending virtual live sessions alone – it is also about following
through and completing the hands-on assignments & projects as
well. For an assignment to be considered complete, learners
must refactor their solution after getting it reviewed. Assignment
completion is necessary to move forward in the program.

The typical structure of a StackRoute program is shown in the

adjacent figure. At the top level, a program is mapped to the
target job role. In turn, the target job role is decomposed into its
constituent competencies which are broken down into the
associated collection of tasks that the job aspirants should be
able to do with confidence & precision. Tasks are in turn mapped
to the associated conceptual knowledge & skills along with the
associated tools, techniques, and best practices.

Structurally, the program is broken down into individual courses. Each course focuses on competency development – either
introducing a new competency or enhancing an existing one to the next level. Each learning sprint within a course typically
require minimum 10 hours of learning effort. Each learning sprint is mapped to a distinct task. It is built around a challenge
that validates a learner’s ability to perform that task effectively and provides granular feedback to the learner as well as the
mentor. By completing all activities in a Learning Sprint, learners acquire the necessary knowledge & skills to complete a task
and master the associated concepts. It is expected that learners spend 70% of the learning effort in a sprint on doing hands-on
practice or reviewing & refactoring their work to complete the sprint.

The table below details the competencies developed and the associated learning outcomes.

Topics, Tools, and Techniques

Course Name Brief Description Learning Sprints
Covered
1. Data Analytics Learn to analyze numerical  Perform Basic Data Analysis  Excel functions (range, sort,
Using Excel and categorized data using Using Excel filter, grouping, Lookups)
MS Excel as a tool. Use  Measure Central  Statistical concepts (Measures of
Descriptive Statistical Tendencies using Statistical central Tendency and Dispersion)
techniques to analyze data. Techniques  Visualization using Graphs and
Visually present the analysis  Data Visualization using Charts (bar, pie, histogram,
using graphs & charts using Excel scatter plots, and trend lines)
Excel  Measuring the Spread and
Correlation of Data

2. Analytics using Learn to represent data in  Creating & manipulating  ER modelling fundamentals
SQL the form of tables in a Database Objects with  DDL (create tables, set
Relational Database. Create, constraints constrains, insert data, modify
update and retrieve data  Query Data using SQL tables and drop tables)
stored in MySQL (RDBMS)  Retrieve Data from Multiple  DML(query using grouping,
database. Use Structured Tables using joins filtering, conditional query, query
Query Language (SQL) to  Retrieve Data using logical operators)
perform various operations subqueries  Joins, Subqueries & views
on the database.

© NIIT – 2022-23 - StackRoute For internal use only Page 2 of 3

3. Introduction to Learn to apply problem  Getting started with Python  Programming constructs (syntax
Programming solving techniques to  Decision making with and semantics)
using Python decompose a problem into conditional statements  Writing simple programs using
computational steps. Then  Iterative statements and list arithmetic and logical operators
to translate the steps into a operations (and, or, not)
program using the Python  Looping over data  Decision making using
language. structures conditional operators
 Writing modular programs  (if, else and elif)
in Python  Looping constructs (for and while
loop)
 User defined functions
 Lambda functions
4. Python for Use NumPy and Pandas  Creating & manipulating  Series
Data Science libraries in Python to arrays (1D & 2D) using  1 D NumPy Arrays
perform data analysis. NumPy  2 D NumPy Arrays
Launch Python scripts/shell  Creating & Manipulating  Reading CSV files into Data
scripts to automate tasks. Series and Data Frames Frames
Connect Python program to  Manipulating Data Frames  Data Frame manipulation
databases to retrieve and  Advanced Data Frame functions
manipulate data. Manipulation operations  Data Visualization using
 Analyzing & visualizing data Matplotlib.
using Python libraries  SQL and Python Interface
 Connecting SQL and Python  Measures of Central Tendency
 Descriptive Analysis using  Measures of Dispersion
Python
5. Exploratory Learn and apply the best  EDA using Descriptive  EDA best practice demonstration
Data Analysis practices of EDA in a Statistics  Univariate, Bivariate and Multi-
systematic way (Univariate,  EDA hackathon variate analysis
Bivariate and Multi-variate  EDA using inferential  Data visualization using graphs
Analysis) along with the Statistics and charts
statistical concepts. Present
the result of this analysis
visually.
6. Exploratory This course will help you deep  Build a view to explore data  Dimensions & Measures
Data Analysis dive into Visual Analytics. It  Structure data for analysis in  Discrete (blue), or continuous
using Tableau covers various advanced Tableau (green) Row level or Aggregates
techniques for analyzing data  Aggregate and disaggregate or multi-level aggregation
to enhance your EDA skills data in Tableau  Concepts related to the use of
 Creating Charts and Graphs graphs - Line, Bar, Stacked Bar,
 Creating data hierarchies Pie, Spider, Word Cloud, …)
7. Story Telling Learn to build Dashboards  Creating Story Lines  Drill Downs
using Tableau and tell stories using Data.  Data Blending in Tableau  Building Story lines
 Adding Filters  Interactive Dashboards
 Adding actions to Dashboards
8. Capstone Perform EDA using all the  Data cleaning  Combine all knowledge & skills
project 1 tools and techniques learned  SQL type queries learnt to solve a problem and
 Data visualization using walk-thru the solution
Tableau
 Presentation

© NIIT – 2022-23 - StackRoute For internal use only Page 3 of 3