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 […]
Author Archive for: Prologika
Entries by Prologika - Teo Lachev
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: […]
SQL Server 2012 Semantic Search
Suppose your company has a web application that allows customers to enter comments, such as to provide feedback about their product experience. How do you derive knowledge from these comments? […]
Gartner’s 2013 Business Intelligence Magic Quadrant
Gartner released the 2013 BI Magic quadrant report. And the winner is…
Gartner’s 2013 Data Warehouse Magic Quadrant
MVP fellow, Andrew Burst, discusses Gartner’s newly released DW (not BI, mind you) magic quadrant. It looks like Gartner fell in love with Teradata but Microsoft is moving up as […]
Performance Degradation with the Aggregate Function and Unrelated Dimensions
I ran into a severe performance issue with the Aggregate function and unrelated dimensions which I reported on connect. In this context, an unrelated dimension is a dimension that doesn’t […]
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.
