top of page

Data Analytics

Basics to Advanced

Course Syllabus

One of the best-suited careers for this century is Data Analyst. It's digital, programming-based, and data-driven. As a result, it's no surprise that demand for Data Analysts has been increasing in recent years. And of course anyone from Non-IT or IT background can make a career in this field


With this course, you will learn the applicability of data analytics across fields, and how data analysis can help you make data-driven decisions & make a successful career in IT.

Salary
Tools You'll Learn
Image 1

Essential Math & Statistics

Image 4

MS Power BI

Image 7

Looker Studio

Image 11

Google Sheets

Image 2

Advanced Excel

Image 5

MySQL

Image 8

Business Finance

Image 12

Google Workspace

Image 3

Python

Image 6

Tableau

Image 9

Git & GitHub

Image 13

Placement Assistance

Our Roadmap
Roadmap
Mathematics & Statistics
applied-mathematics-arithmetic-mathematical-notation-calculation-division-statistics-mathematics-science-emoticon-smiley-removebg-preview

A significant portion of your ability to translate your data science skills into real-world scenarios depends on your success and understanding of mathematics. Data science careers require mathematical and stattistical study because algorithms, and performing analysis and discovering insights from data require math and stats.

  • Numbers & Number System

  • Factorization of Numbers

  • Mathematical Computation

  • Number Series

  • Ratio & Proportion

  • Percentage, Percentile & IQR

  • Profit/ Loss

  • Interest

  • Permutation and Combination

  • Set Theory

  • Probability

  • Measures of Central Tendency

Advanced Excel
61045dfc9cd69c000418c11a

(8+ Live Projects)

Excel is a spreadsheet application that can be used for data analytics. Data analysts use Excel to analyze large amounts of data quickly and easily. With its wide range of charting and graphing options, Excel can help users to present data in a way that is easy to understand. Charts and graphs are essential tools for data analysis, as they allow users to quickly identify patterns and trends in data. What you'll learn here:

  • Excel Interface

  • Data Formatting Techniques

  • Data Cleaning Techniques

  • Data Study Techniques

  • Consditional Formatting

  • Data Validation

  • Calculations in Excel

  • Operators in Excel

  • Different Types of Operators

  • Mathematical & Statistical Calculations

  • Financial Calculations

  • Basic Inbuilt Excel Functions (SUM, MIN, MAX, COUNT etc.)

  • Advanced Functions (VLOOKUP, SUMIFS, COUNTIS etc.)

  • Macros, VBA, Power Pivot & Power Query

  • Analytics Using Functions

  • Pivot Tables

  • Analytics Using Pivot Tables

  • Data Visualization in Excel

  • Applying Charts & Graphs

  • Dashboard & Report Building

Python
5848152fcef1014c0b5e4967

(5+ Live Projects)

Python has become a popular programming language for data analysis and data science due to its simplicity, versatility, and a wide range of libraries and frameworks specifically designed for data manipulation, exploration, and visualization. It's easy to learn, widly used & versatile. It also has wide range of libraries and frameworks. What you'll learn here:

  • Introduction to Python

  • Environment Setup

  • Installing Anaconda

  • Working with Jupyter Notebooks & Lab

  • Python Basics

  • Syntax

  • Variables

  • Data Types

  • Type Casting

  • Keywords & Identifiers

  • Operators

  • Types of Operators

  • Mathematical Calculations

  • Data Structures in Python

  • Int and Float

  • Complex Numbers

  • Boolean

  • Strings

  • String Methods

  • Lists

  • Multidimentional Lists

  • List Methods

  • Tuples

  • Tuple Methods

  • Sets and Frozen Sets

  • Set Methods

  • Dictionary

  • Dictionary Methods

  • Comprehensions

  • Functions

  • Modules

  • Libraries

  • Importing Libraries

  • Data Analytics in Python

  • Introduction to NumPy

  • NumPy Methods

  • NumPy Data Types

  • NumPy Calculations

  • Data Manipulation with NumPy

  • Introduction to Pandas

  • Pandas Data Structures

  • Working with DataFrames

  • Importing Data File Types

  • Data Manipulations

  • Data Cleaning

  • Data Wrangling

  • Generating Insights

  • Exporting Data

  • Data Visualization with Matplotlib

  • Data Visualization with Seaborn

  • Working with Different Chart Types

  • Effective Data Visualization

Power BI
Microsoft-Power-BI-Logo

(10+ Live Projects)

Power BI is a business intelligence service from Microsoft that helps businesses and individuals transform raw data into insights. It is a group of BI (business intelligence) services and products that converts data from various sources into reports, visualizations, and interactive dashboards. Power BI is a valuable tool for illustrating what’s happening within an organization in the present. It also has applications for helping to anticipate what may transpire in the future. What you'll learn here:

  • Introduction to Business Intelligence

  • Different BI Tools

  • Introduction to Power BI

  • Installing Power BI Desktop

  • Working with Interface

  • Understanding 4 Views

  • Report, Table, Model & Query View

  • Importing Different Data Files

  • Types of Import

  • Introduction to Big Data

  • Working with Canvas

  • Working with Charts

  • Choosing Correct Chat Types

  • Formatting Charts

  • Types of Formatting

  • Importing Visuals

  • Applying Themes

  • Building Dahboards & Reports

  • Data Tranformation

  • Data Cleaning

  • Introduction to Power Query

  • Power Query Editor

  • Importing Data in Power Query Editor

  • Bulk Import Data

  • Applying Data Cleaning Techniques

  • Introduction to Data Modeling

  • Working with Relationships

  • Cardinality & Direction

  • Types of Tables

  • Schemas & Types of Schemas

  • Creating Schemas

  • Schema Conversion

  • Introduction to Functional Programming

  • Introduction to DAX

  • Syntax

  • Data Types

  • Operators & Types of Operators

  • Keywords & Identifiers

  • Inbuilt Functions

  • Calculation Types

  • Creating Calculated Columns

  • Creating Calculated Measures

  • Creating Calculated Tables

  • Contexts

  • Types of Contexts

  • Variables and Returns

  • Scope of Variables & Calculations

  • Comments

  • Working with Inbuilt Functions

  • Types of Inbuilt Functions

  • Analyzing Data with DAX

  • Introduction to Power BI Management

  • Workspaces

  • Publishing Dashboards & Reports

  • Introduction to Data Pipelines and Pipelining

  • Introduction to Data Mining

  • Understanding ETL Process

  • Creating Data Flow

  • Working with Semantic Model

  • Connecting Data Flow to Semantic Model

  • Creating Real Time and Automated Reports

  • Building End to End Data Pipeline

  • Using SQL Queries in Power BI

  • Using Python in Power BI

MySQL
Mysql_logo

(5+ Live Projects)

MySQL is a relational database management system (RDBMS) that's used as an interface for SQL. SQL is a structured query language (SQL) that allows you to query, define, manipulate, control, and analyze data in a database. SQL databases are essential for data analysts who work on data architecture and storage systems. MySQL is one of the most sought-after skills in any data-related job, and can boost your job prospects by over 40%. What you'll learn here:

  • Introduction to DBMS & RDBMS

  • Introduction to Structured Query Language

  • Installing MySQL

  • Working with MySQL Workbench

  • Understanding Databases

  • Database Designing

  • Keys and Types of Keys

  • Relationships and Normalization

  • MySQL Query Basics

  • MySQL Data Types

  • MySQL Functions

  • DDL(Data Definition Language)

  • DML(Data Manipulation Language)

  • DQL(Data Query Language)

  • TCL(Transaction Control Language)

  • DCL(Data Control Language)

  • MySQL SELECT

  • MySQL WHERE

  • MySQL AND, OR, NOT

  • MySQL ORDER BY

  • MySQL INSERT INTO

  • MySQL NULL Values

  • MySQL UPDATE

  • MySQL DELETE

  • MySQL LIMIT

  • MySQL MIN and MAX

  • MySQL COUNT, AVG, SUM

  • MySQL LIKE

  • MySQL Wildcards

  • MySQL IN

  • MySQL BETWEEN

  • MySQL Aliases

  • MySQL Joins

  • Sub-Queries & CTE

  • MySQL INNER JOIN

  • MySQL LEFT JOIN

  • MySQL RIGHT JOIN

  • MySQL CROSS JOIN

  • MySQL Self Join

  • MySQL UNION

  • MySQL GROUP BY

  • MySQL HAVING

  • MySQL EXISTS

  • MySQL ANY, ALL

  • MySQL INSERT SELECT

  • MySQL CASE WHEN

  • MySQL Null Functions

  • MySQL Comments

  • MySQL Operators

  • MySQL Create DB

  • MySQL Drop DB

  • MySQL Create Table

  • MySQL Drop Table

  • MySQL Alter Table

  • MySQL Constraints

  • MySQL Not Null

  • MySQL Unique

  • MySQL Primary Key

  • MySQL Foreign Key

  • MySQL Check

  • MySQL Default

  • MySQL Create Index

  • MySQL Auto Increment

  • MySQL Dates

  • MySQL Views

  • Window Functions

  • MySQL Triggers

  • MySQL Stored Procedures

Tableau
tableau-software-logo-F1CE2CA54A-seeklogo.com

(5+ Live Projects)

Tableau is a business intelligence tool that helps organizations analyze and process large amounts of data. Tableau is an end-to-end data analytics platform that allows you to prep, analyze, collaborate, and share your big data insights. Tableau excels in self-service visual analysis, allowing people to ask new questions of governed big data and easily share those insights across the organization. What you'll learn here:

  • Installing Tableau

  • Tableau Fundamentals

  • Tableau Desktop

  • Tableau Server

  • Tableau Online

  • Tableau Reader

  • Tableau Public

  • Connecting With Data

  • Creating Views and Analysis

  • Dashboard Designs

  • Creating Reports

  • Data Cleaning

  • LOD Expressions

  • Creating Parameters

  • Calculated Fields

  • Generating Data Stories

Looker Studio
Looker

(3+ Live Projects)

With Looker Studio, you can easily report on data from a wide variety of sources, without programing. In just a few moments, you can connect to data sets such as: Databases, including BigQuery, MySQL, and PostgreSQL. Google Marketing Platform products, including Google Ads, Analytics, Display 360, Search Ads etc. What you'll learn here:

  • Introduction to Looker

  • Interface

  • Getting Data

  • Charts & Graphs

  • Grouping & Categorizing Data

  • Data Blending

  • Filters & Controls

  • Parameters

  • Sharing, Tracking & Management

  • BigQuery

Business Finance
pngtree-financial-consulting-logo-vector-template-png-image_2132677

(3+ Live Projects)

Finance in data analytics is a field that applies data analysis techniques to financial data to support decision making, optimize performance, and prevent fraud. Learning finance in data analytics can help you gain valuable skills such as financial data analysis. By learning finance in data analytics, you can enhance your career prospects and opportunities in the finance industry, as well as other industries that rely on financial data. You can also improve your financial literacy and decision making for your personal or professional goals. What you'll learn here:

  • Introduction to Finance

  • Getting Familier with Financial Terms

  • Revenue, Expense,  Profit

  • Gross Revenue, Gross Profit, Net Profit

  • EBIT and EBITDA

  • MTD, QTD, YTD

  • Plan, Budget, Forecast, LE

  • General Ledger

  • Cash Flow and Income Statement

  • Balance Sheet

  • Profit and Loss Statement

  • Variance

  • Favorable and Unfavorable Variance

  • YoY, vs LY, vs Bud

  • ROI, ROE, ROA, EPS

  • P/E Ratio

  • NPV, IRR

  • AAGR & CAGR

Google Workspace
Goggle Workspace

(3+ Live Projects)

Google Sheets is a powerful tool for data analytics, offering accessibility, collaboration, cost-effectiveness, and basic data analysis capabilities. Learning it enables efficient data manipulation, visualization, and sharing, making it an essential skill for anyone handling data analysis tasks. Google Sheets provides a user-friendly interface familiar to many, facilitating a smooth learning curve. Its integration with other Google Workspace apps enhances productivity, while its cloud-based nature ensures data accessibility from anywhere. What you'll learn here:

  • Getting started with Google Sheets

  • Google Sheets Interface

  • Data Formatting

  • Data Manipulation

  • Data Cleaning

  • Formulas & Functions

  • Basic Functions (SUM, AVERAGE, COUNT etc.)

  • Advanced Functions (VLOOKUP, IF, INDEX etc.)

  • Pivot Tables

  • Introduction to Google Apps

  • Exploring Data Collection Tools

  • Presentation with Google Slides

  • Documentation with Google Doc

  • Collaboration

  • Sharing

  • Google Drive

  • Google Groups

  • Practice and Projects

Placement Training &
Interpersonal Skills
Placement

Interpersonal skills, also called soft skills or people skills, are important for data analysts because they help with many aspects of their work. Effective communication is essential for data analysts to effectively convey their findings, recommendations, and insights to their audiences. Also some companies do conduct aptitude tests for data analytics jobs. To prepare for such a test, you can focus on improving your problem-solving and critical thinking skills. If you're a data analyst searching for your next career opportunity, one of the most critical components of your job search is your resume or CV. A data analyst resume is your first chance to make an impression to potential employers, and it needs to stand out from the rest to land an interview. What you'll learn here:

  • Effective Communication

  • Reasoning & Aptitude

  • HR Prep

  • Techincal Interview Prep

  • Presentation Skills

  • Personality Development

  • GitHub  & LinkedIn Profiles

  • Mock Interview Sessions

  • Resume Making

  • Get Companies from Us

Job Profiles
You Can Target
Job-description-icon-1-removebg-preview
Job Profiles

With Average Salary for Freshers

Data Analyst

Average Salary

8-12 LPA

Business Analyst

Average Salary

5-8 LPA

Research Analyst

Average Salary

5-9 LPA

Market Analyst

Average Salary

6-9 LPA

Quant Analyst

Average Salary

5-8 LPA

Power BI Dev

Average Salary

6-10 LPA

Financial Analyst

Average Salary

3-6 LPA

Data Architect

Average Salary

3-4 LPA

Risk Analyst

Average Salary

4-6 LPA

Fraud Analyst

Average Salary

3-5 LPA

MIS Executive

Average Salary

3-5 LPA

Data Consultant

Average Salary

4-5 LPA

Our Approach Towards Teaching
pngtree-beginners-vector-png-image_6705511
From Basics to Advanced

Learn With Ease

​

Embark on your learning journey from the basics with industry experts. Starting with familiar tools like Excel and fundamental math concepts

Take on Challenges

​

Learning technology is like learning swimming - you can truly learn it only when you practice. After each subject, dive into challenging projects that let you apply what you've learned.

Active Engagement

​

Stay connected through dedicated WhatsApp groups where you can post doubts—our vibrant community of students and faculty is there to provide quick solutions

Job-Ready Training by IITians

​

Prepare for success with our placement training led by industry experts. Dive into resume building, tackle puzzles and aptitude challenges, refine your communication skills, excel in mock interviews, engage in group discussions, and much more.

bottom of page