Data Analysis Using Power BI Desktop Training - Level 1 Training
Offered to the Jacksonville and Northeast Florida community through UNF Professional and Lifelong Learning in partnership with Applied Technology Academy — live online or in person, taught by ATA's practitioner instructors.
Course Overview
This is the first course in the Data Analysis using Power BI Desktop series. This course lays the foundation for Power BI Report Builders. Report Builders will learn everything they need to create highly effective stand-alone and multi-page narrative reports using data sources that are created using Power BI Desktop. This course covers the use of both the Power BI Desktop application as well as the Power BI Service.
Course Outline
- Module 1: Introducing Power BI
- What Is Power BI for the Cloud
- Power BI Key Features
- Self-Service BI Model
- Power BI Components
- Module 2: Defining a Report
- What is a Power BI Report?
- Defining a Report
- Data-Driven Storytelling
- Module 3: Building Power BI Desktop Reports
- Understanding the Design Interface
- Creating Reports
- Report Visualizations
- Formatting Visualizations
- Report Final Touches
- Module 4: Report Filtering
- Highlighting, Drill-down & Data Actions
- Visual Interactions
- Visual Sorting and Slicers
- Visual, Report, & Page Filters
- Module 5: Understanding Power BI Data Models
- Understanding Data Terminology
- Understanding Tables
- Understanding Relationships
- Diagnosing Data Models
- Data Model Schemas
- Module 6: Gathering Report Data
- Data Queries vs Data Models
- Viewing & Refreshing a Data Source
- Modifying Report Data
- Module 7: Data Model Functions
- Creating Calculated Columns
- What is DAX?
- Basic DAX Functions
- Date Hierarchies
- Module 8: Introducing the Power BI Service
- Power BI Service Interface
- Connecting to Data Sources
- Uploading & Updating PBIX Reports
- Refreshing Power BI Data
- Power BI Service Report Interface Components
- Module 9: Building Power BI Service Dashboards
- Dashboard Interface Components
- Building Dashboards
- Organizing Dashboard Elements
- Module 10: Using Q & A (Cortana)
- Understanding Q & A
- Modifying Q & A Results
- Pinning Q & A results to a Dashboard
- Module 11: Sharing Reports & Dashboards
- Sharing Content
- Managing Power BI Content
- Using App Workspaces
- Content Packs and Apps
- Module 12: Appendix A: Power BI Roles and Security
- Power BI Roles
Intended Audience
General understanding of reporting requirements and a basic understanding of data base concepts is useful, but not required.
Prerequisites
Basic experience with Microsoft Office, Microsoft Excel, and using Web Browsers. General understanding of basic database concepts is useful, but not required.