By John Fegan, Consultant
I have heard this question a lot. Can Qlikview replace a DWH? In my opinion, it depends on the company. If the company has already invested in a DWH why try and reinvent the wheel. Qlikview is the perfect downstream application to extract the data and present it in the most cost-effective way. I am currently working on a project for a large networking company where consolidating data from the many source systems is too difficult to handle with QVD’s or scripting. In this situation the warehouse is most definitely needed.
In smaller companies with less complex needs who might be just starting out with BI it comes down to the amount of data, history and detail that is needed to be stored. Case in point, I previously worked for a small company that did not have traditional business intelligence implementation, thus Excel spreadsheets were readily used for data analysis. In this type of business environment, Qlikview would be an optimal choice because it would more than serve the needs of the client. In fact, due to Qlikview’s ease of use and ability to produce quick results, Qlikview could actually effortlessly replace the need for Excel. Most importantly, the absence of a DBW through Associative Query Logic saves the client money and precious resources and can be implemented in a matter of weeks, thus saving time. The client can spend more time on the project at hand rather than building up and maintaining data warehouses.
I believe that small and large business can greatly benefit from all that Qlikview has to offer. It will allow your day-to-day operations to run more efficiently. Contact Bardess today, and allow us to show you how to make this possible for your company.
About the Author
John is a highly skilled Business and Database Analyst with over 14 years of functional experience in companies of all sizes, Fortune 500 to small, regional businesses. He has acquired both the business acumen and technical expertise to implement effective solutions to complex business processes. He is also a Project Manager capable of overseeing the entire product-development life-cycle. John has worked extensively with Sales and Marketing organizations utilizing data assets to improve top line revenue growth. He has the unique combination of technical and business knowledge to effectively communicate business solutions to Stakeholders.