Overview

This is a practical Data Analyst Career Programme designed to take you from learning data-analysis skills to becoming job-ready and professionally positioned for a career in data analytics.

Over 8 weeks, you’ll develop technical, analytical and professional skills while building projects that demonstrate what you can actually do.

The goal isn’t simply to give you certificates.

The goal is to help you build evidence of your ability.

What You’ll Get

✔ 8 weeks of structured learning
✔ Weekly instructor-led live sessions and Q&A
✔ Excel and Advanced Excel training
✔ Power Query and data preparation
✔ SQL for Data Analysts
✔ Power BI and DAX
✔ Python for Data Analysis
✔ Business Intelligence training
✔ Data storytelling and communication
✔ Real-world datasets and case studies
✔ Multiple practical assignments
✔ Portfolio development
✔ CV development
✔ LinkedIn optimisation
✔ GitHub/project guidance
✔ Data Analyst interview preparation
✔ Personal career roadmap

What Makes This Different?

A lot of people complete courses and still don’t feel ready to apply for jobs.

They may know:

Excel.

SQL.

Power BI.

But when an employer asks:

“Tell me about a project where you used data to solve a problem.”

They don’t have a strong answer.

This programme focuses on skills + application + evidence + career positioning.

You won’t just learn the tools.

You’ll learn how to:

Analyse → Explain → Present → Recommend → Demonstrate

What You’ll Learn

Data Analyst Foundations

• The modern Data Analyst
• Data analysis lifecycle
• Business questions
• KPIs
• Data quality
• Analytical thinking
• Working with stakeholders

Excel & Advanced Excel

• Excel fundamentals
• Advanced formulas
• XLOOKUP
• INDEX/MATCH
• IF/IFS
• SUMIFS/COUNTIFS
• PivotTables
• PivotCharts
• Advanced dashboards
• What-if analysis
• Scenario analysis
• Advanced Excel techniques

Power Query & Data Preparation

• Data cleaning
• Missing values
• Duplicates
• Data transformation
• Merging datasets
• Appending datasets
• Automating preparation
• Refreshable workflows

SQL

• Database fundamentals
• SELECT
• WHERE
• GROUP BY
• HAVING
• JOINs
• CASE
• Subqueries
• CTEs
• Window functions
• Date analysis
• Business intelligence queries

Power BI

• Data connection
• Power Query
• Data modelling
• Relationships
• Star schema
• DAX
• Measures
• KPIs
• Interactive dashboards
• Report design
• Business intelligence

Python

• Python fundamentals
• Pandas
• NumPy
• Data cleaning
• Data transformation
• Exploratory Data Analysis
• Statistics
• Data visualisation
• Using Python for analytical workflows

Data Storytelling

• Turning data into information
• Turning information into insight
• Turning insight into recommendations
• Visualisation principles
• Executive reporting
• Communicating with stakeholders

Portfolio Project

You will complete a real-world project using the skills developed throughout the programme.

Your project can include:

• Excel
• SQL
• Power BI
• Python
• Data storytelling
• Business recommendations

Career Development

Build Your CV

• Data Analyst CV
• Technical skills
• Achievement-focused experience
• Project experience

Build Your LinkedIn

• Professional headline
• About section
• Featured projects
• Skills
• Building your professional presence

Build Your Portfolio

• Project case studies
• GitHub
• Power BI projects
• Documenting your analysis
• Presenting your work

Prepare for Interviews

• Technical questions
• SQL questions
• Excel questions
• Power BI questions
• Case studies
• Portfolio presentation
• Using AI responsibly during your job search

Who This Course Is For

✔ People who have completed the Zabrol AI-Powered Data Analysis Bootcamp
✔ Beginners who want a structured route into data analytics
✔ Career changers
✔ Graduates and students
✔ Professionals moving into data roles
✔ Aspiring Data Analysts
✔ Junior analysts looking to strengthen their skills
✔ Anyone serious about building a data career

Real Impact

✔ Career-focused rather than tool-focused
✔ Industry-relevant technical skills
✔ Real-world projects
✔ Instructor support
✔ Portfolio development
✔ CV and LinkedIn development
✔ Interview preparation
✔ Practical evidence of your ability

What You’ll Achieve

By the end of the programme, you will:

✔ Analyse data using Excel, SQL, Power BI and Python
✔ Build professional dashboards
✔ Work with messy business datasets
✔ Understand business intelligence
✔ Communicate insights effectively
✔ Complete portfolio-ready projects
✔ Build a professional Data Analyst CV
✔ Optimise your LinkedIn profile
✔ Create a data portfolio
✔ Prepare for Data Analyst interviews
✔ Have a clear 90-day career action plan

Your Career Journey

Learn the skills → Build the projects → Build your portfolio → Position yourself → Apply → Interview → Get hired