Introduction to Data Integration in Azure Synapse Analytics

2022

TL; DR

In this session, we will go through Pipelines, Data Flows, and Notebooks to see how easy it is to ingest and transform data in Azure Synapse Analytics.

Session Details

Do you regularly need to get data for your projects? Yep! 🙋‍♀️ Data is at the core of every Business Intelligence, Data Science, and Machine Learning project. You need data to understand what has happened in the past, to predict what may happen in the future, to discover patterns and anomalies, and to gain the insight necessary for making faster and better decisions. But before you can do any of those things, you need to ingest, store, transform, integrate, and prepare your data. Guess what? You can do all of those things in Azure Synapse Analytics - with or without having to write any code! In this session, we will cover the fundamentals of data integration in Azure Synapse Analytics. First, we will discuss when Azure Synapse Analytics is the right tool of choice. Then, we will go through what Pipelines, Data Flows, and Notebooks are, and when to use them. Finally, we will see how easy it is to ingest and transform data starting from samples or from scratch.

3 things you'll get out of this session

Cathrine Wilhelmsen's previous sessions

Website Analytics in My Pocket Using Microsoft Fabric

Join this session to see how easy it is to create a pocket-sized dashboard for your website analytics. First, learn how to automatically collect statistics from an API and store it in a central location. Then, see how quickly you can visualize the data in a mobile-friendly way using Power BI. 📈

Choosing between Microsoft Fabric, Azure Synapse Analytics and Azure Data Factory

Learn the pros and cons of Microsoft Fabric, Azure Synapse Analytics and Azure Data Factory, and how to choose the right Data Integration solution for your project.

"I can't keep up!" - Turning Discomfort into Personal Growth in a Fast-Paced World

Are you struggling to keep up with all the latest product changes and new technologies? Awesome! That means you have ambitions. You can do anything if you set your mind to it. It just might not be easy. Are you ready to turn your "I can't keep up" into "I can't believe I did all of that in just one year"?

Stressed, Depressed, or Burned Out? The Warning Signs You Shouldn't Ignore

Stress barges through your door and yells "hey, it's me!", while depression and burnout silently sneak in and gradually make adjustments until one day you turn around and realize that you no longer recognize your house. What are the warning signs you need to be aware of in yourself or your loved ones?

6 Tips for Building Confidence as a Public Speaker

In this session, I share the top tips I have learned over the years. All it takes is a little preparation and practice.

Lessons Learned: Implementing Azure Synapse Analytics in a Rapidly-Changing Startup

What happens when you mix one rapidly-changing startup, one data analyst, one data engineer, and one hypothesis that Azure Synapse Analytics could be the right tool of choice?

Biml Tips and Tricks: Not just for SSIS packages!

Biml is not just for generating SSIS packages! Come and see how you can use Biml to save time and speed up other Data Warehouse development tasks like T-SQL development, test data creation, and dimension population.

Level Up Your Biml: Best Practices and Coding Techniques

Attend this session for an overview of Biml best practices and coding techniques. Learn how to centralize and reuse code, simplify logic, and create your own C# classes and methods. Improve your code and level up your Biml in no time!

Tools and Tips: From accidental to efficient DWH developer

As data warehouse developers we deliver data to business users... but we don't deliver data as fast as we want. There are many things you can do to increase your own productivity and become a more efficient data warehouse developer.