Looking for Talent
We have two contract positions in Alpharetta, GA. Contact us at info@prologika.com if you are interested. BA ANALYST (4-MONTH CONTRACT) Reviews, analyzes, and evaluates business systems and user needs. Documents […]
Author Archive for: Prologika
Entries by Prologika - Teo Lachev
Applied Excel and Analysis Services e-Learning Course Available
BI solutions typically include a semantic layer. In Microsoft BI, the role of a semantic layer is fulfilled by Multidimensional cubes or Tabular models, whose virtues I extolled in this […]
Optimizing Distinct Count Excel Reports
I wonder how many people believe that Tabular DistinctCount outperforms Multidimensional judging by Excel reports alone. In this case, an insurance company reported a performance degradation with Excel reports connected […]
MVP for 11 Years
Microsoft awarded me again with the Most Valuable Professional (MVP) Award for SQL Server. This is an annual award given to selected individuals worldwide in recognition for their expertise and […]
Atlanta MS BI Group Meeting on Sep 29th
Join us on Monday, September 29th for our meeting of Atlanta MS BI Group to learn about DAX – the programming language of Power Pivot and Tabular. Presentation: DAX 101 […]
Investigating Deadlocks
Two different customers having deadlock issues. The first one is having deadlock issues happening during DML operations in an OLTP database. The second one – during ETL load of a […]
Atlanta MS BI Group Meeting on Aug 25th
Join us tonight for a knowledge-packed meeting of Atlanta MS BI Group to learn how to optimize and automate your ETL. Presentation: Making your SSIS Fly Beyond the Sky […]
Where is SSDT?
Now that Microsoft has decoupled SQL Server Data Tools from the SQL Server 2014 setup, the quest to find SSDT has started. You can download SSDT from the Microsoft SQL Server […]
SSRS Style Templates
As you probably know, the SSRS Report Wizard allows users to select predefined report styles. These styles are basic “skins” that apply to report foreground and background colors. A question […]
Absolute Tabular KPIs
An interesting requirement popped up during an Analysis Services class I’m teaching this week. The customer wants to implement a Tabular/PowerPivot KPI that has this pseudo logic: CASE WHEN Actual […]
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.
