How to import many different marketing data and then see it through Power BI?

Question

Hello everyone, I would like to know how to upload many different marketing statistics, like different Google Analytics into Azure and then sip through the data with Power BI. What tools are needed? Should I just use Azure Synapse Analytics? I would like to know the whole procedure of doing this. Thanks in advance

Answer 1

@Stefan Japelj - Thanks for the question and using MS Q&A platform.

To import many different marketing statistics data into Azure and then visualize it through Power BI, you can follow these general steps:

1. Prepare your data: Make sure your data is in a format that can be easily imported into Azure. You can use tools like Azure Data Factory or Azure Synapse Analytics to transform and prepare your data for import.
2. Import your data into Azure: Once your data is prepared, you can use Azure Synapse Analytics to import your data into Azure. You can use the "Copy Activity" in Azure Synapse Analytics to import data from various sources like Google Analytics, CSV files, or databases.
3. Store your data in Azure Synapse Analytics: After importing your data, you can store it in Azure Synapse Analytics. You can use the "Data" feature in Azure Synapse Analytics to create tables and store your data.
4. Visualize your data with Power BI: Once your data is stored in Azure Synapse Analytics, you can use Power BI to create visualizations and reports. You can connect Power BI to Azure Synapse Analytics and create reports that show your marketing statistics data.

For more details, refer to Google Analtics Azure Data Factory REST API and Access Google Analytics with Azure Data Factory and Copy activity in Azure Data Factory and Azure Synapse Analytics.

This example scenario shows how data can be ingested into a cloud environment from an on-premises data warehouse, then served using a business intelligence (BI) model. This approach could be an end goal or a first step toward full modernization with cloud-based components.

The following steps build on the Azure Synapse Analytics end-to-end scenario. It uses Azure Pipelines to ingest data from a SQL database into Azure Synapse SQL pools, then transforms the data for analysis.

For more details, refer to Enterprise business intelligence

Hope this helps. Do let us know if you any further queries.

---

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Answer 2

Hi @Stefan Japelj

Just to add to what @PRADEEPCHEEKATLA called out, we do have Marketo connector in Preview which can also be used . Please do read more about that here .

Thanks
Himanshu