Power BI (Part 1 – Getting Started)
Microsoft BI has been criticized about its complexity and price because it requires SharePoint Server Enterprise for deploying Power Pivot models and dashboards. Microsoft introduced Office 365 (E3 or E4 plan […]
Author Archive for: Prologika
Entries by Prologika - Teo Lachev
DQS Error after CU Upgrade
I installed SQL Server 2012 SP1 CU5 and I got greeted with the following error while opening Data Quality Services DqsInstaller.exe can be found by default in the C:\Program Files\Microsoft […]
Does Self-service BI Make Sense?
Besides data messiness (in direct proportion with the company size), another common data-related challenge that every organization nowadays is trying to tackle is how applicable self-service BI is to their […]
Speaking at SQL Server Innovators Guild
I’ll be speaking at the SQL Server Innovators Guild group in Greenville, SC on September 3rd. If you happen to be in the area, please join us to learn best […]
Semantic Layer Flavors
Semantics relates to discovering the meaning of the message behind the words. In the context of data and BI, semantics represents the user’s perspective of data: how the end user […]
DAX Variance Calculations
Variance calculations are a common BI requirement but good reference material is lacking. How do we create them in DAX? Let’s say you need to calculate the variance between this […]
Refreshing Excel File in PowerPivot from SharePoint
A couple of SharePoint-related questions from students taking my PowerPivot class that are worth sharing. Question: Can I import data from and auto-refresh an Excel file deployed to a SharePoint […]
Analysis Services Relationship Limitations and Workarounds
Relationships in analytical models (Multidimensional and Tabular) are both a blessing and a curse. Once defined by the modeler, relationships power “slicing and dicing” data. The analytical tool doesn’t have […]
Performance Tuning of Tabular Models in SQL Server 2012 Analysis Services
A really impressive white paper/book with insights about Tabular performance and inner-workings. Kudos to the authors for producing this colossal resource. “Tabular models hosted in SQL Server 2012 Analysis Service […]
Speaking at Atlanta Code Camp
I’ll be speaking at Atlanta Code Camp on August 24th. Given the developer-oriented nature of the event, I settled on a more code-intensive topic: Real-time BI with StreamInsight. “So, you […]
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.
