Microsoft Power BI - Up & Running With Power BI Service from Udemy

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 quizzes & homework (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.

What's inside

Learning objectives

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

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

Syllabus

Getting Started

IMPORTANT: Scheduled Course Update

Course Structure & Outline

READ ME: Important Notes for New Students

DOWNLOAD: Course Resources

Setting Expectations

Helpful Resources

Introducing the Course Project

Introducing Power BI Service

Introduction

Meet Power BI Service

Account Types

Common User Personas

Creating a Power BI Account

PRO TIP: Signing up with a Non-Work Email

Activating Your Trial

Quick Tour of the Interface

Workspaces

Common Workspace Actions

Building Blocks of PBI Service

Power BI Service Administration

Admin Roles & Types

Admin Portal Settings & Options

Tenant Settings

PRO TIP: Configuring Custom Branding

BEST PRACTICES: Power BI Service Administration

Connecting to Data

Data Connection Options

Loading a Local File

Loading Data from Excel

PRO TIP: Loading Data from SharePoint

ASSIGNMENT: Loading Local Data to a Workspace

INSTRUCTIONS: Loading Local Data to a Workspace

SOLUTION: Loading Local Data to a Workspace

Understanding Data Gateways

Setting Up a Data Gateway

Understanding Dataflows

Common Dataflow Use Cases

Creating a New Dataflow

Quick Tour of the Dataflow Interface

Connecting to a Dataflow in Desktop

ASSIGNMENT: Connecting to a Dataflow

INSTRUCTIONS: Connecting to a Dataflow

SOLUTION: Connecting to a Dataflow

DEMO: Creating a Dataflow (MySQL)

DEMO: Creating a Dataflow (Local MySQL)

Scheduled Refresh of a Dataflow

DEMO: Real World Automation Setup

BEST PRACTICES: Connecting to Data

ASSIGNMENT: Finishing the Power BI File

INSTRUCTIONS: Finishing the Power BI File

SOLUTION: Finishing the Power BI File

Reports & Dashboards

Data Lineage

Report Interface & Tools

Inserting & Formatting Basic Visuals

PRO TIP: Adding Personal Bookmarks

PRO TIP: Adding an Image

ASSIGNMENT: Building a Report

INSTRUCTIONS: Building a Report

SOLUTION: Building a Report

Pinning Tiles to a Dashboard

Pinning Entire Reports to a Dashboard

Dashboard Interface & Tools

PRO TIP: Adding a Live Page

ASSIGNMENT: Assembling a Dashboard

INSTRUCTIONS: Assembling a Dashboard

SOLUTION: Assembling a Dashboard

Adding Data Driven Alerts

Exploring Data with Q&A

Generating Quick Insights

Designing for Mobile

Introducing the Power BI Mobile App

DEMO: Power BI Mobile App

BEST PRACTICES: Reports & Dashboards

ASSIGNMENT: Alerts and Q&A

INSTRUCTIONS: Alerts and Q&A

SOLUTION: Alerts and Q&A

Sharing & Collaboration

Sharing & Collaboration Options

Sharing Reports, Dashboards & Apps

Defining User Roles & Permissions

Publishing Apps

Publishing to Web

PRO TIP: Generating Usage Reports

BEST PRACTICES: Sharing & Collaboration

ASSIGNMENT: Sharing & Collaboration

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Provides learners an opportunity to deploy a project tailored to their organization's needs, developing job-ready skills for a career in Data Analysis or Business Intelligence

Provides a comprehensive study of one aspect of either science, math, and technology, in which Power BI Service is used for

Develops professional skills or deep expertise in Power BI Service, which is standard in industry

Taught by Aaron Parry, who is recognized for their work in Power BI

Examines Power BI Service, which is highly relevant to Data Analysis or Business Intelligence

Shares unique perspectives are ideas that may add color to other topics and subjects

Reviews summary

Power bi up & running course

According to students, this course covers the Microsoft Power BI Service at the right length without being too short or too long. It is especially useful for preparing for the 70-778 certification, and it is considered a good value, especially when on sale.

This course has the right length.

"Just the the right length to cover the subject."

This course is worth purchasing, especially when on sale.

"Definitely worth the (sale) price."

"If you are preparing for 70-778 its worth the (sale) price."

No prerequisites are required for this course.

"Best udemy course I have taken so far."

The instructor provides good quality content from Maven Analytics.

"Just the the right length to cover the subject."

"So far everything from Maven Analytics has been good, but this is my favorite given that it is the only course I have seen for Power BI Service."

This course is worth purchasing if you are studying for the 70-778 exam.

"If you are preparing for 70-778 its worth the (sale) price."

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Microsoft Power BI - Up & Running With Power BI Service with these activities:

Familiarize yourself with Azure

Show steps

Refresh your knowledge of Azure fundamentals to strengthen your understanding of Power BI Service.

Browse courses on Azure

Show steps

Review Azure documentation: https://docs.microsoft.com/en-us/azure/
Complete Microsoft Learn modules on Azure: https://docs.microsoft.com/en-us/learn/modules/azure-fundamentals/

Join a Power BI Study Group

Show steps

Engage with peers to discuss course concepts, share insights, and support each other's learning journey.

Show steps

Find or create a study group on platforms like Meetup or LinkedIn
Attend regular meetings and participate in discussions
Share knowledge, resources, and experiences with other group members

Explore Power BI Service Tutorials

Show steps

Enhance your understanding of Power BI Service's features and functionality through guided tutorials.

Show steps

Visit Microsoft's Power BI Service tutorials page: https://docs.microsoft.com/en-us/power-bi/service-tutorials/
Follow step-by-step instructions to complete the tutorials

One other activity

Expand to see all activities and additional details

Show all four activities

Practice Building Reports and Dashboards

Show steps

Solidify your skills in designing effective reports and dashboards using the tools available in Power BI Service.

Show steps

Load sample data into Power BI Service
Create a variety of visualizations to represent data
Organize visualizations into reports and dashboards
Publish and share your reports and dashboards with others

Career center

Learners who complete Microsoft Power BI - Up & Running With Power BI Service will develop knowledge and skills that may be useful to these careers:

Data Analyst

Data Analysts work closely with businesses to improve the efficiency of their operations. A background in Power BI would be highly beneficial as you will be able to quickly build professional-quality business intelligence reports and dashboards. You will be able to move data from a variety of sources into a cohesive report with little effort. Data Analysts continue to be in high demand, and this course will help you build a foundation that will help you succeed.

See salaries and explore the career path for Data Analyst

Business Intelligence Analyst

Business Intelligence Analysts help businesses make better decisions by providing them with data-driven insights. This course will help you develop the skills you need to gather, analyze, and interpret data. You will also learn how to use Power BI to create reports and dashboards that can be used to communicate your findings to stakeholders, which will help you succeed in this field.

See salaries and explore the career path for Business Intelligence Analyst

Data Scientist

Data Scientists use scientific methods to extract knowledge from data. This course will help you develop the skills you need to clean, prepare, analyze, and interpret data. You will also learn how to use Power BI to create reports and dashboards that can be used to communicate your findings to stakeholders, which will help you succeed in this field.

See salaries and explore the career path for Data Scientist

Data Engineer

Data Engineers design, build, and maintain the infrastructure that is used to store and process data. This course will help you develop the skills you need to understand the different types of data storage systems and how to use them to efficiently store and retrieve data. You will also learn how to use Power BI to create reports and dashboards that can be used to monitor the performance of your data infrastructure, which will help you succeed in this field.

See salaries and explore the career path for Data Engineer

Database Administrator

Database Administrators are responsible for the maintenance and performance of databases. This course will help you develop the skills you need to understand the different types of databases and how to use them to store and retrieve data efficiently. You will also learn how to use Power BI to create reports and dashboards that can be used to monitor the performance of your databases, which will help you succeed in this field.

See salaries and explore the career path for Database Administrator

Information Security Analyst

Information Security Analysts are responsible for protecting the confidentiality, integrity, and availability of information systems. This course will help you develop the skills you need to understand the different types of security threats and how to protect against them. You will also learn how to use Power BI to create reports and dashboards that can be used to monitor the security of your information systems, which will help you succeed in this field.

See salaries and explore the career path for Information Security Analyst

Systems Analyst

Systems Analysts design, implement, and maintain computer systems. This course will help you develop the skills you need to understand the different types of computer systems and how to use them to solve business problems. You will also learn how to use Power BI to create reports and dashboards that can be used to monitor the performance of your computer systems, which will help you succeed in this field.

See salaries and explore the career path for Systems Analyst

Software Engineer

Software Engineers design, develop, and maintain software applications. This course will help you develop the skills you need to understand the different types of software applications and how to use them to solve business problems. You will also learn how to use Power BI to create reports and dashboards that can be used to monitor the performance of your software applications, which will help you succeed in this field.

See salaries and explore the career path for Software Engineer

Web Developer

Web Developers design, develop, and maintain websites. This course will help you develop the skills you need to understand the different types of websites and how to use them to solve business problems.

See salaries and explore the career path for Web Developer

Data Warehouse Architect

Data Warehouse Architects design and build data warehouses. This course will help you develop the skills you need to understand the different types of data warehouses and how to use them to store and retrieve data efficiently.

See salaries and explore the career path for Data Warehouse Architect

Database Designer

Database Designers design and build databases. This course will help you develop the skills you need to understand the different types of databases and how to use them to store and retrieve data efficiently.

See salaries and explore the career path for Database Designer

Network Engineer

Network Engineers design, build, and maintain computer networks. This course may be helpful in understanding the different types of computer networks and how to use them to solve business problems.

See salaries and explore the career path for Network Engineer

Computer Support Specialist

Computer Support Specialists provide technical support to computer users. This course may be helpful in understanding the different types of computer hardware and software and how to use them to solve technical problems.

See salaries and explore the career path for Computer Support Specialist

Information Technology Manager

Information Technology Managers plan and direct the activities of an organization's information technology department. This course may be helpful in understanding the different types of information technology systems and how to use them to solve business problems.

See salaries and explore the career path for Information Technology Manager

Project Manager

Project Managers plan and execute projects. This course may be helpful in understanding the different types of project management methodologies and how to use them to manage projects successfully.

See salaries and explore the career path for Project Manager