If you already have a basic understanding of Power BI, it's time to take your analytical skills to the next level. With this training you will be able to go deeper into data analysis, a key element of business intelligence, by combining sources, cleaning up data and visualizing it with reports and dashboards.
Duration
2 days
Schedule
9h to 16h
Regular fee
$995
Preferential fee
A preferential rate is offered to public institutions, to members of certain professional organizations as well as to companies that do a certain amount of business with Technologia. To know more, please read the "Registration and rates" section on our FAQ page. Please note that preferential rates are not available for online training courses. Discounts cannot be combined with other offers.
$895
Objectives of the training
Be able to exploit Power BI: use various data sources, work on large volumes of data, analyze data whose cleaning and structure will have been automated, build visual reports, share them.Targeted audience
Business analyst, data analyst, financial analyst, marketing analyst, manager, executive... Power BI's versatility allows it to serve many users. If you need to analyze data to derive key information, you are concerned.Prerequisite
Knowing the basic features of Power BI.Trainers
Associations and Partners Companies
Course architecture
Training eligible for grants from SCALE AI
With Microsoft Power BI (Business Intelligence) you can create actionable reports based on dynamic and interactive data. Whether it's for your own analysis or to share with other members of the organization and let them know what you find. The sharing function is fast, simple and secure.
Connecting to multiple data sources is the ideal approach to discovering key information, updating competitive advantages and, more globally, taking the pulse of the company and ensuring strategic intelligence. All of these elements promote or reinforce the competitiveness of your department or organization.
Retrieving, exploring and transforming data is no longer an issue.
You will see how to go even further with the DAX language, to better analyze your data with columns and custom calculated fields.
Power BI gives you the ability to do business intelligence, connecting to hundreds of data sources to create advanced relational models, with quick-to-learn tools. Even from scratch, you'll be able to build interactive and relevant dashboards.
Connecting to multiple data sources is the ideal approach to discovering key information, updating competitive advantages and, more globally, taking the pulse of the company and ensuring strategic intelligence. All of these elements promote or reinforce the competitiveness of your department or organization.
Retrieving, exploring and transforming data is no longer an issue.
You will see how to go even further with the DAX language, to better analyze your data with columns and custom calculated fields.
Power BI gives you the ability to do business intelligence, connecting to hundreds of data sources to create advanced relational models, with quick-to-learn tools. Even from scratch, you'll be able to build interactive and relevant dashboards.
Getting started with PowerBI
Get into the right habits and forget those taken with Excel or SQL.
- Components, workflows, building blocks...
- Get the data
- Report view
- Publishing to the Power BI service
- Pinning to a dashboard
How to connect Power BI to data sources
Most data sources are connectable to Power BI, so you might as well take advantage of it.
- Data Sources, File, Database, Power Platform, Azure, Online Services, Other
- Get data from CSV files, Excel workbooks
- Location - Local, OneDrive Enterprise, SharePoint Team Sites
Most data sources are connectable to Power BI, so you might as well take advantage of it.
- Data Sources, File, Database, Power Platform, Azure, Online Services, Other
- Get data from CSV files, Excel workbooks
- Location - Local, OneDrive Enterprise, SharePoint Team Sites
Visual elements in Power BI
Data is good, visualizing it is better to make it easier to interpret.
- Create and customize simple visualizations
- Resize and move
- Tooltips
- Format
- Types of visualizations
- Sorting
Data is good, visualizing it is better to make it easier to interpret.
- Create and customize simple visualizations
- Resize and move
- Tooltips
- Format
- Types of visualizations
- Sorting
Layout and formatting available in Power BI
Or how to take advantage of the customization options of your presentation.
- Shapes, text boxes and images
- Page layout and formatting
- Aggregation control
- Categorizing location data
Or how to take advantage of the customization options of your presentation.
- Shapes, text boxes and images
- Page layout and formatting
- Aggregation control
- Categorizing location data
How to publish datasets and reports with Power BI
- Publish a report
- Republish or replace a dataset
- Publish a report
- Republish or replace a dataset
How to transform and clean data, create a data model with Power BI
Avoid being overwhelmed by data and sources and think intelligently about your data model to avoid clutter.
- Power Query
- Explanation of the ribbons
- Advanced editor
Avoid being overwhelmed by data and sources and think intelligently about your data model to avoid clutter.
- Power Query
- Explanation of the ribbons
- Advanced editor
CSV data sources and advanced transformation
- Connecting to CSV files
- Combining CSV files
- Adding queries
- Connecting to CSV files
- Combining CSV files
- Adding queries
How to prepare data for Power BI
- Formatting and combining data
- Merging queries
- Creating a pivot table
- Formatting and combining data
- Merging queries
- Creating a pivot table
How to optimize Power BI visualizations
Take advantage of Power BI to build dashboards that put forward interesting, explicit perspectives based on concrete data.
- Charts, maps, combined charts
- Tables and matrices
- Segments
- Customization
- Interactions
Take advantage of Power BI to build dashboards that put forward interesting, explicit perspectives based on concrete data.
- Charts, maps, combined charts
- Tables and matrices
- Segments
- Customization
- Interactions
Data modeling with Power BI
To work with complex datasets that are based on multiple tables.
- Relationships
- Option configuration
- Cardinality
- Filtering
To work with complex datasets that are based on multiple tables.
- Relationships
- Option configuration
- Cardinality
- Filtering
Optimization of visual elements
- Exploration mode
- Formatting
- Exploration mode
- Formatting
DAX (intro) - the language of Power BI
Use the data analysis language in formulas or expressions tailored to your needs, without going through IT.
- Types of calculations
- Syntax of column and table names
- Calculated columns, measures and tables
- Functions and formulas
Use the data analysis language in formulas or expressions tailored to your needs, without going through IT.
- Types of calculations
- Syntax of column and table names
- Calculated columns, measures and tables
- Functions and formulas
Collaboration and distribution
- How to share dashboards, reports, data and collaborate in Power BI
- Workspace and sharing
- Embedding reports in secure portals or public websites
- How to share dashboards, reports, data and collaborate in Power BI
- Workspace and sharing
- Embedding reports in secure portals or public websites
How to explore data with Power BI
- The Power BI service
- Quick Insights
- Machine learning
- Displaying information, setting up dashboards
- Querying the data
- The Power BI service
- Quick Insights
- Machine learning
- Displaying information, setting up dashboards
- Querying the data
How to install and configure a gateway
Connect local data sources taking into account the number of users, type of connection and location.
Connect local data sources taking into account the number of users, type of connection and location.
How to use Excel with Power BI
- Importing
- Report creation
- Power View and Power Pivot
- Importing
- Report creation
- Power View and Power Pivot
Power BI Mobile
On iOS, Android or Windows, access, view, annotate and share your Power BI dashboards from your mobile device.
On iOS, Android or Windows, access, view, annotate and share your Power BI dashboards from your mobile device.
If you have any questions about registration, cancellation, schedules, language of instruction, etc. you will find answers in our FAQ.
Private or personalized training
If you have more than 8 people to sign up for a particular course, it can be delivered as a private session right at your offices. Contact us for more details.
Request a quoteDuration
2 days
Schedule
9h to 16h
Regular fee
$995
Preferential fee
A preferential rate is offered to public institutions, to members of certain professional organizations as well as to companies that do a certain amount of business with Technologia. To know more, please read the "Registration and rates" section on our FAQ page. Please note that preferential rates are not available for online training courses. Discounts cannot be combined with other offers.
$895
Private or personalized training
If you have more than 8 people to sign up for a particular course, it can be delivered as a private session right at your offices. Contact us for more details.
Request a quote