This Power BI (Level 2) course is designed for professional users of Power BI who want to learn how to make the most of the tools available in the Power BI stack, including the Power BI Cloud Portal.
We will learn the importance of building good models, we will learn how to use DAX and Power Query to shape additional information that can be found in external data sources.
You will also use the new Power BI cloud platform as a way to distribute/share your reports and dashboards and use extra features like building interactive dashboards, using Q&A and managing data refresh and alerts for your queries and sources.
At the end of the course we will introduce you to some hot topics like data flows, composite models, aggregation tables, Common Data Service for apps.
This training is aimed at those who want to design their own Power BI solutions.
This course has no certification.
We have several trainers for this course. One of these is Lazarus.
Lasaros Mavropoulos is a consultant, communicator and coach with over 25 years of experience in Business Intelligence, data management and technology-driven solutions.
He specializes in Business Intelligence, SQL Server and the entire Power BI ecosystem and has been working with these technologies since 1998 and involved with Power BI since its inception in 2014.
Modules
– Introduction to the Power BI platform
– Getting started with Power BI Desktop
– Designing reports and navigation in Power BI Desktop
– Mastering query functions
– Advanced data modeling topics
– Designing and deploying dashboards
– Integrating Power BI with Excel 2016 and Excel Online
– Understanding data free reading, gateways and DirectQuery mode
– Publishing content using App Workspaces
Outline-Power BI Intermediate
Introduction to the Power BI platform
– Understanding the Power BI platform
– Create a trial version of Office 365 Tenant for testing
– Create datasets, reports and dashboards
– Settings for reports and dashboards in Power BI.com
– Stay in sync with monthly updates
Getting started with Power BI Desktop
– Introduction to the Power BI Desktop settings
– Creating queries in Power BI Desktop
– Modeling data in Power BI Desktop
– Designing reports and navigation in Power BI Desktop
– Publishing Power BI Desktop projects
Mastering query functions
– Working with the Query Editor window
– Managing queries, data sources and credentials
– Deciding what to measure
– Merging operations
– Designing queries to generate a star schema
Advanced topics for data modeling
– Designing a data model
– Understanding relationships
– Understanding bidirectional filtering
– Creating calculated columns
– Creating measures
– Configuring geographic fields to a data model
– Creating dimensional hierarchies
– Data modeling best practices
Designing and distributing dashboards
– Designing Dashboards for Power BI
– Execute Natural Language Q&A.
– Sharing and Collaborating with Dashboards and Office 365 Users
– Managing Permissions and Security
– Configuring Subscriptions and Alerts
– Configuring for Mobile Devices
– Configuring Dashboard & Tile Settings
– Best Practices when Creating Dashboards
Integrate Power BI with Excel 2016 and Excel Online
– Understanding Excel integration with Power BI
– Connecting to files
– Importing and connecting to Excel workbooks
– Using the Power BI Publishing for Excel add-in
– Connecting from Excel to a Power BI dataset
– Creating an Excel survey using forms and Power BI
Publish content using App Workspaces
– Understanding Workspaces
– Content Distribution in Power BI
– App Workspaces
– Publishing Apps
– Introduction to Power BI Premium
Course Overview
2 days
Advanced
Can’t find a (suitable) date, but are interested in the course? Send in an expression of interest and we will do what we can to find a suitable opportunity.
Customized Courses
The course can be adapted from several perspectives:
In interaction with the course leader, we ensure that the course meets your needs.
Send an expression of interest for the training
Send an expression of interest for the training