Data Analysis for Business
Collect, clean, analyse and report business data, and keep the reports accurate over time.
Course overview
Learn to turn business data into decisions. You will clean and organise data, analyse it with Excel and SQL, build dashboards in Power BI and Tableau, and learn how to keep reports accurate as new data arrives.
Who it is for
Programme officers, administrators, students and small business owners who work with records, surveys or sales figures.
Format, schedule and group size can be arranged to suit your team. Get in touch to discuss.
Module outline
Module 1
Data collection and cleaning
- Collecting data and designing simple forms
- Cleaning and organising messy data
Module 2
Analysis with Excel and SQL
- Formulas, pivot tables and charts
- Querying data with SQL
Module 3
Statistics basics
- Descriptive statistics and common tests
- Introduction to SPSS
Module 4
Dashboards
- Building interactive dashboards in Power BI and Tableau
- Choosing the right charts
Module 5
Reporting and decisions
- Writing short insight reports
- Presenting findings to management
Module 6
Maintaining data quality
- Refreshing reports and checking accuracy
- Documenting data sources and changes
What you will be able to do
- Clean, analyse and visualise business data
- Build dashboards that managers can use
- Maintain accurate, repeatable reports