Model Online / On-Site
Duration
Modules 5 modules

Course Objective & Scope

Organisations produce plenty of reports, yet only a few genuinely support decisions. This programme applies the analyst's daily workflow end to end: asking the right question, preparing the data, analysing it and presenting the result convincingly.

Analysis frameworks (funnel, cohort, segmentation), KPI and metric definitions, querying data with SQL, basic statistical interpretation, dashboard design principles in Power BI or Tableau, and storytelling are covered. The organisation's own BI tool is used, and participants analyse a question from their own area, producing a one-page insight report and a dashboard prototype.

Who Should Attend?

  • Junior data analysts and employees moving into an analyst role
  • Reporting specialists in sales, marketing, finance and operations
  • Team leads who want to build a data-driven working culture
  • Prerequisite: intermediate Excel skills

Key Takeaways

  • Turn a vague business request into a clear analysis question and plan
  • Write consistent KPI and metric definitions
  • Apply funnel, cohort and segmentation analyses
  • Design a clean, decision-oriented dashboard
  • Present findings to managers using a storytelling approach

Curriculum

The Analyst's Role and the Analysis Plan
  • Clarifying the business question and forming hypotheses
  • Identifying data sources and constraints
KPI and Metric Design
  • Leading and lagging indicators
  • Metric definition document
Data Preparation and Analysis Techniques
  • Querying and cleaning data with SQL and Excel/Python
  • Funnel, cohort and segmentation analysis
Dashboard Design
  • Page layout and visual selection in Power BI/Tableau
  • Filters, drill-down and performance
Data Storytelling
  • From finding to recommendation: narrative structure
  • Executive presentation and insight report

Other Courses in This Category

  • SQL Fundamentals for Data Analysis

    Querying and aggregating relational databases with SELECT, WHERE, JOIN, GROUP BY, HAVING and subqueries: hands-on SQL training for business analysts and specialists who want self-service access to raw data.

    Data Science & AI-Ready Data Engineering Corporate
    Live Course
    5 modules
    View
  • Advanced SQL for Analytics and Query Optimization

    Window functions, recursive CTEs, cohort and time-series queries, semi-structured (JSON) processing and query tuning with EXPLAIN ANALYZE, for analysts and engineers working on large datasets.

    Data Science & AI-Ready Data Engineering Corporate
    Live Course
    5 modules
    View
  • AI-Ready Data Engineering

    End-to-end data engineering for RAG, LLM and machine learning systems: data contracts, medallion architecture, feature and embedding pipelines, lineage and metadata management.

    Data Science & AI-Ready Data Engineering Corporate
    Live Course
    5 modules
    View
  • Data Quality Testing and Data Contracts

    Automated data quality testing (dbt, Great Expectations, Soda) and enforceable producer-consumer data contracts to stop silent schema changes and corrupted data from breaking downstream analytics and AI.

    Data Science & AI-Ready Data Engineering Corporate
    Live Course
    5 modules
    View
  • Data Lineage, Catalogs and Data Observability

    Discovering data assets, tracking column-level lineage and catching pipeline delays or distribution drift early using OpenLineage, DataHub/OpenMetadata and data observability practices.

    Data Science & AI-Ready Data Engineering Corporate
    Live Course
    5 modules
    View
  • Unstructured Data Pipelines for Documents, Audio and Images

    Scalable data pipelines that turn PDFs, Office files, scanned documents, call-centre audio and images into parsed, chunked, metadata-enriched and indexed assets for RAG and multimodal AI.

    Data Science & AI-Ready Data Engineering Corporate
    Live Course
    5 modules
    View

Get in touch