Tags » Data Model

Managing empty tables

Does your database have a lot of empty tables of (potentially) unknown origin? While the returned space is usually insignificant, there are some simple things you can do to help manage these. 441 more words


A Thousand Exponentially Smaller Hyper-sausages: a Toy Model for Learning Certain Complex Problems

The Toy Model

First consider the following toy problem:

  • the input data distribution is a mixture of very many components (e.g. gaussians) with relative sizes decreasing very fast.
  • 533 more words
Sin Categoría

Configuring PowerPivot for SharePoint

This week I was working on generating some reports using Excel 2013, Power Query, PowerPivot and then I wanted to publish them to SharePoint. Unfortunately our server wasn’t ready for it so I went through the process of installing PowerPivot for SharePoint (existing SharePoint) so my data connections in Excel workbooks (Data Models and PowerPivots) could be refreshed correctly. 166 more words


Application Data Model

Well, now the window dressing is in place we turn our attention to the core of the application, the ship data and how we want to manage the information. 1,379 more words


SSAS Multidimensional cube: How to solve duplicate attribute key error when attribute is non key?


In SSAS multidimensional cube, while processing a cube, you get an error/warning for a non-key “price” column that says:

Errors in the OLAP storage engine: A duplicate attribute key has been found when processing: Table: ‘Table Name’, Column: ‘Price’, Value: ’29′.

96 more words
Microsoft Business Intelligence

Change Management Systems - Is There a Better Way?

There is no denying that plant floor automation can dramatically improve efficiency and increase productivity, but there is an unintended consequence of automation that can make it problematic. 1,013 more words

Datawarehouse modelling: Inmon vs Kimball

If you’re into business intelligence, data warehousing and analytics, you will have heard an endless number of references to Bill Inmon and Ralph Kimball. These two figureheads in datawarehousing architecture have produced an immense number of books, articles, training seminars, etc. 636 more words

SQL Server Concepts