POWER BI Training
Whether you are a web developer, application developer, architect, business analyst, consultant, auditor, management controller, research analyst or simply interested in business intelligence, this course gives you the skills you need to analyze your data independently with Microsoft Power BI.
Skills expected in a professional settingfrom the Power BI training
- Connect to multiple, heterogeneous data sources.
- Transform and model data to make analysis easier.
- Build a visual, interactive dashboard.
- Publish and share dashboards
Power BI training program
1. Introduction to Power BI
- Overview of Power BI tools: Power BI Desktop, the Power BI service and Power BI Mobile.
- Overview of the Power Query editor.
2. Getting data
- Extract, transform and load data into Power BI.
- Use flat files, Excel, relational databases, various sources, Web….
- Choose columns, choose rows, filter, sort and remove duplicates
- Practical examples : Create connections to import data from various sources
3. Transforming data
-
Launch the query editor
- Apply the transformations available in the editor
- Clean and complete datasets.
- Choose which rows and columns to keep, remove duplicates
- Split columns, format them and set data types, append and merge tables.
- Create calculated columns. Append and merge queries.
- Add a custom column from examples
4. Data modeling
-
Use Diagram view to define relationships between tables.
- Define relationships between tables: one-to-many, one-to-one, active or inactive
- Add a date table
- Create a hierarchy, use the date hierarchy.
- Practical examples : Relationships between tables; creating a date table
5. Using DAX in Power BI Desktop
-
Master the overall syntax of DAX formulas
- Choose between a calculated column and a measure
- Understand the difference between implicit and explicit measures
- Master the essential functions: DISTINCTCOUNT, COUNTROWS, RELATED, CALENDAR, CALENDARAUTO, FORMAT, USERELATIONSHIP, ALL, ALLEXCEPT, FILTER, RANKX, CALCULATE…….
- Practical examples : Working with calculation formulas using DAX functions
6. Designing and building Power BI reports
-
Create and configure visuals: tables and matrices, simple charts, maps, slicers, drop-down lists, timelines
- Use basic and advanced filters at visual, page and report level
- Insert an image, a text box
- Display interactions
- Building Power BI reports
- Practical examples : Lay out a report. Format data. Design a visual, interactive dashboard.
7. Publishing and sharing from Power BI Desktop
-
Publish reports from Power BI Desktop to the Power BI service
- Print and export dashboards
- Publishing and refreshing data.
Expected outcomes of the POWER BI training:
✓ Be able tore capabledeprepare data for analysis, de model data and visualize it in Power BI in order to analyze it.
Teaching methods for the POWER BI training
Training is available in person or online
- A mix of theory and practical exercises, case studies,
- End-of-course questionnaire to assess the knowledge acquired
- First, the trainer explains the essential principles. Then application exercises and case studies illustrate the presentations and help participants absorb the knowledge.
- Finally, the trainer ends the course with test exercises. Practical exercises are designed to take into account the specifics of each participant's professional activity.
Audience:
Management controllers, BI project managers, data scientists, analysts, consultants, anyone who needs to analyze multiple, heterogeneous data.
Organization
-
Duration: 3 days
