Course Overview
With the Power BI Online Portal, Microsoft offers an almost unlimited number of analysis tools for evaluating complex data models. Any type of data source can be integrated and used in the portal. No matter whether these originate from the company's own enterprise resource planning systems or are even provided from Google Analytics data. Via the client software Power BI Desktop, Microsoft extends the possibilities even further and facilitates access to complex data models.
Who should attend
Advanced users in the field of Excel, Access data analysis
Prerequisites
Basic knowledge of Windows and good Excel or Access skills are required
Course Content
Power BI - Data Sources
- Retrieval from external data sources
- Import of CSV / text files
- Importing Excel workbooks
- Establish database connections
- Connect to SQL Server
- Access to multiple sources in parallel
Query Editor
- Merge multiple queries
- Select and name fields of a query
- Create user-defined fields
- Remove superfluous columns from the query
- Show / hide tables in field lists
- Deactivating the loading of tables
- Add additional sorts
- Enter your own data as a new table
- Merge tables
- Set up sorting according to additional table
- Apply Sort by Feature to Existing Fields
- Duplicate existing tables
- Removing empty records
- Grouping of data records
- Create calculated columns
Structure of a data model
Link data sources
- Add multiple tables simultaneously as a data source
- Automatic Relationships from Power BI Desktop
- Create and modify relationships between tables
Introduction of measures
- Introduction to DAX (Data Analysis Expressions) Programming
- Editing interactions via Format Ribbon
- Add custom columns for formatting/calculation
- Configuration of combined diagrams
Introduction to calculated tables
- DAX programming for own tables
- Linking of calculated tables
- Relationship types between calculated tables
- Filtering problems in data models
Complex query methods
- Combination of calculated tables, columns and measures
- DAX code for query extension
Individual visualizations
- Selection of standard visualizations
- Creation of own visualization types
- Specific use cases for custom diagrams
- High density dashboard views
DAX in data models
- Examples for DAX programming in data models
German
Germany
This text was automatically translated. Please click here to read the original German version.