Home / Solutions / Reporting & Analytics

Learn More
Solutions to us means integrating people, processes and technology to help solve a problem. No matter how big or small, the solution should always match the problem it is attempting to solve.

Downloads
thinking data Toolkit for Business Intelligence (pdf)
Credit Risk Brochure (pdf)

"Furious activity is no substitute for understanding."
H. H. Williams

Reporting & Analytics
Reporting is often the thing first noticed when a system is constructed. Reporting and analytics may be intended to deliver an enterprise-wide risk management dashboard, forecasting, predictive modeling, self-service reporting applications or to create custom add-in tasks for SAS Enterprise Guide. Regardless of purpose, we recognize the strategic nature of the reporting and analytics infrastructure, both technologically and from a corporate perspective. ThotWave is committed to providing solutions that address the many complex business issues our customers face.

Information reporting can often be one of the most important physical signs of an organization’s progress as measured through its operational systems. By surfacing information that is trapped within the confines of technology (i.e., databases, stored procedures, business rules, aggregation strategies) we can begin to measure, understand and predict changes in a company’s operations. Reporting should be done to solve an information problem - not to create one. Information should be presented in intuitive and compelling ways - ways that uncover meaningful but previously hidden facts about the organization and its stakeholders.

By implementing good processes throughout the life cycle of reporting elements (through collection, integration, transformation, storage, retrieval, dissemination and assimilation), we can rely on information to help us make decisions. Of course, even the best information remains a tool that only aids our capacity for inductive reasoning. Data warehousing, in practice, can yield an understanding of the corporate culture that rivals the water cooler in its efficiency.

Information displays should be crafted from both an understanding of the business content and the art of human-computer interaction. At ThotWave, we get great satisfaction from elucidating requirements, accurately defining context, and designing and building a reporting and analysis system. Our customers know that the reporting and analytics we build are architecturally robust, scalable, and flexible.

Each component in the warehouse can be considered a separate part in this process, enabling the project to be broken down in terms of a series of conversions. The conversions, a set of programs that have logical cohesiveness and are functionally relevant to one another, require mapping of data sources from source - move - target. Using this logical mapping, we usually begin by examining the existing and proposed reporting targets and work backwards to the source systems.

A variety of source-move-target mappings exist within a data warehouse as the physical repository, for example, may be both a target (from the extraction systems) and a source (for the ad-hoc analysis system). The purpose of this methodology is to map the operational data onto how we use it in the data warehouse. This process includes conversion, enrichment and summarization.

In terms of our process for data modeling, we have used the large-scale warehouse approach of both Bill Inmon and Ralph Kimball. For data mart data modeling, we often streamline this process and focus on a rapid warehouse design that includes: Assessment, Requirements, Implementation, Training and Review.