udemy-power-bi-service

I'm going to run this course on Power BI service: https://www.udemy.com/course/power-bi-service/learn/lecture/25124728#overview

Notes

Setting expectations

• The course goes along with Power BI Desktop course. It is recommended to run that first. Hehe.
• Focus on the core parts of Power BI Service.

Intro to PBI Service

Ecosystem

• The cloud environment to share reports and data.
• It connects to data directly.
• You can also build reports here, not just on PBI Desktop.
• Main environment for sharing and publishing.
• There is also PBI Mobile, but well, who cares about that.

Desktop vs Service

• Desktop can connect to more Databases than Service.
• Data Models can only be built in Desktop.
• DAX is only present in Desktop.
• Role level security can only be created in Desktop.
• Service has Gateways and Dataflows
• Service can package stuff into Workspaces and Apps.
• Both have Power Query.

Account Tiers

There are three individual accounts:

• Free
• Pro
  • This is what report builders need.
  • Around $9/month
  • Can create workspaces
  • Can create Email Subscriptions
  • Can share reports with other Pro or Premium users
  • Can create apps
• Premium per user
  • All of Pro
  • AI fancy thingies
  • Advanced Dataflows
  • Deployment Pipelines
  • Other stuff nobody cares about

You can also buy a big, Premium org license. It pretty much means you buy it for the entire org. You still need to pay Pro licenses for report builders.

I have Pro in Superhog.

User Personas

• Creator: build stuff
• Analyzer: consumes stuff to answer business questions and creates his own stuff on the representation layer to some extent
• Collaborator: publishes stuff and manages workspaces/apps

UI

Fluffy stuff. Dear god, this UI is confusing and bloaty.

Workspaces

My Workspace is your personal folder for your own stuff.

All other workspaces are Shared workspaces.

The personal one doesn't have data flows (Power Query)

Content objects:

• Workbook, report or dashboard -> Visualize stuff

Data objects:

• Datasets and Dataflows

Building Blocks of Workspaces

• Datasets and workbooks: build from datasources
• Reports: pages with visuals and filters. Can use one or more datasets
• Dashboard: a collection of visuals that come from one or more reports