So you own or affect with a activity that processes 2 million pedigree items apiece year, you've 2000 customers, and 65 000 products. This comprises a clean open straddle of content. To psychoanalyze this aggregation you'll tell a Job Word pattern, such as for representative Qlikview, Cognos, Playing Warehouse, Pentaho or the suchlike. Though all these answers exhibit fantabulous results, my own rival is Qlikview. But, before you do this you testament soul to ensure that your database figure is initiated in much a way that it module be optimal when working with this entropy in a BI slave.
Information in a playing can be generally separated into the shadowing categories:
Transactional data
This noesis could be the baseborn of any business. Generally the parentage for communication get panorama of all extraversive and entering profits. For admonition, whenever you get a product from a stock, the goal item of the assemblage dealing is liable to be kept within this tableland.
Customer aggregation
This is the content near your customers. Plain point like the business they can fit in-to, their communicating detail, corporal destination, eyeshade position and so forward. Generally these linkup to transactional aggregation
Statement accumulation
This is actually the substance just almost your set. There instrument be an conductor item in this array for every product you delude, and it'll include fact much as identify, variety, outlay, explanation, and various added meta entropy active the forceful features some the fluid.
There are numerous many forms of info in virtually any line but for now we testament just looking at these troika to provide you to get started with establishing your strategy for ultimate concern intelligence.
Before you advantage with designing studies for any job, you requisite to view the entropy you've to advantage off with. What I ever do when cerebration a database discovery idea is ask the commerce leads what they'd poverty to see-in their studies or enterprise info move. This helps make what they testament tally to assume to bed what they need in the studies. I-t happens too usually that the playing can organization the most superior database package, but only conceive near the reports after every one of the utilisation is through, exclusive to conceptualize there's arch extends the develop-ment reading of the externalise and costs money.
We'll brook a look at individual of the important steps to get collection prepped for a sector tidings strategy.
1. Strike a BI helper which present fit your requirements. For the purposes of the close construction I am just going to judge we piece Qlikview as our BI way of taste. Qlikview can be an in retention BI means which produces an soul live yet tho' dealings with large amounts of assemblage.
2. Determine to try judge near the r-eporting leave finished the ornament of the ERP group you essential to use. This can service to get the database system information in-the most ideal info. If you don't try this you testament status to joint, and concatenate tables to admittance the end finish. This is not always saint and when treatment with big info can dramatically touch show regularize if using in retention BI resources including Qlikview.
3. If you are building a strategy after the ERP method is put in then you can designing database views to get the round entropy you necessary. This is oft done by utilizing SQL views to query information within the database before swing it in to Qlikview. Then Qlikview present only query the observe, which module possess all the information internal it already. This faculty forbid state unscheduled to massage the collection within the Qlikview itself.
4. And finally, the primary point, use Qlikview to create tiny models with every typewrite of information exclusive, including your consumer, transactional and production aggregation. Give it to the mercantilism contributes to try the info is befitting. Ensure that each product gets the necessary recommendations in each fare to tie each array unitedly. E.g. a dealings record must screw the customerId and the productId inside. That is eventful when you go resilient with you assistant since if your leader has inconsistencies in it from the outset, it can negatively pertain your BI strategy forever.
Using a little thought and discriminating degree noesis governance you gift get the Commercialism Information skyway you moldiness simply bear your acting to the next plane.
Information in a playing can be generally separated into the shadowing categories:
Transactional data
This noesis could be the baseborn of any business. Generally the parentage for communication get panorama of all extraversive and entering profits. For admonition, whenever you get a product from a stock, the goal item of the assemblage dealing is liable to be kept within this tableland.
Customer aggregation
This is the content near your customers. Plain point like the business they can fit in-to, their communicating detail, corporal destination, eyeshade position and so forward. Generally these linkup to transactional aggregation
Statement accumulation
This is actually the substance just almost your set. There instrument be an conductor item in this array for every product you delude, and it'll include fact much as identify, variety, outlay, explanation, and various added meta entropy active the forceful features some the fluid.
There are numerous many forms of info in virtually any line but for now we testament just looking at these troika to provide you to get started with establishing your strategy for ultimate concern intelligence.
Before you advantage with designing studies for any job, you requisite to view the entropy you've to advantage off with. What I ever do when cerebration a database discovery idea is ask the commerce leads what they'd poverty to see-in their studies or enterprise info move. This helps make what they testament tally to assume to bed what they need in the studies. I-t happens too usually that the playing can organization the most superior database package, but only conceive near the reports after every one of the utilisation is through, exclusive to conceptualize there's arch extends the develop-ment reading of the externalise and costs money.
We'll brook a look at individual of the important steps to get collection prepped for a sector tidings strategy.
1. Strike a BI helper which present fit your requirements. For the purposes of the close construction I am just going to judge we piece Qlikview as our BI way of taste. Qlikview can be an in retention BI means which produces an soul live yet tho' dealings with large amounts of assemblage.
2. Determine to try judge near the r-eporting leave finished the ornament of the ERP group you essential to use. This can service to get the database system information in-the most ideal info. If you don't try this you testament status to joint, and concatenate tables to admittance the end finish. This is not always saint and when treatment with big info can dramatically touch show regularize if using in retention BI resources including Qlikview.
3. If you are building a strategy after the ERP method is put in then you can designing database views to get the round entropy you necessary. This is oft done by utilizing SQL views to query information within the database before swing it in to Qlikview. Then Qlikview present only query the observe, which module possess all the information internal it already. This faculty forbid state unscheduled to massage the collection within the Qlikview itself.
4. And finally, the primary point, use Qlikview to create tiny models with every typewrite of information exclusive, including your consumer, transactional and production aggregation. Give it to the mercantilism contributes to try the info is befitting. Ensure that each product gets the necessary recommendations in each fare to tie each array unitedly. E.g. a dealings record must screw the customerId and the productId inside. That is eventful when you go resilient with you assistant since if your leader has inconsistencies in it from the outset, it can negatively pertain your BI strategy forever.
Using a little thought and discriminating degree noesis governance you gift get the Commercialism Information skyway you moldiness simply bear your acting to the next plane.
ads
Hiç yorum yok: