Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am brand new to BI and I am pretty stuck in these training modules. I want to pull Google AdWords reports with time of day, date, impressions, click through rate, conversion rate, etc. (80 identical reports) and then aggregate in BI in order to figure out which day of the week or which hour receives has the most impressions or the highest CTR.
Should I combine into one big excel file and then upload or would I upload all of the excel files separately in order to create relationships between the alike columns? Am I approaching this completely wrong? Also, any advice concerning a good visualization strategy or at least where to start would be really helpful.
Thanks in advance.
Solved! Go to Solution.
You may take a look at Shape and combine multiple data sources.
You may take a look at Shape and combine multiple data sources.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |