Forum Discussion
Higher education institutions using Power BI?
Hi adam-townsend,
When you said you wanted to develop reports in Power BI, would you please tell us which data source you want to connect to and retrieve data? Currently, in Power BI Desktop and Power BI Service, supported data sources type are listed in below links:
Data sources in Power BI Desktop
Data sources for Power BI service
Also based on my research, there is a sample Power BI Higher Education Analytics solution shows student persistence, retention, and graduation patterns. You can take a look: Higher Education Analytics using Power BI #1: Retention.
If you have any question, please feel free to ask.
Best Regards,
Qiuyun Yu
Community SupportHi adam-townsend,
When you said you wanted to develop reports in Power BI, would you please tell us which data source you want to connect to and retrieve data? Currently, in Power BI Desktop and Power BI Service, supported data sources type are listed in below links:
Data sources in Power BI Desktop
Data sources for Power BI service
Also based on my research, there is a sample Power BI Higher Education Analytics solution shows student persistence, retention, and graduation patterns. You can take a look: Higher Education Analytics using Power BI #1: Retention.
If you have any question, please feel free to ask.
Best Regards,
Qiuyun Yu
Thanks for the response. We are currently using Colleague and extracting census data using SQL into a datawarehouse, where it's imported into BI. This application is simliar to Banner (same software manufacturer, actually), the one used by the institution in the article you mentioned. I have our data set on a 24-hour refresh schedule through Power BI and that seems to be working fine unless there's a hang up in our push from our production database to the datawarehouse.
One recent thought I had was splitting our census data into several distinct tables because currently I'm importing a table with about 20-30 columns and it feels clumsy.
I'd like to hear from other Higher Ed institutions as well. Any thoughts?
- v-qiuyu-msft
Hi adam-townsend,
As the report can work fine in Power BI Service and data refresh is also fine, so the issue is not related to Power BI. For issue about extract production SQL database data to the data warehouse, please post a issue in this forum: SQL Server Data Warehousing .
Best Regards,
Qiuyun Yu Hi Adam - I sent you a private message - I work on the US Education team at Microsoft and would be happy to help out here! Jason
Hi Jason,
I will be pulling Ellucian Colleague data into PowerBI, probably via Colleague ODS.
Have you any suggestions?
- Kent Langseth (klanger) for Mars Hill University
Hi,
I'm unable to download solution template for Higher Education analytics Using Power BI #1:Retention. Please help!
Sonam
I appreciate your initiative to connect with fellow Power BI users in the higher education sector. It's always beneficial to share experiences and insights when it comes to leveraging powerful tools like Power BI, especially in the context of enterprise data from an ERP like Colleague.
At Scribble Bridge, we've had significant success using Power BI to develop comprehensive Reports and Dashboards tailored to the unique needs of higher education institutions. We understand the value of a community where professionals can exchange ideas and discuss successes and challenges.
If you're interested in further expanding your network and gaining insights into optimizing Power BI for educational data analysis, I recommend checking out our recent white paper on "Empowering Higher Education with Power BI: Strategies for Success." This document delves into best practices, success stories, and key considerations when using Power BI in the education sector.
Feel free to access the white paper [insert link to the white paper]. We hope you find it valuable, and we welcome you to share your thoughts and experiences with our community. Looking forward to engaging in meaningful discussions!
