Ten Mistakes to Avoid In Dimensional Modeling

Ten Mistakes to Avoid In Dimensional Modeling: Asset

 

By Christopher Adamson

To attain the full potential of your dimensional model, it is necessary to master a broad range of principles, understand how and what to model, and avoid lapsing into habits from other modeling disciplines. A dimensional model of your business is an important asset of your BI program. Maximize its value by avoiding these 10 mistakes.

File Type: .pdf


 

Related Items: To download additional items, select those you are interested in and click the submit button at the bottom of the page. You will be able to download the current item and any additional items you select.

BI Journal V21, Number 3 cover image

Business Intelligence Journal | Vol 21 No 3: Business Intelligence Journal Vol 21 No 3

No matter how advanced your technology stack, BI success is as much about people and processes as it is about processing speed. This issue of the Business Intelligence Journal takes a closer look at several different ways to solve the people problems that occur in data management and analytics programs, from improving inefficient organizational structures to saving a faltering self-service initiative.


Infographic // Improving Data Preparation for Business Analytics: Download

Business users want the power of analytics—but analytics can only be as good as the data. The biggest challenge nontechnical users are encountering is the same one that has been a steep challenge for data scientists: slow, difficult, and tedious data preparation. The increasing volume, variety, and velocity of data is putting pressure on organizations to rethink traditional methods of preparing data for reporting, analysis, and sharing. In the recent TDWI Best Practices Report: Improving Data Preparation for Business Analytics, we take a look at experiences with data preparation, discuss goals and objectives, and uncover how to take advantage of the rapidly evolving technology and self-service capabilities that allow business users to realize insights from data faster. Here are several of the key survey results.


Ten Mistakes to Avoid in NoSQL: Download

 

By William McKnight

For companies seeking to exploit data to their advantage, NoSQL is a perfect storm of need and solution. Nevertheless, its implementation isn't without hurdles. When reviewing successes and failures, it is clear that some good practices have been overlooked. This Ten Mistakes to Avoid identifies the mistakes with the biggest impact on NoSQL implementation success and recommends applicable solutions.