Business Intelligence
Understand Business Intelligence as both a process and a decision-making culture. Participants learn transactional versus analytical systems, data warehouse architecture, analytics and data mining, visualisation, and the BI market, with applied practice.
At a glance
- 5 days
Who it's for
- Managers and analysts who use data for decisions
- Reporting, IT and BI staff
- Anyone interested in BI
Learning objectives
- Understand BI as a process and a decision- making culture
- Distinguish transactional vs analytical systems, OLAP vs operational reporting
- Understand BI architecture: sourcing, data warehouse, analytics, presentation
- Apply data mining and analytics techniques
- Design effective visuals and reports for decision makers
- Use modern self-service BI tools
Detailed content
- What BI is and why it matters
- BI evolution, trends & careers
- Business problems & BI solution characteristics
- BI vision
- Data – information – knowledge
- Transactional vs analytical systems
- BI users & information access strategies
- Key stages: sourcing, analysis, situation awareness, risk analysis, decision support
- Values, capabilities, components & architectures
- Data warehouse & cloud data platforms
- OLAP vs transaction reporting
- Business analytics techniques
- Data mining
- Levels of analytics: descriptive, diagnostic, predictive, prescriptive
- Data presentation & visual design best practice
- Reporting & delivery
- Self-service BI tools (Power BI, Tableau)
- BI products & market
- Applied practice workshop
Day-by-day agenda
A typical schedule. In-company versions are tailored to your processes, data and timing.
- BI Foundations
- BI Systems & Architecture
- Analytics
- Presentation & Visualization
- BI Market & Applied Practice
- Case study, action plans and course assessment
Practice, tools and assessment
Hands-on practice
- Aspects-and-impacts register for a real site
- Compliance-obligations review exercise
- Hands-on lab on your laptop with a real business data set
- Build a complete dashboard from raw data to one-page report
Tools and templates you keep
- Aspects/impacts significance matrix
- Legal register template
- Practice files and solution workbooks
- Formula, DAX and shortcut cheat sheets
How learning is assessed
- Pre- and post-course knowledge check
- Assessment of practical exercises by the trainer
- Action plan reviewed at the end of the course
Built on these standards and bodies of knowledge
- ISO 14001:2015
- Egyptian Environmental Law 4/1994 and executive regulations
- Microsoft PL-300 skills outline (Power BI)
How it is delivered
- Public courses in Cairo, in-company programs and live online training
- Practical exercises, case studies and examples from your sector
- Can also run as Train & Stay in Sharm El Sheikh, Hurghada or Cairo
Part of these career paths
- Data Analytics & Digital Tools · Expert
Frequently asked questions
How long is Business Intelligence?
The program runs 5 days. In-company versions can be adapted to your needs.
Is the course taught in Arabic or English?
Sessions are usually delivered in Arabic with English technical terms and materials. Full English delivery is available for in-company groups.
Can you run it inside our company?
Yes. In-company programs use exercises built on your own processes. Tell us the group size and preferred timing and we will send a proposal.
Will I receive a certificate?
Participants who complete the program and its assessment receive a certificate from The Excellence Center, which can be verified online.
More programs in this field
- Generative AI for ProfessionalsNew
- Advanced Analytics for Business Excellence5 days
- Advanced Excel4 days
- Data Analysis for Digital Marketing5 days
- Data Analysis Professional Program (Excel, Power BI, SQL & Python)10 days
- Data Analysis Using Excel4 days
- Data Analysis Using Excel & Power BI5–6 days
- Data Analysis Using Microsoft Power BI3 days
- Excel for Beginners3 days
Get dates, fees and the full outline.
Tell us whether you are joining as an individual or planning a program for your team.