Enabling Self-Service Reporting and Analysis
Karl is an IT manager responsible for Business Intelligence at a large manufacturing organization, in charge of the enterprise information systems. The inventory management team believes there is a bottleneck in the supply chain due to a vendor not providing services fast enough.
As an organization, they use Microsoft SQL Server for their data services, but the package is complex. Karl has a number of DBAs working for him, but they are focused more on “fire fighting” – making the data available, or writing stored procedures. Karl needs a way to generate reports enable users to define and build their own reports, without needing to understand everything every last detail about the database architecture. He’s read about SQL Server’s self-service business intelligence functionality, and wonders if it could help him discover the problem with the supply chain.
Karl researches some of the SQL Server reporting functionality. He hires SolidQ to come in, assess the business problem, design and architect a reporting framework, and train him how to build reusable, self-updating, reports with Power View, using an interface very similar to the Excel spreadsheets he already uses. SolidQ also designs the processes and procedures for sharing the Power View reports in the company’s existing SharePoint intranet. Soon, Karl’s team is able to create reports, and individual components for reports, giving anyone in the organization the ability to create their own reports through a drag and drop interface.
A manager in the inventory management division generates a set of reports using elements from Quality Assurance, Procurement, Inventory, Human Resources, and Finance, and is able to identify a supplier that is slow to deliver on parts. He recommends changing vendors, bringing the project back into compliance.
Executives are able to navigate to the SharePoint site and view the automatically updated supply chain status reports. They are able to reuse entire reports, or components, in their own documents and presentations. The IT staff and DBAs are thrilled that they no longer have to schedule report generation into their already tight schedules, saving them time, and money.
NOTE: This is a fictitious scenario and is intended for informational purposes as an example only. No representations or warranties of any kind are made herein. All names, places, events and characters appearing in this scenario are fictitious. Any resemblance to actual events is coincidental.