Course Code:
powerbi
Duration:
14 hours
Prerequisites:
- An understanding of basic data concepts
- Experience with Excel or similar data tools
- Familiarity with general business or operational analysis
Audience
- Business analysts
- Data professionals
- Anyone interested in leveraging data visualization tools for insights
Overview:
Power BI is a business analytics service by Microsoft that enables users to visualize data, share insights, and create interactive reports and dashboards.
This instructor-led, live training (online or onsite) is aimed at beginner-level to intermediate-level data professionals and business analysts who wish to effectively use Power BI for data analysis and visualization.
By the end of this training, participants will be able to:
- Understand Power BI's architecture and its core components.
- Connect to various data sources and perform data transformations.
- Create effective visualizations and interactive dashboards.
- Implement row-level security and manage data access.
Format of the Course
- Interactive lecture and discussion.
- Lots of 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:
Introduction
Power BI Architecture
Data sources
- On-premises and online data sources
- Data transformations + M language
- Direct connections to selected sources (SQL Server, OLAP)
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)
- Functions for naturalizing a parent-child hierarchy
- Filter functions
- DAX templates
Visualizations
- Interactive data analysis
- Select the appropriate visualization
- Filters, grouping, exclusions
- Visualization on maps
- Visualization enhancements (so-called custom visuals)
Data Access Management - Row-Level Security
Team work and mobile with Power BI
- Dashboards and reports
- Q & A mechanism
- Workspaces Mobile applications
Summary and Next Steps
Sites Published: