DATA ANALYTICS WITH EXCEL

Learn how to use large data sets to make critical decisions confidently

This course is created for analysts, digital marketers, sales managers, product managers and everyone looking to learn the essentials of Data analytics. You’ll use industry tools, Excel, SQL, and Tableau, to analyze large real world data sets.

Also, you will be able to create data dashboards and various data visualizations to communicate insights. This course will culminate in a presentation of your data analysis and insights to your classmates and instructional team.

MODULE 1: FUNDAMENTALS OF EXCEL
  • Welcome to Excel
  • Getting Started with Data in Excel
  • Cleaning Data in Excel
  • Visualizing Data in Excel
  • Introduction to Statistics in Excel
EXPLORING DATA WITH EXCEL
  • The Value of Data
  • Data Narratives
  • Excel Fundamentals
  • Data Referencing
  • Data Aggregation
  • Data Visualization in Excel
  • Statistics in Excel
MANAGING DATA WITH SQL
  • Foundations of Databases and SQL
  • Combining Data in SQL
  • Cleaning Data and Creating Multiple Joins in SQL
  • Using Logic in SQL
  • Subqueries
  • Applying SQL Functions
COMMUNICATING DATA ANALYSIS WITH TABLEAU/POWER BI
  • Visualizing and Mapping Data in Tableau
  • Text Manipulation in Tableau
  • Designing Data Dashboards in Tableau
  • Working with Data Across Excel, SQL and Tableau
  • Final Project Presentation

Here’s what you stand to gain