PROLOGIKA NEWSLETTERS
Browse the archive for practical insights into Microsoft data analytics and the decisions behind successful solutions.
Back to CommunityMarch 15, 2024
One of the main goals and benefits of a semantic model is to centralize important business metrics and KPIs, such as Revenue, Profit, Cost, and Margin. In Power BI, we accomplish this by crafting and reusing DAX measures. Usually, implementing most of these metrics is…
Read newsletterDecember 18, 2023
I’ve covered my first impression about Microsoft Fabric in a series of blogs starting with this one. In the recap, I said that certain features might benefit organizations that are already on Power BI Premium because all Fabric features are available in Power BI Premium…
Read newsletterSeptember 16, 2023
Microsoft Fabric is upon us with a grand fanfare. You can get a good overview of its vision and capabilities by watching the Microsoft Fabric Launch Digital Event (Day 1) and Microsoft Fabric Launch Digital Event (Day 2) recordings. Consultants and experts are extolling its…
Read newsletterJune 11, 2023
Enterprise Resource Planning (ERP) systems capture a wealth of information from main business processes within an organization, such as Sales, Inventory, Orders, etc. Therefore, a BI journey typically starts with analyzing the ERP data, with revenue analytics usually taking the center stage because of its…
Read newsletterMarch 4, 2023
There has been a lot of noise surrounding a data lakehouse nowadays, so I felt the urge to chime in. In fact, the famous guy in cube, Patrick LeBlanc, gave a great presentation on this subject to our Atlanta Power BI Group and you can find the…
Read newsletterDecember 9, 2022
A few days ago an exalted customer shared that they've acquired Synapse and now they're ready for Power BI modeling. He just wasn't sure how to give business users access to Synapse so cool self-service BI can finally start. In the process of the conversation,…
Read newsletterSeptember 17, 2022
BI implementation shortcuts are tempting and disguise themselves as cost-effective. True, you can slap a Power BI dataset on top of your data (the cornerstone of self-service BI), but most BI implementations will greatly benefit from a datamart, irrespective of the propaganda of self-service BI…
Read newsletterJune 12, 2022
The workhorse of any modern BI solution is the semantic model that provides unparallel performance and contains business logic and security roles. Microsoft BI gives us three options to host semantic model: SQL Server Analysis Services (SSAS), Azure Analysis Services (AAS), and Power BI. This newsletter…
Read newsletterMarch 13, 2022
Nowadays, it’s unlikely to envision a data analytics solution without ingesting data from some cloud vendor. Unfortunately, as many of you have found out the hard way, moving to the cloud, such as moving your on-prem ERP system to the vendor's cloud offering, comes at…
Read newsletterDecember 20, 2021
Happy Holidays! More and more organizations consider data virtualization to abstract the underlying storage and integrate siloed sources. In this letter, I'll discuss a real-life project that used PolyBase to expose third-party ERP data as SQL tables. Before I get to the subject of this…
Read newsletter
