Full Stack Data Analytics Program

Home

Courses

/Full Stack Data Analytics Program

Learn with IHHPET

29 modules

HINGLISH

Access for 200 days

Data Analytics: Where Data Becomes Your Superpower

Overview

Data will change the world, and becoming data-literate will pay dividends for your career. Data analytics is a fast-growing field and it will continue to grow over the next decade. Since many companies are now working based on data, its analysis is crucial. This is why the demand for data analysts will grow more and more in the future.
So, what are you waiting for? Become a Data Analyst, Enroll in our courses today and embark on a path toward success!

Key Highlights

Learn the foundations of data analytics from scratch

Gain expertise in data extraction, cleaning, and transformation

Explore various data visualization techniques for effective analysis

Comprehensive curriculum with hands-on projects.

Prepare for data analytics career success.

Get hands-on experience with popular data analytics tools and languages

Real projects, expert insights, and certification.

Learn to build interactive dashboards for data reporting and visualization

What you will learn



Introduction to Full Stack Data Analytics

Learn the foundational concepts and principles of Full Stack Data Analytics.



Understanding Data Collection and Manipulation

Develop skills in data collection, cleansing, transformation, and manipulation using various tools and techniques.



Exploratory Data Analysis

Learn how to perform exploratory data analysis to discover patterns, trends, and insights in datasets.



Building Advanced Data Models

Gain expertise in building complex data models using algorithms, statistical techniques.



Data Visualization and Reporting

Master the art of visualizing data effectively and presenting analytical findings in a clear and concise manner.



Working with Data Technologies

Learn how to handle large-scale datasets and leverage data technologies for data processing and analysis.



Developing Interactive Dashboards

Acquire skills in creating interactive and dynamic dashboards for data exploration and decision-making.



Applying Data Analytics in Business

Understand how data analytics is applied in various industries and learn to derive actionable insights for business decision-making.

Modules

Course Details

5 attachments

Curriculum Python

7 pages

Curriculum SQL

6 pages

Curriculum Excel

3 pages

Curriculum Power BI

4 pages

Curriculum Tableau

LIVE Doubt Class

4 attachments

Live Doubt Class Schedule

Live Doubt Class || Python + SQL || 15 May,2024 Wednesday at 08:00 PM

Live Doubt Class || Python + SQL || 18 May,2024 Saturday at 07:00 PM

Live Doubt Class || Python + SQL || 21 May,2024 Tuesday at 07:00 PM

Special Class

3 attachments • 40.3 mins

Special Session with MNC expert

Special Virtual Class || Interview Business Case Study- MPL || 19th May 2024

Notes || Business Case Study - MPL || 19th May 2024

Monthly LIVE Test

6 attachments

SQL Live Test: 5th February 2024

Python Live Test: 10th February 2024

SQL Live Test: 12th March 2024

Python LIve test: 13th March 2024

Python LIVE Test: 8th April 2024

SQL LIVE Test: 10th April 2024

Week 1 : Python Basics

17 attachments • 7 hrs

1st - Introduction to Python

Unit 1 Assignment

2nd -Variables & operators | Part 1

3rd -Variables & operators | Part 2

Unit -2 Notes

Unit 2 Assignment

Unit 2 Assignment Explanation Video

4th - Built-in Functions | Part 1

5th - Built-in Functions | Part 2

Unit 3 Notes

Unit 3 Assignment

Unit 3 Assignment Explanation Video

6th - Conditional Statements | Part 1

7th - Conditional Statements | Part 2

Unit 4 Notes

Unit 4 Assignment

Unit 4 Assignment Explanation Video

Week 2 : Python Foundation

13 attachments • 6 hrs

8th - Concepts of Loops | Part 1

9th - Concepts of Loops | Part 2

10th - Concepts of Loops | Part 3

Unit - 5 Notes

Unit 5 Assignment

Unit 5 Assignment Explanation Video

11th - User Defined Functions | Part 1

12th - User Defined Functions | Part 2

13th - User Defined Functions | Part 3

Unit -6 Notes

Unit 6 Assignment

Unit 6 Assignment Explanation Video

14th - Strings in Python | Part 1

Week 3 : Python Moderate 1

13 attachments • 6 hrs

15th - Strings in Python | Part 2

16th - Strings in Python | Part 3

17th - Strings in Python | Part 4

Unit - 7 - notes

Unit 7 Assignment

Unit 7 Assignment Explanation Video

18th - List in Python | Part 1

19th - List in Python | Part 2

20th - List in Python | Part 3

Unit-8 - notes

Unit 8 Assignment

Unit 8 Assignment Explanation Video

21st - Tuples in Python | Part 1

Week 4 : Python Moderate 2

15 attachments • 6 hrs

22nd - Tuples in Python | Part 2

Unit - 9 notes

Unit 9 Assignment

Unit 9 Assignment Explanation Video

23rd - Set in Python | Part 1

24th - Set in Python | Part 2

25th - Set in Python | Part 3

Unit-10 notes

Unit 10 Assignment

Unit 10 Assignment Explanation Video

26th - Dictionary in Python | Part 1

27th - Dictionary in Python | Part 2

Unit 11 notes

Unit 11 Assignment

Unit 11 Assignment Explanation Video

Week 5 : Python Libraries level 1

9 attachments • 7 hrs

Will be updated soon

28th - Numpy Library | Part 1

29th - Numpy Library | Part 2

30th - Numpy Library | Part 3

31st - Numpy Library | Part 4

32nd - Numpy Library | Part 5

33rd - Numpy Library | Part 6

34th - Numpy Library | Part 7

Numpy Notes

Week 6 : Python Libraries level 2

12 attachments • 6 hrs

35th - Pandas Library | Part 1

36th - Pandas Library | Part 2

37th - Pandas Library | Part 3

38th - Pandas Library | Part 4

Pandas Titanic Data Set

Pandas Taxonomy dataset taxonomy.csv

Pandas Dataset services

LUSID Excel - Setting up your market data

Pandas notes

39th - Matplotlib Library | Part 1

40th - Matplotlib Library | Part 2

41st - Matplotlib Library | Part 3

Week 7 : Python Libraries level 3

4 attachments • 1 hrs

42nd - Matplotlib Library | Part 4

43rd - Matplotlib Library | Part 5

44th - Matplotlib Library | Part 6

Matplotlib Notes

Week 8 : Projects

7 attachments • 2 hrs

45th - Project 1: Covid 19 Impact Analysis | Part 1

46th - Project 1: Covid 19 Impact Analysis | Part 2

47th - Project 1: Covid 19 Impact Analysis | Part 3

Covid 19 Impact Analysis Project Files

Covid 19 project notes

state_wise_daily

style.css

Week 9 : Projects

7 attachments • 3 hrs

48th - Project 2 - Image Scrapping

Google Image Scrapping Project Files

49th - Project 3 - WhatsApp Chat Analysis | Part 1

50th - WhatsApp Chat Analysis | Part 2

51st - WhatsApp Chat Analysis | Part 3

WhatsApp Chat Analysis Project Files

Notes - Project chat analysis

Week 10 : SQL Module- 1 [Fundamental of SQL and DBMS]

26 attachments • 4 hrs

1.1. Download SQL Schedule

1.2. Download & Install MySQL

1.3. Download & Install XAMPP

1.4. Download & Install PostgreSQL & Pgadmin

Learning Recourses

PDF Book 1: O'Reilly Head First SQL

586 pages

PDF Book 2: Data Analysis Using SQL and Excel

690 pages

PDF: Latest SQL Cheat Sheet

166 pages

SQL Reference Notes

100 SQL Interview Questions

Unit:2 SQL Introduction and Fundamentals

2.1. Introduction to SQL

2.2. Database Fundamental

2.3 Learning Resources

Unit:3 Case Study with Example.

Unit 3 Download Notes

3.1. Create/Drop Database | Create / Insert / Drop Table

3.2. Case study with XAMPP Software

3.3. Case study with MySQL software

3.4. Case study with PostgreSQL

Unit: 4 Data Types and Keys

Unit 4 Download Notes

4.1. All Data Type in SQL

4.2 Database Key

4.3. Cardinality of Relationships

4.4. ER Diagram or Modeling

Week 11 : SQL Module 2 [ SQL DDL Commands “Data Definition Language”]

20 attachments • 4 hrs

Unit: 5 DDL Commands for SQL

Unit 5 Download Notes

5.1. DDL Commands for Databases: Create | Drop

5.2. DDL Commands for Table: Create | Truncate | Drop

5.3. Data Integrity

Unit: 6 Constraints

Unit 6 Download Notes

6.1 Constraints in MySQL (NOT NULL | UNIQUE | PRIMARY KEY)

6.2. Constraints in MySQL (AUTO INCRIMENT | CHECK | DEFAULT | FOREIGN KEY)

6.3. Referential Actions (Restrict | CASCADE | SET NULL | SET DEFAULT)

Unit: 7 Alter Table

Unit 7 Download Notes

7.1. ADD Columns in Alter Table

7.2. DELETE Columns in Alter Table

7.3. MODIFY Columns in Alter Table

Unit: 8 ADD, Editing and Deleting Constraints

Unit 8 Download Notes

8.1. ADD Constraints

8.2. DELETE Constraints

8.3. EDIT Problems in MySQL, Drop Constraints

Week 12 : SQL Module 3 [ DML Commands “Data Manipulation Language”]

30 attachments • 4 hrs

Unit: 9 INSERT Query

Unit 9 Download Notes

Unit 9 : Download Dataset (Smartphones) CSV Files

Unit 9 : Download Dataset (Smartphones) XLXS Files

9.1 INSERT in SQL

9.2. INSERT query variation

9.3. INSERT multiple values

Unit: 10 SELECT | DISTINCT | Operator: WHERE, BETWEEN, IN and NOT IN

Unit 10 Download Notes

Unit 10 Download Notes (SQL-Operators)

Unit 10 Download Dataset (Smartphones) CSV Files

Unit 10 Download Dataset (Smartphones) XLXS Files

10.1 SELECT All | Filter Columns | Alias 'AS' (Part -1)

10.2. Create expression & Constant value Using SELECT (Part - 2)

10.3. DISTINCT(unique) Values | Combinations(Part -3)

10.4. Filter Rows WHERE | BETWEEN | IN and NOT IN

Unit: 11 UPDATE Query

Unit 11 Download Notes

11.1. Update Query to update row(s)

11.2. Update Multiple Columns

Unit: 12 DELETE Query

Unit 12 Download Notes

12.1. DELETE Query to delete row(s)

12.2. Deletion based on multiple conditions

Unit: 13 Functions: Aggregate Functions in MySQL/SQL

Unit 13 Download Notes

13.1. MAX() & MIN() | AVG() | SUM() | COUNT() | STD() | VARIANCE()

Unit: 14 Scalar Functions in MySQL/SQL

Unit 14 Download Notes

14.1. ABS() | ROUND() | CEIL() & FLOOR()

Week 13 : SQL Module 4 [Sorting + Grouping + Having]

8 attachments • 2 hrs

Unit: 15 Sorting (Order By)

Unit 15 Download Notes

Unit 15 Download Dataset (IPL) CSV Files

15.1 Sorting (Ascending - Descending | Limit Syntax | Multiple Condition)

Unit: 16 Grouping (Group By & Having)

Unit 16 Download Notes

16.1 Grouping (Part-1) : Average Function | Multiple Columns

16.2 Grouping (Part-2) : Asc-Desc | Limit | Group By

Week 14 : SQL Module 5 [SQL Joins + Subquery+ Windows + TCL & DCL]

21 attachments • 5 hrs

Unit: 17 SQL Join

Unit 17 Download Notes

Unit 17 Download Dataset 1 (class_table)

Unit 17 Download Dataset 2 (customers)

Unit 17 Download Dataset 3 (orders)

Unit 17 Download Dataset 4 (student_table)

17.1 Joins (Part 1) : Type | Inner Join | Left | Righr | Full

17.2 Joins (Part 2) : Cross Join | Self-Join | multiple table | Filtering Columns | Filtering Rows

Unit: 18 Subquery

Unit 18 Download Notes

Unit 18 Download Dataset 1 (movies)

Unit 18 Download Dataset 2 (Cust_Table)

18.1 Subquery (Part 1) | Scalar, Row & Table | Correlated

Unit: 19 Window Functions

Unit 19 Download Notes

Unit 19 Download Dataset (st_marks)

19.1 Window Functions (Aggregate | Ranking | Value)

Unit: 20 DCL & TCL Command

Unit 20 Download Notes

20.1 DCL & TCL (Commit | Rollback | Savepoint | Grant | Revoke)

Week 15 : Excel (Fundamental | Intermediate | Moderate)

32 attachments • 3 hrs

Download Excel Schedule

3 pages

Download Excel Book (PDF)

Excel Shortcuts Notes (PDF)

Unit: 1 [Fundamental of Excel: Beginner Level]

1.1. Basic Features - Introduction

1.2. Basic Formatting

1.3. Using Formulas

1.4. Save File

1.5. Filter & Sorting

1.6. Conditional Formatting

1.7. Insert & Delete Columns or Rows

1.8. Find & Remove Duplicates

1.9. Merge and Centre

Unit: 2 [Intermediate Level of Excel]

2.1. Rounding of Numbers

2.2. Autofill in Excel

2.3. Add or Edit Comment

2.4. Filters for Data Manipulation

2.5. Sorting on Multiple Columns

2.6. Insert Table

2.7. Slicers

Unit: 3 [Moderate Level of Excel]

3.1. Creating an Excel Column Chart

3.2. Working with Excel Pie Charts

3.3. Chart Group (Line, Area, Waterfall)

3.4. Insert Picture or Shapes

3.5. Add link or hyperlink

3.6. Excel Sparkline’s

3.7. Add Drop Down List

3.8. Split Text

3.9. Page Layout Tab and Ribbon

3.10. Printing Excel Worksheet

Week 16 : Excel (Advanced Projects & Dashboard Design)

43 attachments • 10 hrs

Unit: 4 [Advance Level of Excel]

Download Excel File 1 (Unit: 4)

Download Excel File 2 (Unit: 4)

Download Excel File 3 (Unit: 4)

Download Excel File 4 (Unit: 4)

4.1. Formula Tabs & Library

4.2. Define Names

4.3. Formula Auditing

4.4. Calculation Options & Watch Window

4.5. Get and Transform Data

4.6. Queries and Connections

4.7. Excel data validation

4.8. Excel PivotTables

4.9. Excel conditional functions

4.10. Excel Text based Functions

4.11. Excel “What if?” Tools

4.12 Conditional IF Function IN [EXCEL]

4.13. Result Format with Nested-IF [Excel]

4.14. XOR Formula (Exclusive OR) EXCEL

4.15. Excel VLOOKUP Function

4.16. Advance VLOOKUP Formula

4.17. VLOOKUP in Multiple Sheet

4.18. HLOOKUP Formula

4.19. XLOOKUP Formula

4.20. Excel Double-VLOOKUP

4.21. SUMIF Formula in Excel Condition

4.22. Sumif Vs Sumifs Formula in Excel

4.23. Work in Data Validation Function

4.24. MARCO

4.25. Advance Forecast Report

Unit: 5 [Capstone Project: 1]

Download : Excel File (Online Store Annual Report)

Advance Excel Unit5- Analysis the Online Store Annual Report

Unit: 5 [Capstone Project: 2]

Download: Excel File (Hotel_Booking_Project)

Download: CSV Dataset (hotel_bookings)

Download : Excel Project File (Hotel_Booking_Cancle)

Advance Excel Unit5 -Analysis the Hotel Booking Cancel

ASSIGNMENT of EXCEL

Excel Assignment

Fast Food Sales Raw

Assignment Statement File

Assignment Solution

Week : 17 Power BI

18 attachments • 4 hrs

Unit 1 : Introduction Power BI

Download Power BI Schedule

Download & Install Power BI

User Interface & Navigation

Dataset : Global Superstore

Import First Sample Data

Unit 2 : Charts

Download- Unit 2 PBIX File

Power BI Unit 2

Unit 3 : Tables & Matrix

Download- Unit 3 PBIX File

Power Bi Unit 3

Unit 4 : Slicers

Download- Unit 4 PBIX File

Power BI Unit 4

Unit 5 : Charts Visualizations Tools

Download- Unit 5 PBIX File

Power BI Unit 5

Week : 18 Power BI

15 attachments • 5 hrs

Unit 6 : Map

Download - Unit 6 PBIX File

Power BI Unit 6

Unit 7 : Cards & Filter

Download - Unit 7 PBIX File

Power BI Unit 7

Unit 8 : Insert & Action Functions

Download - Unit 8 PBIX File

Power BI Unit 8

Unit 9 : Advanced Charts

Download - Unit 9 PBIX File

Power BI Unit 9

Unit 10. KPI & Other Functions

Download - Unit 10 PBIX File

Power BI Unit 10

Week: 19 Power BI

25 attachments • 4 hrs

Project 1 : Amazon Global Sales Dashboard

Download - Project 1 PBIX File

Download Dataset Amazon

Unit 11 & Unit 12 (Project 1 | Power BI Service)

Project 2 : Virat Performance Analysis

Download - Project 2 PBIX File

Download Dataset Kohli T20

Download Theme Kohli

Virat Kohli T20 - Project 2

Project 3 : Netflix Dashboard & Analysis

Download - Project 3 PBIX File

Download Dataset 1 (Netflix - Stock Prediction)

Download Dataset 2 (Netflix - Titles)

Download Dataset 3 (Netflix - Credits)

Netflix Dashboard - Project 3

Project 4 : IPL Dashboard

Download - Project 4 PBIX File

Download Dataset (IPL)

Download Theme 1 IPL

Download Theme 2 IPL

Download Theme 3 IPL

Download Theme 4 IPL

IPL Dashboard - Project 4

Interview Questions

Power BI Interview Questions

DAX Function

17 attachments • 6 hrs

DAX Data

DAX Sales Data

MTDQTDYTD

DAX-datediff-sample-data

DAX Unit 1

DAX Unit 1 Notes

Dax Unit 2

DAX Unit 2 Notes

Dax Unit 3

DAX Unit 3 Notes

Dax Lec 4

DAX Lec 4 Notes

Customer_Lookup Excel File

Date_Lookup

Product_Lookup

Sales_Data

DAX Cheat Sheet

Optional Module

14 attachments • 4 hrs

IMDB Scrapping Project

Web Scrapping - IMDB Project

IMDB Project Notes

4 pages

imdb-rating

movie-data

Web Scrapping - Flipkart Project

Flipkart Live Master Class

Flipkart_Project_Dataset-1

1 page

Seaborn Library

Seaborn Library | Part 1

Seaborn Library | Part 2

Seaborn Library | Part 3

Seaborn Library | Part 4

Seaborn Notes

Week: 20 Tableau

26 attachments • 7 hrs

Unit 01- Introduction to Tableau

Sample Data Set - Superstore

Sample Data Set - EU Superstore

Lecture: 1 Introduction to Tableau

Lecture: 2 Introduction to Visualizations

Bar

PieCharts

Lecture: 3 Treemap , Packed Bubbles and Maps

Lec 3 Notes

Lecture: 4 Text Table and Formatting

TextTables

Unit 02- Creating Visualizations

Lecture: 1 Heat Maps and Highlight Tables

Lec 1 - Heat Maps and Highlight Tables Notes

Lecture: 2 Line Charts and Area Charts

Lec 2 - Line Charts and Area Charts Notes

Lecture: 3 Circle View and Word Cloud

Lec 3 - Circle View and Word Cloud Notes

Lecture: 4 Scatter Plot and Histogram

Lec 4 - Scatter Plot and Histogram Notes

Lecture: 5 Gant View and Water Fall Chart

Gantt View and Waterfall Graph

Lecture: 6 Reference Lines and Bullet Graphs

Reference Lines and Bullet Graphs

Lecture: 7 Dual Axes

Duel Axis Graph

Week: 21 Tableau

24 attachments • 7 hrs

Unit 03 - Advance Visualizations, Filtering and Sorting

Lecture: 1 Animated and Funnel Chart

Animated Chart and Funnel Chart

Lecture: 2 Donut, Dumbbell and Butterfly Chart

Donut, Dumbbell and Butterfly Chart

Lecture: 3 Box and Whiskers Plot

Box and Whiskers Plot

Lecture: 4 Filters in Tableau

Filters

Unit 04 - Dashboards and Actions

Lecture: 1 Sets and Parameter

Sets and Parameters

Lecture: 2 Dashboard and Stories

Sales Dashboard and Stories

Project 01

Capstone Project-1 [‘London Bike Ride’]

london_bike_ride_notes

london_bikes_final

london_merged

London Bike Ride Project

kaggle_link

Project 02

Capstone Project-2 [‘FIFA World Cup Dashboard’]

Tableau Project 2 Notes & data

Week: 22 Practice Interview Questions

Week: 23 Practice Interview Question

FAQs

How can I enrol in a course?

Enrolling in a course is simple! Just browse through our website, select the course you're interested in, and click on the "Enrol Now" button. Follow the prompts to complete the enrolment process, and you'll gain immediate access to the course materials.

Can I access the course materials on any device?

Yes, our platform is designed to be accessible on various devices, including computers, laptops, tablets, and smartphones. You can access the course materials anytime, anywhere, as long as you have an internet connection.

How can I access the course materials?

Once you enrol in a course, you will gain access to a dedicated online learning platform. All course materials, including video lessons, lecture notes, and supplementary resources, can be accessed conveniently through the platform at any time.

Can I interact with the instructor during the course?

Absolutely! we are committed to providing an engaging and interactive learning experience. You will have opportunities to interact with them through our community. Take full advantage to enhance your understanding and gain insights directly from the expert.

About the creator