Krpex
Create account
Data analysisbeginner

Data Analysis with Excel and SQL

Clean, analyse and present data the way analysts do every day, using Excel and SQL on realistic business data.

Lessons
12 lessons in 4 modules
Study time
about 6 hours
Duration
~5 weeks at your own pace

Free plan: counts as one of your 2 new courses this month. Plans

What you'll learn

  • Clean messy data and build pivot tables
  • Use lookups and formulas to combine data
  • Answer analysis questions with SQL
  • Present findings in clear charts and a short report

Syllabus

  1. Module 1Thinking like an analystQuestions before tools.2 lessons
    1. What data analysts doDescribe the analysis process from question to decision.20 min
    2. Types of data and good questionsTurn a vague request into measurable questions.30 min
  2. Module 2Excel for analysisFormulas, cleaning and pivots.4 lessons
    1. Cleaning data in ExcelFix duplicates, blanks, text case and inconsistent dates.30 min
    2. Essential formulasUse IF, SUMIFS, COUNTIFS and text functions.30 min
    3. Lookups: XLOOKUP and VLOOKUPCombine data from two sheets with lookups.30 min
    4. Pivot tablesSummarise thousands of rows in seconds with a pivot table.30 min
  3. Module 3SQL for analysisQuery data at scale.3 lessons
    1. SQL queries for analystsFilter, group and sort data with SQL.30 min
    2. Joins for analysisCombine orders, customers and products tables.30 min
    3. Cohorts and trends with SQLCalculate month-over-month growth and retention.30 min
  4. Module 4Presenting insightsCharts and storytelling.3 lessons
    1. Choosing the right chartMatch the chart type to the question.30 min
    2. Building a simple dashboardCombine key numbers and charts on one page.30 min
    3. Project: sales analysis reportAnalyse the sales dataset and write a one-page report.50 min