You must then determine the names of the match fields: Fields are specified as keywords that begin with # followed the field name from the source of spatial data. Fields are specified as simple field expressions, for example, or =Fields!Sales.Value.ĭata fields provided by the spatial data source. Analytical data can come from the following sources:Īn existing report dataset. Determine the analytical data and the analytical data match fieldsĪfter you identify the spatial data, you must identify the analytical data. The match fields are used to relate the spatial data with the analytical data. If the store name is not unique in the spatial data, you might include the name of the city as well as the store. For example, for a store location point, you might use the name of the store. One or more fields that uniquely identify each spatial data field. A spatial data field that has the sets of coordinates that define each point, line, or polygon. Spatial data must contain the following fields: To display analytical data on a map and to vary the size, color, or marker type, you must specify fields that relate the spatial data and analytical data. Determine the spatial data and the spatial data match fields ![]() For more information, see Balance Report Definition Size and Report Processing Time later in this topic. Check the terms of use and privacy statements for spatial data sources to understand how you can use spatial data in your report.Īfter you find the data that you want, you can embed the data in the report definition or retrieve the data dynamically when the report is processed. Spatial data can be politically sensitive and possibly copyrighted. Spatial data from SQL Server spatial data sources.īing map tiles, which provide a background for the map view. To find spatial data to use in your map, you can use the following sources: After you add polygons to a map, in addition to displaying the outline, you can display a marker at the center point of the area of the polygon.Īfter you identify which spatial data that you need, you must find a source for it. Polygons specify areas, for example, territories, countries/regions, states, provinces, counties, cities, or areas covered by cities, postal codes, telephone exchanges, or census districts. After you add a line to a map, you can vary the line color and line width. Lines specify paths or routes, for example, delivery routes or flight paths. After you add points to a map, you can display a marker at the point location and vary the marker type, size, and color. For every location that you want to display on a map, you must provide the spatial data for that location. Points specify locations, for example, a city or an address for a store, restaurant, or convention center. Spatial data comes in three forms: points, lines, and polygons. You must specify which spatial and analytical data that you need.Īnalytical data comes from a report dataset, from sample data included with a map from the map gallery, or from analytical data included with spatial data in an ESRI Shapefile. Location data comes from spatial data sources that you must specify. Analytical data comes from report datasets. Sales categorized by customer demographics, based on customer location relative to store locations.Ĭomparative sales or other financial data by sales territory.Ĭomparative sales for different discount strategies across multiple stores.Īfter you identify the purpose of the map display, you must analyze what data you need. For example, on a map you can visualize the following types of data to identify market opportunities: To create a useful, easily understood map display, decide what questions you want the map to help answer. Good report design provides information that help users take actions to address issues. You can associate your analytical data with map elements on each layer. A map can contain multiple layers, where each layer displays map elements that are defined by a specific type of spatial data: points that represent locations, lines that represent routes, or polygons that represent areas. To present analytical data such as sales totals or demographics against a geographic background, you can add a map to your Power BI paginated report. Good reports present information that leads to actions or insights.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |