Calculations from different data sources

[seimax]

Hello,

I would like to bring together data from Google Analytics and a Google Spreadsheet and put it into a calculation so that, for example, I can calculate the revenue per user of the website. How can this best be done with Power BI?

Greetings,
Max.

[v-juanli-msft]

Hi @seimax

First of all, you need to connect to Google Analytics and Google Spreadsheet.

How to connect google sheet to Power BI

Google Analytics connector for Power BI Desktop

Then you may need to shape data to meet your requirements.

Query editor

Tutorial: Shape and combine data in Power BI Desktop

Tutorial: Analyze web page data using Power BI Desktop   (Google Spreadsheet can be considered as a web page data)

Next try to create relationship between two dataset, then create calculated columns or measures to use the data from different tables.

Tutorial: Create calculated columns in Power BI Desktop

Tutorial: Create your own measures in Power BI Desktop

Best Regards

Maggie

Create and manage relationships in Power BI Desktop

[seimax]

Hi Maggie,

many many thanks for your answer. Does this process also works with the Power BI Cloud App?

Best regards from Cologne,
Max.