Why an Analytical Layer?
I had a presentation on the BI Semantic Layer and Tabular modeling for the Atlanta BI Group on Monday. Midway during the presentation, a DBA asked why we need an […]
Author Archive for: Prologika
Entries by Prologika - Teo Lachev
Presenting at Atlanta BI Group
I’ll be presenting “The Analysis Services 2012 Tabular Model” for the Atlanta BI Group on Monday, May 21st. And, Darren Herbold will share some great insights harvested from a real-life […]
Analysis Services Processing and CXPACKET Waits
Performance tuning – my favorite! This blog originated from a quest to reduce the processing time of an SSAS cube which loads some 2.5 billion rows and includes DISCINTCT COUNT […]
SQL Server 2012 ETL Framework Features in the New SSIS Project Deployment Model
When moving to SQL Server 2012, ETL developers would need to rethink custom ETL frameworks. If you embrace the new project deployment model, SQL Server 2012 offers a lot of […]
Reducing Analysis Services Index Processing Time
Scenario: Processing a 100 GB SSAS 2012 cube on a dedicated DELL PowerEdge server (128 GB RAM with 32 logical cores) reveals that 50% of the time is spent on […]
Presenting at SQL Saturday
I have a talk “The Personal-Team-Organizational BI Conundrum” at SQL Saturday on April 14th at 9 AM. Confused about the BI alphabetical soup? Not sure which one makes sense for […]
Report Builder Connectivity Issues
Issue: Previewing a Report Builder report connected to Analysis Services works in Report Designer but it fails in Report Builder 3.0 with the following error: An existing connection was forcibly […]
Finding Source Column Names in PowerPivot
Question: How do I find the source column name in PowerPivot if I’ve renamed and moved columns around? Answer: Assuming that the table doesn’t use a custom query to import […]
VertiPaq Rebranded as xVelocity
Apparently, the name “VertiPaq” wasn’t catchy enough so Microsoft rebranded it as xVelocity (probably got tipped by Comcast). This is just a name change, no new features. Glossary xVelocity: The […]
BIDS Helper 1.6 Beta Released
Fellow MVPs have just released the latest public beta build of BIDS Helper, which should one of the first utilities you install after you install SQL Server on your machine. […]
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.
