IT and data
Power BI: from data to dashboards in the Central African Republic
Interactive reports that genuinely support decisions
Three days to import and transform data with Power Query, build a reliable model, write your first DAX measures and publish clear, interactive dashboards.
- Duration
- 3 days · 21 hours
- Level
- Intermediate
- Format
- In-company · Virtual classroom
Upcoming sessions
This course is run on demand: in a virtual classroom or at your premises, on dates that suit you. Ask us for the next dates or a quote for your team.
Also available
- In-company, at your premises: Central African Republic, France
- In a virtual classroom: Central African Republic, France
This course in the Central African Republic
Onarcle offers the course "Power BI: from data to dashboards" in the Central African Republic, at your premises for a group (in-house), or in a live virtual classroom with the trainer. The programme, objectives and method are the same as in all our sessions: a practitioner trainer, exercises on real cases and an Onarcle certificate of completion.
The price in the Central African Republic is FCFA 915,000 excl. VAT per participant. For a group or a session at your premises, we provide a quote in local currency stating the applicable taxes and schedule.
In the Central African Republic, this course is designed for NGOs, international agencies, institutions, banks and companies, in Bangui and in the provinces. It can be attended in a live virtual classroom or delivered at your premises in Bangui for a group. Materials are provided as downloads, which helps when the connection is unreliable, and several partner organisations can join a shared session.
Overview
Power BI replaces hours of manual reporting with automatically refreshed dashboards. You build a complete report step by step: connecting to sources, cleaning, modelling, KPIs, visuals and sharing, while applying readability best practice.
Objectives
- Import and transform data with Power Query
- Build a star-schema data model
- Create measures with DAX
- Design readable, interactive visuals
- Publish, share and refresh reports
Who is it for?
- Management controllers, analysts, reporting managers
- Managers who track KPIs
- Advanced Excel users
Prerequisites
Good Excel skills (tables, common formulas, pivot tables).
Programme
Day 1
Preparing data
- Connecting to sources: Excel, CSV, databases, web
- Power Query: clean, merge, append
- Data preparation best practice
Day 2
Modelling and calculating
- Relationships and star schema
- Calculated columns and measures
- Essential DAX: CALCULATE, filters, time intelligence
Day 3
Visualising and sharing
- Choosing the right visual
- Filters, slicers and navigation
- Publishing, sharing and refreshing
Teaching method
Build a complete dashboard, on your own data if you wish. Groups of up to 10 participants, in a virtual classroom or at your premises, with a practitioner trainer. For 30 days after the course, you can email your questions to the trainer.
What you receive
- Power BI file of the running case
- DAX cheat sheet
- Dashboard design guide
Assessment and certificate
Initial assessment, hands-on exercises and a final quiz. Certificate of attendance; Onarcle certificate of achievement from a 70% score on the final quiz.
Price and funding
Public course price per participant, materials included. In-company (up to 10 participants, programme tailored to your needs): €4,190 excl. VAT per group. 10% discount from 3 participants from the same organisation. If your employer or a funding body will pay, contact us and we will find the right arrangement.
Frequently asked questions
How much does this course cost in the Central African Republic?
The price is FCFA 915,000 excl. VAT per participant in the Central African Republic. For a group, a session at your premises or a funding application, contact us and we will send you a quote in local currency.
Can I take this course from Bangui?
Yes. From Bangui, the course is available at your premises for a group (in-house), or in a live virtual classroom with the trainer. Materials are provided as downloads.
Can this course be organised for our team in the Central African Republic?
Yes. For a group, we adapt examples and exercises to your sector and tools, and run the session at your premises or in a virtual classroom, depending on your constraints in the Central African Republic.
Enrolment and quotes
Book a place, request a quote or a session for your teams. We reply within 2 working days.
Software and brand names mentioned belong to their respective owners. Onarcle is an independent training provider, not affiliated with their publishers; this course does not award an official vendor certification.