Full Stack Data Analytics Program
Learn with TheiScale
29 modules
HINGLISH
Access for 180 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
Monthly LIVE Test
9 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
PowerBI Live Test: 10th June, 2024
SQL & Python Live Test: 14th June 2024
Python, Power BI & SQL Live Test: 3rd August 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
17 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
IPYNB Files
ALL UNITS IPYNB FILES
Week 5 : Python Libraries level 1
8 attachments • 7 hrs
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
18.2 Subquery (Part 2) | Select | From | Where | Having | Insert
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
26 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)
Download Dataset 4 (titles)
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
Power Query
12 attachments • 1 hrs
Lecture 1
Lecture 2
power query notes
SalesFile
Product-Color-Model
target
CompanySales
OtherSales
Product
Sales
lecture 1 pbix file
lecture 2 pbix file
Optional Module
19 attachments • 6 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
Plotly Library
Plotly Library | Part 1
Plotly Library | Part 2
plotly
MSFT
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
26 attachments • 9 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
Capstone Project - 3['Best Bowlers']
Tableau Project 3 Notes & Data
Week: 22 Practice Interview Questions
3 attachments
Python Interview Questions
100 SQL Interview Questions
Power BI 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
Learn with TheiScale
Expert Mentor
Rate this Course
₹ 6999.00
Order ID:
This course is in your library
What are you waiting for? It’s time to start learning!
Wait up!
We see you’re already enrolled in this course till Access for 180 days. Do you still wish to enroll again?
