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 […]
Author Archive for: Prologika
Entries by Prologika - Teo Lachev
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 […]
PowerPivot Data Refresh in Excel 2013
What options does a PowerPivot user have to refresh data in a PowerPivot model on the desktop, aka PowerPivot for Excel? Prior to Excel 2013, the answer was just one […]
PerformancePoint 2013 Dependencies for Analysis Services
Besides the usual hassle configuring PerformancePoint, including insufficient permissions to databases and service accounts, version 2013 requires the SQL Server 2008 R2 drivers. This is surprising considering that SharePoint 2013 […]
The SharePoint 2013 Business Intelligence Center
Where should I put my BI reports? Should I upload them to department-level SharePoint sites or put them in one place? These are common questions that we get from customers. […]
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.
