English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 91 lectures (5h 52m) | 2.26 GB
Learn Power BI Service for data prep, data analysis, visualization & business intelligence w/ a top Power BI instructor!
This top-rated course offers a practical and project-based guide to mastering Microsoft Power BI in the cloud, including powerful tools for connecting to data, building reports & dashboards, automating workflows, collaborating with other users, and more. We’ll cover the entire data analysis and business intelligence workflow, from data prep and analysis to visualization and dashboard design.
You’ll play the role of a data analyst for Maven Inspectional Services, a restaurant health inspection agency based in Los Angeles. Your objective? Use Power BI Service – and the skills you develop throughout the course – to build scalable reports and dashboards to deliver insights across the entire organization.
What you’ll learn
- Publish professional-quality business intelligence reports to the cloud
- Automate reports and dashboards with gateways, dataflows, and scheduled refresh
- Explore and analyze data with natural language Q&A, quick insights, bookmarks and data-driven alerts
- Collaborate and share with other users and teams online and in real time
- Configure user roles and row-level security to maintain data quality and control
- Master the latest tools and features availlable in Power BI Service (2024)
- Connect data from flat files, Excel workbooks, Sharepoint folders, SQL databases, and more
- Build job-ready skills for a career in Data Analysis or Business Intelligence
Table of Contents
Getting Started
1 READ ME Important Notes for New Students
2 Course Introduction
3 Course Structure & Outline
4 DOWNLOAD Course Resources
5 Setting Expectations
6 Helpful Resources
7 Introducing the Course Project
Microsoft Fabric & Power BI Ecosystem
8 Section Introduction
9 Introducing Microsoft Fabric
10 Fabric Components & User Personas
11 Meet Power BI Service
12 Account Types
13 Power BI User Personas
14 Creating a Power BI Account
15 PRO TIP Signing up with a Non-Work Email
16 Activating your Trial
17 Power BI Service Interface
18 Preview – Task Flows
19 Workspaces
20 Workspace Actions
21 Power BI Service Workflow
22 Microsoft Fabric & Power BI Ecosystem
Connecting to Data
23 Section Introduction
24 Data Connection Options
25 Loading a Local File
26 ASSIGNMENT Loading a CSV File
27 SOLUTION Loading a CSV File
28 Understanding Data Gateways
29 Setting up a Data Gateway
30 Understanding Dataflows
31 Common Dataflow Use Cases
32 Creating a Dataflow
33 Dataflow Interface
34 Connecting to a Dataflow in Desktop
35 ASSIGNMENT Connecting to a Dataflow
36 SOLUTION Connecting to a Dataflow
37 Demo Creating a Dataflow (MySQL)
38 Dataflows Gen 1 vs. Gen 2
39 Scheduled Refresh
40 PRO TIP Workspace Folders
41 Demo Real-World Automation Setup
42 ASSIGNMENT Finishing the Semantic Model
43 ASSIGNMENT Finishing the Semantic Model (Text Lesson)
44 SOLUTION Finishing the Semantic Model
45 Key Takeaways
46 Connecting to Data
Reports & Dashboards
47 Section Introduction
48 Data Lineage
49 Report Interface & Tools
50 Building & Formatting Charts
51 PRO TIP Adding Images
52 ASSIGNMENT Building the Report
53 SOLUTION Building the Report
54 PRO TIP Adding Personal Bookmarks
55 Pinning Tiles to a Dashboard
56 Pinning Entire Reports to a Dashboard
57 Dashboard Interface & Tools
58 PRO TIP Embedding Web Content
59 ASSIGNMENT Assembling a Dashboard
60 SOLUTION Assembling a Dashboard
61 Data-Driven Alerts
62 ASSIGNMENT Adding Alerts
63 SOLUTION Adding Alerts
64 Natural Language Q&A
65 Generating Quick Insights
66 Designing for Mobile
67 Demo Power BI Mobile App
68 Key Takeaways
69 Reports & Dashboards
Sharing & Collaboration
70 Section Introduction
71 Sharing & Collaboration Options
72 Sharing & Viewing Content
73 Defining User Roles & Permissions
74 Publishing Apps
75 Publishing to Web
76 PRO TIP Generating Usage Reports
77 ASSIGNMENT Sharing & Collaboration
78 SOLUTION Sharing & Collaboration
79 Key Takeaways
80 Sharing & Collaboration
Row-Level Security
81 Section Introduction
82 Static Row-Level Security
83 Testing Row-Level Security
84 Dynamic Row-Level Security
85 Configuring RLS in Service
86 ASSIGNMENT Row-Level Security
87 SOLUTION Row-Level Security
88 Key Takeaways
89 Row-Level Security
Power BI Service Administration
90 Section Introduction
91 Admin Roles
92 Admin Portal & Settings
93 Tenant Settings
94 Tenant Customization
95 Key Takeaways
96 Service Administration
Wrapping Up
97 BONUS LESSON
Resolve the captcha to access the links!