Data Analyst
Data Analyst — Foundations
Get started in data with advanced Excel, SQL and dashboards that speak to decision-makers.
This course lays the foundations of the data analyst role: advanced Excel, querying databases with SQL and data literacy. As a capstone, you build a complete Excel dashboard from a sales dataset.
Objectives
- Master Excel advanced functions and pivot tables
- Query a relational database with simple SQL statements
- Understand the data lifecycle and the analyst's role
- Design clear visualizations and a readable dashboard
Program
Advanced Excel for analysis
- Logical functions, VLOOKUP and XLOOKUP
- Pivot tables and slicers
- Conditional formatting and quick cleaning
Databases and SQL
- Relational model and table vocabulary
- SELECT, WHERE, ORDER BY queries
- Simple joins and aggregates (COUNT, SUM)
Data literacy and dataviz
- Data roles and business vocabulary
- Choosing the right chart for the message
- Assembling an Excel tracking dashboard
Prerequisites
No prerequisites