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 […]
Author Archive for: Prologika
Entries by Prologika - Teo Lachev
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 […]
Solving Laptop Overheating Problems
Off the BI path but I wanted to save this tip for future generation and my sake in case I forget and I run into the same issue in Windows.NEXT […]
Power BI Expands Microsoft Cloud Self-service BI
Expanding its Office 365 feature set, Microsoft introduced Power BI. Power BI is an umbrella name of the following BI offerings in the cloud: Power Pivot, PowerView, Power Query (previously […]
PerformancePoint Display Condition Not Working
Issue: A client reports an issue with our PerformancePoint dashboard where the clicking a KPI in the scorecard doesn’t show the supporting analytical grid. Normally, when the user clicks a […]
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.
