Category

Data Warehouse

Category

We all have a friend who’s bragged about getting the greatest deal ever on a used car, right up until they’re calling us from the side of the highway because their new hot rod doesn’t work quite as well as advertised. Some of us, too, have been that unlucky buyer, watching the smoke curl from our engine and wondering where we went wrong. Making a decision on a big purchase is tough. Apart from trying…

Data lakes are cool, but you don’t have to jump in head-first. It’s easy to start by dipping a toe: Integrating a legacy data warehouse into a data lake leverages the structured systems that have been built over the years while taking advantage of the ever-increasing volume of unstructured data across the organization. A Familiar Structure Data warehouses are familiar. Generally, IT teams know how to work with them. Over the past two decades, companies…

We can all agree on one thing: nobody likes to wait. When we go to the airport, we like our flights to be on time, and when we head to the grocery store, we want our ripe avocados to be in stock. Businesses don’t like to wait either: time is money. If a store is running low on avocados, the business wants to know as soon as possible, so they can get the restock process…

Gartner estimates that close to 70 to 80 percent of newly initiated business intelligence projects fail. This is due to myriad reasons, from bad tool choice to a lack of communication between IT and business stakeholders. Having successfully implemented BI projects across industries, I hope to share my experiences in this blog post and highlight key reasons why business intelligence projects fail. This article will present counter-measures to failure based on three principles that should govern…

It is surprisingly rare for IT people (in general) to appreciate that data warehousing requires a lot of disk space. Non-IT people, on the other hand, is more appreciative. They understand that if we collect data from many different places and put them in 1 place, then naturally it will require a big disk space. But IT people are quite the opposite: they can appreciate that email and file servers are disks hungry, but…

The data warehouse has proven to be a useful and resilient approach to report and understand an organization’s operations with a history that runs decades. Before data warehousing, reporting and provisioning data from disparate systems was an expensive, time-consuming and often futile attempt to satisfy an organization’s need for actionable information. Data warehousing promised clean, integrated data from a single repository. The ability to connect a wide variety of reporting tools to a single model…

Data warehousing refers to the technique of construction with the aid of a data warehouse. It is constructed by the integration of different data from several heterogeneous sources which bestow support to ad hoc queries, structured queries, analytical reporting. Data warehousing involves the integration of data, cleaning of data, and consolidation of data. Steps for the implementation of data warehousing Here is a list of the steps for the implementation of data warehousing Determining the…