Golad Academy
March 2027 cohort
- Starts Mon, 1 March 2027 · 12 weeks
- Live online
Fee: £99Apply now
Applications close 26 February 2027.
Golad Academy · Training Services
Data Analysis
The Data Analysis course gives learners the practical skills to collect, clean, analyse and present data. Using Excel, business intelligence tools and core statistics, you will learn to turn everyday data into clear insights and recommendations for decision-makers in business, health, education and government. Designed for beginners, it requires no programming experience.
- Duration:12 weeks
- Skill level:Beginner to Intermediate
- Next cohort:1 March 2027
- Course price:£99
Learning outcomes
What you will be able to do
- Collect, validate and clean data from surveys, databases and spreadsheets
- Use advanced Excel: lookups, PivotTables and dynamic dashboards
- Build interactive reports in a business intelligence tool
- Apply core statistics and probability to everyday decisions
- Write executive summaries and present findings to stakeholders
- Complete an end-to-end portfolio project
12 core modules
Curriculum
01Module 1Introduction to Data Analytics
- What is Data Analysis? Importance in Decision-Making
- Types of Data Analysis: Descriptive, Diagnostic, Predictive, Prescriptive
- Overview of The Data Analytics Lifecycle: Collection → Cleaning → Analysis → Storytelling
- Real-World Applications: Business, Health, Governance, Education
02Module 2Data Collection & Management
- Data Sources: Surveys, Databases, Reports, CSV/Excel Files
- Ethical Considerations and Privacy in Data Collection
- Data Validation and Entry Standards
- Organizing and Storing Data for Analysis
03Module 3Data Cleaning & Preparation
- Handling Missing Data, Duplicates, and Outliers
- Formatting and Standardizing Data (Dates, Text, Categories)
- Simple Transformations: Sorting, Filtering, Grouping
- Introduction to Data Quality Checks
04Module 4Exploratory Data Analysis (EDA)
- Summary Statistics: Mean, Median, Mode, Range, Standard Deviation
- Visual Exploration: Charts, Graphs, Tables
- Identifying Patterns, Trends, and Anomalies
- Basic Correlation and Relationships Between Variables
05Module 5Data Visualization Principles
- Best Practices for Presenting Data Effectively
- Choosing the Right Chart Type: Bar, Line, Pie, Scatter, Heatmaps
- Storytelling with Visuals for Decision-Making
- Infographics and Dashboard Design Principles
06Module 6Advanced Excel for Data Analysis
- Lookup and Reference Functions: VLOOKUP, HLOOKUP, INDEX-MATCH
- PivotTables, PivotCharts, and Dynamic Dashboards
- Conditional Formatting and Custom Calculations
- Scenario Analysis and Simple Forecasting
07Module 7Introduction to Business Intelligence (BI)
- Understanding BI and Its Role in Organizations
- BI Tools for Non-Technical Users
- Creating Interactive Dashboards and Visual Reports
- Connecting Data Sources for Analysis
08Module 8Statistical Concepts for Decision-Making
- Descriptive vs Inferential Statistics
- Probability Basics and Distributions
- Introduction to Hypothesis Testing
- Interpreting Results for Business Insights
09Module 9Data Storytelling & Reporting
- Translating Data into Actionable Insights
- Writing Executive Summaries and Visual Reports
- Creating Presentations for Stakeholders
- Communicating Trends, Patterns, and Recommendations
10Module 10Domain-Specific Applications
- Healthcare: Patient Data Trends, Program Evaluation
- Education: Enrollment Statistics, Performance Analysis
- Business: Sales, Marketing, and Operational KPIs
- Governance: Public Data Monitoring, Program Performance
11Module 11Capstone Project & Portfolio Building
- Capstone: End-to-End Data Analysis Project
- Apply Full Pipeline: Data Collection → Cleaning → Visualization → Insights
- Present Findings in a Written Report and Interactive Dashboard
- Build a Portfolio for Career
12Module 12Career Workshop & Next Steps
- Resume Building for Data Analysis Roles
- LinkedIn Branding and Online Portfolio Strategies
- Interview Preparation: Explaining Analysis and Insights
- Continuing Education: Certifications and Learning Paths
Industry extension
Optional advanced modules
Self-paced on GADLE alongside the core programme, so your skills keep pace with where the field is heading — including AI.
SQL for Analysts
- • Relational databases and tables
- • SELECT, WHERE, ORDER BY and aggregation
- • JOINs across related tables
- • Using SQL as a data source for dashboards
Automating Reports
- • Power Query for repeatable data preparation
- • Scheduled refresh and shared dashboards
- • Data validation and error checks
- • Documenting your reporting process
Benefits of Data Analysis
What you’ll gain from this course
- Confident Decision-Making
- Clear Reporting
- Time Saved Through Automation
- Career Opportunities
Tools you’ll use
- Microsoft Excel
- Power Query
- Power BI
- Tableau
- Google Sheets
- Looker Studio
- PowerPoint
- SQL basics
Prepares you for
- Microsoft PL-300: Power BI Data Analyst (foundation)
- Microsoft Office Specialist: Excel Expert
- Google Data Analytics Professional Certificate
Career paths
- Data Analyst
- Reporting / MI Analyst
- Business Intelligence Assistant
- Monitoring & Evaluation Analyst
- Operations Analyst
- Research Assistant
Certification exams are set and awarded by their own bodies; our curriculum covers their knowledge areas. Trademarks belong to their owners.
Open for applications
Choose your start date
Apply online in about five minutes. An advisor will review your application and contact you.
Questions
Can’t find your answer? Contact us.
When does the next cohort start?
The next cohort for every Golad Academy programme starts on 1 March 2027. Apply online and an advisor will confirm your place.
How much does the course cost?
The course price is £99. Employers can sponsor a place and ask us for an invoice.
Do I need experience?
No. Programmes are designed for beginners to intermediate learners. An advisor reviews every application and will recommend the right starting point.
How is the course delivered?
Through live, instructor-led online classes with real-world projects. Between classes you learn on GADLE, our learning platform, where you will find recordings, lessons and assignments.
What are the industry-extension modules?
Two optional advanced modules, completed on GADLE alongside the twelve core modules, that keep the programme aligned with how the field is changing — including AI.
Get in touch
Ready to Start Your Learning Journey?
Ask an advisor about the programme, fees and the next intake.