Duration
Microsoft Power BI Desktop Fundamental
3 days
Overview
Overview Getting Started with Power BI Desktop (From Basic to In-depth Understanding) Workshop Overview Discover how to quickly glean insights from your data using Power BI. This formidable set of business analytics tools—which includes the Power BI service, Power BI Desktop, and Power BI Mobile—can help you more effectively create and share impactful visualizations with others in your organization. In this course, we help you get started with this powerful toolset. It begins by covering the web-based Power BI service, explaining how to import data, create visualizations, and arrange those visualizations into reports. We will also discuss how to pin visualizations to dashboards for sharing, as well as how to ask questions about your data with Power BI Q&A. This course will also show you how to use the data modelling capabilities in Power BI Desktop.
By the end of the course, participants will:
- Clean and transform data, model it and build KPIs and metrics that answer specific business questions.
- Use DAX effectively to build time intelligence reports, slice reports by measures and filter according to context
- Access data from supported on-premises and cloud-based sources with automated, incremental refreshes
- Combining multiple data sources into one dataset
- Perform forecasting
- Apply security rules and share content
- Create stunning reports with interactive data visualisations
- Perform analytics and find patterns with Power BI features like quick measures, grouping, forecasting, and clustering.
Prerequisites
No prior knowledge of programming or data analysis is required. Basic Excel knowledge is required.
Who should attend
This workshop is crucial for analysts, managers, reporting professionals, business owners, executives, and anyone who need to derive and share insights with business data. This training is highly recommended for
- Directors
- HR Managers and Executives
- General Managers
- Finance Managers
- Business Analysts
- BI Professionals
- Sales Managers
- HR Managers
- Data Analytics Manager
- Business Owners
- Anyone who deals with business, management, and financial reporting
Course Outline
Introduction to Power BI Desktop
- Installing Power BI
- Exploring the Power BI Workflow
- Comparing Power BI with Excel
- Introduction on Power BI Components
Connecting and Shaping Data
- Connecting to Source Data
- Shaping and Transform Data
- In-depth Understanding on Editing Tables
- Merging and Appending Queries Quiz
Understanding Data Model
- Data Type in Power BI Desktop
- Building Relationship Models
- Creating Table Relationships
- Understanding Cardinality
- Exploring Filter Flow
- Quiz
Adding Calculated Fields with DAX
- Understanding DAX Syntax
- Adding Calculated Columns and Measures
- Writing Common Formulas and Functions
- Quiz
Creating Interactive Visualization Data with Reports
- Inserting Charts and Visuals
- Customizing Formats
- Editing Interactions
- Quiz
Wrapping Up
- Creating Visualization Report in Mobile View
- Publish and Share Power BI Desktop to Power BI Service
Programme scope, delivery arrangements and suitability are confirmed during enquiry.