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
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
Layout and formatting available in Power BI
- 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
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
CSV data sources and advanced transformation
- 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
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
Data modeling with Power BI
- To work with complex datasets that are based on multiple tables.
- Relationships
- Option configuration
- Cardinality
- Filtering
Optimization of visual elements
- 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
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 explore data with Power BI
- 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.
How to use Excel with Power BI
- 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.
If you have any questions about registration, cancellation, schedules, language of instruction, etc. you will find answers in our FAQ.