|
Arch
|
Dev
|
Vwr
|
Topic & Estimated Duration
|
Duration
|
Description
|
|
Managing Workspace
|
|
R
|
R
|
N
|
What is a Workspace?
|
20 min
|
Workspaces are places to collaborate with colleagues on specific content. Power BI designers create workspaces to hold collections of dashboards and reports. The designer can then share the workspace with colleagues. Designers can also bundle a collection of dashboards and reports into an app and distribute.
Optional* Workspaces in Power BI
|
|
R
|
N
|
N
|
Create a Workspace
|
15 min
|
You create and manage workspaces in the Power BI service (in a browser at app.powerbi.com), not in Power BI Desktop. Power BI Desktop lets you publish to an existing workspace you have access to but doesn't provide workspace creation settings.
|
|
R
|
A
|
N
|
Naming the Workspace
|
|
[NUIT has provided guidelines for Naming Convention]
|
|
R
|
A
|
N
|
Manage and Secure Power BI
|
168 min
|
The NU tenant has limited who can create workspaces. Every School/Unit with an existing shared Power BI service has an administrator to manage the department’s content. Ensure content is accessible and distributed effectively in Power BI to foster collaboration and informed decision-making. Protect sensitive information with robust security, building trust across your organization
Core Content:
Manage workspaces in Power BI service (20 min)
Secure data access in Power BI (39 min)
|
|
R
|
N
|
N
|
Delete / Restore Workspaces
|
5 min
|
While a deleted collaborative workspace is in a retention period, Fabric administrators can restore it and its contents.
Please email servicedesk@northwestern.edu with Subject line "#DMA Restore PBI Workspace" to request restoration.
|
|
R
|
A
|
N
|
Access to Workspace
|
5 min
|
After you create a workspace in Power BI, or if you have an admin role in a workspace, you can give others access to it by adding them to the different roles. Workspace creators are automatically admins.
|
|
Access / Sharing
|
|
R
|
R
|
N
|
Power BI Roles
|
30 min
|
NUIT recommends only using Admin and Member; to delineate the developers and the consumer. Consumers would be provided access via Apps.
|
|
R
|
R
|
N
|
Choosing a Content Distribution Method
|
25 min
|
Power BI provides powerful tools to share and distribute insights across your organization, ensuring the right people have access to the right data at the right time.
|
|
R
|
A
|
N
|
Giving Individual Access
|
5 min
|
After you create a workspace in Power BI, or if you have an admin role in a workspace, you can give others access to it by adding them to the different roles. Workspace creators are automatically admins. For an explanation of the different roles, see Roles in workspaces.
|
|
A
|
A
|
N
|
Create a Contact List
|
5 min
|
You can specify which users receive notification about issues occurring in the workspace.
|
|
R
|
R
|
N
|
Publish an App
|
30 min
|
In Power BI, you can create official packaged content and distribute it to a broad audience as an app. You create apps in workspaces, where you can collaborate on Power BI content with your colleagues.
|
|
R
|
R
|
N
|
Manage Semantic Model Access
|
15 min
|
Manage semantic model access permissions in Power BI to keep your sensitive data secure. The semantic model manage permissions page enables you to monitor and control who has access to your semantic model.
|
|
Semantic Model
|
|
A
|
A
|
N
|
What is a Sematic Model?
|
10 min
|
A semantic Model is an established standardized semantic models that can be the one source of truth.
|
|
A
|
R
|
N
|
Creating a Semantic Model
|
80 min
|
Semantic models organize complex data into an intuitive structure, enhancing data visualization and enabling efficient, insightful reporting for better decision-making. Good modeling practices lead to scalable semantic models that simplify analysis and reporting of large, complex data, enhancing Power BI reports for an optimal user experience.
|
|
R
|
R
|
N
|
Share access to a Semantic Model
|
10 min
|
To make it possible for other users to take advantage of a semantic model, you can share it with them. Sharing a semantic model means granting access to it.
|
|
A
|
A
|
N
|
Semantic Model Permissions
|
20 – 30 min
|
This article describes semantic model permissions in the Power BI service and how these permissions are acquired by users.
Also see Control the Use of Semantic Models (for Architect, 10 min)
|
|
Security
|
|
R
|
R
|
N
|
Role Level Security
|
15 min
|
RLS roles are applied to members who are assigned to the Viewer role in the workspace. Admin, Member, or Contributor have edit permission for the semantic model and, therefore, RLS doesn’t apply to them.
|
|
R
|
R
|
N
|
Object-level security (OLS)
|
15 min
|
OLS roles are applied to members who are assigned to the Viewer role in the workspace. Admin, Member, or Contributor have edit permission for the semantic model and, therefore, OLS doesn’t apply to them.
|
|
A
|
R
|
N
|
Permissions for Shared Semantic Model
|
20 min
|
When you create a report in Power BI Desktop, the data in that report is stored in a data model. When you publish a report to the Power BI service, the data model is also published to the service as a semantic model at the same time. When you share the report with others, you can give them Build permission for the semantic model that the report is built on, so they can discover and reuse it for their own reports, dashboards, etc.
Note* Your admin should be consulted for changes semantic model changes.
|
|
Data Sources
|
|
A
|
A
|
N
|
Get data from files
|
10 min
|
In Power BI, you can connect to or import data and reports from these types of files:
- Microsoft Excel .xlsx and .xlsm files
- Power BI Desktop .pbix report files
- Comma-separated value (CSV) .csv files
Also see :
Access and prepare data for Power BI Desktop (50 min)
YouTube – Connect to Multiple Data Sources (~7 min)
|
|
A
|
A
|
N
|
Workspace Semantic Models
|
10 min
|
In Power BI, semantic model creators can control who has access to their data by using the Build permission. Semantic model creators can also certify or promote semantic models so others can discover them.
|
|
A
|
A
|
N
|
Workspace OneDrive
|
15 min
|
Allows you to configure a Microsoft 365 Group whose SharePoint document library is available to workspace users.
|
|
A
|
A
|
N
|
SQL Server Database
|
15 min
|
Connect to SQL Server database
|
|
Introduction & Fundamentals
|
|
A
|
A
|
A
|
What is Power BI?
|
15 min
|
Power BI is Microsoft's business analytics platform that helps you turn data into actionable insights. Whether you're a business user, report creator, or developer, Power BI offers integrated tools and services to connect, visualize, and share data across your organization.
|
|
A
|
R
|
A
|
Introduction and prerequisites for Power BI
|
35 min
|
This module guides you through the steps of installing the required software on your computer so that you can complete this course.
Also See: LinkedIn Video – Power BI Essential Training (3 hrs 49min)
|
|
R
|
A
|
N
|
Introduction to end-to-end analytics using Microsoft Fabric
|
20 min
|
Discover how Microsoft Fabric can meet your enterprise's analytics needs in one platform. Learn about Microsoft Fabric, how it works, and identify how you can use it for your analytics needs.
|
|
N
|
R
|
A
|
Getting Started with Building
|
21 min
|
Learn about Power BI, the building blocks and flow of Power BI, and how to create compelling, interactive reports.
Also See: YouTube - Key Components of Power BI (~8min)
LinkedIn Video - Learning Power Bi (2 hr 22 min)
|
|
R
|
R
|
N
|
Sharing Considerations & Limitations
|
5 min
|
Power BI offers several ways to collaborate and share Power BI reports, dashboards, and data with others—inside or outside your organization. This article explains the main sharing and collaboration options, when to use each, and how to manage permissions.
|
|
R
|
A
|
N
|
Explore fundamentals of data visualization
|
38 min
|
Provides foundational Understanding of Power BI. Learn the fundamental principles of analytical data modeling and data visualization, using Microsoft Power BI as a platform to explore these principles in action.
|
|
N
|
R
|
N
|
Create reports and dashboards in Power BI
|
N/A
|
This is a resource page aimed at learning how to create compelling reports in Power BI using visuals, AI, filters, and formatting. Explore tutorials, samples, and best practices.
Also see: LinkedIn Video - Dashboard for Beginners (40 min)
|
|
A
|
A
|
A
|
Create Subscriptions
|
15 min
|
Subscribe yourself and others to Power BI reports, dashboards, and paginated reports. You receive an email on a schedule you set. The email contains a snapshot and link to the report or dashboard or a full attachment of the report or dashboard.
Note* Your Architect can also manage subscriptions in your workspace, including how to take over subscriptions owned by others.
|
|
N
|
R
|
A
|
Cross Filtering
|
10 min
|
One of the great features of Power BI is the way all visuals on a report page are interconnected. If you select a data point on one of the visuals, all the other visuals on the page that contain the same data change based on your selection.
|