Preparing Data for a Qlikview Business Intelligence Strategy

So you own or paintings for a business that procedures 2 million line items in keeping with year, you have got 2000 customers, and sixty five 000 merchandise. This makes up a quite huge quantity of statistics. To investigate this statistics you may want a business intelligence tool, including qlikview, cognos, commercial enterprise warehouse, pentaho or the like. At the same time as most of these solutions supply notable effects, my private favourite is qlikview. However, earlier than you try this you'll need to make certain that your database layout is installation in this type of way that it will be premiere while the usage of this records in a bi device.

Facts in a business can be basically damaged down into the following categories:

Transactional information

This data is the base of any commercial enterprise. In most cases the road for line transaction detail of all incoming and outgoing revenues. As an example, when you order a e book from a shop, the line item of the e book transaction will be saved in this desk.

Customer facts

This is the facts approximately your clients. Fundamental element such as the arena they fit into, their touch element, physical cope with, account repute etc. In maximum instances those link to transactional information

Product statistics

That is the facts all about your product. There will be an line object in this table for every product you promote, and it will encompass detail along with rate, kind, class, description, and numerous different meta statistics about the bodily characteristics approximately the product.

There are many more forms of information in any commercial enterprise however for now we are able to simply examine these three to help you get started out with putting in place your method for final enterprise intelligence.

Before you begin with designing reports for any enterprise, you want to study the information you need to start out with. What i usually do while designing a database capturing gadget is ask the commercial enterprise leads what they might need to see in their reports or business intelligence method. This allows decide what they will want to capture to get what they want inside the reports. It occurs too regularly that a business will layout the maximum brilliant database system, but best think about the reviews after all of the development has been executed, only to discover there is key data they did no longer capture. This in the long run extends the development time of the assignment and expenses cash.

We are able to observe a number of the key steps to get data prepped for a commercial enterprise intelligence approach.

Select a bi tool in an effort to in shape your desires. For the functions of the following steps i am simply going to count on we choose qlikview as our bi device of choice. Qlikview is an in reminiscence bi device which grants a fast consumer experience even if dealing with big amounts of information.

Try consider the reporting factor in the course of the layout of the erp device you want to apply. This can help to get the database structure layout inside the maximum most appropriate layout. If you don't do that you'll need to join, and concatenate tables to get to the end result. This isn't always usually top-quality and while managing big facts can extensively have an effect on overall performance even if using in reminiscence bi equipment consisting of qlikview.

In case you are building a strategy after the erp device has been installed then you may design database views to get the base facts you need. This could be accomplished by way of the usage of square views to question statistics inside the database earlier than putting it into qlikview. Then qlikview will just question the view, for you to have all the statistics in it already. This will prevent having to massage the data within the qlikview itself.

And finally, the most essential step, use qlikview to create mini models with each sort of facts in it, consisting of your transactional, purchaser and product information. Supply it to the enterprise results in verify that the records is correct. Make certain that every model has the necessary keys in every desk to hyperlink each table together. E.G. A transaction document need to have the customerid and the productid in it. That is important when you go stay with you model due to the fact in case your model has inconsistencies in it from the outset, it is able to negatively have an effect on your bi approach for all time.
With a little planning and a few accurate facts governance you could get the business intelligence approach you want to take your business to the subsequent level.