Fixing Power View to SQL Server 2014 SSAS Multidimensional
Scenario: You have Power View integrated with SharePoint. You attempt to create a Power View report that connects to a SQL Server 2014 cube. The connection fails with “Internal Error: […]
Author Archive for: Prologika
Entries by Prologika - Teo Lachev
Top 10 Reasons for Choosing Microsoft Self-service BI
Every organization should have a strategy for self-service BI. As a rule of thumb, my advice is that 80% of the BI effort should be directed toward implementing organizational BI […]
Introducing the Reimagined Power BI Platform
Come and join us for an information-packed meeting of the Atlanta Microsoft BI Group on February 23th. You will learn about Power BI vNext and Panorama Necto. Our sponsor will […]
Filtering Tables Dynamically in DAX
Sometimes, your DAX calculated measures might need to filter a table dynamically based on a certain condition. For example, you might have a Type 2 table like this one: ClaimID […]
Finding Duplicates in DAX
A prerequisite for creating a relationship in Tabular/Power Pivot is to have a primary key column in the table on the One side of the relationship. This column must have […]
My Wish List for SQL Server.vNext
In an attempt to give customers more transparency, Microsoft recently published a Cloud Platform Roadmap. The product groups are also actively seeking feedback for the on-premise products (also known as […]
Microsoft is Serious about Statistical Analysis and Machine Learning
Microsoft announced two company acquisitions related to data analytics. It announced that it will acquire Revolution Analytics. Revolution Analytics is the leading commercial provider of software and services for R, […]
Demystifying Clustered Columnstore Indexes
Non-clustered columnstore indexes (NCCI) were introduced in SQL Server 2012 to improve the performance of large aggregate queries (common for data warehousing) with the caveat that there were read-only. Consequently, […]
Presenting at Atlanta.MDF
I’m presenting at the Atlanta.MDF group on Monday, January 12th. I’ll be covering a wide range of tips and techniques for analyzing and improving performance of SQL Server-based data analytics […]
SQL Server and 20 Cores Limit
Scenario: You execute a SQL Server 2012 task that uses parallelism, such as index rebuild or a query on a server with more than 20 cores running SQL Server 2012 […]
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.
