Gain data analysis and visualization skills with SQL and Tableau. Work on real projects and develop practical skills. Join now and start learning! Read more.
I am a Senior Data and Insights Analyst with over 4 years experience working with data. I use SQL, Tableau and Microsoft Excel at an advanced level in my job every day and want to share my skills and teach how I would have wanted to learn these topics which can help you become a data analyst quickly. I aim to make my courses practical so you are getting real experience and getting a feel for what the job will be like. It is the best way to learn in my opinion. Please get in touch if you ha
Access all courses in our library for only $9/month with All Access Pass
Get Started with All Access PassBuy Only This CourseAbout This Course
Who this course is for:
- Beginners who want to learn data analysis and visualization from scratch
- Anyone interested in leveraging data for decision-making and insights
- Students pursuing careers in data analysis, business intelligence, or data visualization
What you’ll learn:Â
- SQL Server – Beginner to Intermediate. You will install and use SQL server management studio
- Write complex queries to extract data from a database
- Understand relational databases and entity relationship diagrams
- Do a customer profile on Adventureworks database including Google Sheets pivot tables and dual axis charts
- Build two Tableau dashboards
- Create calculated fields and a period parameter in Tableau
- Publish your Tableau dashboards online so they can be accessed anywhere
Requirements:Â
- No prior experience required, although basic knowledge of databases and data analysis concepts would be helpful
- You will need access to a windows computer with internet connection
Software version used in the course:
- SQL Server Express 2019
Thanks for your interest in this hands-on course for SQL and Tableau! In this comprehensive course, you will learn how to effectively analyze and visualize data using two of the most popular tools in the field of data analysis – SQL and Tableau.
Whether you’re a beginner looking to dive into the world of data analysis or an experienced professional looking to enhance your skills, this course is designed to cater to all levels of learners. With a practical, hands-on approach, you’ll gain the confidence to apply SQL and Tableau to real-world data scenarios.
In the SQL section, you’ll start with the fundamentals, learning how to do basic queries using SQL Server Management Studio. You’ll gain expertise in querying databases, filtering and sorting data, and performing advanced operations such as joins, subqueries, window functions and aggregations.
You will then ask questions of the data and visualize the output in Google Sheets using pivot tables and charts to help identify trends.
In the Tableau section, you’ll learn how to create interactive dashboards. You’ll start with the basics, including connecting to data sources, creating visualizations, and building interactive dashboards. You’ll then move on to advanced topics such as calculated fields, sets and parameters. You’ll also learn how to create dynamic and interactive visualizations that can be shared with others.
Throughout the course, you’ll work on practical exercises and real-world projects to reinforce your learning. You’ll gain real experience in data analysis and visualization, and build a portfolio of work to showcase your skills to potential employers.
By the end of this course, you’ll have a strong foundation in SQL and Tableau, and be able to confidently analyze and visualize data for business intelligence, reporting, and decision-making purposes. Join us on this exciting journey to become a data analysis and visualization expert!
Course Features:
- Comprehensive coverage of SQL and Tableau, from fundamentals to advanced topics
- Practical, hands-on approach with real-world projects and exercises
- Step-by-step guidance and demonstrations
- Portfolio-building opportunities
- Access to course materials and updates for lifetime
Don’t miss this opportunity to become proficient in SQL and Tableau and unlock the power of data analysis and visualization. Enroll now and take your data skills to the next level!
Our Promise to You
By the end of this course, you will have learned how to use SQL and Tableau to analyze and visualize data by working on real projects.
10 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.
Get started today!
Course Curriculum
| Section 1 - Introduction And Thank You! | |||
| Introduction To The Course | 00:00:00 | ||
| Section 2 - Download SQL Server Management Studio And Adventureworks Database | |||
| SSMS And Adventureworks Download | 00:00:00 | ||
| Section 3 - What Is SQL And A Relational Database? | |||
| SQL, Relational Database And Entity Relationship Diagram | 00:00:00 | ||
| Quick SSMS Overview | 00:00:00 | ||
| Section 4 - Beginner SQL | |||
| Select, From, Where, And, Or | 00:00:00 | ||
| Select, From, Where, And, Or - Questions And Answers | 00:00:00 | ||
| Upper And Lower | 00:00:00 | ||
| IN And NOT IN Operators | 00:00:00 | ||
| Distinct, Like And Order By | 00:00:00 | ||
| Section 5 - Intermediate SQL | |||
| Inner Join | 00:00:00 | ||
| Left And Right Join | 00:00:00 | ||
| Joins - 2 Questions And Answers | 00:00:00 | ||
| Union And Union All | 00:00:00 | ||
| Section 6 - Aggregate Functions | |||
| Sum, Round And Group By | 00:00:00 | ||
| Having And Practice Question | 00:00:00 | ||
| Count | 00:00:00 | ||
| Max And Min | 00:00:00 | ||
| Average | 00:00:00 | ||
| Questions On Aggregate Functions | 00:00:00 | ||
| Section 7 - Sub Query And Common Table Expression (CTE) | |||
| Sub Queries | 00:00:00 | ||
| Common Table Expression (CTE) | 00:00:00 | ||
| Section 8 - Case Statement And Flags | |||
| Case When | 00:00:00 | ||
| Flags | 00:00:00 | ||
| Section 9 - Window Functions | |||
| Row_Number() | 00:00:00 | ||
| Row Number Q And A | 00:00:00 | ||
| Lead And Lag | 00:00:00 | ||
| Section 10 - Date Functions | |||
| Year, Month, Day and Get Date | 00:00:00 | ||
| DateDiff | 00:00:00 | ||
| DateAdd | 00:00:00 | ||
| Date Table | 00:00:00 | ||
| Cast And Convert | 00:00:00 | ||
| Joining Tables On More Than One Condition | 00:00:00 | ||
| Date Functions - Questions And Answers | 00:00:00 | ||
| Section 11 - String Functions | |||
| Concat | 00:00:00 | ||
| Substring | 00:00:00 | ||
| Section 12 - Google Sheets And Pivot Tables | |||
| Google Sheets - Pivot Tables | 00:00:00 | ||
| Thanks And Any Question | 00:00:00 | ||
| Section 13 - Adventureworks Analysis Project | |||
| Countries' Sales By Age Group | 00:00:00 | ||
| Products' Sales By Age Group | 00:00:00 | ||
| Sales In USA And Australia Compared | 00:00:00 | ||
| Products First Reorder Date | 00:00:00 | ||
| Products With High Stock Levels | 00:00:00 | ||
| Sales On Promotion | 00:00:00 | ||
| Change In Value Between A Customers' First And Last Purchase | 00:00:00 | ||
| Section 14 - Profile Of Customers Who Purchased A Bike | |||
| Customers By Commute Distance And Country | 00:00:00 | ||
| Amount Of Bike Purchases By Salary | 00:00:00 | ||
| Sales For Customers With Children Vs No Children | 00:00:00 | ||
| Putting It Together | 00:00:00 | ||
| Additional Analysis - Next Product Purchase Part 1 | 00:00:00 | ||
| Additional Analysis - Next Product Purchase Part 2 | 00:00:00 | ||
| Section 15 - Create Tableau Dashboard | |||
| Getting The Data For Tableau | 00:00:00 | ||
| Download And Install Tableau Public | 00:00:00 | ||
| Tableau Overview | 00:00:00 | ||
| Create Dual Axies Chart | 00:00:00 | ||
| Create Country Sales Donut Chart | 00:00:00 | ||
| Create Stacked Bar Chart And Grouping Our Data | 00:00:00 | ||
| Create Sales Cards | 00:00:00 | ||
| Accessories Bar Chart | 00:00:00 | ||
| Building Our Dashboard | 00:00:00 | ||
| Format And Publish The Dashboard To Tableau Public | 00:00:00 | ||
| Tableau Map | 00:00:00 | ||
| Running Total | 00:00:00 | ||
| Section 16 - Create Your Own Stock Performance Dashboard On Tableau | |||
| Introduction - What You Will Do In This Section | 00:00:00 | ||
| Section 17 - Getting Our Data | |||
| Getting Our Stock Data | 00:00:00 | ||
| Download Tableau And Connect To Data Source | 00:00:00 | ||
| Section 18 - Creating Our Charts For The Dashboard | |||
| Create Cards For Stock Value And Profit And Loss | 00:00:00 | ||
| Create Donut Chart | 00:00:00 | ||
| 3 Month Trend Charts And Stock Overview | 00:00:00 | ||
| 3 Month Portfolio Value Chart | 00:00:00 | ||
| Performance % Of Each Stock | 00:00:00 | ||
| Individual Stock Chart And Parameter | 00:00:00 | ||
| Section 19 - Building And Publishing Our Dashboard | |||
| Building Our Tableau Dashboard | 00:00:00 | ||
| Formatting Our Tableau Dashboard | 00:00:00 | ||
| Publishing Our Dashboard | 00:00:00 | ||
| Section 20 - Create Stock Price Tracker On Tableau | |||
| Getting Data | 00:00:00 | ||
| Connect To Data And Change Data Type | 00:00:00 | ||
| Candlestick Chart | 00:00:00 | ||
| Volume And Volatility Charts | 00:00:00 | ||
| Logos | 00:00:00 | ||
| Last Price And % Change Cards | 00:00:00 | ||
| Put Dashboard Together | 00:00:00 | ||
| Final Format And Publish | 00:00:00 | ||
| Additional Price Cards - One Year Low And One Year % Change | 00:00:00 | ||
About This Course
Who this course is for:
- Beginners who want to learn data analysis and visualization from scratch
- Anyone interested in leveraging data for decision-making and insights
- Students pursuing careers in data analysis, business intelligence, or data visualization
What you’ll learn:Â
- SQL Server – Beginner to Intermediate. You will install and use SQL server management studio
- Write complex queries to extract data from a database
- Understand relational databases and entity relationship diagrams
- Do a customer profile on Adventureworks database including Google Sheets pivot tables and dual axis charts
- Build two Tableau dashboards
- Create calculated fields and a period parameter in Tableau
- Publish your Tableau dashboards online so they can be accessed anywhere
Requirements:Â
- No prior experience required, although basic knowledge of databases and data analysis concepts would be helpful
- You will need access to a windows computer with internet connection
Software version used in the course:
- SQL Server Express 2019
Thanks for your interest in this hands-on course for SQL and Tableau! In this comprehensive course, you will learn how to effectively analyze and visualize data using two of the most popular tools in the field of data analysis – SQL and Tableau.
Whether you’re a beginner looking to dive into the world of data analysis or an experienced professional looking to enhance your skills, this course is designed to cater to all levels of learners. With a practical, hands-on approach, you’ll gain the confidence to apply SQL and Tableau to real-world data scenarios.
In the SQL section, you’ll start with the fundamentals, learning how to do basic queries using SQL Server Management Studio. You’ll gain expertise in querying databases, filtering and sorting data, and performing advanced operations such as joins, subqueries, window functions and aggregations.
You will then ask questions of the data and visualize the output in Google Sheets using pivot tables and charts to help identify trends.
In the Tableau section, you’ll learn how to create interactive dashboards. You’ll start with the basics, including connecting to data sources, creating visualizations, and building interactive dashboards. You’ll then move on to advanced topics such as calculated fields, sets and parameters. You’ll also learn how to create dynamic and interactive visualizations that can be shared with others.
Throughout the course, you’ll work on practical exercises and real-world projects to reinforce your learning. You’ll gain real experience in data analysis and visualization, and build a portfolio of work to showcase your skills to potential employers.
By the end of this course, you’ll have a strong foundation in SQL and Tableau, and be able to confidently analyze and visualize data for business intelligence, reporting, and decision-making purposes. Join us on this exciting journey to become a data analysis and visualization expert!
Course Features:
- Comprehensive coverage of SQL and Tableau, from fundamentals to advanced topics
- Practical, hands-on approach with real-world projects and exercises
- Step-by-step guidance and demonstrations
- Portfolio-building opportunities
- Access to course materials and updates for lifetime
Don’t miss this opportunity to become proficient in SQL and Tableau and unlock the power of data analysis and visualization. Enroll now and take your data skills to the next level!
Our Promise to You
By the end of this course, you will have learned how to use SQL and Tableau to analyze and visualize data by working on real projects.
10 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.
Get started today!
Course Curriculum
| Section 1 - Introduction And Thank You! | |||
| Introduction To The Course | 00:00:00 | ||
| Section 2 - Download SQL Server Management Studio And Adventureworks Database | |||
| SSMS And Adventureworks Download | 00:00:00 | ||
| Section 3 - What Is SQL And A Relational Database? | |||
| SQL, Relational Database And Entity Relationship Diagram | 00:00:00 | ||
| Quick SSMS Overview | 00:00:00 | ||
| Section 4 - Beginner SQL | |||
| Select, From, Where, And, Or | 00:00:00 | ||
| Select, From, Where, And, Or - Questions And Answers | 00:00:00 | ||
| Upper And Lower | 00:00:00 | ||
| IN And NOT IN Operators | 00:00:00 | ||
| Distinct, Like And Order By | 00:00:00 | ||
| Section 5 - Intermediate SQL | |||
| Inner Join | 00:00:00 | ||
| Left And Right Join | 00:00:00 | ||
| Joins - 2 Questions And Answers | 00:00:00 | ||
| Union And Union All | 00:00:00 | ||
| Section 6 - Aggregate Functions | |||
| Sum, Round And Group By | 00:00:00 | ||
| Having And Practice Question | 00:00:00 | ||
| Count | 00:00:00 | ||
| Max And Min | 00:00:00 | ||
| Average | 00:00:00 | ||
| Questions On Aggregate Functions | 00:00:00 | ||
| Section 7 - Sub Query And Common Table Expression (CTE) | |||
| Sub Queries | 00:00:00 | ||
| Common Table Expression (CTE) | 00:00:00 | ||
| Section 8 - Case Statement And Flags | |||
| Case When | 00:00:00 | ||
| Flags | 00:00:00 | ||
| Section 9 - Window Functions | |||
| Row_Number() | 00:00:00 | ||
| Row Number Q And A | 00:00:00 | ||
| Lead And Lag | 00:00:00 | ||
| Section 10 - Date Functions | |||
| Year, Month, Day and Get Date | 00:00:00 | ||
| DateDiff | 00:00:00 | ||
| DateAdd | 00:00:00 | ||
| Date Table | 00:00:00 | ||
| Cast And Convert | 00:00:00 | ||
| Joining Tables On More Than One Condition | 00:00:00 | ||
| Date Functions - Questions And Answers | 00:00:00 | ||
| Section 11 - String Functions | |||
| Concat | 00:00:00 | ||
| Substring | 00:00:00 | ||
| Section 12 - Google Sheets And Pivot Tables | |||
| Google Sheets - Pivot Tables | 00:00:00 | ||
| Thanks And Any Question | 00:00:00 | ||
| Section 13 - Adventureworks Analysis Project | |||
| Countries' Sales By Age Group | 00:00:00 | ||
| Products' Sales By Age Group | 00:00:00 | ||
| Sales In USA And Australia Compared | 00:00:00 | ||
| Products First Reorder Date | 00:00:00 | ||
| Products With High Stock Levels | 00:00:00 | ||
| Sales On Promotion | 00:00:00 | ||
| Change In Value Between A Customers' First And Last Purchase | 00:00:00 | ||
| Section 14 - Profile Of Customers Who Purchased A Bike | |||
| Customers By Commute Distance And Country | 00:00:00 | ||
| Amount Of Bike Purchases By Salary | 00:00:00 | ||
| Sales For Customers With Children Vs No Children | 00:00:00 | ||
| Putting It Together | 00:00:00 | ||
| Additional Analysis - Next Product Purchase Part 1 | 00:00:00 | ||
| Additional Analysis - Next Product Purchase Part 2 | 00:00:00 | ||
| Section 15 - Create Tableau Dashboard | |||
| Getting The Data For Tableau | 00:00:00 | ||
| Download And Install Tableau Public | 00:00:00 | ||
| Tableau Overview | 00:00:00 | ||
| Create Dual Axies Chart | 00:00:00 | ||
| Create Country Sales Donut Chart | 00:00:00 | ||
| Create Stacked Bar Chart And Grouping Our Data | 00:00:00 | ||
| Create Sales Cards | 00:00:00 | ||
| Accessories Bar Chart | 00:00:00 | ||
| Building Our Dashboard | 00:00:00 | ||
| Format And Publish The Dashboard To Tableau Public | 00:00:00 | ||
| Tableau Map | 00:00:00 | ||
| Running Total | 00:00:00 | ||
| Section 16 - Create Your Own Stock Performance Dashboard On Tableau | |||
| Introduction - What You Will Do In This Section | 00:00:00 | ||
| Section 17 - Getting Our Data | |||
| Getting Our Stock Data | 00:00:00 | ||
| Download Tableau And Connect To Data Source | 00:00:00 | ||
| Section 18 - Creating Our Charts For The Dashboard | |||
| Create Cards For Stock Value And Profit And Loss | 00:00:00 | ||
| Create Donut Chart | 00:00:00 | ||
| 3 Month Trend Charts And Stock Overview | 00:00:00 | ||
| 3 Month Portfolio Value Chart | 00:00:00 | ||
| Performance % Of Each Stock | 00:00:00 | ||
| Individual Stock Chart And Parameter | 00:00:00 | ||
| Section 19 - Building And Publishing Our Dashboard | |||
| Building Our Tableau Dashboard | 00:00:00 | ||
| Formatting Our Tableau Dashboard | 00:00:00 | ||
| Publishing Our Dashboard | 00:00:00 | ||
| Section 20 - Create Stock Price Tracker On Tableau | |||
| Getting Data | 00:00:00 | ||
| Connect To Data And Change Data Type | 00:00:00 | ||
| Candlestick Chart | 00:00:00 | ||
| Volume And Volatility Charts | 00:00:00 | ||
| Logos | 00:00:00 | ||
| Last Price And % Change Cards | 00:00:00 | ||
| Put Dashboard Together | 00:00:00 | ||
| Final Format And Publish | 00:00:00 | ||
| Additional Price Cards - One Year Low And One Year % Change | 00:00:00 | ||
Related Courses
Database SQL Course With Queries Hands-On Training Using Microsoft SQL Server
BeginnerMazhar Hussain$199.00
Database SQL Course With Queries Hands-On Training Using Microsoft SQL Server
Are you interested in higher education?
All Rights Reserved