- 10
- 36 345
Market Grunt
Australia
Приєднався 9 січ 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.
Переглядів: 49
Відео
Using Bing Maps API to Geocode addresses with Power Query
Переглядів 17 тис.4 роки тому
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: ua-cam.com/video/x5NDJX0NRBI/v-deo.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
Переглядів 6 тис.4 роки тому
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
Переглядів 1374 роки тому
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
Переглядів 854 роки тому
An update to the report version which now includes predictive analytics.
Edit and Update a Territory Map in Power BI using PowerApp
Переглядів 8214 роки тому
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
Переглядів 3514 роки тому
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
Переглядів 2194 роки тому
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
Переглядів 12 тис.4 роки тому
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