fr
en
Designing interactive dashboards with Power BI
Your data is accumulating, but your teams need clear indicators to make decisions. Analysts, management controllers and business managers can turn dispersed sources into interactive, shareable Power BI dashboards. Become more independent in producing reliable analyses, highlighting variances and supporting business performance management.
- Duration
- 2 days 14 hours
- Code
- DATA009FR Code
Presentation
As data volumes grow rapidly, the ability to make data understandable is a strategic skill. This 2-day course introduces Microsoft Power BI, a leading business intelligence tool. It is designed to make you operationally effective, able to transform raw data into impactful decision-support dashboards.
The course covers the entire data value chain. First, learn to connect and clean your sources, including Excel, the web and databases, with Power Query. Then discover how to model this information and create precise indicators using DAX. Finally, apply your creativity to design interactive visualisations and share them through Power BI Service.
The approach is firmly practical: alternating theory and workshops, you will build a complete report step by step, simulating a real business case so you can apply your new skills immediately.
Objectives
By the end of this course, you will be able to:
- identify data visualisation principles for creating relevant reports;
- import, transform and clean data from multiple sources with Power Query;
- model data relationships and create calculated measures with DAX;
- design dynamic dashboards with filters and interactions;
- publish and share reports securely through Power BI Service.
Program
Day 1: importing, preparing and transforming data
- The Power BI ecosystem: distinguishing Desktop, Service and Mobile.
- Connecting to data sources: Excel and CSV files, and web sources.
- Cleaning and transforming with Power Query: merging, joining and creating columns.
Hands-on exercises
- Explore the interface, connect several heterogeneous sources and prepare a clean dataset for analysis.
Day 2: modelling, visualising and sharing reports
- Data modelling: managing relationships and an introduction to DAX formulas.
- Visual design: choosing visuals such as maps and line charts, filters and slicers.
- Distribution: publishing to Power BI Service and managing workspaces.
Hands-on exercises
- Create DAX measures, design a complete interactive dashboard and publish it online for sharing.
Audience
This course is intended for professionals seeking to get more value from their data, including:
- data analysts and management controllers who want to automate reporting and improve the reliability of financial or operational indicators;
- business managers and project managers who need visual dashboards to manage activities and support decision-making;
- anyone seeking to move from Excel to a professional business intelligence solution to work more efficiently.
Prerequisites
The following prerequisites apply:
- Environment: a good command of Windows is essential.
- Data: basic Excel knowledge or experience handling data is strongly recommended.
Teaching and assessment methods
- Initial skills assessment
- Training materials provided to participants
- Continuous assessment throughout the course
- End-of-course feedback questionnaire
- Combination of theory and practical application
- Attendance records
- Post-course follow-up evaluation
- Practical exercises
Course highlights
- Leading solution: train on the most widely used and in-demand BI tool on the market.
- Complete process: master the end-to-end workflow, from extracting raw data to the final visualisation.
- Introduction to DAX: discover the power of Power BI's formula language to create tailored indicators.
- Professional presentation: learn visual design best practices to make your data clear and visually appealing.
Dates and sessions
Choose the date and delivery format that suit you.
No upcoming sessions are currently available.
Any brand names and logos mentioned in this course description (such as Microsoft, Power BI, Excel and Windows) belong to their respective owners. Their mention for educational purposes does not imply any commitment or partnership.