Data & SpreadsheetsIntermediate

Data Analysis: Excel, SQL & Power BI

Name: Data Analysis: Excel, SQL & Power BI
Availability: InStock

Start a career in one of the most in-demand skills: turning data into decisions.

19 lessons3h 25m of video2 quizzes1 practical task Certificate

Start this course — free

What you'll learn

Explain what data analysts do and the tools they use
Clean messy data in Excel
Describe data with mean, median and standard deviation
Write SQL queries with SELECT, WHERE, GROUP BY and JOIN
Build an interactive dashboard in Power BI
Plan a data portfolio project

Course content

Part 1. The data analyst's job4 lessons

Part 2. Cleaning & describing data4 lessons

Part 3. SQL: talking to databases5 lessons

Part 4. Dashboards & storytelling3 lessons

Part 5. Your portfolio3 lessons

Capstone project: Capstone project: Analyse a real dataset. You finish by building something real; a mentor reviews it before your certificate is issued.

About this course

Data analysts help businesses, governments and NGOs make better decisions with data. This course follows the path real analysts take: understanding the job, cleaning data, basic statistics, querying databases with SQL, building dashboards in Power BI, and creating a portfolio that gets you noticed. It's taught by working analysts and top educators. Finish with your own dashboard project.