Углублённый курс по Power BI для аналитиков и BI разработчиков. Предполагается, что слушатели уже знакомы с Power BI Desktop/Service и имеют опыт работы с ним, понимают общую архитектуру.
Agenda
1. 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
2. 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
3. Using Custom Visualizations
4. Power BI Q&A
- How to use
- Model optimization for better result
5. Security
- Row Level Security in Power BI
- Dynamic Row Level Security
6. On Premise Gateway
- Import Data and DirectQuery
- Security Migrate PowerBI Model to SSAS Tabular
Speaker: Sergey Lunyakin
DWH/BI Consultant, ITMagination Inc
Responsible for designing and developing Data Warehouse and BI solutions using on-premises Microsoft products and Azure cloud. Sergei is into helping others with their problems regarding Microsoft SQL Server and all the related BI stack. Sharing his knowledge is one of his passions as well. He is a regular speaker at conferences and user groups, including 24Hours of PASS, SQLSaturday, and PASS local chapter meetings.
Sergei also runs Lviv SQL Server User Group in Ukraine and is an organizer of SQLSaturday Lviv. He also possesses the following titles:
Microsoft Certified Solutions Expert (MCSE) – Data Management and Analytics
Microsoft Certified Solutions Associate (MCSA) – Cloud Platform
Microsoft Certified Professional (MCP)
Microsoft Certified Technology Specialist (MCTS)