Transforming Data Insights with Power BI Solutions
Explore the evolution of Business Intelligence tools like Power BI and Tableau, their advantages, and the simplification of data visualization for California colleges. Discover how easy it is to create interactive dashboards, gain strategic insights, and revolutionize decision-making processes. Uncover the power of BI in a rapidly changing digital landscape.
Download Presentation
Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
You are allowed to download the files provided on this website for personal or commercial use, subject to the condition that they are used lawfully. All files are the property of their respective owners.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.
E N D
Presentation Transcript
Power BI Solutions for California Colleges Joe McGinn Microsoft Enterprise Platform Architect Nuventive 2016 Nuventive Users Conference
The BI Demo Lie How to have a tax free MILLION DOLLARS!! All of these beautiful, robust, interactive, web- based dashboards and reports can be yours today!! We ve removed ALL the complexity !! Just plug in, turn on, connect to all your data and brace for stardom as you begin to uncover incredible new insights that transform your institution and probably the WORLD! FIRST! Get a million dollars THEN . 2016 Nuventive Users Conference
The BI Reality BI HAS come a long way in a short time. so much so Gartner has completely redefined it. The cloud DOES change everything. Creating robust, interactive dashboards over your data and uncovering new strategic insights ISeasier than it s ever been. BUT getting the data together is STILL COMPLEX and TIME CONSUMING. 2016 Nuventive Users Conference
BI Tools are Better Than Ever Power BI and Tableau Both are robust and easy to use. Both are great if you have a mature EDW to plug in. Tableau has best visuals, but not a great mashup tool and can get expensive. Power BI visuals catching up quickly and also an EPIC mashup tool. but Power BI Templates + Azure Automation + ADLA + ADLS + ADF changes everything! 2016 Nuventive Users Conference
Power BI Mashups DEMO 2016 Nuventive Users Conference
What is IE/IRs Highest and Best Use?!? Mashup: Days to AnalysisTemplate:Minutes to Analysis On Premises Microsoft Azure MIS File Upload cb.csv Azure PaaS st.csv Azure Explorer Access Tabular Data Model sx.csv Storage (Azure) xb.csv View View Field Officer Metrics Views ODBC Kai ODBC Access BI Semantic Model Tabular Development Data model Azure SQL database Static Dimension Tables Other Reports Advisor PopSels DAX Business logic CSV Files Access Data access xVelocity Campaign Websites Focus Reports 6 2016 Nuventive Users Conference
Jump Straight to Creating Insightful, Interactive Visuals in Power BI Power BI Tabular Data Model Power BI User Publish & Share in Multiple Places IntePort Power BI Content Pack Power BI User Nuventive Action Point Power BI Service Embedded in web sites (IE, CCCCO, etc.) Apps like Nuventive s Action Point Other Action Point User Action Point User Action Point Action Point User Action Point User 7
Simple, Self- Help Data Refresh Process On Premises Microsoft Azure MIS File Upload Azure PaaS Simply drag/drop raw MIS files into (free) Azure Explorer app on the desktop that s it! Azure Explorer Tabular Data Model Storage (Azure) All MIS DED field values already stored in Azure SQL Database Semantic model contains relationships, measures and KPI calculations. Updated MIS files are automatically run through the semantic model and reflected in all published datasets, dashboards & reports. Azure SQL database Static Dimension Tables 8
End to End: College Level Solution MIS files uploaded to secure Azure Storage Account Cloud ETL via Azure Data Lake Analytics Grabs raw MIS files Power BI Free Free Power BI User Processes in ADLA utilizing U-Sql Drops processed files back to Azure Storage Account Semantic model hosted directly in Power BI Shared Dashboards & Reports On Premises Microsoft Azure Free Power BI User Azure PaaS MIS File Upload Power BI Pro Storage (Azure) Contains relationships and measure definitions Pulls processed MIS files from Azure Storage Azure Explorer Pro Power BI User Pulls dimension data directly from Azure SQL Dataset and all reports auto- refresh Role based and row-level security Azure ADLA IntePort Power BI Content Pack Pro Power BI User Azure SQL database Static Dimension Tables 9 2016 Nuventive Users Conference
Power BI Templates DEMO 2016 Nuventive Users Conference
Solution Benefits Simple, quick and highly customizable reporting of disaggregated MIS data elements in Power BI. Automate redundant, manually intensive and error prone data staging efforts. Free up valuable analyst cycles to focus on new, strategic institutional insights to improve student outcomes. 2016 Nuventive Users Conference
Solution Benefits Complex measures handled in the semantic model (MDX/DAX) Easily extendable to non-MIS data sources. Fully deployed in 1-2 days we re told it saves the colleges using it more time than that every month. 2016 Nuventive Users Conference
