Going with the Flow
Currently in preview, Microsoft Flow is a cloud service for creating automation flows without writing code, similar to Zapier’s “zaps” and IFTTT’s “recipes”. How is this useful for BI? Let’s […]
Author Archive for: Prologika
Entries by Prologika - Teo Lachev
Trend Lines in Power BI Charts
Recently, Power BI charts introduced trend lines. However, they require numeric or date values on X-axis, which must have a continuous type. In fact, if you use a text field […]
Happy Birthday, Power BI!
Power BI is one-year old. it’s hard to imagine that one year has passed but here we are. The momentum behind Power BI is huge both from development and customer […]
Atlanta MS BI Group Meeting on July 25th
MS BI fans, join me for the next Atlanta MS BI and Power BI Group meeting on July 25th at 6:30 PM. Shabnam Watson will teach you MDX fundamentals. Pyramid Analytics, our […]
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 […]
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 […]
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.
