Multi-level Column Unpivoting with Power Query
An interesting challenge today come up while mentoring finance users in Power BI. Consider the following Excel layout. The user wants to unpivot the data by rotating the three header rows […]
Author Archive for: Prologika
Entries by Prologika - Teo Lachev
Prologika Newsletter Summer 2019
After learning how to model the data properly (the most important skill), DAX would be the next hurdle in your self-service or organizational BI journey. You won’t get far in […]
Power BI Sharing is Getting Better 2
We had to wait four years but here they are: Power BI shared datasets are here. This makes it a good time to revisit the remaining Power BI sharing limitations, which […]
Power BI Palooza
May was a hectic month but June is even busier… I’m presenting and sponsoring the tomorrow’s Power BI Group meeting and teaching a class on Tue and Wed. Then, on […]
Atlanta MS BI and Power BI Group Meeting on June 3rd
MS BI fans, join us for the next Atlanta MS BI and Power BI Group meeting on June 3, Monday, at 6:30 PM at the Microsoft office in Alpharetta. I’ll show you how to […]
“Applied DAX with Power BI” Book Available
I’m excited to announce my latest book: “Applied DAX with Power BI: From zero to hero with 15-minute lessons“. This book was born out of necessity. In my consulting practice, […]
Presenting at SQL Saturday Atlanta on May 18
SQL Saturday Atlanta next Saturday might break the attendance record with over 900+ people registered! Kudos to the organizers. It’s not easy to organize an event of this size with […]
Fixing Random Problems with DAX
Scenario: You have a dimension table and a fact table, and you want to generate some test data, such by randomly looking up a value from the dimension table for […]
APPLIED DAX WITH POWER BI
(From zero to hero with 15-minute lessons)
Start your self-paced DAX study today and get from zero to hero in a month! Publication date: May 10, 2019 Size: 220 pages, 7.5″ x 9.25″ Price: $34.99 ISBN 10: 1-7330461-0-0 […]
Another Successful BPM Solution
Business Performance Management (BPM) is a methodology to help the company predict its performance. An integral part of a BPM strategy is a process for Budgeting, Planning, and Forecasting which […]
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.
