Course Code:
powbi1
Duration:
7 hours
Prerequisites:
Audience that will most benefit from this training:
- Business Analysts: Those who need to analyze and visualize data to make informed business decisions.
- Data Analysts: Professionals working with data, who want to create interactive reports and dashboards.
- Managers/ Team Leads: Individuals responsible for monitoring key performance indicators (KPIs) and tracking business metrics.
- Anyone interested in data visualization and analytics.
By the end of this training, participants will be able to have:
- Understanding of Power BI architecture, data sources, and transformations.
- Proficiency in creating relationships between tables and using DAX functions.
- Ability to design effective visualizations and dashboards.
- Familiarity with teamwork/report sharing features
Overview:
Power BI is a powerful business analytics tool that enables users to visualize data and share insights across an organization or embed them in an app or website.
This instructor-led, live online training is aimed at business analysts, data analysts, managers and team leads who wish to design a perfect visualization and interactive dashboards and reports.
Format of the Course
- Interactive lecture and discussion.
- Exercises and practice.
- Hands-on implementation in a live-lab environment.
Course Customization Options
To request a customized training for this course, please contact us to arrange.
Course Outline:
Power BI Architecture
Data sources
- On-premises and online data sources
- Data transformations + M language
Modeling
Relationship between tables (single and multidirectional data filtering)
- DAX - Understanding the syntax and best practices
- Introduction to DAX
- Most commonly used functions and context of calculations
- Working with the time dimension (including fiscal periods, comparing periods, YTD)
- Filter functions
Visualizations
- Interactive data analysis
- Select the appropriate visualization
- Filters, grouping, exclusions
- Visualization on maps
Teamwork with Power BI
- Dashboards and Reports
- Q & A
Sites Published: