Course Overview
TOPGain an essentials understanding of the features and benefits of Power BI for your data analysis actions.
Scheduled Classes
TOP06/03/24 - GVT - Virtual Classroom - Virtual Instructor-Led | |
08/12/24 - GVT - Virtual Classroom - Virtual Instructor-Led | |
09/23/24 - GVT - Virtual Classroom - Virtual Instructor-Led | |
10/28/24 - GVT - Virtual Classroom - Virtual Instructor-Led | |
12/09/24 - GVT - Virtual Classroom - Virtual Instructor-Led |
Outline
TOPIntroduction to Self-Service BI Solutions
- Introduction to business intelligence
- Introduction to data analysis
- Introduction to data visualization
- Overview of self-service BI
- Considerations for self-service BI
- Microsoft tools for self-service BI
- Hands-on: Exploring an Enterprise BI solution
- Viewing reports
- Creating a Power BI report
- Creating a Power BI dashboard
Introducing Power BI
- Power BI
- The Power BI service
- Hands-on: Creating a Power BI dashboard
- Connecting to Power BI data
- Create a Power BI dashboard
Power BI Exploration
- Using Excel as a data source for Power BI
- The Power BI data model
- Using databases as a data source for Power BI
- The Power BI service
- Hands-on: Importing data into Power BI
- Importing Excel files into Power BI
- Viewing reports from Excel files
Shaping and Combining Data
- Power BI desktop queries
- Shaping data
- Combining data
- Hands-on: Shaping and combining data
- Shape power BI data
- Combine Power BI data
Modelling data
- Relationships
- DAX queries
- Calculations and measures
- What is DAX (Overview)
- What is DAX (Tabular)
- Creating Calculated Columns (Basics)
- Navigation Functions
- Conditional and Logical Functions
- Creating Calculated Measures
- Time Intelligence (Overview)
- Time Intelligence (Time Intelligence Functions)
- Using X-Functions and A-Functions
- Table Functions
- DAX as a Query Language
- Hands-on: Let s Model Data
- Create relationships
- Calculations
Interactive Data Visualizations
- Creating Power BI reports
- Managing a Power BI solution
- Hands-on: Creating a Power BI report
- Connecting to Power BI data
- Building Power BI reports
- Creating a Power BI dashboard
Managing Power BI web interface
- Creating reports and referencing data sets
- Managing Power BI web
- Creating dashboards via web
- Creating Basic Reports with the Power BI Desktop
- Creating Interactive Reports (Adding Slicers for Filters)
- Creating Interactive Reports (Visualizing Tabular Data)
- Creating Interactive Reports (Visualizing Categorical Data)
- Creating Interactive Reports (Visualizing Data Trends)
- Creating Interactive Reports (Visualizing Categorical and Trend Data Together)
- Creating Interactive Reports (Visualizing Geographical Data with Maps)
- Creating Interactive Reports (Visualizing Goal Tracking)
- Creating Interactive Reports (Using Custom Visuals)
- Creating Interactive Reports (Digital Storytelling)
- Creating Interactive Reports (Other Features)
- Using the Power BI Service (Deploying to the Power BI Service)
- Using the Power BI Service (Creating and Sharing Dashboards)
- Using the Power BI Service (Using Power BI Q&A)
- Using the Power BI Service (Setting up App Workspaces)
- Using the Power BI Service (Subscriptions and Alerts)
- Using the Power BI Service (Excel Integration)
- Using the Power BI Service (Export and Embed Options)
- Refreshing the Data (Refreshing Data Overview)
- Refreshing the Data (Installing the Data Gateway)
- Refreshing the Data (Scheduling a Data Refresh)
- Mobile BI (Power BI Mobile Overview)
- Mobile BI (Designing Reports and Dashboards for Mobile)
- Mobile BI (Interacting with the Power BI Mobile App)
Prerequisites
TOPBefore attending this course, you should have:
- A general knowledge of database concepts (fields, records, relationships)
- Awareness of key business priorities such as revenue, profitability, and financial accounting
- Comfort when using Excel
Who Should Attend
TOPBusiness Analyst, Data Analysts, Data Scientist, or professionals responsible for reporting on your organization's data.