{"course":{"productid":21280,"modality":1,"active":true,"language":"en","title":"Power BI Desktop Training","productcode":"PBID","vendorcode":"FL","vendorname":"Fast Lane","fullproductcode":"FL-PBID","courseware":{"has_ekit":false,"has_printkit":true,"language":"de"},"url":"https:\/\/portal.flane.de\/course\/training-pbid","essentials":"<p>Basic knowledge of Windows and good Excel or Access skills are required<\/p>","audience":"<p>Advanced users in the field of Excel, Access data analysis<\/p>","contents":"<h5>Power BI - Data Sources<\/h5><ul>\n<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>\n<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>\n<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>\n<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>\n<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>\n<li>Combination of calculated tables, columns and measures<\/li><li>DAX code for query extension<\/li><\/ul><h5>Individual visualizations<\/h5><ul>\n<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>\n<li>Examples for DAX programming in data models<\/li><\/ul>","comments":"<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>","summary":"<p>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&#039;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.<\/p>","essentials_plain":"Basic knowledge of Windows and good Excel or Access skills are required","audience_plain":"Advanced users in the field of Excel, Access data analysis","contents_plain":"Power BI - Data Sources\n\n\n- Retrieval from external data sources\n- Import of CSV \/ text files\n- Importing Excel workbooks\n- Establish database connections\n- Connect to SQL Server\n- Access to multiple sources in parallel\nQuery Editor\n\n\n- Merge multiple queries\n- Select and name fields of a query\n- Create user-defined fields\n- Remove superfluous columns from the query\n- Show \/ hide tables in field lists\n- Deactivating the loading of tables\n- Add additional sorts\n- Enter your own data as a new table\n- Merge tables\n- Set up sorting according to additional table\n- Apply Sort by Feature to Existing Fields\n- Duplicate existing tables\n- Removing empty records\n- Grouping of data records\n- Create calculated columns\nStructure of a data model\n\nLink data sources\n\n\n- Add multiple tables simultaneously as a data source\n- Automatic Relationships from Power BI Desktop\n- Create and modify relationships between tables\nIntroduction of measures\n\n\n- Introduction to DAX (Data Analysis Expressions) Programming\n- Editing interactions via Format Ribbon\n- Add custom columns for formatting\/calculation\n- Configuration of combined diagrams\nIntroduction to calculated tables\n\n\n- DAX programming for own tables\n- Linking of calculated tables\n- Relationship types between calculated tables\n- Filtering problems in data models\nComplex query methods\n\n\n- Combination of calculated tables, columns and measures\n- DAX code for query extension\nIndividual visualizations\n\n\n- Selection of standard visualizations\n- Creation of own visualization types\n- Specific use cases for custom diagrams\n- High density dashboard views\nDAX in data models\n\n\n- Examples for DAX programming in data models","comments_plain":"This text was automatically translated. Please click here to read the original German version.","summary_plain":"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.","skill_level":"Intermediate","version":"1.0","duration":{"unit":"d","value":2,"formatted":"2 days"},"pricelist":{"List Price":{"SE":{"country":"SE","currency":"EUR","taxrate":25,"price":990},"IL":{"country":"IL","currency":"ILS","taxrate":17,"price":3440},"DE":{"country":"DE","currency":"EUR","taxrate":19,"price":1290},"AT":{"country":"AT","currency":"EUR","taxrate":20,"price":1290},"CH":{"country":"CH","currency":"CHF","taxrate":8.1,"price":1680}}},"lastchanged":"2026-02-04T12:37:32+01:00","parenturl":"https:\/\/portal.flane.de\/ibb\/en\/json-courses","nexturl_course_schedule":"https:\/\/portal.flane.de\/ibb\/en\/json-course-schedule\/21280","source_lang":"en","source":"https:\/\/portal.flane.de\/ibb\/en\/json-course\/training-pbid"}}