Data Analytics with Excel and SQL
Analyze a fictional retail dataset and present a management dashboard with defensible recommendations.
Data Analytics with Excel and SQL develops practical capability through six curriculum modules combining focused lessons, guided activities and assessed deliverables. Analyze a fictional retail dataset and present a management dashboard with defensible recommendations. The six-week outline is an estimated learning sequence, not a confirmed cohort timetable; tutors and administrators configure actual dates separately.
Learning outcomes
- Profile a fictional sales dataset.
- Build a reconciled monthly sales report.
- Answer five business questions using SQL.
- Investigate changes in conversion and revenue.
- Create a management dashboard.
Who it's for
Analysts, finance staff and operations professionals
Prerequisites
Basic spreadsheet use
Learning tools
Excel or compatible spreadsheet, SQL client and fictional business datasets
Estimated learning time
36 hours · 6 curriculum modules
Curriculum
Final project
Analyze a fictional retail dataset and present a management dashboard with defensible recommendations.
Completion & certificates
- Complete each published lesson.
- Submit every practical assignment and the final project.
- Satisfy the published assessment criteria in tutor or administrator review.
- Receive administrator completion review before certificate eligibility.
Certificate eligibility requires verified completion and administrator review. No certificate has been issued for this course.
Cohorts & class dates
No cohort dates have been confirmed. The curriculum sequence is not a scheduled class timetable.