Data Analysis Using Power BI Desktop – Level 1 – Report Builder
Applied Technology Academy offers the best in Cloud computing training. Cloud computing is the leading edge platform and no one is gaining greater market share than Amazon’s AWS cloud platform. As an official AWS Training Partner through a partnership, we offer authorized AWS curriculum and labs developed by Amazon and delivered by Amazon Authorized Instructors (AAI’s).
Training at a glance
Level
Beginner
Duration
2 Days
Experience
0 year: Reporting & Data Base Concepts
Average Salary
$109,029
Labs
Yes
Level
Beginner
Duration
2 Days
Experience
0 year: Reporting & Data Base Concepts
Average Salary
$109,029
Labs
Yes
Training Details
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.
- 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
General understanding of reporting requirements and a basic understanding of data base concepts is useful, but not required.
Basic experience with Microsoft Office, Microsoft Excel, and using Web Browsers. General understanding of basic database concepts is useful, but not required.
Upcoming Classes
We Offer More Than Just AWS Training
Our successful training results keep our corporate and military clients returning. That’s because we provide everything you need to succeed. This is true for all of our courses.
Strategic Planning & Project Management
From Lean Six Sigma to Project Management Institute Project Management Professional, Agile and SCRUM, we offer the best-in-class strategic planning and project management training available. Work closely with our seasoned multi-decade project managers.
IT & Cybersecurity
ATA is the leading OffSec and Hack the Box US training provider, and a CompTIA and EC-Council award-winning training partner. We offer the best offensive and defensive cyber training to keep your team ahead of the technology skills curve.
Leadership & Management
Let us teach your team the high-level traits and micro-level tools & strategies of effective 21st-century leadership. Empower your team to play to each others’ strengths, inspire others and build a culture that values communication, authenticity, and community.
