About Course
In this course you will learn the fundamentals of data analytics outside the Python programming environment. By the end of the module, you’ll be able to query SQL relational databases, design & build databases, and build dashboards and tell stories with BI tools.
- SQL Programming: Build basic and advanced queries with SQL on relational databases
- SQL Database Design: Learn how to design databases, build, and optimize relational databases
- Advanced Excel: Learn advanced formulae, Excel statistical modelling, build charts, forecasts, and pivot tables
- Tableau Visualization: Data storytelling through live dashboards with Tableau business intelligence tool
Course Content
Welcome to the course
-
Overview of the course
08:24
01.01 Introduction to Databases
-
20:53
-
20:41
-
Daily Challenge – Preparation
00:00
01.02 Introduction to SQL
-
What is SQL
09:14 -
Installing MySQL on Windows
09:52 -
My SQL – Mac Installation
14:10 -
Creating Tables
15:36 -
Inserting Data
07:31 -
Constraints
10:13 -
Daily Challenge – Creating Tables
00:00 -
Daily Challenge – Inserting Data Into Tables
00:00
01.03 Basic SQL Queries
-
Update and Delete
08:19 -
Basic Queries
12:45 -
PROJECT: SQL Basic Queries
00:00
01.04 More SQL Queries – Intermediate
-
Company Database Intro
08:48 -
Creating Company Database
13:41 -
More Basic Queries
06:17 -
Daily Challenge – More Basic Queries
00:00
01.04 SQL Advanced Queries
-
Functions
09:07 -
Wildcards
08:59 -
Union
08:02 -
Joins
10:33 -
Daily Challenge – Advanced SQL Queries – Combining tables
00:00
01.05 SQL Project
02.01 Nesting and Triggers
-
Nested Queries
10:22 -
On Delete
08:32 -
Triggers
12:26 -
Daily Challenge – Functions with SQL Queries
00:00
02.02 ER Diagrams
-
ER Diagrams Intro
14:01 -
ER Diagram Design
12:59 -
ER Diagram Mapping
12:25
02.03 Database Normalization Concepts
-
Normal Forms in Database Design
00:00
02.05 SQL Project
-
PROJECT: Advanced SQL Queries
00:00 -
Submit Your Project
00:00
03.01 Introduction to Excel
-
Tips and Tricks in Excel and Introduction
21:47 -
Navigating with Excel
05:13 -
Useful Keyboard Shortcuts
09:22 -
Using Filters in Excel
08:05
03.02 Excel Intermediate
-
Intemediate Excel Tips and Tricks
20:18 -
Using Count A and Count in Excel
06:58 -
Moving and Copying Columns
02:47 -
Freeze Panes in Excel
03:10 -
Intro to Excel functions and Formulars
08:48 -
Sumproduct Function
07:11 -
F4 for absolute cell references
04:18 -
Text Functions in Excel
06:31
03.03 Advanced Excel
-
Fixing Common Errors
14:27 -
Fixing Common Errors Part 2
10:02 -
Fixing Common Errors Part 3
06:07 -
Excel Index and Match
10:47 -
Using Recommended Pivot Tables
00:00
03.04 Excel Data Visualization
-
Beginners Guide to Excel Dashboards
14:03 -
Intermediate Guide to Dashboards
10:50 -
Using Slicers
07:17
03.05 Excel Project
-
Recruitment Data Project
00:00 -
Submit Your Project
00:00
04.01 Introduction to Tableau
-
Introduction to Tableau
01:51 -
Installing Tableau
01:03 -
Creating a Tableau Public Profile
01:50
04.02 Connecting to Data
-
Join Types
03:44 -
Data Blending
06:35 -
Relationships
05:24 -
Data Types and Connections
04:42 -
Basic Data Transformation and Importation
04.03 Data Visualizations
-
Tableau Interface
09:04 -
Dimensions and Measures
02:09 -
Understanding Pills
04:11 -
Show Me Tab
04:41 -
Bar Charts
04:41 -
Line Charts
00:35 -
Lollipop Charts
01:17 -
Area Charts
00:56 -
Data Transformations and Linkages
04.04 Advanced Visualization
-
Maps
00:49 -
Scatter Plots
00:40 -
Histogram
01:17 -
Bubble Charts
01:05 -
Donut Charts
02:01 -
Tree Maps
00:49 -
KPI Charts
03:44 -
Data Visualization
05.05 Data Storytelling with Tableau
-
Tooltips and Viz in ToolTips
05:32 -
Dashboard and Layout Pane
09:55 -
Dashboard Clone 1
04:07 -
Dashboard Clone 2
26:41 -
Dashboard Clone 3
19:51
Tableau Project
-
Tableau Project
00:00
Final Capstone and Conclusion
-
Final Capstone Project
00:00 -
Submit Capstone Project
00:00
Additional/Bonus Materials
-
Further Resources
00:00 -
Next Steps
00:00
Student Ratings & Reviews
No Review Yet