SQL Saturday Iceland pre-con

Um viðburðinn

PowerBI for BI developer and analysts.

 This is an advanced course about PowerBI for BI developers and analytics. It covers topics about data importing, modeling, security, migration and optimization. Also, you will learn some helpful tips and tricks that may ease your everyday tasks.
Prerequisites
 - Participants must have some hands-on experience with PowerBI Desktop/Service and know components.
 - You need a laptop with a x64 operational system and at least 4 GB RAM for comfort work with labs. 
 - The latest version of the Power BI Desktop must be installed.
 - Power BI Service account will be provided you at pre-con.
Agenda
Advanced PowerQuery: Import Data and Transformations
 - Power Query Function’s Library
 - Use generators and EACH function for data importing
 - Writing Custom Functions
 - Performance - Cache and Query Folding
 - Error Handling in Power Query
Data Modeling and DAX
 - Data Modeling and Relationship, Best Practice
 - Power of Query Context and CALCULATION function 
 - Performance Analyse, Query Plan, Model/Code optimization, Debugging
Using Custom Visualizations
Power BI Q&A 
 - How to use
 - Model optimization for better result
Security
 - Row Level Security in Power BI
 - Dynamic Row Level Security
On Premise Gateway
 - Import Data and DirectQuery
 - Security
Migrate PowerBI Model to SSAS Tabula
Security
 - Row Level Security in Power BI
 - Dynamic Row Level Security
On Premise Gateway
 - Import Data and DirectQuery
 - Security
Migrate PowerBI Model to SSAS Tabular