Data Warehousing

DW_c

Unleash the full potential of your data

What is a Data Warehouse?

Data Warehouses are central repositories of integrated data from one or more disparate sources. They store current and historical data which allow creation of actionable insights to be consumed throughout the enterprise.

They are the foundation for a successful BI program. The concept is simple; create a central location and permanent storage space to house a deep data pool that can be sliced and diced in an infinite number of ways to support desired analysis, reporting and other BI functions.

In-house Data Warehouse design, development, infrastructure and maintenance can be very expensive and inefficient due to the need to have scale based around peak demand.

How Do Data Warehouses Work?

The pernix approach to Data Warehousing is:

  • Envision the initial architecture;
  • Model the details just in time (JIT);
  • Prove the architecture early;
  • Focus on usage;
  • Promote active stakeholder participation;
  • Take an evolutionary approach;
  • Embrace change;
  • Deliver working outputs regularly;
  • Generate regular iterations;
  • Test throughout the lifecycle; and
  • Involve operations and support people early.

Good Data Warehouse Design

  • Congregates data from multiple sources into a single database so a single query engine can be used to present data;
  • Mitigates the problem of database isolation level lock contention in transaction processing systems caused by attempts to run large, long running, analysis queries in transaction processing databases;
  • Maintains data history, even if the source transaction systems do not;
  • Integrates data from multiple source systems, enabling a central view across the enterprise;
  • Improves data quality by providing consistent codes and descriptions, flagging or even fixing bad data;
  • Presents the organisation’s information consistently;
  • Provides a single common data model for all data of interest regardless of the data’s source;
  • Restructures the data so that it makes sense to the business users;
  • Restructures the data so that it delivers excellent query performance, even for complex analytic queries, without impacting the operational systems;
  • Adds value to operational business applications; and
  • Makes decision–support queries easier to write.

Poor Data Warehouse Design

I can’t get an answer when I need it…

Demands on Management and decision making can be very dynamic in today’s business climate. Often, decision makers need the best information and need it now!

pernix solutions ensure that they can query the data themselves with little or no support from IT; saving more time and more money. That means that users won’t have to wait until IT gets around to generating the reports, and those hardworking folks in IT can do what they do best—keep the systems running.

My Gut Feeling is…

Often, when data is limited or incomplete, decision makers defer to instinct. In some cases this works extremely well, but in the majority of cases this is a recipe for failure and certainly introduces an unacceptable risk profile for big ticket decisions.

pernix solutions provide the  capability to draw better data from a wider range of sources; decision makers will no longer need to make business decisions based on limited data or their gut.  Data warehouses and related BI can be applied directly to business processes including marketing segmentation, inventory management, financial management, and sales.

I’m not sure that’s right…

When business critical decisions need to be made it is imperative that there is confidence in the data and what it has to say. Too many handshakes and heavy reliance on cascading conversions leaves the door open for error.

pernix Data Warehouse implementation includes the conversion of data from numerous source systems into a common format.  Since each data from the various departments is standardised, each department will produce results that are in line with all the other departments. So you can have more confidence in the accuracy of your data. Accurate data is the basis for sound decisions.

I can’t see the detail…

Data from traditional front end source systems on well-defined Entity Relationships or mainframes make it difficult to generate historical reports with sensible granularity. This frustrates and limits any attempt to mine data or develop enhanced models.

pernix developed Data Warehouse provide access to large amounts of previously unaccessible historical data so you can analyse different time periods and trends in order to make better predictions and forecasts.

I thought we had integrated data…

More and more proprietary systems are offering 1st or 2nd party integration with other systems. Each new system and integration adds complexity and decreases flexibility.

pernix solutions ensure that all data is centralised, data quality is enhanced and users can quickly access critical data from a number of sources. As the data is all in one place and not specific to one platform it is future-proofed.