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 they come from the company's own ERP systems or are even provided from Google Analytics data. With the Power BI Desktop client software, Microsoft extends the possibilities even further and facilitates access to complex data models.
Who should attend
Advanced users in the area of Excel, Access data analysis
Prerequisites
Basic knowledge of Windows and good Excel or Access skills are required
Course Content
Power BI data sources • Retrieve from external data sources • Reading in CSV / text files • Read 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 unnecessary columns from the query • Show / hide tables in field lists • Disable loading of tables • Add additional sorts • Enter your own data as a new table • Merging the tables • Set up the sorting according to an additional table • Apply sort by feature to existing fields • Duplicate existing tables • Remove empty records • Grouping of records • Create calculated columns Structure of a data model Link data sources • Add multiple tables as a data source at the same time • Automatic relationships from Power BI Desktop • Create and change relationships between tables Introduction of measures • Introduction to DAX (Data Analysis Expressions) programming • Editing of interactions via format ribbon • Add custom columns for formatting / calculation • Configuration of combined diagrams Introduction to calculated tables • DAX programming for your own tables • Linking calculated tables • Relationship types between calculated tables • Filter problems in data models Complex query methods • Combination of calculated tables, columns and measures • DAX code for expanding queries Individual visualizations • Choice of standard visualizations • Creation of own visualization types • Specific use cases for custom diagrams • Highly compressed dashboard views DAX in data models • Examples of DAX programming in data models