Newsletter
Prologika Newsletter Spring 2024 (DAX Visual Calculations)
March 15, 2024 / No Comments »
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...
Prologika Newsletter Winter 2023 (Dataverse Link to Fabric)
December 18, 2023 / No Comments »
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...
Prologika Newsletter Fall 2023 (A First Look at Microsoft Fabric: The Good, the Bad, and the Ugly)
September 16, 2023 / No Comments »
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...
PROLOGIKA NEWSLETTER SUMMER 2023 (Fast Track to ERP Analytics)
June 11, 2023 / No Comments »
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...
Prologika Newsletter Spring 2023 (Data Lakehouse: The Good, The Bad, and the Ugly)
March 4, 2023 / No Comments »
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...
Prologika Newsletter Winter 2022 (What Exactly is Synapse?)
December 9, 2022 / No Comments »
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...
Prologika Newsletter Fall 2022 (Power BI Datamarts: The Good, The Bad, and the Ugly)
September 17, 2022 / No Comments »
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...
Prologika Newsletter Summer 2022 (Hosting Semantic Models to AAS)
June 12, 2022 / No Comments »
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...
Prologika Newsletter Spring 2022 (Data Integration Options with Cloud Providers)
March 13, 2022 / No Comments »
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...
Prologika Newsletter Winter 2021 (Virtualizating Data with PolyBase)
December 20, 2021 / No Comments »
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...
