Data Analysis & Visualization

Overview

The Data Analysis and Visualization course is an eight-week intensive program designed to equip participants with essential data analysis and visualization skills using industry-standard tools such as Excel, Power BI, and SQL.

This hands-on course guides participants from foundational concepts to advanced techniques, empowering them to analyze, model, and present data effectively. Each week builds upon the last, incorporating assignments and projects that provide practical experience, culminating in a final project to showcase acquired skills.

This course is ideal for beginners looking to start a career in data analysis, as well as professionals seeking to enhance their data-driven decision-making abilities.

Course Objectives

The primary objectives of this course are to:

Understand core concepts of data analysis, including its types, importance, and applications across various industries.
Demonstrate proficiency in data handling, entry, and transformation using Excel for structured data analysis.
Utilize advanced Excel functions for data cleaning, validation, and creating interactive dashboards.
Develop and manage interactive visualizations and reports, and understand key data modeling principles.
Write SQL queries to extract, manipulate, and analyze data from relational databases.
Integrate data from different sources, refine queries, and apply techniques to answer complex business questions.

Course Outline

Week 1 - Introduction to Data Analysis

Definition and types of data analysis
Importance and overview of the data analysis process
Introduction to Excel, Power BI, and SQL as tools
Data collection/gathering techniques
Assignment

Week 2 - Microsoft Excel Fundamentals

Excel interface and navigation
Data entry, formatting, and basic formulas/functions
Sorting and filtering data
Creating charts and graphs
Assignment

Week 3 - Advanced Microsoft Excel for Data Analysis

Data cleaning with Power Query
Pivot Tables and Pivot Charts
Data validation and conditional formatting
Data modeling and building dashboards
First project

Week 4 - Power BI

Overview and components of Power BI
Connecting to data sources and data modeling
Creating visualizations and dashboards
Basics of DAX (Data Analysis Expressions)
Assignment

Week 5 - SQL for Data Analysis (Part 1)

Relational databases
Understanding SQL Syntax
Querying Data with SELECT statements
Assignment

Week 6 - SQL for Data Analysis (Part 2)

SQL Aggregate Functions, GROUP BY, and WHERE Clauses
Combining Data with JOIN Statements
Assignment

Week 7 - Advanced SQL

Practical Class
Subqueries and Nested Queries
Data Manipulation (INSERT, UPDATE, DELETE)
Assignment

Week 8 - Capstone Project

Capstone Project
Capstone Project Presentations
Review and Course Conclusion

Course Outcomes

By the end of this course, students will be able to:

Be able to perform data cleaning, aggregation, and summarization tasks in Excel and Power BI.
Develop functional and interactive dashboards that effectively communicate data insights.
Master the fundamentals of SQL, enabling them to query and manipulate data within relational databases.
Possess the ability to design and present data-driven projects, demonstrating their ability to analyze data, build visualizations, and tell a compelling story.
Earn a certificate of completion, validating their skills in data analysis and visualization.

Expert Instructors