Data Analysis Using Power BI Desktop Training - Level 1 Training
Power BI is a powerful business intelligence tool from Microsoft that transforms messy, raw data into beautiful, interactive dashboards and reports. It helps businesses see and understand their data without needing complex coding or advanced math skills. It acts like an incredibly advanced version of Microsoft Excel charts, designed to handle massive amounts of data from different places simultaneously.
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.
Follow-On Courses
Related training topics
Justify your training
Use this sample request letter — copy it into an email to your manager and personalize the bracketed details to make the case for the time and budget.
Sample training request letter
Subject: Request for Data Analytics & Databases training from Applied Technology Academy
[Decision Maker Name],
I'm writing to request time and budget approval to complete Applied Technology Academy's course, Data Analysis Using Power BI Desktop Training - Level 1 Training. The information below outlines how this training benefits our organization, the tasks I'll be able to perform after completing it, and relevant cost and funding details.
Course Description
Power BI is a powerful business intelligence tool from Microsoft that transforms messy, raw data into beautiful, interactive dashboards and reports. It helps businesses see and understand their data without needing complex coding or advanced math skills. It acts like an incredibly advanced version of Microsoft Excel charts, designed to handle massive amounts of data from different places simultaneously. Applied Technology Academy is an award-winning, SBA-certified woman-owned training provider (est. 2008) whose instructors are active practitioners. The course combines instructor-led training with practical exercises, real-world examples, and computer-based activities designed to reinforce job-relevant skills. It also includes formal hands-on labs for applied, learn-by-doing practice in a live environment.
Course Objectives
Once I've completed the course, I'll have job-ready skills in data analytics & databases that I can apply immediately to our work.
Expected Organizational Benefits
After completing this course, I will be better equipped to apply these skills directly to our projects, reduce our reliance on outside expertise, strengthen our team's capabilities, and share what I learn with colleagues.
Expected Cost & Funding
Course fee: [request an itemized quote at the link below]. Applied Technology Academy supports multiple funding paths that may reduce or cover this cost: GSA MAS purchasing and government purchase orders, military credentialing funding (Army CA, AF COOL, CG COOL), VA GI Bill and VR&E, ATA Flexible Spending, and student financing. Private team cohorts are available if colleagues should attend with me.
Conclusion
This training provides practical, hands-on experience I can apply immediately to strengthen our work in data analytics & databases. Additional course information is available at https://appliedtechnologyacademy.com/microsoft-training/data-analysis-using-power-bi-desktop-level-1-report-builder-training/.
Thank you for your consideration,
[Your Name]
Design training around your team, not the other way around.
Talk to a training advisor about private cohorts, funding paths and program management.