Microsoft Power BI - Publishing to Power BI Service

In this lecture, you'll meet Power BI Service. We'll discuss some of the features within the Service environment, talk about how Power BI Service fits into the Power BI ecosystem, and compare the Service features against Power BI Desktop.

In this section, we'll look at the three tiers of Power BI, Free, Pro, and Premium, dig into the features associated with each tier, and also talk about the cost of Power BI Pro.

In this lecture we'll walk through how to sign into Power BI Service by creating a new Power BI account or signing in with an existing account.

In this lecture I'll introduce the Power BI Service interface, covering core views like, the Navigation Pane, Get Data button, Content Canvas, Search functionality, and the Help menu.

In this section I'll discuss some of the resources that I find most helpful, like the "Help & Support" menu, Microsoft Power BI blog, Microsoft Power BI YouTube channel, Guy in a Cube, and Power BI User Group (PUG).

The Get Data menu is our portal for connecting to all kinds of data sources. While not as robust as Power BI Desktop, the data connection options in Power BI Service allow you to connect to apps created by your organization, various services (Github, Google Analytics, JIRA), files (csv, xlsx, pbix), and Databases (SQL, Azure, SSAS, Spark).

In this lecture we'll load our first dataset into Power BI, understand where the dataset is stored, and look at the Power BI Service features in a bit more detail.

This lecture continues to breakdown the components of Power BI. I'll show you the main building blocks of Power BI Service; Datasets, Reports, and Dashboards and how they come together to form Workspaces.

In this lecture we'll cover all the actions available in Power BI across our Datasets, Workbooks, Reports, and Dashboards and discuss a few of these actions in detail like, scheduled refresh, insights, delete, etc.

In this section I'll cover how to load an excel workbook to Power BI, discuss how the workbook is opened in an Excel Online environment, talk about the features and limitations of excel workbooks in Power BI Service, and pin pivot charts to a dashboard.

In this lecture I'll cover how to load tables from an excel workbook into Power BI Service to be used as datasets.

There are two types of workspaces in Power BI Service; My Workspace and App Workspaces. In this lecture, we'll compare and contrast the two workspace types.

In this lecture we'll create an App Workspace where you can share and collaborate with your coworkers. But before creating the app workspace, we first need to sign up for a Power BI Pro license trial.

In this lecture we'll continue to reinforce loading data, by using the Get Data menu, and load a .csv file into an app workspace.

In this section we'll load a complete data model, that was built in excel, into Power BI Service as a dataset. We'll also look at what gets imported like measures, calculated columns, and the underlying data relationships.

In this lecture I'll show you how to load a .pbix file by using the Get Data button from Power BI Service or by using the Publish button in Power BI Desktop.

In this lecture I'll show you how to download the data gateway from Microsoft, walk you through setting up the gateway in personal mode, and then check Power BI to make sure the gateway is running.

In this lecture I'll show you how to enable scheduled refresh in Power BI and configure different options like frequency, time zone, and time of day.

In this section we'll set up the recommended Enterprise Gateway, set a recovery key, and confirm our gateway cluster running in Power BI Service.

Meet Dataflows - Query Editor processes that can be configured in Power BI Service to transform, enhance, and ingest your data. In this lecture we'll talk about why and how Dataflows can be used.

In this lecture we're going to walk through creating a new Dataflow. First, we'll talk about the process and then we'll jump into Power BI Service and create a Dataflow.

In this lecture we'll talk about how the basic building block in Power BI, datasets, are used to build reports and dashboards.

In this lecture we'll talk about the Reporting interface and the two different views: Reading View and Editing View. After each view is introduced, I'll walk you through the layout, features, and functionality.

In this section I'll show you how to add our first visual to the Power BI report canvas (stacked column chart) and cover the fields and formats options available for this specific chart type.

In this lecture we'll practice adding additional visuals to our Power BI report canvas; a date slicer and a matrix visual. We'll cover some of the formatting options available and also set up conditional formatting for our matrix.

Now that we've created a couple of visuals, I'll show you how to add these visuals to a Power BI Dashboard by pinning tiles.

Have you ever wanted to create a dashboard from multiple  Power BI reports? In this lecture I'll show you how to pin tiles from multiple disparate reports into one Power BI Dashboard

In this section we'll walk through the Power BI Dashboard interface, talk about the layout, features, functionality, and then jump into a hands-on demo where we'll add text boxes and schedule emails from Power BI Service.

In this lecture I'll show you how to set up data-driven alerts for three visual types; KPI cards, Cards, and Gauge charts.

In this lecture we'll explore the Power BI Q&A feature that uses natural language processing to help create visuals in Power BI Service.

In this lecture I'll show you how to generate Quick Insights in Power BI Service that will generate custom visuals and descriptions based on your dataset. Then, I'll cover how you can pin these quick insights visuals to a Power BI Report or Dashboard.

In this lecture we'll cover personal bookmarks in Power BI Service, which are bookmarks only accessible by you, and then we'll walk through how to add personal bookmarks in the report reading and editing views.

In this lecture I'll show you the difference between the Power BI Service web view and Power BI Mobile view and how the mobile view can be used to design custom Power BI mobile layouts.

In this section we'll cover the last main function of Power BI Service, sharing with individuals, teams, and organizations.

In this lecture we'll cover the different ways to print or export a physical copy of your Power BI reports and dashboards.

In this lecture we'll publish our report to the web which creates a link that is accessible by anyone who has it. Publish to Web is a great way to share your Power BI Reports and Dashboards that do not contain sensitive data.

Want to give individual Power BI users access to the reports and dashboards in your app workspace? In this lecture I'll show you how you can share reports and dashboards with specific individuals.

In this lecture we'll talk about adding other users to our app workspaces as Admins, Members, or Contributors.

In this lecture I'll show you how to define, configure, and test row-level security (RLS) in Power BI Desktop. After this is defined in Power BI Desktop, we'll publish to Power BI Service and test the roles to make sure they're functioning properly.

In this section, we'll look at how to create an app in Power BI Service. Once our app is created, I'll show you how to selectively add Power BI Reports and Dashboards to the app and how to update your Power BI app.

In this lecture I'll provide an overview of the Power BI Mobile app and talk through the 4 core functions of the mobile app: Interact, Share, Draw & Comment, and Notify.

In this lecture I'll provide a live demo of the Power BI Mobile app and walk through all of the different features and functionality like, settings, favorites, notifications, apps, shared with me, workspaces, and scanner.

Complete the full stack of Excel, Power BI, and SQL analytics courses and emerge a certified wizard. Courses include Formulas & Functions, PivotTables, Charts & Graphs, Power Query, Power Pivot & DAX, Publishing to Power BI Service, and MySQL for Data Analysis (Beginner & Advanced).