Dashboard Gear

Many professionals have heard of data warehousing but are unsure of how it works, and whether your organization would benefit from utilizing a data warehouse.  The concept of data warehousing is actually fairly simple.  A data warehouse is a unique central repository – a warehouse – for data that an enterprise’s various business systems collect.  Periodically, production data from online business applications and other sources is selectively extracted and organized in the data warehouse for useful analysis and access for reporting.  Meaning, a data warehouse stores a standardized, consistent, clean, and integrated form of data sourced from various operational systems in the organization. A data warehouse is structured in a way that specifically address an organization’s reporting and analytic requirements.  The resulting data warehouse becomes the main source of information for an organization’s report generation, analysis, and presentation through ad hoc reports, portals, and dashboards.