Market Grunt
Market Grunt
  • Видео 10
  • Просмотров 35 718
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.
Просмотров: 47

Видео

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: ruclips.net/video/x5NDJX0NRBI/видео.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:...
What we do at Market Grunt
Просмотров 234 года назад
An overview of what we do at Market Grunt.
Category Review Model
Просмотров 1334 года назад
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
Просмотров 814 года назад
An update to the report version which now includes predictive analytics.
Edit and Update a Territory Map in Power BI using PowerApp
Просмотров 7804 года назад
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
Просмотров 3384 года назад
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
Просмотров 2134 года назад
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
Просмотров 11 тыс.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