Posts by EmoryDay
Dynamic Mapping Using a Copy Activity Within Azure Synapse Analytics
If you’ve ever encountered issues with corrupt file types, or encoded files that aren’t supported on the destination end of an Azure Synapse data pipeline, you won’t want to miss this video. In this latest Tech Talk Thursday video, Ray Marquina, one of OmniData™’s top Azure Synapse pipeline gurus, walks you through the process. See…
Read MoreHow to Configure API Pagination within Azure Synapse Pipeline
API pagination can be an exceptional data display and analytics tool. This is especially true in Azure Synapse pipelines. But using REST APIs can get a bit confusing and tricky sometimes. In this short video, we’ll explain and walk you through the process, screen-by-screen, using some simple but powerful tools and techniques. You’ll learn how…
Read MorePower BI Tips & Tricks: Group Values
Are you building back-end fields, over and over, to group existing data points for additional reports in Power BI? Or maybe you’re adding a new column in the database when you want to create a new report group? Did you know you can create new groups and information-packed reports with a few mouse clicks instead?…
Read MoreHow to Create a Metadata Driven Pipeline using Azure Synapse Analytics
This Tech Tip from OmniData™ Principal Solutions Architect Ray Marquina is perfect for beginners as well as advanced data analytics professionals who want to understand large information processing pipelines in Azure Synapse. You’ll learn the essentials of creating a data pipeline and moving large amounts of information from the source database to the destination, such…
Read MoreHow to Use Switch Activity Within Azure Synapse Analytics
Using Switch Activity in Azure Synapse Analytics, located in “Activities” under “Iterations and Conditionals,” will provide you with the same functionality as using a switch statement in most programming languages. Switch Activities, built in Synapse Studio, will evaluate a set of activities corresponding to a created “case” that matches the condition evaluation you defined in…
Read MorePower BI Tips & Tricks: Faster Power Query
Extracting relevant, insightful business information from your critical data sources is significantly streamlined with Power BI using Power Query. But Power Query can be slow, especially if you’re capturing information from multiple databases, tables, and other sources in Azure. Streamline your ETL, or data Extract, Transform, and Load operations in Power Query with a few…
Read MoreHow to Setup Notifications Within Synapse Pipelines With Logic App
Have you ever wished you could have been notified when you had an Azure Synapse Pipeline fail? If so, you don’t want to miss this Tech Tip from OmniData™’s Principal Solutions Architect, Ray Marquina. Sure, you can always log into the Azure portal to check pipeline activity, but that’s a manual, time-consuming process. This tip…
Read MorePower BI Tips & Tricks: Field Parameters
Have you ever had information overload, aka TMI (too much information!) when generating graphical reports in Power BI? If so, you’re not alone. What you probably didn’t realize is that you can significantly simplify and consolidate your charts, graphs, and other graphical data insights with Field Parameters in Power BI. That’s right, and you’ll learn…
Read MoreHow to Leverage Variables within Azure Synapse Analytics
In today’s Tech Talk Thursday video, OmniData™’s Ray Marquina, Principal Solutions Architect, shares how to leverage variables within Azure Synapse Analytics. More specifically, he’ll look at how you can increment a variable within an iteration activity. Data integration, enterprise data warehousing, and big data analytics are all combined into a limitless analytics solution with Azure…
Read MorePower BI Tips & Tricks: Themes
Formatting in Power BI got you down? Are you getting bogged down with redoing your charts, graphs, and graphical insights from scratch? Too many formatting changes and too many file saves every time you generate a report or presentation? If you answered yes to that question, you’ve come to the right place. Our Power BI…
Read More