Implementing Business Intelligence using Microsoft Tools

Presentation Summary

Joanne Wilhelm and Rebecca Cooksey; Indiana University

Implementing Business Intelligence using Microsoft Tools

Indiana University is completing the first phase of our Business Intelligence Initiative including the deployment of the Microsoft BI tool set and a Consolidated Business Intelligence portal. This session identifies the steps taken in our process, from building the foundation of our BI strategy, to deploying BI and analytics. We will share our approach to the foundational requirements for BI, including governance, standards, data modeling, and infrastructure. We will highlight the Microsoft tools and the Consolidated Business Intelligence portal, which enables us to integrate new BI and analytic services along with our existing decision support services and Oracle data warehouse. We will show dashboards and deliverables in subject areas ranging from finance to enrollment to student success. Microsoft BI tools used include Dashboard Designer, Reporting Services, and PowerPivot delivered through SharePoint and the portal. We will share what we have learned and discuss risks and rewards of this strategy.