- 10
- 35 537
Market Grunt
Australia
Registrace 9. 01. 2020
Hi! My name is Steve Doherty and I'm the founder of Market Grunt. My company specialises in business strategy development for Suppliers and Retailers in the FMCG and Hardware Industries. We use Power BI for decision support and insight development.
First thing, I'm not a tech geek. I learnt how to use Power BI when it was first launched in 2015. Back then I was a Sales and Marketing Manager and I had the privilege of being able to watch Power Query and DAX Masters build models and reports. As I watched on, I thought to myself, Power BI is going to change the world and what's more, I believed I could do what the consultants were doing. Soon I was developing my own reports. And, I found out that my own reports were more relevant than those built by consultants because I knew the questions that were being asked of the data and the business strategy that shaped those questions.
First thing, I'm not a tech geek. I learnt how to use Power BI when it was first launched in 2015. Back then I was a Sales and Marketing Manager and I had the privilege of being able to watch Power Query and DAX Masters build models and reports. As I watched on, I thought to myself, Power BI is going to change the world and what's more, I believed I could do what the consultants were doing. Soon I was developing my own reports. And, I found out that my own reports were more relevant than those built by consultants because I knew the questions that were being asked of the data and the business strategy that shaped those questions.
Creating a Power BI Reporting System from your Power BI Reports
When we build a Power BI Report, a lot of effort goes into ensuring everyone understands the background and features available.
This is an example of how we build a system from our Population Clustering report. Hope you like it. Let me know in the comments below.
This is an example of how we build a system from our Population Clustering report. Hope you like it. Let me know in the comments below.
zhlédnutí: 47
Video
Using Bing Maps API to Geocode addresses with Power Query
zhlédnutí 16KPřed 4 lety
This is part 2 of our "how to geocode" demonstrations. In Part 1 we demonstrated how to Geocode and address list with the Google Maps API. In this demonstration, we show how to use Bing Maps Geolocation API. Part1. Geocoding with Google Maps API can be found here: czcams.com/video/x5NDJX0NRBI/video.html An Executive Summary provides a comparison of the two. Our opinion is Google is the fastest ...
Create a Power Query Geocode Function with Google API
zhlédnutí 6KPřed 4 lety
In this demonstration, we use Power Query to geocode an address list using a Google API. During the demonstration, we convert the Power Query Geocode step to a function and invoke it on our input table. We also demonstrate that you need to verify the results that are returned and demonstrate a method for doing using Excel Part 2 shows how to use Bing Maps API with Power Query can be found here:...
Category Review Model
zhlédnutí 133Před 4 lety
In the FMCG industry, a Category Review is possibly the most arduous and intense presentation an Account Manager will have to do for their accounts. Basically, Its a health report of the Category and the Accounts performance in the category. This model quickly identifies what's happening in the Category, allowing Account Managers to indicate which items support growth and the limitations that a...
Power BI Covid19 Report
zhlédnutí 81Před 4 lety
An update to the report version which now includes predictive analytics.
Edit and Update a Territory Map in Power BI using PowerApp
zhlédnutí 770Před 4 lety
In this video, I demonstrate the use of the PowerApp visual for Power BI to edit the territory assignment file (an excel file in OneDrive). For those that have had to re-assign stores and edit territories, the new PowerApp addin allows real-time editing and feedback on how changes affect territory value, numbers and balance.
A Sample Sales Report
zhlédnutí 337Před 4 lety
Getting data is easy, getting it to tell a story is the challenge. Is this presenting data or presenting insight?
Demonstration of the Supermarket Strategy Model
zhlédnutí 213Před 4 lety
A quick tour of Power BI model I've been working on that investigates the strategy supermarkets use for choosing store location. The model uses advanced bookmarking techniques to keep the data story focused and relevant. Notice how easy it is to move between the strategic level, where you try to establish what everyone is doing, to the tactical level, where you are looking at local regions, the...
Create a Mapbox Drill Down, Choropleth Map in Power BI
zhlédnutí 11KPřed 4 lety
In this video, I show how to create a drill-down choropleth map in Power BI. A resource pack containing the Power BI file and shapefiles can be found here: drive.google.com/drive/folders/1MD9gJwhDi1Xgc9ddcKNfyfb9QIgVhaNl?usp=sharing. Before starting may I suggest: 1. Sign up for a Mapbox account at www.mapbox.com 2. QGIS can be downloaded from download.qgis.org