Posts Tagged ‘data warehouse’

  I recently stumbled upon the picture on the right on LinkedIn and it reminded me of a conversation that I had with my mother, who is an architect by trade. She told me that many roads came to be what they are today, not by well-thought-out plans, but rather by people and animals getting […]

Almost every type of ETL tool has its extract and load strategy with its configurations. In general the user should be concentrated in full load (aka initial load) and incremental load options in whatever tools to utilize. Oracle BI Apps component provides straightforward options to let developer configure appropriate approaches to achieve data load in […]

Today, during annual Microsoft Build conference keynote, Microsoft’s own Scott Guthrie (executive VP  of cloud and enterprise group) introduced new Azure service which is going to be available in public preview in June: Azure SQL Data Warehouse. Large enterprise today can’t effectively function without big data realtime analytics. Realtime analytics means processing large amounts of […]

In the Big Data world Lambda architecture created by Nathan Marz is a standard technique applied to solve many predictive analytics problems. This architecture effectively delivers the streaming data and batch data to combine the past information with the current changes, producing a comprehensive platform for predictive framework. Lambda Architecture On a very high generic […]

The data warehouse has been a part of the EIM vernacular for nearly 20 years. The vision of the single source of the truth and a single repository for reporting and analysis are two objectives that have resulted in a never-ending journey.   The data warehouse never has had enough data and the quality required for […]

Years of work went into building the elusive single version of truth. Despite all the attempts from IT and business, Excel reporting and Access databases were impossible to eliminate. Excel is the number one BI tool in the industry and for the following good reasons : accessibility to the tool, speed and familiarity. Almost all […]

Recent articles and the technology hype around Big Data, is forcing big companies as well as medium size companies to do something with this technology. Lot of companies have kicked off Big Data projects albeit in silos. New titles like Data Scientists and the cool factor has increased the expectations of value, the Big Data […]

Like my 1st grade teacher would tell me when I ended a sentence with this preposition……”It’s between the ‘A’ and the ‘T’”.  Well, in this situation, it’s between the “cloud” and the “on premise”. More and more companies are starting to explore and use Infrastructure as a Service (IaaS) as a viable option for developing […]

A health insurance client of mine recently embarked on an initiative to truly have “trusted data” in its Enterprise Data Warehouse so that business leaders could make decisions based on accurate data. However, how can one truly know if your data is trustable?? In addition to having solid controls in place (e.g., unique indexes on […]

In an earlier blog post, I pointed out a number of companies complete a BI Strategy but only to shelve it shortly after its completion.   One main reason is that companies let their BI Strategy atrophy by not maintaining it; however, the other main cause of shelving a BI Strategy is that it was not […]

(Part One of Seven) Have you ever wondered why some data warehouse projects fails while others do not?  I’ve often wondered that myself. I‘ve also observed  that more often than not key ingredients are not described robustly enough or even worse not identified at all.  By an ingredient I mean a requirement may not be […]

Nowadays when people talk about IT technology and trend, there was overwhelming world of big data as we entering the new technology era. I know that big data has been promoted to national strategy in many countries. A few days ago I found an interesting debate whether the traditional data warehouse will be replaced by […]