Hey there Everyone! I've a query that I hope someone could advice me on.
I've watched all of Will's videos too, and seek validation and guidance on how to apply it into practice 😜
I know I'm very vague HAHA but this are the information I have to work with for now
Suppose that I have a case as follows:
- I am transitioning from PowerBI into Fabric
- I'd like to connect different business units (IT, Sales etc.) across a few countries.
- The data mainly consist of Google Ads (Provided by a service, so technically I'd have the CSV files only haha) and Google Analytics.
- Architect with the intention to perform predictive analysis in the future
The following is my proposed approach:
- Capacity is segragated by region. (I need advice on how much CU is required or how to know how much CU should I purchase)
- Power Query to connect to Google Analytics.
- Lakehouse to store Google Ads CSV files and a datapipeline to clean and transform