This is an example of a simple banner

Training: Power BI – Build Your Reports and Visuals Independently

Ref. MPB-I1
Duration:
3
 jours
Exam:
Not certifying
Level:
Intermédiaire

Power BI - Build Your Reports and Visuals Independently

Learn to use Power BI independently

Are you looking to better understand and make use of your data? This course teaches you how to use Power BI in a simple, clear, and structured way. Over three days, you’ll learn how to import, transform, and model your data to build interactive reports. The goal is to make you fully autonomous in visual data analysis.

Through hands-on exercises, you’ll explore the tool’s key features, design best practices, and sharing options. You’ll be able to create visually impactful dashboards that are useful for your business. Each module includes real-world scenarios to strengthen your skills, whether in finance, HR, or business performance tracking.

A course designed for non-technical professionals

This training is ideal for business analysts, team leaders, or Excel users who want to build their skills. No prior Power BI experience is required. If you understand the basics of data and already use Excel, you’re fully equipped to take the course. You’ll leave with practical skills you can apply immediately to your reporting projects.

Participant Profiles

  • Business analysts
  • Data professionals
  • Project managers
  • Managers or team leads looking to improve reporting
  • Excel users wanting to transition to Power BI

Objectives

  • Understand the Power BI environment (Desktop, Service, Mobile)
  • Import and transform data using Power Query
  • Model data with relationships and basic formulas
  • Create clear and relevant visualizations
  • Build interactive reports with filters and slicers
  • Apply design principles and UX best practices
  • Publish and share reports via Power BI Service
  • Adapt analyses to real-world business scenarios

Prerequisites

  • Basic understanding of data structures
  • Proficiency with formulas and tables in Excel
  • No prior knowledge of Power BI required

Course Content

Module 1: Introduction to Power BI

  • Overview of Power BI (Desktop, Service, Mobile)
  • User interface: ribbon, panes, views
  • Navigation and shortcuts
  • Connecting to data sources

Module 2: Data import and transformation

  • Import from Excel, CSV, Web
  • Cleaning and transforming data with Power Query
  • Data types, removing duplicates, pivoting

Module 3: Basic data modeling

  • Relationships between tables
  • Managing dimension and fact tables
  • Introduction to basic DAX (columns and measures)

Module 4: Creating effective visualizations

  • Chart types and use cases
  • Maps, gauges, combined charts
  • Visual customization: colors, formats, dynamic titles

Module 5: Interactive reports

  • Slicers, filters, drill-down, drill-through
  • Report pages and navigation
  • Interactions between visuals

Module 6: Themes, formatting and design

  • Using themes
  • Visual hierarchies and readability
  • UX/UI best practices

Module 7: Sharing and collaboration

  • Publishing to Power BI Service
  • Setting access and roles
  • Exporting (PDF, Excel, web)
  • Viewing on mobile app

Module 8: Guided business scenarios

  • Real-world analysis cases (sales, HR, finance)
  • Adapting visuals to specific business needs
  • Applying previous modules to guided scenarios

Documentation

  • Digital course materials included

Complementary Courses

Eligible Funding

ITTA is a partner of a continuing education fund dedicated to temporary workers. This fund can subsidize your training, provided that you are subject to the “Service Provision” collective labor agreement (CCT) and meet certain conditions, including having worked at least 88 hours in the past 12 months.

Additional Information

Understanding the value behind your data

Data has become central to strategic business decisions. But to leverage it effectively, you need the right tools. Power BI provides a modern and intuitive environment to meet this need. This course takes you from simple Excel file manipulation to mastering interactive reporting and data visualization. You won’t just display numbers—you’ll tell a story through them.

One of Power BI’s strengths is its ability to connect to multiple sources: Excel files, databases, and online content. You’ll learn how to easily integrate them into your reports. With Power Query, you’ll clean, transform, and structure your data—all without writing code. This will save you valuable time in preparing your analyses.

Creating value with clear data modeling

Once your data is prepared, the next step is to organize it logically. This course guides you through linking tables, creating hierarchies, and adding key indicators using the DAX language. This step is essential to avoid misinterpretation. A well-designed model allows you to navigate data easily and offer clear insights to others.

You’ll learn how to build dashboards using relevant visuals: pivot charts, maps, gauges, and interactive filters. Every element should serve a purpose—highlighting trends, comparing results, or tracking performance. You’ll know how to select the right visual based on your audience’s needs.

Creating real impact with your presentations

A well-designed visualization makes all the difference. One key part of the course focuses on design best practices. You’ll learn how to simplify layouts, balance colors, and create visual hierarchy to draw attention. The goal is to tell a compelling, clear story with your data.

Power BI reports are not static—they’re interactive, thanks to filters, navigation buttons, and exploration options. You’ll build dynamic pages where each user can dive into the details that matter to them. This fosters autonomy and improves understanding across teams.

Sharing your reports efficiently

Creating a great dashboard is not enough—it also needs to be seen, understood, and used. That’s why this course teaches you how to publish your reports in Power BI Service. You’ll learn how to manage access rights, share securely, and allow mobile viewing. This ensures your analysis reaches the right people at the right time.

Finally, real-world case studies help you apply what you’ve learned. You’ll face practical scenarios like sales analysis, HR monitoring, or financial tracking. You’ll test different approaches, discuss analysis choices with other participants, and learn from their insights.

FAQ:

Is this course suitable for complete beginners in Power BI?
Yes, no prior experience is required. The course starts from the basics and gradually introduces advanced features.

Do I need technical IT skills?
No. A basic understanding of data and good Excel skills are enough to follow and understand the content.

Will I be able to apply what I learn immediately?
Yes. Each module includes hands-on exercises to help you practice new skills directly in your work environment.

Can I share my reports with my entire team?
Yes. You’ll learn how to publish your reports to Power BI Service and manage permissions to make them accessible to colleagues.

Prix de l'inscription
CHF 2'150.-
Inclus dans ce cours
  • Training delivered by a subject matter expert
  • Digital documentation and course materials
  • Completion badge awarded
Mois actuel

lun12Mai(Mai 12)09:00mer14(Mai 14)17:00VirtuelVirtual Etiquettes de sessionMPB-I1

lun12Mai(Mai 12)09:00mer14(Mai 14)17:00Genève, Route des Jeunes 35, 1227 Carouge Etiquettes de sessionMPB-I1

lun16Juin(Juin 16)09:00mer18(Juin 18)17:00VirtuelVirtual Etiquettes de sessionMPB-I1

lun16Juin(Juin 16)09:00mer18(Juin 18)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMPB-I1

lun21juil(juil 21)09:00mer23(juil 23)17:00VirtuelVirtual Etiquettes de sessionMPB-I1

lun21juil(juil 21)09:00mer23(juil 23)17:00Genève, Route des Jeunes 35, 1227 Carouge Etiquettes de sessionMPB-I1

lun25Aoû(Aoû 25)09:00mer27(Aoû 27)17:00VirtuelVirtual Etiquettes de sessionMPB-I1

lun25Aoû(Aoû 25)09:00mer27(Aoû 27)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMPB-I1

lun29Sepmer01OctVirtuelVirtual Etiquettes de sessionMPB-I1

lun29Sepmer01OctGenève, Route des Jeunes 35, 1227 Carouge Etiquettes de sessionMPB-I1

lun03Nov(Nov 3)09:00mer05(Nov 5)17:00VirtuelVirtual Etiquettes de sessionMPB-I1

lun03Nov(Nov 3)09:00mer05(Nov 5)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMPB-I1

lun08Déc(Déc 8)09:00mer10(Déc 10)17:00VirtuelVirtual Etiquettes de sessionMPB-I1

lun08Déc(Déc 8)09:00mer10(Déc 10)17:00Genève, Route des Jeunes 35, 1227 Carouge Etiquettes de sessionMPB-I1

Contact

ITTA
Route des jeunes 35
1227 Carouge, Suisse

Opening hours

Monday to Friday
8:30 AM to 6:00 PM
Tel. 058 307 73 00

Contact-us

ITTA
Route des jeunes 35
1227 Carouge, Suisse

Make a request

Contact

ITTA
Route des jeunes 35
1227 Carouge, Suisse

Opening hours

Monday to Friday, from 8:30 am to 06:00 pm.

Contact us

Your request