![Page 1: Power BI and SharePoint in Higher Your Education picture · 2019. 11. 23. · LEVEL 100 Power BI and SharePoint in Higher Education What’s the experience with an organization-wide](https://reader033.vdocuments.us/reader033/viewer/2022060910/60a4e1245f71a6620f731769/html5/thumbnails/1.jpg)
LEVEL 100
Power BI and SharePoint in Higher
Education
What’s the experience with an organization-
wide deployment of Power BI and SharePoint
Online and how does this adapt to the
requirements and needs of Higher Education?
NOV 23
2019SharePoint Saturday Toronto #SPSToronto
Norm Young
Data Architect, Brock University
#PowerBI #SharePoint
Your picture ☺
![Page 2: Power BI and SharePoint in Higher Your Education picture · 2019. 11. 23. · LEVEL 100 Power BI and SharePoint in Higher Education What’s the experience with an organization-wide](https://reader033.vdocuments.us/reader033/viewer/2022060910/60a4e1245f71a6620f731769/html5/thumbnails/2.jpg)
Agenda
Power BI
• Admissions dashboards
• Enrolment planning management
SharePoint
• Employee portal
• Collaboration sites
• Site request and provisioning solution
• Case Management solution
• SharePoint Usage Docs
![Page 3: Power BI and SharePoint in Higher Your Education picture · 2019. 11. 23. · LEVEL 100 Power BI and SharePoint in Higher Education What’s the experience with an organization-wide](https://reader033.vdocuments.us/reader033/viewer/2022060910/60a4e1245f71a6620f731769/html5/thumbnails/3.jpg)
Admissions dashboards
Problem:
• Too much data and not enough information
• No timely access to performance indicators
Solution:
• Near real-time information using SQL data warehouse and Power BI
Value:
• Transform data into meaningful, timely and actionable information
• Create opportunities for intervention
• Informed decision making
![Page 4: Power BI and SharePoint in Higher Your Education picture · 2019. 11. 23. · LEVEL 100 Power BI and SharePoint in Higher Education What’s the experience with an organization-wide](https://reader033.vdocuments.us/reader033/viewer/2022060910/60a4e1245f71a6620f731769/html5/thumbnails/4.jpg)
Admissions dashboards
Tech overview:
• On premise SQL Server
• SSAS for OLAP and SSIS for ETL
• DQS for address validation
• 2 stage ETL – source to staging (1) and staging to target (2); Runs 1AM and noon daily
• On Premise Data Gateway for connectivity
• Deployed using Power BI Apps
• Hosted on Power BI Premium
![Page 5: Power BI and SharePoint in Higher Your Education picture · 2019. 11. 23. · LEVEL 100 Power BI and SharePoint in Higher Education What’s the experience with an organization-wide](https://reader033.vdocuments.us/reader033/viewer/2022060910/60a4e1245f71a6620f731769/html5/thumbnails/5.jpg)
Admissions dashboards
Demo:
• Applicant pipeline KPI’s.
• Forecasted to Actual’s.
• Flowthrough rate.
• Historical comparisons.
• Global, provincial and local recruitment.
• Applicant choice comparisons.
![Page 6: Power BI and SharePoint in Higher Your Education picture · 2019. 11. 23. · LEVEL 100 Power BI and SharePoint in Higher Education What’s the experience with an organization-wide](https://reader033.vdocuments.us/reader033/viewer/2022060910/60a4e1245f71a6620f731769/html5/thumbnails/6.jpg)
Enrolment planning management
Problem:
• Not enough information to make fully informed decisions.
Solution:
• Custom web app that leverages Power BI Embedded.
Value:
• Provides information tailored to the decision making at hand.
• Increases informed decision making.
• Used for University wide strategic (i.e. budget), tactical ( i.e. staffing) to operational (i.e. residence) planning.
• Sets realistic, informed and “agreed” upon targets!!!
![Page 7: Power BI and SharePoint in Higher Your Education picture · 2019. 11. 23. · LEVEL 100 Power BI and SharePoint in Higher Education What’s the experience with an organization-wide](https://reader033.vdocuments.us/reader033/viewer/2022060910/60a4e1245f71a6620f731769/html5/thumbnails/7.jpg)
Enrolment planning management
Tech overview:
• SQL Server Database.
• C# MVC web app.
• Power BI Embedded.
![Page 8: Power BI and SharePoint in Higher Your Education picture · 2019. 11. 23. · LEVEL 100 Power BI and SharePoint in Higher Education What’s the experience with an organization-wide](https://reader033.vdocuments.us/reader033/viewer/2022060910/60a4e1245f71a6620f731769/html5/thumbnails/8.jpg)
Enrolment planning management
Demo:
• Web app.
• Scorecards
• Step by step though the process.
• In context analytics.
• Output.
• Power BI App.
![Page 9: Power BI and SharePoint in Higher Your Education picture · 2019. 11. 23. · LEVEL 100 Power BI and SharePoint in Higher Education What’s the experience with an organization-wide](https://reader033.vdocuments.us/reader033/viewer/2022060910/60a4e1245f71a6620f731769/html5/thumbnails/9.jpg)
Employee portal
Problem:
• Public web site became a dumping ground for employee content making it difficult for applicants and students to find key information.
Solution:
• Move all employee content to SharePoint communication sites and revamp public site to a recruitment and retention tool.
Value:
• Focused content for targeted audiences.
![Page 10: Power BI and SharePoint in Higher Your Education picture · 2019. 11. 23. · LEVEL 100 Power BI and SharePoint in Higher Education What’s the experience with an organization-wide](https://reader033.vdocuments.us/reader033/viewer/2022060910/60a4e1245f71a6620f731769/html5/thumbnails/10.jpg)
Employee portal
Tech overview:
• SharePoint root URL for parent site and subsites for departments using “classic” Publishing sites.
• Moving to a flat architecture using “modern” Communication sites tied together by a single HUB.
![Page 11: Power BI and SharePoint in Higher Your Education picture · 2019. 11. 23. · LEVEL 100 Power BI and SharePoint in Higher Education What’s the experience with an organization-wide](https://reader033.vdocuments.us/reader033/viewer/2022060910/60a4e1245f71a6620f731769/html5/thumbnails/11.jpg)
Employee portal
Demo:
• Quick walk through of existing.
• Global navigation.
• Site usage.
• HUB site preview.
![Page 12: Power BI and SharePoint in Higher Your Education picture · 2019. 11. 23. · LEVEL 100 Power BI and SharePoint in Higher Education What’s the experience with an organization-wide](https://reader033.vdocuments.us/reader033/viewer/2022060910/60a4e1245f71a6620f731769/html5/thumbnails/12.jpg)
Collaboration sites
Problem:
• Email and “shadow IT” only forms of collaboration.
Solution:
• SharePoint Team sites for departmental, committee, projects collaboration.
Value:
• Centralized location.
• Modern document management with less reliance on IT.
• Less email!!!
• Consistency in use and design.
![Page 13: Power BI and SharePoint in Higher Your Education picture · 2019. 11. 23. · LEVEL 100 Power BI and SharePoint in Higher Education What’s the experience with an organization-wide](https://reader033.vdocuments.us/reader033/viewer/2022060910/60a4e1245f71a6620f731769/html5/thumbnails/13.jpg)
Collaboration sites
Tech overview:
• Information architecture decision making.
• Document library scenarios.
![Page 14: Power BI and SharePoint in Higher Your Education picture · 2019. 11. 23. · LEVEL 100 Power BI and SharePoint in Higher Education What’s the experience with an organization-wide](https://reader033.vdocuments.us/reader033/viewer/2022060910/60a4e1245f71a6620f731769/html5/thumbnails/14.jpg)
Collaboration sites
Demo:
• Simple site.
• Targeted solution site.
• Complex site.
![Page 15: Power BI and SharePoint in Higher Your Education picture · 2019. 11. 23. · LEVEL 100 Power BI and SharePoint in Higher Education What’s the experience with an organization-wide](https://reader033.vdocuments.us/reader033/viewer/2022060910/60a4e1245f71a6620f731769/html5/thumbnails/15.jpg)
Site request and provisioning solution
Problem:
• Custom site builds taking too long for IT to complete.
• No consistency in the builds.
Solution:
• Custom provisioning app with standard site templates using Azure and PnP cmdlets.
Value:
• Less reliance on IT.
• Standardized builds with fast turn around time.
• More time for user support, engagement and adoption.
![Page 16: Power BI and SharePoint in Higher Your Education picture · 2019. 11. 23. · LEVEL 100 Power BI and SharePoint in Higher Education What’s the experience with an organization-wide](https://reader033.vdocuments.us/reader033/viewer/2022060910/60a4e1245f71a6620f731769/html5/thumbnails/16.jpg)
Site request and provisioning solution
Tech overview:
• Azure SQL Database.
• Azure App Service.
• Azure Functions using PnP cmdlets.
• Power BI for reporting.
![Page 17: Power BI and SharePoint in Higher Your Education picture · 2019. 11. 23. · LEVEL 100 Power BI and SharePoint in Higher Education What’s the experience with an organization-wide](https://reader033.vdocuments.us/reader033/viewer/2022060910/60a4e1245f71a6620f731769/html5/thumbnails/17.jpg)
Site request and provisioning solution
Demo:
• Provision project site.
• Provision team site.
• Power BI reporting.
![Page 18: Power BI and SharePoint in Higher Your Education picture · 2019. 11. 23. · LEVEL 100 Power BI and SharePoint in Higher Education What’s the experience with an organization-wide](https://reader033.vdocuments.us/reader033/viewer/2022060910/60a4e1245f71a6620f731769/html5/thumbnails/18.jpg)
Case Management solution
Problem:
• Manual tracking of processes not covered off by IT/ERP systems.
Solution:
• Convert manual forms/processes to SharePoint Lists with Flow.
Value:
• Central and modern solution with all the benefits of a SharePoint and O365.
• Automation to add value to users.
![Page 19: Power BI and SharePoint in Higher Your Education picture · 2019. 11. 23. · LEVEL 100 Power BI and SharePoint in Higher Education What’s the experience with an organization-wide](https://reader033.vdocuments.us/reader033/viewer/2022060910/60a4e1245f71a6620f731769/html5/thumbnails/19.jpg)
Case Management solution
Tech overview:
• SharePoint team site for collaboration
• Lists for process tracking.
• Flow for automation.
• PowerApps for form customization.
![Page 20: Power BI and SharePoint in Higher Your Education picture · 2019. 11. 23. · LEVEL 100 Power BI and SharePoint in Higher Education What’s the experience with an organization-wide](https://reader033.vdocuments.us/reader033/viewer/2022060910/60a4e1245f71a6620f731769/html5/thumbnails/20.jpg)
Case Management solution
Demo:
• Site tour.
• List purpose and functions.
• Flow automation.
![Page 21: Power BI and SharePoint in Higher Your Education picture · 2019. 11. 23. · LEVEL 100 Power BI and SharePoint in Higher Education What’s the experience with an organization-wide](https://reader033.vdocuments.us/reader033/viewer/2022060910/60a4e1245f71a6620f731769/html5/thumbnails/21.jpg)
SharePoint Usage Docs
• https://github.com/SharePoint/sp-usage-docs
• SharePoint Documentation on usage and feature patterns for site owners and citizen developers.
• This repository is here for YOU.
• From SharePoint basics, decision making through too scenarios - learn from others…
… or help others by contributing issues and content.
![Page 22: Power BI and SharePoint in Higher Your Education picture · 2019. 11. 23. · LEVEL 100 Power BI and SharePoint in Higher Education What’s the experience with an organization-wide](https://reader033.vdocuments.us/reader033/viewer/2022060910/60a4e1245f71a6620f731769/html5/thumbnails/22.jpg)
Thank you for attending!
Want to know more?
Visit the Power BI blog
Visit the SharePoint blog
Want to get inspired?
Visit the Power BI Customer Showcase
Get the SharePoint Look Book
Want to connect?
Linkedin.com/in/norm-young
Twitter.com/stormin_30
![Page 23: Power BI and SharePoint in Higher Your Education picture · 2019. 11. 23. · LEVEL 100 Power BI and SharePoint in Higher Education What’s the experience with an organization-wide](https://reader033.vdocuments.us/reader033/viewer/2022060910/60a4e1245f71a6620f731769/html5/thumbnails/23.jpg)
PLA
TIN
UM
Thank You Sponsors!SI
LVER
GO
LD
![Page 24: Power BI and SharePoint in Higher Your Education picture · 2019. 11. 23. · LEVEL 100 Power BI and SharePoint in Higher Education What’s the experience with an organization-wide](https://reader033.vdocuments.us/reader033/viewer/2022060910/60a4e1245f71a6620f731769/html5/thumbnails/24.jpg)
24
SharePint
SharePintThe Drake & Firkin6982 Financial Dr, Mississauga, ON L5N 8J4
SharePoint Saturday
Toronto #SPSToronto
![Page 25: Power BI and SharePoint in Higher Your Education picture · 2019. 11. 23. · LEVEL 100 Power BI and SharePoint in Higher Education What’s the experience with an organization-wide](https://reader033.vdocuments.us/reader033/viewer/2022060910/60a4e1245f71a6620f731769/html5/thumbnails/25.jpg)
Thank you
Toronto community!
Toronto SharePoint Business(meetup.com/tspbug/)
Toronto SharePoint(meetup.com/torontospug/)
Metro Toronto .NET(meetup.com/metrotorontoug/)
North Toronto Cloud & DevOps(meetup.com/NorthTorontoUG/)
Toronto Nintex User Group(meetup.com/TorontoNintexUG/)
IT Pro Toronto(meetup.com/ITProToronto/)
Toronto Enterprise DevOps(meetup.com/Toronto-Enterprise-
DevOps-User-Group/)
Toronto Power Platform(meetup.com/Toronto_Power_Plat
form_UG/)
NOV 23
2019SharePoint Saturday Toronto #SPSToronto