Home
About us
Courses
Gallery
Login
Contact
0
Login
0
Login
Data Analytics | Excel | SQL | Power BI | Tableau
Curriculum
7 Sections
112 Lessons
24 Weeks
Expand all sections
Collapse all sections
Data Analysis with Excel
4
1.1
Introduction
1.2
Basics of Excel – 1
1.3
Basics of Excel – 2
1.4
Basics of Custom Formatting
Most Important formulae for Analysis
25
2.1
Cell Referencing
2.2
Assignment Announcement
2.3
Sum, Subtract, Division, Multiplication
2.4
Average Mean Function
2.5
Count, Count A, Count Blank
2.6
Max, Min, Small, Large Functions
2.7
Assignment No. 2
2.8
Assignment 8.1 Count
2.9
IF Function
2.10
Nested IF function
2.11
IFS Function
2.12
Count IF Function
2.13
Sum IF, Average IF function
2.14
Upper, Lower and Right Function
2.15
Left, Right, Mid, Find, Search, Substitute, Length Function
2.16
Combination of Left, right and Find Function
2.17
Text to Colomn
2.18
Assignment Announcement
2.19
Today, Now, Day, Month, Year Function
2.20
VLook UP Function
2.21
HLook UP Function
2.22
Concatenate Function
2.23
Index and Match Function
2.24
AND , OR Function
2.25
Trim Function
Analysis of Data
5
3.1
What IF Analysis
3.2
Pivot Table and Pivot Charts
3.3
Data Validation
3.4
Descriptive Statistics in Excel
3.5
Solver Add-in
SQL DATA ANALYTICS FOR BEGINNER
15
4.1
Getting started
30 Minutes
4.2
My SQL Intro & Setup
30 Minutes
4.3
Single ANALYTICS (Part 1) – A
30 Minutes
4.4
Single ANALYTICS (Part 1) – B
30 Minutes
4.5
Single ANALYTICS (Part 1) -C
30 Minutes
4.6
Single ANALYTICS (Part 1) – D
30 Minutes
4.7
Single ANALYTICS (Part 1) – E
30 Minutes
4.8
Single ANALYTICS (Part 1) – F
30 Minutes
4.9
Single ANALYTICS (Part 2)
30 Minutes
4.10
MID COURSE PROJECT
30 Minutes
4.11
Analysing Multiple Tables with Joins – Part 1
30 Minutes
4.12
Analysing Multiple Tables with Joins – Part 2
30 Minutes
4.13
Analysing Multiple Tables with Joins – Part 3
30 Minutes
4.14
Analysing Multiple Tables with Joins – Part 4
30 Minutes
4.15
Final Project
30 Minutes
SQL DATA ANALYTICS & BI
30
5.1
01-Introduction to databases, SQL, and MySQL
30 Minutes
5.2
SQL theory
30 Minutes
5.3
Basic database terminology
30 Minutes
5.4
Installing MySQL and getting acquainted with the interface
30 Minutes
5.5
First steps in SQL
30 Minutes
5.6
MySQL constraints
30 Minutes
5.7
SQL best practices
30 Minutes
5.8
Loading the ’employees’ database
30 Minutes
5.9
SQL SELECT statement – Part 1
30 Minutes
5.10
SQL SELECT statement – Part 2
30 Minutes
5.11
SQL SELECT statement – Part 3
30 Minutes
5.12
SQL INSERT statement
30 Minutes
5.13
SQL UPDATE Statement
30 Minutes
5.14
SQL DELETE Statement
30 Minutes
5.15
MySQL – Aggregate functions
30 Minutes
5.16
SQL Joins – Part 1
30 Minutes
5.17
SQL Joins – Part 2
30 Minutes
5.18
SQL Subqueries
30 Minutes
5.19
SQL Self Join
30 Minutes
5.20
SQL Views
30 Minutes
5.21
Stored routines
30 Minutes
5.22
Advanced SQL Topics
30 Minutes
5.23
SQL Window Functions
30 Minutes
5.24
SQL Common Table Expressions (CTEs)
30 Minutes
5.25
SQL Temporary Tables
30 Minutes
5.26
Combining SQL and Tableau – Introduction
30 Minutes
5.27
Combining SQL and Tableau – Task 1
30 Minutes
5.28
Combining SQL and Tableau – Task 2
30 Minutes
5.29
Combining SQL and Tableau – Task 3
30 Minutes
5.30
Combining SQL and Tableau – Task 4
30 Minutes
MS-Power-BI-DA-100
17
6.1
Getting Started
30 Minutes
6.2
Preparing for the DA-100 Exam
30 Minutes
6.3
Setting Up Power BI Desktop & Service
30 Minutes
6.4
Data Prep_ Getting Data from Different Sources – Part 1
6.5
Data Prep_ Getting Data from Different Sources – Part 2
6.6
Data Prep_ Profiling
30 Minutes
6.7
Data Prep_ Cleaning, Transforming & Loading – Part 1
30 Minutes
6.8
Data Prep_ Cleaning, Transforming & Loading – Part 2
30 Minutes
6.9
Data Modelling 101
30 Minutes
6.10
Data Modelling_ DAX Calculations – Part 1
6.11
Data Modelling_ DAX Calculations – Part 2
30 Minutes
6.12
Data Visualization_ Creating Reports & Dashboards – Part 1
30 Minutes
6.13
Data Visualization_ Creating Reports & Dashboards – Part 2
30 Minutes
6.14
Data Analysis_ Enhancing Reports
30 Minutes
6.15
Deploying & Maintaining Deliverables – Part 1
30 Minutes
6.16
Deploying & Maintaining Deliverables – Part 2
30 Minutes
6.17
Practice Exam
30 Minutes
TABLEAU ANALYST SPECIALIST
16
7.1
Introduction to Tableau and Getting Started
30 Minutes
7.2
Tableau Prep – Part 1
30 Minutes
7.3
Tableau Prep – Part 2
30 Minutes
7.4
Connecting to Data – Part 1
30 Minutes
7.5
Connecting to Data – Part 2
30 Minutes
7.6
Visual Analytics – Part 1
30 Minutes
7.7
Visual Analytics – Part 2
30 Minutes
7.8
Visual Analytics – Part 3
30 Minutes
7.9
Dashboard and Stories
30 Minutes
7.10
Mapping
30 Minutes
7.11
Calculations – Part 1
30 Minutes
7.12
Calculations – Part 2
30 Minutes
7.13
Why is Tableau doing that?
30 Minutes
7.14
How to create LOD?
30 Minutes
7.15
Publish to Tableau Online
30 Minutes
7.16
Publish to Tableau Server
30 Minutes
This content is protected, please
login
and
enroll
in the course to view this content!
