TV Show Broadcast Watch Data

The analysis of TV broadcast is performed using a highly detailed database that contains, at the minute level, which channel a subject is looking at. This database let the analyst look at the behavior of people, whether the same people looks at the same channel over time and so on. The detailed relational database is then used to feed some OLAP cubes. The customer (one important TV broadcast company in Italy) called us because they had problems on both ETL and query time with their SSAS cube. Read more...

Inventory Calculation

The customer, a steel manufacturing company, has a Dynamics NAV (formerly known as Navision) customized solution and implemented a complete data analysis system based on Analysis Services to analyze Sales, Production and Purchases. A new requirement was the analysis of the inventory over the time, both in terms of quantity and value. An important part of the issue was that the steel price changes each day in the commodities market, and this has strong implications over certain calculations of the inventory value. The end users were used to query cubes using Excel, thus another requirement was to create an Inventory cube in Analysis Services.  Read more...