PBIDFLFast LaneFL-PBID1.0<p>Basic knowledge of Windows and good Excel or Access skills are required</p><p>Advanced users in the field of Excel, Access data analysis</p><h5>Power BI - Data Sources</h5><ul> <li>Retrieval from external data sources</li><li>Import of CSV / text files</li><li>Importing Excel workbooks</li><li>Establish database connections</li><li>Connect to SQL Server</li><li>Access to multiple sources in parallel</li></ul><h5>Query Editor</h5><ul> <li>Merge multiple queries</li><li>Select and name fields of a query</li><li>Create user-defined fields</li><li>Remove superfluous columns from the query</li><li>Show / hide tables in field lists</li><li>Deactivating the loading of tables</li><li>Add additional sorts</li><li>Enter your own data as a new table</li><li>Merge tables</li><li>Set up sorting according to additional table</li><li>Apply Sort by Feature to Existing Fields</li><li>Duplicate existing tables</li><li>Removing empty records</li><li>Grouping of data records</li><li>Create calculated columns</li></ul><h5>Structure of a data model</h5><h5>Link data sources</h5><ul> <li>Add multiple tables simultaneously as a data source</li><li>Automatic Relationships from Power BI Desktop</li><li>Create and modify relationships between tables</li></ul><h5>Introduction of measures</h5><ul> <li>Introduction to DAX (Data Analysis Expressions) Programming</li><li>Editing interactions via Format Ribbon</li><li>Add custom columns for formatting/calculation</li><li>Configuration of combined diagrams</li></ul><h5>Introduction to calculated tables</h5><ul> <li>DAX programming for own tables</li><li>Linking of calculated tables</li><li>Relationship types between calculated tables</li><li>Filtering problems in data models</li></ul><h5>Complex query methods</h5><ul> <li>Combination of calculated tables, columns and measures</li><li>DAX code for query extension</li></ul><h5>Individual visualizations</h5><ul> <li>Selection of standard visualizations</li><li>Creation of own visualization types</li><li>Specific use cases for custom diagrams</li><li>High density dashboard views</li></ul><h5>DAX in data models</h5><ul> <li>Examples for DAX programming in data models</li></ul><p>This text was automatically translated. Please click <span class="cms-link-marked"><a class="fl-href-prod" href="/ibb/de/course/training-pbid"><svg role="img" aria-hidden="true" focusable="false" data-nosnippet class="cms-linkmark"><use xlink:href="/css/img/icnset-linkmarks.svg#linkmark"></use></svg>here</a></span> to read the original German version.</p>Basic knowledge of Windows and good Excel or Access skills are requiredAdvanced users in the field of Excel, Access data analysisPower 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 modelsThis text was automatically translated. Please click here to read the original German version.2 days990.003440.001290.001290.001680.00