Este programa se imparte bajo demanda para su equipo, en directo en línea o en su empresa. Las sesiones y los materiales del curso están en inglés. Envíe el formulario de abajo y le contactaremos para organizarlo. Solicitar esta formación
InstructorAlaa Hady MBA, AI Engineer
Socio director, Advanced Management Solutions
From Analyst to Trusted Advisor
Individual track Business intelligence (BIPulse) Course materials in English
Key facts
| Key fact | |
|---|---|
| For | Analysts, report authors, BI developers and power users who build and use BI every day. |
| Duration | 8 weeks, then 30/60/90-day follow-up and a month-6 re-assessment |
| Modules | 9 |
| Time | About 3 hours a week |
| Format | Hands-on labs in Power BI or Tableau, on a sample dataset and then on your own reports |
| Language | English |
| Instructor | Alaa Abdulhady |
| Before the course | BIPulse assessment |
Overview
An eight-week, lab-based program for the people who build and use BI every day. It is personalised twice: by the participant's own skills self-check and by their organisation's BIPulse results, so each person practises the skills they lack that their organisation needs most. Every lab ends with a deliverable built on the participant's real reports, and the program ends with a portfolio piece a stakeholder actually uses.
What you will achieve
- Close your personal skill gaps in the order your organisation needs them, measured by your own self-check before and after.
- Build six practical deliverables on your real reports - not toy exercises - in Power BI or Tableau.
- Finish with a decision-ready dashboard and a one-page impact case you can show your manager.
Problems it solves in your organisation
| The problem | What the program delivers | Modules |
|---|---|---|
| Reports depend on manual exports refreshed by hand. | Governed connections with scheduled refresh and a documented source map. | P1 Modern Data Foundations for Analysts |
| Totals do not add up between pages and reports. | A star-schema model with measures defined once and reconciled to the source. | P2 Modelling and Data Quality |
| Sensitive data is shared more widely than it should be. | Row-level security, sensitivity labels and certified datasets as standard practice. | P3 Governance in Daily Work |
| Analysts cannot show what their work is worth. | An impact log and a one-page value case confirmed by the people who use the report. | P7 Showing the Value of Your Work |
Learning objectives
- Diagnose your own BI skill gaps against your organisation's BIPulse results and turn them into a learning plan.
- Connect, refresh and document data sources, and explain where your numbers come from and how fresh they are.
- Build a star-schema model with tested measures and basic data-quality checks.
- Publish content safely: certification, row-level security and privacy by design.
- Design dashboards around decisions and roles, including mobile views.
- Use AI assistants in BI productively and verify their answers; help others self-serve.
- Tell a clear data story with its uncertainty, and reconcile conflicting numbers.
- Estimate and communicate the business value of your work.
Who it is for
8-16 practitioners. They can come from one organisation or several; each works on their own report and self-check.
- Power user / report consumer turning builder: Uses dashboards daily and is starting to build their own; needs foundations and good habits.
- Business or data analyst: Prepares data and analysis for decisions; needs modelling, storytelling and value skills.
- Report author: Owns departmental reports; needs decision-first design, governance and self-service enablement.
- BI developer / analytics engineer: Owns models and platforms; uses the Scale paths for performance, governance and AI.
Not for: Executives and BI leaders who own sponsorship, funding and operating-model decisions - route them to the BIPulse Leadership Lab (Organizational Track).
Prerequisites
- Comfortable with Excel: filters, pivot tables, simple formulas.
- Access to Power BI Desktop or Tableau Desktop (a trial licence is enough) and to one real report or dataset the participant owns or uses.
- A BIPulse report for their organisation: the enterprise report, or their own Comprehensive individual report.
- The 10-minute skills self-check, completed before week 1.
How it runs
8 weeks, about 3 hours a week: one live lab (90 minutes, or 45 for sprint labs) plus about 90 minutes of applied work on the participant's own reports. Followed by 30/60/90-day impact checks and a self-check re-take at month 6.
| When | What | Detail |
|---|---|---|
| Week 0 | Pre-work | Skills self-check (10 min); read the BIPulse report; choose one real report to improve throughout the program. |
| Week 1 | Diagnostic (P0, 90 min) | Self-check meets report; personal learning plan. |
| Weeks 2-5 | Core labs 1-4 (90 min each) | The four highest-priority modules, in dependency order. |
| Week 6 | Sprint labs 5-6 (2 x 45 min) | Priorities 5 and 6, one session with a break. |
| Weeks 2-7 | Peer mentor role | The participant's strongest module: self-study of its Scale path and helping peers in labs. |
| Week 7 | Capstone build week | 60-minute office hours and peer review of portfolio drafts. |
| Week 8 | Capstone showcase (P8, 90 min) | Portfolio presentations to invited stakeholders. |
| Day 30 / 60 / 90 | Impact checks (30 min) | Impact log review: what changed for the people who use your work. |
| Month 6 | Self-check re-take | Same 12 items; compare with week 0. Organisation re-assesses with BIPulse where possible. |
Session formats:
- Core lab (90 min): The four highest-priority modules: concepts, hands-on lab on a sample dataset, then applying it to the participant's own report
- Sprint lab (45 min): Priorities 5 and 6: condensed concepts and the core lab steps; the deliverable is finished as homework
- Peer mentor (self-study) (self-paced): The participant's strongest module: they study its Scale path alone and help peers during the labs that touch it
- Plenary (90 min): Diagnostic kick-off (P0) and capstone showcase (P8)
Modules
P0: Your Diagnostic: Skills Meet Report
Practitioners usually learn whatever the next course offers. This program starts from two pieces of evidence instead: what you can do today (the self-check) and what your organisation lacks (the BIPulse report). Where both are low is where your learning pays off fastest.
You will:
- Read your organisation's BIPulse results and link them to your daily work.
- Interpret your self-check by pillar and spot your biggest gaps and strengths.
- Write a personal learning plan with one measurable goal per core module.
Activity: Self-check meets report: Turn the two diagnostics into personal priorities.
You produce: Personal Learning Plan: Your priorities for the eight weeks, with one measurable goal per core module.
P1: Modern Data Foundations for Analysts
Most report problems start before the first chart: copied extracts, manual refreshes, unknown data age and slow queries. An analyst who can connect, refresh and explain their data saves hours every week and earns trust in every meeting.
You will:
- Connect to governed sources instead of copies, and schedule a refresh.
- Document where each number comes from and how fresh it is.
- Diagnose and fix the most common causes of slow reports.
Activity: From export to connection: Replace a manual extract with a refreshable, documented connection and measure the speed gain.
You produce: Data Source and Refresh Map: Shows where every table in your report comes from, who owns it and how fresh it is.
P2: Modelling and Data Quality
A good model is what makes numbers consistent across every page and every report built on it. Flat tables and copy-pasted calculations produce totals that do not add up, and the analyst ends up defending numbers instead of explaining them.
You will:
- Turn a flat extract into a star schema with fact and dimension tables.
- Write measures once, name them clearly and test them against known totals.
- Add simple data-quality checks and document lineage.
Activity: Flat to star: Rebuild a flat sales extract as a star schema with tested measures.
You produce: Model Diagram and Measure Catalogue: A one-page picture of your model and a list of measures with definitions, so others can trust and reuse them.
P3: Governance in Daily Work
Governance is not only a policy for leaders; it is a set of habits for the people who publish content. One unprotected dataset can expose salaries or customer data, and one uncertified copy can spread a wrong number across the organisation.
You will:
- Apply row-level security and test it as a user would see it.
- Label, certify or promote content according to your organisation's rules.
- Apply privacy by design: minimise, aggregate and protect personal data.
Activity: Secure, label, certify: Make a shared sales dataset safe to publish.
You produce: Pre-Publication Governance Checklist: A short checklist applied before any report or dataset is shared.
P4: Designing Dashboards for Decisions
A dashboard succeeds when someone makes a better decision faster - not when it shows every available field. Decision-first design, role-specific views and a usable phone layout are what make reports part of how work gets done.
You will:
- Write a dashboard brief starting from the decision, the user and the action.
- Design layouts that answer the main question in five seconds.
- Build a role-specific view and a phone layout of the same content.
Activity: Clutter to clarity: Redesign a cluttered sample dashboard around one decision and one user.
You produce: Dashboard Design Brief: One page that fixes the decision, users and layout before building - and the yardstick for reviewing the result.
P5: Self-Service and AI Assistants, Done Safely
AI assistants can write measures, summarise pages and answer questions in plain language - and can be confidently wrong. Practitioners who prepare their models for AI, verify its answers and help colleagues self-serve multiply their impact without multiplying their workload.
You will:
- Prepare a model so AI assistants and self-service users get correct answers.
- Use AI assistants to speed up work and verify their output against trusted measures.
- Enable colleagues to self-serve on certified data.
Activity: Is the AI right?: Prepare a model for an AI assistant and measure its accuracy.
You produce: AI Answer Verification Log: Records what you asked the AI, what it answered, whether it was right and what you changed - evidence that AI use is safe.
P6: Data Storytelling and Resolving Conflicting Numbers
Analysis changes nothing until someone acts on it. A clear story with a recommendation and an honest statement of uncertainty gets decisions made; a calm, traceable explanation of why two numbers differ turns a meeting-stopping argument into a fix.
You will:
- Structure an insight as context, finding, implication and recommendation.
- Communicate uncertainty without undermining the message.
- Trace two conflicting numbers to their definitions and sources and explain the difference.
Activity: Two revenues, one story: Reconcile two conflicting figures and present a three-minute recommendation.
You produce: Insight Brief and Reconciliation Note: A one-page recommendation with its evidence and uncertainty, plus a traceable explanation of a number conflict.
P7: Showing the Value of Your Work
Analysts who can show the value of their work get resources, interesting projects and a seat in decisions. Those who cannot are seen as a cost. Simple, honest value estimates - hours saved, errors avoided, better decisions - are a career skill.
You will:
- Keep an impact log of how your work changes decisions and time spent.
- Estimate value honestly: baseline, change, attribution.
- Frame a future automation or agentic use case in business terms.
Activity: Value in 30 minutes: Build a credible value estimate for one report and frame one automation idea.
You produce: Impact Log and One-Page Value Case: Evidence of the value your work creates, in terms a sponsor and finance recognise.
P8: Capstone: Your Portfolio Piece
The capstone pulls the program together on one real report: connected, modelled, governed, designed for its decision and backed by a value case. Presenting it to its real users turns eight weeks of practice into visible capability.
You will:
- Present a decision-ready report built with the techniques from your core labs.
- Show its value with a one-page impact case.
- Commit to a 90-day plan for applying and teaching what you learned.
Activity: Portfolio showcase: Present the portfolio piece and receive structured feedback.
You produce: Capstone Portfolio: Your improved report plus a one-page impact case, presented to its users.
What participants produce
A personal learning plan, six lab deliverables built on the participant's own reports, and a capstone portfolio: a decision-ready dashboard with a one-page impact case.
How results are measured
| Level | Measure | When |
|---|---|---|
| Kirkpatrick 1 - Reaction | Lab relevance and confidence ratings (target: 4.2 / 5 or higher). | End of every lab |
| Kirkpatrick 2 - Learning | Retrieval checks (target: 80% correct); lab deliverables rated 'usable' or better on every rubric criterion. | Weeks 2-8 |
| Kirkpatrick 3 - Behaviour | Portfolio dashboard in use by its stakeholders; impact log kept; at least two techniques applied to other reports. | Day 30 / 60 / 90 |
| Kirkpatrick 4 - Results | Self-check re-take: +1.0 on the items of the four core modules. For the organisation: movement on the related BIPulse capabilities; hours saved and time-to-insight on the participant's reports. | Month 6 |
| Phillips 5 - ROI (optional) | Monetised hours saved and decision gains from the impact logs against program cost, isolated with expert estimates. | Month 12, cohorts of 10 or more |
Instructor
Alaa Abdulhady, Advanced Management Solutions (AMS). Instructor and facilitator for all four programs.
take the BIPulse assessment, then enquire about a cohort with Alaa Abdulhady.
Take the BIPulse assessment · How these programs work · All four programs
Solicitar esta formación
Cuéntanos sobre tu equipo y te contactaremos para acordar las fechas, el idioma, la modalidad y el precio.