Understand how to prepare, clean, aggregate, visualize, and build data narratives.
Learn the fundamentals of SQL including database basics, advanced SQL functions, and how to write efficient, dynamic queries to get the data you need to make the best data driven decisions.
Data Visualization and Insights with Tableau
Learn how to get the most out of your data by making powerful charts, dashboards, and other visualizations in Tableau and learning how to communicate those with stakeholders.
By the end of the course, you will be able to:
‣ Use Excel, SQL and Tableau to collect, clean, and analyze large datasets.
‣ Understand some of the basic fundamentals of Data Science.
‣ Present data driven insights to key stakeholders
using data visualization and dashboards.
‣ Tell compelling stories with your data.
Week 1 - Analytics Basics:
How to approach a problem, the data analytics life-cycle, dive into EDA (Exploratory Data Analysis), and get started on your data journey.
Week 2 - Intro to SQL:
Learn how to pull, clean, and manipulate data with SQL.
Week 3 - Advanced SQL Functions:
Learn advanced SQL functions and to export your data.
Week 4 - Data Visualization with Tableau
Learn how to connect your data source and make powerful charts and dashboards that help you derive insights and communicate your data.
Week 5 - So What? Telling your Data’s Story
This week focuses on problem solving, insights, and the “so what”. Building on what you’ve learned, you’ll learn how to derive insights, tell your data’s “story”, and develop a problem solving framework to ultimately approach any problem.
Week 6 - Putting everything together:
The last week of the class will focus on some advanced analytical topics including the basics of Machine Learning. You’ll also get a chance to present your final project to the instructor and get valuable feedback.