Venue & Date
Place and date according to your availability.
About this workshop
- Create advanced data models and Power BI reports with BI and Power BI best practices
- Develop advanced DAX metrics and complex calculated columns
- Understand the Power BI ecosystem: Power BI Service, Power BI Mobile, etc.
- Monitor Power BI activity from the cloud (Power BI Service)
- Use and understand external Power BI tools
- Preparing for Power BI certification
What will you learn:
Day 1
- Business Intelligence: Overwiew
- Modern BI (real-time, AI, cloud)
- Power BI: pricing and architecture
- Power BI in Power Platform
- Workspaces and applications
- Power BI security (RLS and OLS)
- Power Query: advanced
- DAX measurements: advanced
- Power BI service: guided tour
Day 2
- Bookmarks: presentation & concept
- Incremental updating and hybrid tables
- DataSet vs DataFlow vs DataMart
- Themes in Power BI
- Creating bookmarks
- Charticulator
- Create and customize themes in Power BI
- Publish and share reports in the Power BI portal
Day 3
- Data governance
- External tools
- Performance analyzer
- Prepare for Microsoft certification (DA-100 / PL-300)
- Power BI administration portal
- Using metrics and monitoring activity
- Create a Power BI mobile application
The target audience of this course:
- BI Consultants
- Data Consultants
- Data Analyst
- Business Analyst
- Project Manager
Prerequisites:
- Basic knowledge of databases and MS Excel.
- Power BI Pro or Premium license.
- Training may be adjusted if Power BI Premium is already installed.
Evaluation:
- Certificate, diploma
- Participants will receive a certificate of attendance.