SQL Data Analytics with Tableau Data Visualisation

Overview

Please note, some of the resources in this course are located on Dropbox or GitHub, hence you will need to use the supplied URL to download files e.g. Software

Syllabus

• Introduction to SQL Data Analytics
Overview of data analytics and its importance
Introduction to SQL and relational databases
Setting up the learning environment: accessing resources on Dropbox and GitHub
• SQL Fundamentals
SQL syntax and basic commands
Selecting and filtering data
Aggregating data: COUNT, SUM, AVG, MIN, MAX
Sorting and limiting results
• Advanced SQL Techniques
Using JOINs to combine data from multiple tables
Subqueries and nested queries
Advanced filtering techniques: CASE statements, IF conditions
SQL functions and how to create custom functions
• Data Cleaning with SQL
Identifying and handling missing data
Data transformation and formatting
Removing duplicates and outliers
• Introduction to Data Visualization
Importance of data visualization in analytics
Overview of Tableau: capabilities and installation
• Getting Started with Tableau
Connecting Tableau to SQL databases
Understanding Tableau interface and data importation
Creating basic charts and graphs
• Advanced Visualization Techniques in Tableau
Customizing visualizations with calculated fields
Creating interactive dashboards and stories
Advanced chart types: heat maps, scatter plots, box plots
• Dashboard Design Best Practices
Principles of effective data visualization
Designing user-centric dashboards
Incorporating interactivity and storytelling in dashboards
• Case Studies and Applied Projects
Real-world data analytics problems
Hands-on project: End-to-end analytics with SQL and Tableau
Project presentation and peer review
• Conclusion and Next Steps
Recap of course lessons
Resources for further learning
Certification and course completion guidelines

Taught by

Paul Scotchford

Subjects

Programming