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 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 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 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 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, 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 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 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 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 Read more…
What goes into a blog post? Helpful, industry-specific content that: 1) gives readers a useful takeaway, and 2) shows you’re an industry expert. Use your company’s blog posts to opine on current industry topics, humanize your company, and show how Read more…