Power Bi Service

Master Power BI Service & learn advanced data analysis & data visualization w/ a top business intelligence instructor

Last updated 2022-01-10 | 4.6

- 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

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 (2021)
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

* Requirements

* Students are STRONGLY ENCOURAGED to complete our Up & Running with Power BI Desktop course first
* Several features covered in this course require a PRO plan (60 day free trial
* then $9.99/month)
* A work or school email address is required to sign up for a Power BI Service account (no gmail
* aol
* hotmail
* etc.)

Description

IMPORTANT NOTE: 

In order to cover the latest features and provide the best learning experience for our students, this course was completely rebuilt in 2021, with all-new topics, resources, datasets and hands-on projects.

As a reminder, this is PART 2 of our Microsoft Power BI series, which covers Power BI Desktop (Part 1) and Power BI Service (Part 2). We strongly recommend completing our Power BI Desktop course before taking this one!


This top-rated course offers a practical and project-based guide to mastering Power BI in the cloud, including powerful tools like gateways, dataflows, row-level security, data-driven alerts, and much more.


You’ll be playing 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 & dashboards to deliver insights across the entire organization.


Here are just a few of the topics we’ll cover:


  • Administration Tools

    • Admin roles, tenant settings, custom branding, etc.


  • Connecting to Data

    • Connection types, gateways, dataflows, scheduled refresh, etc.


  • Reports & Dashboards

    • Data lineage, bookmarks, data-driven alerts, Q&A, mobile, etc.


  • Sharing & Collaboration

    • User roles, apps, publish to web, usage reports, etc.


  • Row-Level Security

    • Static vs. dynamic RLS, testing roles, etc.


  • PREVIEW: Premium Per User

    • Key features, incremental refresh, UX, etc.


By the end of the course, you’ll have a deep, practical understanding of Power BI Service, along with the skills and confidence you need to apply these tools to your own real-world projects and analyses.


Whether you're a casual Power BI user, aspiring analyst, or business intelligence professional, this course will give you the tools you need to become an absolute Power BI ROCKSTAR -- guaranteed.


__________


Join today and get immediate, lifetime access to the following:

  • 8+ hours of high quality videos

  • 100+ page Power BI Service ebook (PDF)

  • Power BI project files & sample data

  • Course quizzeshomework (with solutions)

  • Expert support & Q&A forum

  • 30-day money-back guarantee


We can't wait to see you in the course!

-Aaron (Lead Power BI Instructor, Maven Analytics)


__________

Looking for the full business intelligence stack? Search for "Maven Analytics" to browse our full course library, including Excel, Power BI, MySQL, and Tableau courses!


Hear why our Power BI Desktop and Power BI Service courses are the TOP-RATED on Udemy:

"I totally loved this Power BI course! Everything was very easy to understand, but it moved at a fast enough pace that I never got bored. I learned SO much and had fun doing it. In fact, at the end of the day, I didn't want to stop learning -- I wanted to keep charging on to the next lesson!"

-Ann S.

"Amazing! 5+ stars if you ask me! Concise, superbly organized and prepared. I have learned a ton about Power BI Service and in addition I have learned how to create a great course as well. Enjoyed the course from start to finish."

-Nikola H.

"Hands-down the best Power BI courses on Udemy. Courses are well prepared and very hands-on, and the instructor makes the whole experience easy and fun. I recommend it 100%!"

-Jorge M.

"Where can I leave a 6 star rating?"

-Carlos B.

Who this course is for:

  • Anyone looking for complete, comprehesive deep dive into Microsoft Power BI Service (2021)
  • Users who are familiar with Power BI Desktop and want to learn how to publish, share & collaborate in the cloud
  • Aspiring data professionals and teams looking to master the #1 business intelligence tool on the market
  • Students who want a comprehensive, engaging, and project-based approach to training
  • Anyone looking to pursue a career in Data Analysis or Business Intelligence

Course content

9 sections • 106 lectures

Course Structure & Outline Preview 02:20

READ ME: Important Notes for New Students Preview 02:13

DOWNLOAD: Course Resources Preview 00:16

Setting Expectations Preview 02:38

Helpful Resources Preview 01:50

Introducing the Course Project Preview 03:20

Introduction Preview 01:32

Meet Power BI Service Preview 06:30

Account Types Preview 10:53

Common User Personas Preview 02:05

Creating a Power BI Account Preview 04:22

PRO TIP: Signing up with a Non-Work Email Preview 08:17

Activating Your Trial Preview 03:33

Quick Tour of the Interface Preview 06:21

Workspaces Preview 09:06

Common Workspace Actions Preview 04:35

Building Blocks of PBI Service Preview 04:04

Introducing Power BI Service

Introduction Preview 01:42

Admin Roles & Types Preview 04:29

Admin Portal Settings & Options Preview 08:17

Tenant Settings Preview 09:33

PRO TIP: Configuring Custom Branding Preview 03:49

BEST PRACTICES: Power BI Service Administration Preview 01:52

Power BI Service Administration

Introduction Preview 02:01

Data Connection Options Preview 08:03

Loading a Local File Preview 03:13

Loading Data from Excel Preview 09:44

PRO TIP: Loading Data from SharePoint Preview 08:34

ASSIGNMENT: Loading Local Data to a Workspace Preview 01:40

INSTRUCTIONS: Loading Local Data to a Workspace Preview 00:55

SOLUTION: Loading Local Data to a Workspace Preview 05:02

Understanding Data Gateways Preview 05:43

Setting Up a Data Gateway Preview 07:33

Understanding Dataflows Preview 08:54

Common Dataflow Use Cases Preview 02:17

Creating a New Dataflow Preview 14:59

Quick Tour of the Dataflow Interface Preview 04:52

Connecting to a Dataflow in Desktop Preview 05:19

ASSIGNMENT: Connecting to a Dataflow Preview 00:53

INSTRUCTIONS: Connecting to a Dataflow Preview 01:20

SOLUTION: Connecting to a Dataflow Preview 12:10

DEMO: Creating a Dataflow (MySQL) Preview 05:54

DEMO: Creating a Dataflow (Local MySQL) Preview 06:06

Scheduled Refresh of a Dataflow Preview 10:31

DEMO: Real World Automation Setup Preview 06:17

BEST PRACTICES: Connecting to Data Preview 01:45

ASSIGNMENT: Finishing the Power BI File Preview 00:48

INSTRUCTIONS: Finishing the Power BI File Preview 01:29

SOLUTION: Finishing the Power BI File Preview 13:13

Connecting to Data

Introduction Preview 01:29

Data Lineage Preview 09:36

Report Interface & Tools Preview 12:23

Inserting & Formatting Basic Visuals Preview 11:21

PRO TIP: Adding Personal Bookmarks Preview 03:10

PRO TIP: Adding an Image Preview 03:39

ASSIGNMENT: Building a Report Preview 00:46

INSTRUCTIONS: Building a Report Preview 01:56

SOLUTION: Building a Report Preview 06:54

Pinning Tiles to a Dashboard Preview 04:38

Pinning Entire Reports to a Dashboard Preview 05:48

Dashboard Interface & Tools Preview 07:19

PRO TIP: Adding a Live Page Preview 02:58

ASSIGNMENT: Assembling a Dashboard Preview 01:16

INSTRUCTIONS: Assembling a Dashboard Preview 01:26

SOLUTION: Assembling a Dashboard Preview 07:25

Adding Data Driven Alerts Preview 05:36

Exploring Data with Q&A Preview 08:20

Generating Quick Insights Preview 07:29

Designing for Mobile Preview 03:25

Introducing the Power BI Mobile App Preview 02:54

DEMO: Power BI Mobile App Preview 11:56

BEST PRACTICES: Reports & Dashboards Preview 01:34

ASSIGNMENT: Alerts and Q&A Preview 00:50

INSTRUCTIONS: Alerts and Q&A Preview 00:31

SOLUTION: Alerts and Q&A Preview 02:31

Reports & Dashboards

Introduction Preview 01:04

Sharing & Collaboration Options Preview 02:16

Sharing Reports, Dashboards & Apps Preview 07:12

Defining User Roles & Permissions Preview 06:07

Publishing Apps Preview 10:10

Publishing to Web Preview 05:12

PRO TIP: Generating Usage Reports Preview 06:05

BEST PRACTICES: Sharing & Collaboration Preview 01:15

ASSIGNMENT: Sharing & Collaboration Preview 00:50

INSTRUCTIONS: Sharing & Collaboration Preview 00:27

SOLUTION: Sharing & Collaboration Preview 03:24

Sharing & Collaboration

Introduction Preview 01:03

Static RLS Preview 07:11

Testing RLS Preview 03:38

Dynamic RLS Preview 05:43

Configuring RLS in Power BI Service Preview 10:52

BEST PRACTICES: Row-Level Security Preview 01:00

ASSIGNMENT: Row-Level Security Preview 00:55

INSTRUCTIONS: Row-Level Security Preview 00:37

SOLUTION: Row-Level Security Preview 03:04

Row-Level Security

Introduction Preview 01:24

Premium Per User Workspace Preview 04:45

Premium Per User Features Preview 07:15

REFERENCE: Monthly Power BI Updates Preview 00:22

BONUS LECTURE: More from Maven Preview 00:59