skip to Main Content

Data Warehouse

Data Warehouse provides rapid access to relevant information extracted from key systems on a scheduled basis.

Data Warehouses: Build It and They Will Come… Or Maybe Not

Although seemingly simple, building an enterprise data warehouse is an extremely complex process that can easily end in disaster if not done correctly. Over the years, countless IT departments have mistakenly undertaken data warehouse projects thinking that centralizing the company’s data into one “source of truth” will provide limitless information to their organizations, only to find their project stalled, over-budget, and failed. In fact, it is widely believed that between 60% to 70% of data warehousing projects fail.

Successful data warehouse projects need to begin with the end in mind. They should be designed to support the organization’s constantly evolving strategy and operational requirements. Therefore, the first stage starts with executive buy-in and proper resource allocation, which includes appointing a business leader/champion capable of defining the future methods and processes for using information to improve the company’s reporting and decision-making. If it becomes an “IT Project,” it is likely doomed before it begins.

Assuming the company is willing to commit the right leader, project team and financial support, the next stage of the project start-up is answering key questions that will determine the scope and scale of the data warehouse such as:

  1. What are the specific business objectives to be accomplished?
  2. What information is most useful?
  3. Who will use the information?
  4. When should it be updated?
  5. How will it be accessed?

The third stage of the project start-up is determining the database architecture and data requirements. This requires thinking about a number of operational and technical components of your data warehouse:

  • Database Schema
  • Data Quality
  • Performance
  • Frequency
  • On-Premise or Cloud
  • Database Software
  • Reconciliation Requirements
  • Cost

At this point, and now likely months into the project, you are ready to set up your server(s) and begin writing ETLs. If you have done your initial start-up/pre-work well, this will likely be the easiest part of the process. There are also a number of tools (e.g., www.scribesoft.com) that can help automate portions of this stage, and now many legacy software systems now have pre-built APIs to transfer data to popular database platforms.

If you are patient and dedicated enough to reach the last stage of the start-up process, the deployment stage, congratulations! Most companies never reach this point. Their data warehouse projects die on the vine after thousands of hours and hundreds of thousands of dollars.

Unfortunately, your reward for reaching this point is that the end is just the beginning. Now that your data warehouse is “deployed” comes the really tough part…getting user adoption. Users don’t always like to operate with the truth, especially if it goes against their personal perspective. So get ready to have your data challenged daily, all your hard work snubbed and every possible request geared subconsciously to slow down further progress.

Supporting articles:

Why data warehousing projects fail
by Monique I. CuvelierGo to TechTarget article

Top 5 Challenges of Data Warehousing
by DWBIConcepts TeamGo to DWBI article

Do you have multiple data silos within your organization including multiple ERP’s, Points of Sale, CRM systems, Traffic Counters and more?

The EBM Data Mart/Data Warehouse is specifically configured to provide rapid access to relevant information extracted from key systems on a scheduled basis. Combined with proprietary security, hierarchy mapping and built-in administrative tools, the result is a powerful engine to drive your Enterprise Business Managment solutions.

Security Management

Robust security with flexibility. Implement security based on user roles, individuals, groups, stores, down to individual SKU’s, customers and accounts. Securely roll out to your entire organization providing access to what users need unique to their role.

Hierarchy Management

EBM’s Hierarchy Management utility allows admin users to easily adjust the order and structure of data across each Hierarchy that exists in the Data Mart. Easily adjust the hierarchy mapping of a piece of information & see that change within all modules of the tool suite on a proforma basis.

Chart of Accounts
Category & Items
Channel & Customer

Scenario Management

The Scenario Management utility allows Admin Users to create new scenarios, manage existing scenarios, lock/unlock scenarios, and adjust the ordering of relevant Scenarios; Actuals, Plans, Forecasts, and Budgets. These adjustments are then reflected in the full suite of Enterprise Business Management tools.

Companies can create nearly an unlimited number of scenarios in order to accommodate their specific planning and reporting needs.

Easily Compare:

Historical Actuals
Current Plan/Forecast/Budget
Future Plan

Allocation Management

Admin users have the ability to allocate costs to specific cost objectives such as various departments, accounts, items, and customers. Provides a full view of your cost structure efficiently and effectively.

Back To Top