About Tableau 8
Jen Underwood highly recommended I attend the Tableau 8 tour on Tuesday to witness firsthand its new features. Naturally, I couldn’t resist of comparing everything I saw with Microsoft BI. […]
Author Archive for: Prologika
Entries by Prologika - Teo Lachev
Data Warehouse Physical Design Best Practices Session by Carlos Rodrigues at Atlanta BI Tonight
It looks like Carlos will deliver another slam tonight with a record number of some 63 people registered and counting… Join our Atlanta BI meeting at 6:30 to see his […]
Query Options for Analytical Models and Transactional Reporting
Requesting both historical and transactional reports is a very common requirement. As they stand, neither Multidimensional nor Tabular are designed to support well transactional (detail-level) reporting with large datasets, as […]
Transactional Reporting with Tabular
Scenario: We had a requirement to replace the existing implementation of transactional reporting over large data volumes. By “transactional reporting” I mean allowing the user to query individual transactions as […]
Improving Tabular Design Experience
When you develop an organizational Tabular model in SSDT, there is always an implicit processing phase for each action you perform, such as renaming columns, creating hierarchies, changing formatting, and […]
When Developers and BI Collide
I’ve been running in this situation quite often so I thought this will make a good topic for a blog. Scenario: Management has asked for some sort of a BI […]
Adding a Set Total
Scenario: You have defined an MDX set in the cube script, such as a set that returns a few months. For the sake of simplicity, we will hardcode the months. […]
Optimizing Massive SQL Joins
Scenario: Run ETL to perform a full data warehouse load. One of the steps requires joining four biggish tables in a stating database with 1:M logical relationships. The tables have […]
CU2 for SQL Server 2012 SP1
Microsoft released a while back a cumulative update 2 for SQL Server 2012 SP1. Besides other things, it includes a fix for the “wide” MDX query performance degradation issue with […]
Nevron Chart for Reporting Services
Nevron was kind enough to show me their chart and gauge for Reporting Services. In certain areas, their products exceed the charting capabilities of Reporting Services. Here are the highlights: […]
Follow Us
Prologika is a boutique consulting firm that specializes in Business Intelligence consulting and training. Our mission is to help organizations make sense of data by applying effectively BI technologies.
