Your training funded up to 50%

See available funding programs

Power BI - Data Analysis and Visualization for Super Users

Deepen your knowledge of Power BI to connect, transform and design data models to create analytical content within their organization.
Microsoft Partner

Upcoming sessions

Guaranteed to run

No date suits you?

Notify me when a session is added.

  • Duration: 2 days
  • Regular price: $1,000
  • Preferential price: $880

Course outline

Duration : 2 days

© AFI Expertise inc.

This training helps professionals already familiar with Power BI optimize and manipulate advanced formatting, publishing or calculating functions to produce interactive and informative visual dashboards.

Audience

This training is for professional data analysts and BI specialists who want to improve their knowledge of Power BI to connect different data sources, transform data, design data models, and create and publish analytical content within their organization.

Prerequisites

The concepts covered in the course Introduction to Power BI are prerequisites for this training.

Objectives

  • See how Power BI Desktop fits into the Microsoft Power BI suite of software services
  • Review and use Power BI features
  • Combine data from different sources
  • Transform data with Power Query
  • Design and use a data model
  • Use DAX language to complete data
  • Configure and arrange visuals to create attractive reports using best practices
  • Manage security with roles
  • Create and publish an advanced report

Teaching method

Theoretical presentations, demonstrations, and directed exercises.

Contents

Chapter 1: Introduction to Power BI Desktop

  • Explore Microsoft Power BI’s different features
  • Review licencing models offered
Chapter 2: Importing data into Power BI
  • Get data from files
  • Get data from NoSQL databases
  • Get data from Azure Analysis Services
  • Fix performance issues
  • Resolve data import errors
Chapter 3: Transforming and loading data
  • Shape the initial data
  • Simplify data structure
  • Evaluate and change column types
  • Combine multiple tables into a single table
  • Profile data in Power BI
  • Use Advanced Editor to modify M code
Chapter 4: Designing a data model
  • Work with tables
  • Create a date table
  • Work with dimensions
  • Define data granularity
  • Work with relationships and cardinality
Chapter 5: Adjusting the data model using DAX
  • Use advanced features of DAX
  • Create calculated columns
  • Create measures using DAX
  • Use the CALCULATE function to manipulate filters
  • Work with time functions
Chapter 6: Optimizing data model for performance
  • Review data model performance
  • Use variables to improve performance
  • Reduce cardinality
  • Optimize DirectQuery models with storage
  • Create and manage aggregations
Chapter 7: Working with advanced visualizations
  • Import custom visuals
  • Add an R or Python visual
  • Work with key performance indicators
Chapter 8: Telling a story with your data
  • Design a report layout
  • Add buttons, bookmarks and selections
  • Design report navigation
  • Use basic interactions
  • Use advanced interactions and drillthrough
  • Configure conditional formatting
  • Apply slicing, filtering and sorting
  • Publish and export reports
  • Manage comments on reports
  • Tune report performance
  • Optimize reports for mobile use
Chapter 9: Creating interactive dashboards
  • Configure a real-time dashboard
  • Configure data classification
  • Set mobile view
Chapter 10: Creating paginated reports
  • Get data
  • Create a paginated report
  • Work with charts and tables on the report
  • Publish the report
Chapter 11: Performing analytics in Power BI
  • Explore statistical summary
  • Identify bias and outliers
  • Group data for analysis
  • Apply clustering techniques
  • Conduct time series analysis
  • Use the Analyze feature
  • Use advanced analytics custom visuals
  • Review Quick insights
  • Apply AI Insights
Chapter 12: Working with AI visuals
  • Use the Q&A visual
  • Find important factors with the key influencers visual
  • Use the Decomposition Tree visual to break down a measure
Chapter 13: Creating and managing workspaces in Power BI
  • Monitor usage and performance
  • Recommend a development life cycle strategy
  • Troubleshoot data by viewing its lineage
  • Configure data protection
Chapter 14: Managing datasets in Power BI
  • Create dynamic reports with parameters
  • Create what-if parameters
  • Use a gateway to connect to on-premises data sources
  • Configure a scheduled refresh for a dataset
  • Configure incremental refresh settings
  • Manage and promote datasets
  • Troubleshoot service connectivity
  • Boost performance with query caching (Premium)
Chapter 15: Implementing row-level security (RLS)
  • Configure RLS by using a static method
  • Configure RLS by using a dynamic method

Surround yourself with the best

Pierre-Edouard Brondel
Pierre-Edouard Brondel
Trainer and Desktop Application Consultant
Renowned as an educational expert in the IT and office technology field who has accumulated more than 25 years of experience, Pierre-Édouard is first and foremost passionate about human capital.
Marc Maisonneuve
Marc Maisonneuve
Trainer and Professional Efficiency Consultant
Frédéric Paradis
Frédéric Paradis
Certified Trainer and Cloud Architect
As a certified Microsoft trainer, Frédéric describes himself as a Cloud magician who easily navigates the mythical space between technology and reality.
Virginie Louis
Virginie Louis
Efficiency Trainer, Facilitator and Spatial Intelligence Consultant
Virginie sees herself first and foremost as a facilitator: she strays from the standard training to provide solutions that are adapted to her clients’ realities and objectives.
Be aware of trends, innovations and best practices, every month.
Confidentiality
Training center accredited by Emploi-Québec, Accreditation : 0051460
GST : 141582528 – QST : 1019557738
© 2021 AFI
AFI Expertise

The AFI experience brought to you by Edgenda

At AFI, our focus is to offer you relevant training and impactful learning experiences in line with your transformation approach. Do you need support for your approach? Check out Edgenda’s services: Edgenda.com