Newsletter
-
PROLOGIKA NEWSLETTER SUMMER 2023 (Fast Track to ERP Analytics)
June 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...
-
Prologika Newsletter Spring 2023 (Data Lakehouse: The Good, The Bad, and the Ugly)
March 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...
-
Prologika Newsletter Winter 2022 (What Exactly is Synapse?)
December 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...
-
Prologika Newsletter Fall 2022 (Power BI Datamarts: The Good, The Bad, and the Ugly)
September 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...
-
Prologika Newsletter Summer 2022 (Hosting Semantic Models to AAS)
June 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...
-
Prologika Newsletter Spring 2022 (Data Integration Options with Cloud Providers)
March 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...
-
Prologika Newsletter Winter 2021 (Virtualizating Data with PolyBase)
December 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...
-
Prologika Newsletter Fall 2021 (The US Largest Laboratory Network Gets Consolidated Reporting)
September 11, 2021
LabCorp operates one of the largest clinical laboratory networks in the world. It also has an Interactive Response Technology system that healthcare vendors can use to conduct case studies. Thanks to the cloud data analytics solution implemented by Prologika, LabCorp...
-
Prologika Newsletter Summer 2021 (First Look at Power BI Goals)
June 19, 2021
Business Performance Management (BPM) is a methodology to help the company predict its performance. An integral part of a BPM strategy is creating and monitoring a scorecard with Key Performance Indicators (KPIs). In this newsletter, I’ll discuss how the newly...
-
Prologika Newsletter Spring 2021 (State Health Department Gains Reliable and Rapid Insights)
March 13, 2021
Amidst the COVID pandemic, the Houston Health Department (HHD) had another predicament to tackle. With lab results accumulating rapidly at one million cases per month, the vendor system they used for capturing and analyzing COVID data couldn't keep up. In...
