Forum Discussion

adam-townsend's avatar
adam-townsend
New Member
10 years ago
Solved

Higher education institutions using Power BI?

Is there anyone else out there using Power BI to develop Reports and Dashboards from enterprise data (we are currently using Colleague as an ERP) for a Higher Education Institution? I am looking to j...
v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
9 years ago

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

adam-townsend's avatar
adam-townsend
New Member
9 years ago

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's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity Support
    9 years ago

    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

  • jasonaeiou's avatar
    jasonaeiou
    Frequent Visitor
    9 years ago

    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

    • klanger's avatar
      klanger
      Regular Visitor
      8 years ago

      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