Code never lies, comments sometimes do [Ron Jeffries]

Visitors Map

Follow on Twitter

@ZammaCode
Powered by Blogger.

Friday, May 26, 2023

Map, Filled Map, Gauge, Multi-row Card, KPI Visuals


The following dashboard uses the Sample - Superstore and Financial Sample datasets to demonstrate the creation of:

  • Map
    • Map enables to track and analyze data on a geographic level.
    • Map is integrated with Bing Maps to provide default map coordinate (called geo-coding).
    • Map visual displays points that can be scaled as area bubbles.
    • In Power BI the following fields are shown in details pans:
      • Location specify the country, city or state columns
      • Legend provides additional context or information about the data being displayed on the map
      • Latitude and Longitude specify exact coordinates
      • Bubble size specify the size of data point or bubble on the map which is usually a numeric field e.g. sum of profit
  • Filled Map
    • Filled map displays quantitative information using filled regions or polygons.
    • In Power BI the following fields are shown in details pans:
      • Location specify the country, city or state columns
      • Legend sub-categorize the data 
      • Latitude and Longitude specify exact coordinates
  • Gauge
    • Gauge or radial gauge chart shows a single value that measures progress toward a goal or a Key Performance Indicator (KPI).
    • The line or needle represents the target value while shading represents the progress toward that goal.
    • In Power BI the following fields are shown in details pans:
      • Values specify the value to be displayed e.g. average of sales
      • Minimum Value specify the minimum value for the gauge 
      • Maximum Value specify the maximum value for the gauge
      • Target Value specify the target value to be achieved
  • Multi-row Card
    • Multi-row Card visuals displays the aggregated information of a multiple numeric values in group format.
    • In Power BI the following fields are shown in details pans:
      • Fields specify the columns which are to be shown in the group on multi-row card
  • KPI
    • KPIs (Key Performance Indicators) tracks an organization’s performance in different areas toward defined targets.
    • A KPI always has a base value which is evaluated against a target value.
    • In Power BI the following fields are shown in details pans:
      • Value specify the base value that has to be evaluated
      • Trend Axis specify the time
      • Target specify the target or goal value that needs to be achieved
    • For visual SalesKPI table is created in PowerBI. 

0 comments:

Post a Comment