86 lines
2.3 KiB
Markdown
86 lines
2.3 KiB
Markdown
# 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
|
|
|