Skills in data analysis, reporting and the creation of dashboards are highly valued in today’s business environment. Microsoft Power BI is now recognized as the leading Business Intelligence tool in the world for the development of reports, data analysis and dashboards. SQL Master Academy team designed this class for experts who want to master their skills in the area of designing, implementing and optimizing BI solutions with Power BI.

• Data Analysts, BI professionals or data engineers, who need to work with different sources of data, analyse it, need to collaborate and share finding with key users, business or an entire organization

• Define and implement complex import and data cleansing scenarios using functions, M language and parameters
• Sharing reports and dashboards with colleagues, departments or whole organization
• Analyze and troubleshoot performance problems with their models
• Schedule data refresh, connecting their on-premise data with PowerBI Gateway
• Create complex models and visualizations, including dynamic slicers, implementing parameters and what-if analysis
• Implement Row-level security in PowerBI
• Configure and use R within PowerBI
• Designing on-premise or hybrid PowerBI infrastructure with PowerBI Report Server

Module 1. Advanced data import and preparation with PowerBI Desktop

Module 2. Taking Modelling to the next level with PowerBI Desktop

Module 3. Advanced visualization and report design with PowerBI Desktop

Module 4. End to end sharing and collaboration with PowerBI

Module 5. Security in PowerBI

Module 6. PowerBI performance troubleshooting and best practices

Module 7. Integrating PowerBI Service with Excel

Module 8. Advanced analytics with PowerBI and R

Module 9. PowerBI Report Server

Mastering PowerBI