Implementing a Default Date Filter in Tabular and Power BI
Problem: A long standing limitation in Analysis Services Tabular and Power BI is the lack of default members, such as to default a Date dimension to the last date with […]
Author Archive for: Prologika
Entries by Prologika - Teo Lachev
Determining Power BI Relationships
Problem: Consider the following Power BI report that shows the sum of ResellerSales[SalesAmount] by SalesTerritory[SalesTerritoryCountry], Employee[FullName], and ResellerSales[SalesOrderNumber]. This report is based on the following schema consisting of three tables. […]
MVP For 15 Years!
Got awarded for Microsoft Most Valuable Professional (MVP) – Data Platform again. This will make my 15th consecutive year to be recognized by Microsoft for my expertise and contributions to […]
Beware Fast Columnar Databases
A large company uses the SAP HANA ERP system. Users requires real-time access to transactional data. To avoid performance degradation, SLT replication (trigger-based change data capture) replicates data to another […]
Prologika Newsletter Summer 2018
Microsoft Common Data Services BI and data integration projects often benefit from an operational data source (ODS), whose benefits and design I discussed in my “Designing an Operational Data Store […]
Atlanta MS BI and Power BI Group Meeting on June 25
MS BI fans, join us for the next Atlanta MS BI and Power BI Group meeting on Monday, June 25th at 6:30 PM. Your humble correspondent will share 10 ways Power BI can […]
Common Data Service for Analytics: The Good, the Bad, the Ugly
UPDATE 11/15/2018: Common Data Service for Analytics is superseded by Power BI dataflows. Find the updated review here. In a previous blog I discussed the Common Data Service for Apps […]
Power BI Feature Discrepancies for Data Acquisition
Power BI churns out new features fast but not all features are available everywhere. As one of the most confusing aspects of Power BI, feature availability depends on the data […]
10 Ways to Empower your BI Strategy with Power BI
Standing room today for my presentation on the same subject at SQL Saturday Atlanta. I uploaded the slides to the event site and to my LinkedIn profile page. This week […]
Atlanta MS BI and Power BI Group Meeting on May 21
MS BI fans, join us for the next Atlanta MS BI and Power BI Group meeting on Monday, May 21st at 6:30 PM. Paco González will take us into a deep dive […]
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.
