Is Your BI Strategy Cost Effective?
Have you looked at your BI spend recently? Sometimes, I’m puzzled by the enormous spending in “this is how we’ve always done it” initiatives that probably could be replaced and […]
Author Archive for: Prologika
Entries by Prologika - Teo Lachev
Presenting for Steel City SQL User Group, Birmingham
I’m presenting in person “What’s New for BI in SQL Server 2016” for the SQL User Group in Birmingham, AL tomorrow, July 19th starting at 6 PM local time. Steel […]
Aggregates over Aggregates in DAX
Sometimes, you might run into a scenario that requires an aggregate over an aggregate. Consider the following report: The AvgOrderAmount has a simple calculation: SUM(Sales)/SUM(Qty). This calculation is applied uniformly. The […]
Upgrading Power BI Desktop Models to Tabular
One great feature of Microsoft BI has been the continuum from personal BI to organizational BI. For example, a business user can start small with an Excel Power Pivot model […]
Implementing Qlik-style Variables in DAX
A large publicly-traded organization is currently standardizing on Power BI as a single BI platform as a replacement of Qlik and Tableau. They analysts have prepared a gap analysis of […]
Presentation for SQL Saturday Chattanooga
SQL Saturday Chattanooga will take place on June 25st at UT Chattanooga EMC Building, 784 Vine Street, Chattanooga, Tennessee, 37403, United States. Your humble correspondent will sponsor the event and […]
Power BI Quick Calculations
DAX is very powerful but it could entail a steep learning curve for novice users. Power BI Desktop has started on the road of delivering pre-packaged calculations. The first one […]
Prologika Newsletter Summer 2016
Why Choose Power BI as BI Platform Are you deciding which BI platform to adopt? With so many vendors and products, you are not alone and the choice is far from […]
ADOMD.NET Connection Pooling
I helped a customer to implement ADOMD.NET connection pooling with the goal to increase significantly the query throughput. Their predictive service platform had to scale to thousands of queries per […]
Applied MDS and DQS Training Class Available
In my opinion, every mid-size to large organization should have a solution for master data management. Based on my observations, data quality issues have reached a pandemic level. Ironically, putting 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.
