Having just finished work on a project to develop a mapping solution in Power BI, I though I would share some of my experiences, in case it is of benefit to others. In a nutshell, I needed to develop a map that allowed the user (a sales representative) to select Read more…
So continuing on from my previous post, the second phase of our tasks is to show our 2 relative suburbs (based on 2 Geo-fence radii) as colored pins on a map. Phase 2 – Show a map with coloured pins that also indicate the suburbs (free, paid) After testing various Read more…
Now when have been able to place coloured pins on a map, our users wanted us to show them a map with coloured suburb shapes, as it more accurately indicated coverage for the sales process, especially in remote areas. Phase 3 – Show a map with coloured shape for the Read more…
Anyone who works in search cannot avoid Google Adwords & Google Analytics. Power BI has built some templates for reporting for Google Analytics, but nothing exists at time of writing for Google Adwords. We had a need to measure the success of our Adwords efforts, while also determining where Read more…
This is a continuation of the series “Adwords Analytics in PowerBI” At time of writing, having the option to connect directly to Adwords data via Power BI is not being considered by the PowerBI development team, but there are options, if you are willing to write your own custom connector Read more…
AdWords is a Google product, so most AdWords users have probably come across the PowerBI equivalent – Google Data Studio (beta) (well kind of doesn’t compete yet, but will discuss in another post!)… In Google Data Studio, there are report templates, that can just be pointed to your data, for common Google Read more…
This is a continuation from part 3 about Adwords Reporting in Power BI… So I have demonstrated how to consume Adwords data via Google Big Query in Power BI and replicate existing Adwords Datalabs reports. Now we want to mash our data with other data and need to find something Read more…
If you have followed my previous posts I collected data from 3 separate sources. Adwords via Google Big Query SERPS via our Data Warehouse & Google Big Query Revenue data also from our Data Warehouse via FileMaker & SalesForce Now What? Generally this is where you are directed by a Read more…
Recently I was tasked with building a Return on Investment Calculator in Power BI, for our sales team to demonstrate what sort of return a client may receive for their advertising spend. So I needed to provide number inputs to deliver this and quickly found there are no out of Read more…