BUSINESS INTELLIGENCE & REPORTING FROM SVA CONSULTING

Improve decision making with information.

 

Do you find your organization is inundated with data, yet it is unusable? Or worse, the data is not accessible without great human feats and when assembled, it is old and unusable. You’re not alone. Many organizations have turned to SVA for help. Our proven methodology of solving this problem is based on providing...

insight

the right information

evaluation

to the right people

right time guidelines

at the right time

...to answer critical business questions. Our measure of success is better decision making, not the volume of data we can provide. There is a difference!

There is also a difference in how we engage your organization to solve this problem. Our methodology is grounded in the business impact and technical feasibility of providing accurate information to decision makers. We can show you how to empower your users while removing the frustration of investing in technologies that quickly become aged and expensive to support. We don’t subscribe to selling you a product and a bunch of unfulfilled dreams.

Customer Scenarios

A school district consisting of 12 different schools and 750+ teachers found themselves struggling to make sense of data from many different systems. Teachers were spending hours assembling data. Administrators spent time comparing assessment and achievement scores across different assessment tools, schools, grades, classrooms, and teachers.

Our professionals solved the problem by working with the client to build a data warehouse, conforming and normalizing the data. Through data assessment and profiling, we worked with the client to develop a standard, multi-tier scoring system. The student, teacher, and classroom data was conformed across the district. As a result, teachers and administrators have a centralized source to access this information delivered through Microsoft SharePoint®. Information is delivered to teachers in a static, highly formatted manner; it’s delivered to administrators using a flexible tool that lends itself well to analytics.

A large insurance company was struggling with aggregating hundreds of thousands of rows of transactional data per month into meaningful data for statutory reporting and financial analysis. In addition, they needed to create journal entries to account for these transactions from their operational system. Not all the information required in the financial and reporting logic was available in any source system.

We solved the problem by creating a system to apply the required business logic to generate both the journal entries and reporting necessary to support their business. Where an existing data source did not exist, web-based configuration screens were developed and made available to the users. This put Finance in control of their own system, rather than relying on an IT resource to change configurations in the database. Working within their technology footprint, the data is sourced and housed in an Oracle database and transformed using SQL Server Integration Services. Information is delivered via Business Objects and Crystal Reports. We took the efficiency a step further and developed an import to bring the journal entries into their ERP system.

A higher education institution with over 100 departments needed a better way to manage costs and expenditures. Each department chair needed to be able to see the actual revenue and expenses attributed to their department as well as the future commitments made and how those expenditures compared to budget. Dynamic security and the ability for users to answer their own questions by drilling into the detail were key drivers in the project.

Our professionals were able to address these issues by designing a data mart capturing key information from their ERP system as well as making information usable and actionable. Using SQL Server Integration Services to transform the data and SQL Server Analysis Services to manage the dynamic security, each person can see the data for their departments and nothing else. The information was delivered through drillable reports developed in SQL Server Reporting Services, further leveraging the investment they already made in SQL Server.

A non-profit provider of social and medical services needed a way to better manage their financial and client service goals at an agency level while providing needed detail to people in the field. Data was sourced in multiple homegrown and commercial systems. Because of the multiple systems, the data did not always have a consistent structure or use.

We worked with this client to build an enterprise reporting system by first assessing their organizational reporting needs. Rather than taking a data-centric approach, we assessed their business questions, then designed a system to feed those informational needs. Sourcing data from multiple systems, as well as conforming it into standard metrics, allowed us to provide apples-to-apples performance management across programs and services. The data is accessible to executive and field personnel through dashboards and reports deployed through Microsoft SharePoint®.


Providing the Right Information


Business intelligence (BI) is more than just analytics and numbers. It’s really the process of getting the right information out of systems and into the hands of decision makers. We provide a variety of services in a consistent manner to meet the unique needs of your team members.



Assessment of Information Requirements


Our assessment is all about the impact of information on your business.  Ignoring technology, we assess the opportunities for providing the right information at the right time to the right people. Our assessment uses a proven methodology of gathering requirements from key stakeholders within the organization. We use the data gathered to identify measurable metrics to be used to answer questions and provide insight into your business.  We believe if you can’t measure it, you can’t manage it.  The deliverable of the assessment is a map of the reporting needs of the company, the detail behind those needs, and a plan on how to deliver on those metrics.


Want More Information?

Want to learn more about this topic or the services SVA Consulting provides? Great, we'd be happy to answer any of your questions. Just fill out the form below and we'll get in contact.