Python coding to connect a "Choroplethe map" to PowerBI report
- or -
Post a project like this69
€240(approx. $257)
- Posted:
- Proposals: 13
- Remote
- #4146730
- OPPORTUNITY
- Awarded
UK Based SharePoint / O365 development / migration to O365 from SharePoint or File Shares
Long Eaton
1550+ Projects (iOS | Android | Mac OS | Web | Win | BlockChain | IOT)
Bad Vilbel
WordPress Expert/Woocommerce Expert/Data Scientist/Python Expert/Auto-CAD/3D/2D Animation/ White Board Animation
Rawalpindi
Web and App Development | Database Expert | Database Analysis| Python Developer
Islamabad
663771342705654870096857031147433151005889746791466289603337102179691067980010752580
Description
Experience Level: Entry
We want a custom Python visual for Power BI to display geographical information.
N1 Pie Chart: We want to be able to get a choropleth map completed with a pie chart in the centre of the area in python based on a Json file and a label to display the value corresponding to the colour shade used.
N2 Color gradient: We want the colour of the area to be a gradient based on a measure given to the visual inside of Power BI with that measure result to be displayed in the label and the pie chart size based on another one and using inputted legend.
The visual need to be fast so to not slow down the report.
Colours used need to be referenced as a variable at the start of the script in order to be easily changed to fit multiple themes.
N3 Json variable path: Json must be referenced as a variable at the start to be easily swapped for different map according to the current need. It must be available to users only either with local storage or with a private online storge (for example, SharePoint).
N4 2 Metrics: We will be using data similar to the included dataset (quantity and sales for 3 products and a geographic group). The visual need to be able to display both total quantity and value with either the map colour or pie chart size.
With the included dataset, the visual need to display the total value of sales as the colour of the choropleth map and the quantity as the size of the pie chart, depending on the product.
The “Product Values” tab list the value of each product, “Sales QTY” list the total quantity of sales for each product at the lowest level and the tab “Geolevel” link the lowest geolevel to the geolevel used in the Json file (“Geolevel 1“).
Thank for reading.
N1 Pie Chart: We want to be able to get a choropleth map completed with a pie chart in the centre of the area in python based on a Json file and a label to display the value corresponding to the colour shade used.
N2 Color gradient: We want the colour of the area to be a gradient based on a measure given to the visual inside of Power BI with that measure result to be displayed in the label and the pie chart size based on another one and using inputted legend.
The visual need to be fast so to not slow down the report.
Colours used need to be referenced as a variable at the start of the script in order to be easily changed to fit multiple themes.
N3 Json variable path: Json must be referenced as a variable at the start to be easily swapped for different map according to the current need. It must be available to users only either with local storage or with a private online storge (for example, SharePoint).
N4 2 Metrics: We will be using data similar to the included dataset (quantity and sales for 3 products and a geographic group). The visual need to be able to display both total quantity and value with either the map colour or pie chart size.
With the included dataset, the visual need to display the total value of sales as the colour of the choropleth map and the quantity as the size of the pie chart, depending on the product.
The “Product Values” tab list the value of each product, “Sales QTY” list the total quantity of sales for each product at the lowest level and the tab “Geolevel” link the lowest geolevel to the geolevel used in the Json file (“Geolevel 1“).
Thank for reading.
Guy C.
100% (39)Projects Completed
34
Freelancers worked with
31
Projects awarded
52%
Last project
22 Feb 2024
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies