Data Warehousing And Business Intelligence Pdf

Posted on

Data Warehousing And Business Intelligence Pdf – This post follows a question posted in the Data Warehousing Institute (TDWI™) 2.0 group. Unfortunately, the original thread is unavailable for whatever reason, but the gist of the question is if anyone has experience using some BI tools to cover various functions in an implementation. So the scenario might be: Tool A for dashboards, Tool B for OLAP, Tool C for analytics, Tool D for formatted reports and even Tool E for visualization.

In my original reply, I admitted that I had not encountered this exact situation, but when I was working with the setup shown in the diagram below, I felt that it was no different:

Data Warehousing And Business Intelligence Pdf

Data Warehousing And Business Intelligence Pdf

There are no analysis tools here (in the statistical modeling sense – Excel played that role) and no real visualizations (unless you count graphs in PowerPlay), but there are dashboards, OLAP cubes, formatted reports and simple list reports. There are two reasons why this arrangement may not initially seem relevant to the question…

Data Warehouse System Architecture

There are no analysis tools here (in the statistical modeling sense – Excel played that role) and no real visualizations (unless you count graphs in PowerPlay), but there are dashboards, OLAP cubes, formatted reports and simple list reports. The reason this arrangement doesn’t seem relevant to’s question at first is that two layers (and three reporting technologies) are from one vendor; Then Cognos, now IBM-Cognos. I thought it was important to have Cognos products in different major versions. The dashboard tool is from their version 8 architecture and the OLAP cubes and formatted reports are from their version 7 architecture.

A note of explanation may be necessary, as it is clear that we did not expect such a slight mismatch in techniques. We originally built our BI infrastructure without a panel layer. Because dashboards weren’t such a hot topic for CEOs when we started. However, I think it makes sense to overlay dashboards into an established information structure (my previous article, “All that glitters is not gold”, for some thoughts on dashboards, is also relevant to this discussion).

When we started thinking about adding icing to our BI cake, ReportStudio in Cognos 8 had just arrived and we thought it would make sense to check it out; To provide dashboards and assess its future role in our BI implementation. At the time, the initial Cognos 8 version of Analysis Studio was not an attractive upgrade path for PowerPlay users, so we wanted to stick with PowerPlay 7.3 a little longer.

Another thing I should mention is that we have a built-in web-based reporting tool that we developed internally as a Powerplay practice tool. The reasons for this are: a) we have already trained 750 users on this tool and it seemed reasonable to use it, and b) using it we didn’t need to buy additional Cognos 7 products like Impromptu to support it. required This hopefully explains the slight heterogeneity of our setup. I should probably say that users can directly access any BI tool for information and move between them as shown by the arrows in the diagram.

Data Warehouse Engineer Resume Example For 2023

I’m sure things have improved dramatically in the Cognos toolset since then, but at the time there wasn’t a seamless integration between ReportStudio and PowerPlay because it was on different architectures. This means we have to code the parameter passed between the ReportStudio panel and the PowerPlay cube ourselves. While there are some similarities between the two products, there are also some differences at that point, apart from the custom integration we need to develop, the two Cognos products must be viewed as separate tools. Add to this the custom integration of our native PowerPlay reporting app and you can begin to see why I felt there were some similarities between our implementation and those using different providers for each tool.

I’ll talk about the pros and cons of the single-vendor approach later, but for now the obvious question is “Did our setup work?” The answer was yes. While the behind-the-scenes IT work may not be the most elegant (though everything is kept up-to-date), things look great from the users’ perspective. To anticipate the latter point a bit, I think it’s the user experience that matters, rather than what happens on the IT side of the house. However, let’s move from some specifics to some general comments.

I think it makes sense if I lay my cards on the table early. I am a paid member of the BI Standardization Club. I believe you unlock the true potential of BI when you take a broader view and bring as many areas into your stack as possible (see my previous article, Holistic vs Incremental Approaches to BI , for my reasons for believing this).

Data Warehousing And Business Intelligence Pdf

The warehouse itself should have a standard view of dimensions (business entities and embedded hierarchies should be the same everywhere – I’m sure this would make all my MDM friends happy) and dimensions (what’s the point if it’s profitable). defined in different ways in different reports?). It’s almost a cliché to talk about “one version of the truth” these days, but I’ve always been in favor of this approach.

Warehouse Data Flowchart Template

Also, I think you should have at least two tools. However, the minimum here need not always be one. To misquote one of Württemberg’s most famous sons:

It cannot be denied that the supreme aim of any theory is to make the irreducible fundamentals as simple and as few as possible, without giving up an adequate representation of the single data of experience.

But perhaps mere performance does justice to the principle he proposes. Let me outline the main reasons cited for taking a single-vendor approach to BI:

This all seems to make perfect sense, and you can see that each of the above points can reduce the complexity and cost of your BI solution. Surely taking that approach doesn’t make sense? Well let me offer some alternative views on each topic; None of this completely negates the point, but I think it’s worth considering another perspective before deciding what’s best for your organization.

Pdf) Etl Evolution For Real Time Data Warehousing

In general, a single-vendor solution is still likely to be cheaper than a multi-vendor solution, but I hope I’ve made enough points to consider that not warranted. Also, the cost difference may not be as significant as initially thought. You should definitely look into both approaches and see what works best for you. However, there is another important point to consider here, which I mentioned earlier; The most important thing is that your users have the best experience, and the tools you use will ensure that. If you can stick it to the dealer, great. However, if your customers are better served by different tools at different levels, this should be your approach, even if it makes things a little harder for your team.

Of course, there may be some additional costs associated with such an approach, but I suspect this problem is not insurmountable. A comparison to consider is that the cost per user of many BI tools is similar to desktop productivity tools like Office. The main cost of BI programs is not the tools you use to deliver the information, but all the work behind the scenes to ensure the right information at the right time and with the right level of accuracy. The majority of BI project costs fall into the four pillars I mentioned:

BI tools cost a fraction of the above (see also BI Implementations Like Icebergs). Of course, any savings on tools can be used to fund other parts of the project. However, it is important not to cut off the nose here to complete the face. Choosing the right tools for the job, from a vendor or two (or even three in a hurry), is more important to the overall profitability of your project than saving a few nickels and dimes while sticking to strategy. Just a salesman.

Data Warehousing And Business Intelligence Pdf

Published in

Msbi Cheat Sheet

Business intelligence vs data warehousing, big data and business intelligence, business data intelligence warehousing, data warehousing and business intelligence, business intelligence and data visualization, data warehousing in business intelligence, business intelligence & data warehousing, data warehousing and business intelligence course, data warehousing for business intelligence specialization github, business intelligence and data analytics, what is business intelligence and data warehousing, data warehousing for business intelligence

Leave a Reply

Your email address will not be published. Required fields are marked *