Enterprise Reporting and Self-Service Business Intelligence

Enterprise Reporting and Self-Service Business Intelligence

Agenda Overview of Enterprise reporting, BI and Self-Service BI BI Architecture Governance: ComIT, people and processes Demos Takeaways Questions

Q: What challenges do we face as ComIT while addressing reporting needs of our customers? LOB applications built-in reports Custom reports SS challenge Access control Multiple versions of truth Data silos Data versus information

Report definition A report is any informational work made with the specific intention of relaying information or recounting certain events in a presentable form.

According to Gartner Business Intelligence (BI) Business intelligence (BI) is an umbrella term that includes the applications, infrastructure and tools, and best practices that enable access to and analysis of information to improve and optimize decisions and performance. Self-Service BI Self-service business intelligence is defined as end users designing and deploying their own reports and analyses within an approved and supported architecture and tools portfolio.

Q: What is reporting and what difference “Enterprise” does in “Reporting”

Enterprise reporting is: A combination of technology , tools , policies and procedures that provides robust unified platform for report development and presentation utilizing enterprise data sources for sharing across departments and business units while providing security and controlled access to information on a corporate, team and individual levels

Microsoft Reporting and BI offering SharePoint Dashboards & Scorecards SharePoint Collaboration Analysis Services Integration Services Excel Workbooks PowerPivot Applications Reporting Services Master Data Services LOB Apps Odata Feeds

ENTERPRISE REPORTING ARCHITECTURE Internet Explorer SharePoint Power View SQL Server Data Tools Excel Excel Services Services Reporting Reporting Services Services PowerPivot for xlsx Excel Excel PowerPivot PowerPivot for for SharePoint SharePoint (Analysis (Analysis Services) Services) xlsx Analysis Services BI Semantic Model Third Party Apps Personal BI Team BI Corporate BI

Developers Power Users IT IT Pros Pros Sophisticated Design Environment Report Viewer Controls Productive Authoring Re-use of insights Flexible layout End Users Visual data representation Highly Interactive Rich Presentation Rich Design Capabilities Report Designer Embedded Enterprise Report Builder Operational Team Power View Business Individual

http:// www.vbgov.com/government/departments/real-estateassessor/Pages/annual-reports.aspx https:// wwws.vbgov.com/ePRO/MainUI/Crimes/CrimesMain.asp x

Where we are and what is next on the map? Expand reporting and BI service to customers Follow industry’s path in BI technology Data warehouse and data services Master data files Create enterprise data catalogs oData

Takeaways: Environment is built and is ready to be utilized city-wide on a corporate, team and individuals levels Think how you can apply this technology in your workplace? Which of your customers will benefit and in what ways from using this technology?

Questions