Posts by EmoryDay
How to Automatically Update Partitions in Power BI Semantic Models
Often when working with large semantic models, we see fact tables with many partitions. A common pattern is to partition by a date grouping (ie month, quarter, etc). Partitioning a fact table this way can provide many benefits: greater control over refreshes, faster refresh times, ability to re-run specific partitions if needed. This approach also…
Read MoreTransform Your Data Insights: Unleash the Power of OmniAnalytics D365 Business Central
Specifically built for Business Central and powered by Microsoft Fabric, OmniAnalytics™ offers a game-changing solution that will transform the way you work with data. With user-friendly data models and dozens of pre-built reports, it provides the fastest and most efficient path to achieving enterprise-grade analytics. We have provided a series of videos to share how…
Read MorePower BI Dataset Refresh Part 2 – Confirming a Dataset Refresh
Welcome to Part Two of this two-part video series on dataset refresh from Power BI within our Synapse Analytics pipeline using Power BI REST API presented by OmniData™’s Principal Solutions Architect, Ray Marquina. In this second video of our two-part series, we will be exploring how to check the status of whether or not a…
Read MorePower BI Dataset Refresh Part 1 – Trigger a Dataset from Power BI using REST API
Welcome to another two-part series for Tech Talk Thursday hosted by Ray Marquina, OmniData™’s Principal Solutions Architect. In this series, we will be exploring how we can trigger a dataset refresh from Power BI within our Synapse Analytics pipeline using Power BI REST API. In this Part One video, we will be exploring the following:…
Read MoreElevate your Business Central Reporting: Modern Data Architecture for Analytics
Business Central helps companies take a major leap in the depth of processes they can automate, as well as the data available for analysis. But what is the right solution for your business? “Over the last five to ten years, there has been a pretty massive level of innovation – which is great and that’s…
Read MoreBuild a Synapse Pipeline Part 3: Full and Incremental Refresh / Building a Notebook
Welcome to Part Three of this three-part video series on creating a pipeline to handle both full and incremental refreshes in Azure Synapse presented by OmniData™’s Principal Solutions Architect, Ray Marquina. In Part One, we created our control table using Delta Lake. In Part Two, we left off with building our initial pipeline and ended…
Read MoreBuild a Synapse Pipeline Part 2: Expanding on Control Tables
Welcome to Part Two of this three-part video series on creating a pipeline to handle both full and incremental refreshes in Azure Synapse presented by OmniData™’s Principal Solutions Architect, Ray Marquina. In Part One, we created our control table using Delta Lake. If you missed Part One, please check out that video because it is…
Read MoreBuild a Synapse Pipeline Part 1: Handle Full and Incremental Refreshes Using Delta Lake Control Tables
What exactly is Delta Lake and how can you use it to build Azure Synapse Pipelines for full and incremental loads? Find out in Part One of a three-video series describing the step-by-step process. In today’s Tech Talk, OmniData™’s Principal Solutions Architect, Ray Marquina, will discuss an architecture using Azure Data Lake as the storage…
Read MoreUnderstanding Business Central Reporting Challenges and Overcoming Reporting Limitations in Microsoft Dynamics 365
Discover the challenges of reporting in Microsoft Dynamics 365 Business Central (D365) and learn how OmniData™ can help you overcome reporting limitations.
Read MoreExplore the “If” Condition Within Azure Synapse Pipelines
Don’t miss this tutorial for beginners just learning about Azure Synapse Pipeline configurations and analytics. This tutorial builds on the concept of using Switch statements to do conditional evaluations in Synapse Pipelines. You can check out that short video in a previous Tech Talk Thursday. In this video, Ray Marquina, our Principal Solutions Architect, will…
Read More