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
NoneTrainers
Course architecture
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
- 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
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
- 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
- Publish a report
- Republish or replace a dataset
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
- Connecting to CSV files
- Combining CSV files
- Adding queries
- Formatting and combining data
- Merging queries
- Creating a pivot table
- 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
- To work with complex datasets that are based on multiple tables.
- Relationships
- Option configuration
- Cardinality
- Filtering
- Exploration mode
- Formatting
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
- How to share dashboards, reports, data and collaborate in Power BI
- Workspace and sharing
- Embedding reports in secure portals or public websites
- The Power BI service
- Quick Insights
- Machine learning
- Displaying information, setting up dashboards
- Querying the data
- Connect local data sources taking into account the number of users, type of connection and location.
- Importing
- Report creation
- Power View and Power Pivot
On iOS, Android or Windows, access, view, annotate and share your Power BI dashboards from your mobile device.
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 quotePrivate 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