Master of Data Analytics Program
Learn with TheiScale
25 modules
HINGLISH
Access for 200 days
Data Analytics: Where Data Becomes Your Superpower
Overview
Join our 'Master of Data Analytics Program' to accelerate your career in the world of data analytics. This comprehensive course covers all the essential components of a full-stack data analytics program, providing you with the skills and knowledge needed to excel in this field. Throughout this program, you will gain an in-depth understanding of various data analytics concepts and techniques. Starting with the basics, you will learn about data collection, cleaning, and transformation. You will discover how to work with different types of data, including structured, unstructured, and semi-structured data. Next, we will dive into data visualization and exploration, where you will master the art of representing data visually and extracting meaningful insights from it. You will learn how to use popular data visualization tools and techniques to create compelling visualizations that effectively communicate your findings. Moving on, we will explore advanced data analytics topics, such as statistical analysis and predictive modeling. You will learn how to apply statistical methods to analyze data, identify patterns, and make informed business decisions. Additionally, you will delve into predictive modeling techniques, enabling you to build accurate models that can predict future trends and outcomes. Building on your foundational knowledge, we will then introduce you to big data technologies and platforms. You will gain hands-on experience with tools like Hadoop and Spark, learning how to handle large volumes of data efficiently and derive insights from them. You will also explore cloud-based data analytics solutions and understand their benefits and applications. In the latter part of the course, we will focus on data storytelling and communication.
Key Highlights
Learn advanced statistical techniques and machine learning algorithms
Gain expertise in big data technologies and data visualization tools
Develop skills to collect, clean, and analyze large datasets
Apply data analytics to solve real-world business problems
Master programming languages commonly used in data analytics, such as Python and R
Acquire knowledge of data management and data governance principles
Understand ethical considerations and legal aspects of working with data
Work on industry projects and gain hands-on experience
Join a network of professionals in the field of data analytics
Modules
Course Details
5 attachments
Curriculum Python
7 pages
Curriculum SQL
6 pages
Curriculum Excel
3 pages
Curriculum Power BI
4 pages
Curriculum Tableau
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 for All Units
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
services
taxonomy.csv
LUSID Excel - Setting up your market data (1)
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]
25 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
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”]
31 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()
SQL - Assigments
4 pages
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
16 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
Power BI Business Account Issue
Unit 10. KPI & Other Functions
Download - Unit 10 PBIX File
Power BI Unit 10
Week: 19 Power BI
24 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
DAX Function
17 attachments • 6 hrs
DAX-datediff-sample-data
MTDQTDYTD
DAX Sales Data
DAX 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
Product_Lookup
Date_Lookup
Sales_Data
DAX Cheat Sheet
Power Query
12 attachments • 1 hrs
Lecture 1
Lecture 2
lecture 1 pbix file
lecture 2 pbix file
power query notes
Sales
Product
OtherSales
CompanySales
target
Product-Color-Model
SalesFile
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
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
Optional Module
19 attachments • 5 hrs
IMDB Scrapping Project
Web Scrapping - IMDB Project
IMDB Project Notes
4 pages
imdb-rating
movie-data
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 notes
plotly notes pdf
MSFT
Power BI Temporary mail creation
Power BI Business Email Solution
About the creator
Learn with TheiScale
Expert Mentor
Rate this Course
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 200 days. Do you still wish to enroll again?
