Data & Business Intelligence · Transights certificate
DAD
Data Analysis Diploma (DAD)
Why data analysis matters
Most organisations already hold the data they need, spread across spreadsheets, systems and online tools. When people can frame a business question, clean and model that data, and present the answer in a report decision-makers understand, discussions move from opinion to evidence.
Without these skills, analysis stays locked in a few people's files, figures differ between departments, and charts confuse more than they explain. This programme builds a foundation in analytical thinking and statistics, then hands-on skills in Excel, Power BI, Tableau and Looker Studio, leading to a Transights certificate of completion.
What you will be able to do
- Frame business questions as clear, measurable analysis problems and summarise data with descriptive statistics
- Clean and prepare raw data sets and calculate business metrics with Excel formulas, functions and pivot tables
- Connect Power BI to data sources, shape data with Power Query and build a simple data model
- Select suitable chart types and combine visuals into interactive dashboards in Tableau
- Build, share and maintain web-based reports in Looker Studio
- Present insights clearly to non-technical stakeholders to support business decisions
Course outline: 5 modules
Each module below shows what it covers and what you will be able to do at the end of it.
1. Theoretical Background and Analytical Thinking
Covers data architecture, core statistics and structured analytical thinking as the foundation for business data analysis.
- Explain how data is structured, stored and organised for analysis
- Apply basic descriptive statistics to summarise business data
- Frame business questions as clear, measurable analysis problems
- Describe key principles of data quality and governance
2. Data Analysis with Excel
Uses Excel to clean, organise, summarise and analyse business data with formulas, functions and pivot tables.
- Clean and prepare raw data sets for analysis in Excel
- Use formulas and functions to calculate business metrics
- Summarise data with pivot tables and charts
- Interpret results to support practical business decisions
3. Data Analysis with Power BI
Introduces Power BI for connecting, transforming and modelling data and building interactive reports for decision-makers.
- Connect Power BI to common data sources
- Transform and shape data using Power Query
- Build a simple data model with relationships between tables
- Create interactive reports and visuals for business users
4. Data Visualisation with Tableau
Covers building clear charts and dashboards in Tableau to explore data and communicate findings.
- Connect Tableau to data and prepare it for visual analysis
- Select suitable chart types for different business questions
- Combine visuals into an interactive dashboard
- Present insights clearly to non-technical stakeholders
5. Data Visualisation with Looker Studio
Uses Looker Studio to build shareable, web-based reports and dashboards from connected data sources.
- Connect Looker Studio to data sources
- Build reports with charts, tables and filters
- Share and maintain dashboards with team members
- Compare Looker Studio with other visualisation tools for business needs
Programme details
| Award | Transights certificate of completion for the Data Analysis Diploma. |
|---|---|
| Award criteria | Awarded on completing the programme; there is no external or vendor certification exam. |
| Duration | 48 training hours over 12 sessions of about 4 hours each. |
| Level | Intermediate. |
| Tools used | Microsoft Excel, Microsoft Power BI, Tableau and Looker Studio. |
| Prerequisites | Basic computer skills and familiarity with Microsoft Excel; no prior statistics or programming required. |
| Format | Practical, hands-on sessions working with business data sets in each tool. |
| Structure | Five modules: analytical thinking and statistics foundations, then Excel, Power BI, Tableau and Looker Studio. |
| Next step | Participants can deepen a single tool through Transights' Power Excel, Power BI or Tableau courses. |
Your path through DAD
- Enquire and choose your format. Classroom in Cairo, live online, or an in-house cohort for your team.
- Learn with practitioners. 48 hours over 12 sessions of about 4 hours each, every live session recorded on our learning platform.
- Practise in every tool. Hands-on sessions with business data sets in Excel, Power BI, Tableau and Looker Studio, after a foundation module in analytical thinking and statistics.
- Receive your Transights certificate. A Transights certificate of completion for the Data Analysis Diploma is awarded on completing the programme; there is no external or vendor certification exam.
- Go deeper in one tool. Continue with Transights' Power Excel, Power BI or Tableau courses.
What you walk away with
- An analysis method you can apply the next working day: frame the question, clean the data, summarise it and present the answer
- Working skills in four tools: Excel, Power BI, Tableau and Looker Studio
- A Transights certificate of completion for the Data Analysis Diploma
- Recordings of every live session and the official course files on our learning platform
- A clear next step into a single-tool course in Power Excel, Power BI or Tableau
Want the full picture?
The DAD brochure has the complete module outline, exam facts and delivery options in one PDF.
Download the DAD 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
- Market research, finance and marketing professionals
- Professionals making data-based decisions
- College students
Frequently asked questions
What is the DAD course?
Builds a foundation in data architecture, statistics and analysis, then moves on to data wrangling, governance and visualisation. Participants learn to use Excel, Power BI, Tableau and Looker Studio to support business decisions.
Who should take DAD?
It suits: Market research, finance and marketing professionals; Professionals making data-based decisions; College students.
How long is the DAD course at Transights?
48 hours, 12 sessions. 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.