How to report on Hubspot data in less than 20 minutes, using Azure Data Factory

preview_player
Показать описание
While we all love data and appreciate the many valuable insights it can give us, extracting data in a meaningful way can be complex and time-consuming and it can be difficult to rapidly glean the valuable information that can power and shape your business effectively.

Using ADF, even large amounts of data can be transformed and visualised quickly and easily.

During this webinar, the my[data]force industry experts will show you:
- The capabilities of Azure Data Factory platform
- How to connect to HubSpot from Azure Data Factory and pull data into Azure SQL Database
- Example of data transformation in Azure Data Factory
- How to connect to Azure SQL Database in PowerBI and visualization on Hubspot data

Companies have access to a massive amount of data. However, on its own, raw data does not provide meaningful insights to business decision makers. Big data requires a service that helps to refine these enormous stores of raw data into actionable business insights.

The purpose of the webinar is to provide an overview of loading Hubspot data into Azure SQL Database, data transformation in Azure Data Factory, and advanced data analytics and visualization in PowerBI.
Рекомендации по теме
Комментарии
Автор

How would I select all tables? Would I have to create multiple datasets in ADF?

GP_
Автор

Can you show how to add more value to the pivot? It would be better if you could have explained more in detail about extracting the data from the hubspot

sdhilip
Автор

Are you able to share the authentication process for Hubspot? I've been trying to get this pipeline set up for a while now but the way hubspot oauth works has been confusing me.

maxisqt
Автор

Hello, interesting video but it seems not to be that easy when retrieving the hubspot deal property values:
ERROR [HY000] [Microsoft][Hubspot] (100) Error parsing JSON: Invalid value. while parsing string <html> <head><title>414 Request-URI Too Large</title></head> <body> <center><h1>414 Request-URI Too Large</h1></center> </body> </html> .
Activity ID


How do you deal with this ?

JeffreyVanpachtenbeke
visit shbcf.ru