When your information consists of geographic data, including a visible map will improve your reporting capabilities. There are a number of methods to include maps into your Energy BI studies.
Configure Your Knowledge
For the very best mapping skills, you first need to make certain that your information is categorized appropriately as geographic data. It will assist you to filter by geography and create maps to raised show your information.
It’s additionally most efficient in the event you use a number of columns on your information. So don’t put a whole handle right into a column; separate the road handle, metropolis, state, and zip code into unbiased columns. This helps guarantee accuracy, notably with Bing integration.
From Knowledge View, choose a column with geographic data. Then click on the Modeling tab and go to Knowledge Class. From there, select the class on your column. Repeat for all columns with geographic information. Now you’re ready to create maps.
Fundamental Maps for Energy BI Studies
There are a pair forms of maps which are constructed into Energy BI and subsequently work fairly seamlessly. One is just known as Map, and the opposite is the Crammed Map. They each work with international and regional geographic information, and each are built-in with Bing. This implies you don’t have to enter longitude and latitude in an effort to get correct reporting.
Some customers do discover the occasional error within the Bing mapping, so at all times double examine your studies. For Bing integration, it is best to ensure that your firewall permits these URLs, as a result of Bing makes use of them for location accuracy.
That is the essential native mapping device out there on your Energy BI Studies. It’s nice for simple information representations. For instance, chances are you’ll need to present gross sales by zip code. You possibly can create a map with dots whose dimension corresponds to the variety of gross sales within the given zip code and time-frame.
Crammed maps use colours and shading to outline sections. They’re helpful when you want to present spatial boundaries or simply evaluate one area to a different. You possibly can regulate the colours and saturation to show your information. That is typically used when evaluating one thing like states, for instance.
Different Mapping Choices
In the event you want extra personalization and are tech-savvy, there are different choices for mapping in Energy BI.
ArcGIS is one other map that’s native to Energy BI, and it gives some options that can’t be present in different mapping choices. One key element is the flexibility so as to add clustering whenever you zoom.
Form mapping is one other native function in Energy BI. With it, you’ll be able to create your personal polygons to use to your geographic information. This sort of map truly works for non-geographic data as nicely.
This map is an add-on created by a Energy BI person. It provides you the flexibility to show a route as a line on a map. You do have to make use of Bing because the basemap although as there are not any different choices out there.
Supplied as one other customized map, the circulation map means that you can present motion in your map, akin to strains that converge or diverge from a single level. Once more, Bing is your solely basemap selection right here.
It is a much less generally used possibility as a result of it doesn’t assist requirements types of geographic data. However in the event you’re prepared to place within the effort, you’ll be able to create some wonderful visuals. It’s out there within the Workplace retailer and isn’t just for maps!
The Globe map can also be out there within the Workplace retailer, and shows your information in a 3D mannequin. Whereas this actually has its perks, many customers discover it harder to view information within the 3D format, and its customization choices are restricted.
Create Your Personal
You probably have the time and know-how, you’ll be able to create your personal type of map in Energy BI. This offers you complete management over your show and may also help if in case you have a singular information set.
Maximize Your Energy BI Studies with ChristianSteven Software program
You’ve bought the maps up and working; now it’s time to verify your studies are entering into the correct arms on the proper time. With our Energy BI Studies Scheduler, you’ll be able to automate your studies and enhance your effectivity. Contact us at this time to start out your free trial.