Data & Business Intelligence · Transights certificate
PBI
Data Analysis with Power BI (PBI)
Why data analysis with Power BI matters
Decisions move faster when everyone looks at the same numbers. A well-built Power BI model brings data from several sources into one place, applies the same definitions to every measure and publishes reports that refresh on a schedule, so managers can explore trends and drill into detail themselves.
Without it, reports are assembled by hand, figures differ from one department to the next, and dashboards are out of date soon after they are sent. This programme takes you through the full Power BI workflow, from raw data to a shared dashboard, in hands-on sessions and a final project, and leads to a Transights certificate of completion.
What you will be able to do
- Connect Power BI to files, databases and online sources and shape the data with Power Query
- Organise data into fact and dimension tables with relationships and a date table
- Write DAX measures using CALCULATE and simple time intelligence functions
- Design interactive reports with suitable visuals, slicers, filters and drill-through
- Publish to Power BI Service, pin visuals to dashboards and set up scheduled refresh
- Add trend lines, forecasts, AI visuals and what-if parameters to test business scenarios
Course outline: 8 modules
Each module below shows what it covers and what you will be able to do at the end of it.
1. Introduction to Power BI
Introduces the Power BI components, interface and typical workflow from data to shared report.
- Describe the roles of Power BI Desktop and Power BI Service
- Navigate the report, data and model views
- Outline the end-to-end Power BI workflow
2. Getting and Transforming Data
Covers connecting to data sources and cleaning and shaping data with Power Query before modelling.
- Connect Power BI to files, databases and online sources
- Clean and reshape data using Power Query transformations
- Combine data from several sources with merge and append
3. Data Modelling in Power BI
Covers designing efficient data models with relationships, star schema structure and date tables.
- Create and manage relationships between tables
- Organise data into fact and dimension tables
- Add a date table to support time-based analysis
4. Introduction to DAX
Introduces DAX for creating calculated columns and measures that answer common business questions.
- Distinguish calculated columns from measures
- Write basic measures for totals, averages and ratios
- Use CALCULATE and simple time intelligence functions
5. Visualisation and Dashboard Design
Covers choosing visuals and designing clear, interactive Power BI reports for business users.
- Select suitable visuals for different types of analysis
- Add slicers, filters and drill-through for interactivity
- Apply layout and formatting principles for readable reports
6. Publishing and Sharing in Power BI Service
Covers publishing reports to Power BI Service, building dashboards and sharing content with colleagues.
- Publish reports from Power BI Desktop to workspaces
- Pin visuals to dashboards in Power BI Service
- Share content and set up scheduled data refresh
7. Advanced Analytics in Power BI
Covers Power BI's built-in analytical features for exploring trends, drivers and what-if scenarios.
- Add trend lines and forecasts to time-series visuals
- Use AI visuals such as key influencers and decomposition tree
- Build what-if parameters to test business scenarios
8. Project: Building a Business Dashboard
Applies the full Power BI workflow in a practical project, from raw data to a shared business dashboard.
- Prepare and model a business data set end to end
- Design a dashboard that tracks agreed business KPIs
- Present findings and recommendations from the dashboard
Programme details
| Award | Transights certificate of completion for Data Analysis with Power BI. |
|---|---|
| Award criteria | Awarded on completing the programme; there is no external or vendor certification exam. |
| Duration | 24 training hours over 4 weeks. |
| Level | Intermediate. |
| Tools used | Microsoft Power BI Desktop and Power BI Service, with Power Query and DAX. |
| Prerequisites | Comfort with basic Excel and working with tabular data; no prior Power BI experience needed. |
| Format | Practical, hands-on sessions: connecting, transforming, modelling and visualising data, then publishing and sharing reports. |
| Final project | The course closes with a project in which participants build a business dashboard. |
| Next step | Participants wanting a multi-tool qualification can continue to Transights' Data Analysis Diploma. |
Your path through PBI
- Enquire and choose your format. Classroom in Cairo, live online, or an in-house cohort for your team. You should be comfortable with basic Excel and tabular data; no prior Power BI experience is needed.
- Learn the eight modules with an instructor. 24 hours over 4 weeks, every live session recorded on our learning platform.
- Practise the full workflow. Hands-on sessions on connecting, transforming, modelling and visualising data, then publishing and sharing reports.
- Build a business dashboard. The course closes with a project in which you prepare and model a data set, design a dashboard that tracks agreed KPIs and present your findings.
- Receive your certificate. A Transights certificate of completion for Data Analysis with Power BI, awarded on completing the programme. There is no external exam.
- Take the next step. For a multi-tool qualification, continue to Transights' Data Analysis Diploma.
What you walk away with
- A complete Power BI workflow you can apply the next working day, from connecting data to sharing a report
- Experience of building a business dashboard end to end in the final project
- A Transights certificate of completion for Data Analysis with Power BI
- Recordings of every live session and the course files on our learning platform
- A clear next step to the Data Analysis Diploma
Want the full picture?
The PBI brochure has the complete module outline, exam facts and delivery options in one PDF.
Download the PBI brochure (PDF) Enquire about the next cohort
How you will learn
- Classroom: Interactive sessions at our training and exam centre in Nasr City, Cairo, Egypt.
- Live online: Instructor-led virtual classes for participants anywhere in the region.
- In-house: A private cohort for your team, at your premises and tailored to your context.
- Every live session recorded: Watch any session again, or catch up on one you missed, on our learning platform.
- Official study material: Books, handbooks and course files for the programme, in one place.
Exam and certification
Transights
| Exams | No external exam |
|---|---|
| Certificate | Transights certificate of completion |
| Where you sit it | Awarded on completing the programme |
Who should attend
- Business professionals and decision-makers
- Data analysts and Excel users
- Dashboard designers
Frequently asked questions
What is the PBI course?
Introduces Microsoft Power BI for business data analysis and visualisation. Participants learn to connect, transform, model and visualise data, and to build and share interactive dashboards.
Who should take PBI?
It suits: Business professionals and decision-makers; Data analysts and Excel users; Dashboard designers.
How long is the PBI course at Transights?
24 hours, 4 weeks. It runs live online, in class in Cairo, or in-house for company teams in Egypt and the GCC.
Is there an exam?
There is no external exam. Participants receive a Transights certificate of completion.