Design Tip #178 Tried and True Concepts for DW-BI Success

Time marccropped-cropped-filo01_cartoonized_42.jpghes on and soon the collective retirement of the Kimball Group will be upon us. At the end of 2015 we will all retire. In my final Design Tip, I would like to share the perspective  for DW/BI success I’ve gained from my 26 years in the data warehouse/business intelligence industry. By Bob Becker – © Kimball Group. All rights reserved.

Continue lendo »

Design Tip #177 Final Word of the Day: Collaboration

By Margy Ross© Kimball Group. All rights reserved.

For cropped-filo01_cartoonized_4.jpgmy final Design Tip, I’m returning to a fundamental theme that’s not rocket science, but too often ignored: business-IT collaboration. If you buy into the proposition that the true measure of DW/BI success is business acceptance of the deliverables to improve their decision-making, then buying into the importance of collaboration should be easy. Achieving business adoption is a pipedream if the IT resources on a DW/BI team don’t collaborate with their business counterparts. Likewise, the business needs to be willing to collaborate with IT.

Continue lendo »

Design Tip #176 Dimensional Models – Logical or Physical?

Dimensional data models have been around for a very long time, almost certainly trcropped-cropped-filo01_cartoonized_42.jpgacing their lineage back to the original Data Cube project between Dartmouth and General Mills in the late 1960s. The appeal of dimensional modeling stems from the obvious simplicity of the models and the natural way in which both business people and technical folks can understand what the models mean. By Ralph Kimball – © Kimball Group. All rights reserved.

Continue lendo »

Design Tip #175 There is No Database Magic

An ever-growing set of data storage technologies offer advantages to the data warehouse architect that look pretty magical. How can you figure out what to do? Should you stick to the tried-and-true relational cropped-cropped-filo01_cartoonized_42.jpgdatabases to host your data warehouse? Should you use cubes? Or should you move to the latest and greatest data management solutions like the massively parallel processing (MPP) or columnar solutions? Or to the cloud?   By Joy Mundy  © Kimball Group. All rights reserved.

Continue lendo »

Design Tip #174 Does Your Organization Need an Analytic Sandbox?

cropped-cropped-filo01_cartoonized_42.jpgCountless organizations have created mature dimensional data warehouses that are considered tremendous successes within their organizations. These data warehouse environments support key reporting and analysis requirements for the enterprise. Many are capable of supporting self-serve data access and analysis capabilities for disparate business users. By Bob Becker – © Kimball Group. All rights reserved.

Continue lendo »

Design Tip #171 Unclogging the Fact Table Surrogate Key Pipeline

cropped-cropped-filo01_cartoonized_42.jpgWe characterize the ETL system as a back room activity that users should never see nor touch. Even so, the ETL system design must be driven from user requirements. This Design Tip looks at the design of one bit of ETL plumbing – the fact table surrogate key pipeline – from the perspective of business users’ needs. By Joy Mundy © Kimball Group. All rights reserved.

Continue lendo »

Os números de 2014

Os duendes de estatísticas do prepararam um relatório para o ano de 2014 deste blog.

Aqui está um resumo:

A sala de concertos em Sydney, Opera House tem lugar para 2.700 pessoas. Este blog foi visto por cerca de 31.000 vezes em 2014. Se fosse um show na Opera House, levaria cerca de 11 shows lotados para que muitas pessoas pudessem vê-lo.

Clique aqui para ver o relatório completo