Videos
Tech Talk Thursday: How 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 MoreTech Talk Thursday: How 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 MoreTech Talk Thursday: How 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 MoreTech Talk Thursday: How 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 MorePower BI Tips & Tricks: Pro Formatting
Have you ever looked at your Power BI reports and thought they looked a little bland? Now you can make your Power BI presentation graphics sizzle with this information-packed 90-second video about Pro Formatting. Our Power BI Tips & Tricks expert-of-the-day shows you how to take simple reports, and with some quick formatting, transform them…
Read MorePower BI Tips & Tricks: Concatenate
Have you ever generated a chart, and the headings were way too long? Learn how to use the concatenate feature to make your charts look great! Power BI is packed with data-enhancing tools and techniques to help you make your graphical information more user-friendly and human-readable, but sometimes these tools can get complicated. Concatenation, or…
Read MorePower BI Tips & Tricks: Small Multiples
It’s time to become a Power BI Chart Wizard with the latest expert tip of the day on Power BI Tips & Tricks. Let’s explore Small Multiples! Have you ever tried to pack so much information into a line chart that you can’t read it when you’re done? All those awesome, informative data insights are…
Read More