Misalignment detection system for efficiently processing database-stored data and automatically generating misalignment information for display in interactive user interfaces
Various systems and methods are provided that integrate data from disparate sources to identify shipment misalignments and display such information in interactive user interfaces. For example, the systems described herein can define various geographic regions using location and census data and identify the defined geographic regions in which stores are located. Using shipment data and micro-market data, the systems described herein can then identify the geographic regions that items are shipped to, identify the demand for such items in the geographic regions, and determine whether the quantity of items shipped to the geographic regions is appropriate based on the demand. Such information can be displayed in an interactive user interface that allows a user to view the geographic clustering of item demand, identify potential opportunities for correcting shipment misalignment, and/or correct identified shipment misalignments.
1. A computer-implemented method comprising:
generating graphical representations of a plurality of geographic regions;
generating user interface data for rendering an interactive user interface on a computing device, wherein the interactive user interface includes:
a map representing a large geographic region, wherein the map displays the graphical representations of the plurality of geographic regions at locations within the large geographic region; and
a table displaying information associated with the plurality of geographic regions, wherein the information includes at least one of: names, a number of associated stores, a percentage of unserved stores, total shipments made, a percentage of unserved shipments, a percentage of a category of goods, and an opportunity index;
receiving a selection of a first graphical representation of a first geographic region in the plurality of geographic regions;
modifying the user interface data such that the interactive user interface displays an expanded view of the map, wherein the expanded view of the map includes an identification of a location of one or more entities located within the first geographic region and hides geographic regions in the plurality of geographic regions other than the first geographic region;
receiving a selection of a first entity in the one or more entities located within the first geographic region;
modifying the modified user interface data such that the interactive user interface displays shipment misalignment data associated with the first entity selected within the first geographic region;
in response to an alert generated based on a determination that a shipment misalignment is detected, modifying the modified user interface data such that the interactive user interface displays a notification that shipment misalignment is detected;
modifying, in response to the selection of the first entity within the first geographic region, the modified user interface data such that the interactive user interface includes a selectable option to ship additional items to the first entity; and
in response to selection of the selectable option via the interactive user interface, generating an instruction to increase or decrease shipment of the additional items to the first entity.
2. The computer-implemented method of claim 1 , wherein the graphical representations of the plurality of geographic regions are each shaded a color corresponding to a demand for an item in the respective geographic region.
3. The computer-implemented method of claim 1 , wherein the first graphical representation of the first geographic region has an appearance that indicates a demand for an item in the first geographic region.
4. The computer-implemented method of claim 1 , wherein a first category of items is a first subcategory of a second category of items, and wherein the computer-implemented method further comprises:
determining, for the first geographic region, a first percentage of sales of the second category of items that are sales of the first category of items using micro-market data stored in a first database;
determining, for the first geographic region, a second percentage of shipments of the second category of items to the first geographic region that are shipments of the first category of items using shipment data stored in a second database; and
generating a first opportunity score that indicates shipment misalignment has occurred in response to a determination that the first percentage is greater than the second percentage.
5. The computer-implemented method of claim 4 , wherein the displayed shipment misalignment data comprises the first opportunity score.
6. The computer-implemented method of claim 5 , wherein a third category of items is a second subcategory of the second category of items, and wherein the computer-implemented method further comprises:
receiving a selection of the third category of items;
determining, for the first geographic region, a third percentage of sales of the second category of items that are sales of the third category of items using the micro-market data;
determining, for the first geographic region, a fourth percentage of shipments of the second category of items to the first geographic region that are shipments of the third category of items using the shipment data;
generating a second opportunity score that indicates shipment misalignment has occurred in response to a determination that the third percentage is greater than the fourth percentage; and
modifying the modified user interface data such that the shipment misalignment data comprises the second opportunity score.
7. The computer-implemented method of claim 1 , further comprising retrieving shipment data associated with the first geographic region from a database, wherein the shipment data comprises an amount of an item shipped to the first geographic region.
8. The computer-implemented method of claim 1 , wherein the one or more entities comprise at least one of a store, a warehouse, or a distributor.
9. The computer-implemented method of claim 8 , wherein the store is represented by a first icon depicted in the expanded view of the map, the warehouse is represented by a second icon depicted in the expanded view of the map, and the distributor is represented by a third icon depicted in the expanded view of the map.
10. The computer-implemented method of claim 1 , further comprising modifying, in response to the selection of the first entity within the first geographic region, the modified user interface data such that the interactive user interface includes information on at least one second entity in the one or more entities that is related to the first entity.
11. The computer-implemented method of claim 1 , wherein the one or more entities comprise at least one of a first type of building, a second type of building, or a third type of building, wherein each of the first, second, and third types of buildings is represented by a different icon in the expanded view of the map.
12. A computing system comprising:
a shipment routing system; and
a processor configured with executable code that, when executed, causes the processor to:
generate graphical representations of a plurality of geographic regions;
generate user interface data for rendering an interactive user interface on a computing device, wherein the interactive user interface includes:
a map representing a large geographic region, wherein the map displays the graphical representations of the plurality of geographic regions at locations within the large geographic region; and
a table displaying information associated with the plurality of geographic regions, wherein the information includes at least one of: names, a number of associated stores, a percentage of unserved stores, total shipments made, a percentage of unserved shipments, a percentage of a category of goods, and an opportunity index;
receive a selection of a first graphical representation of a first geographic region in the plurality of geographic regions;
modify the user interface data such that the interactive user interface displays an expanded view of the map, wherein the expanded view of the map includes an identification of a location of one or more entities located within the first geographic region and hides geographic regions in the plurality of geographic regions other than the first geographic region;
receive a selection of a first entity in the one or more entities located within the first geographic region;
modify the modified user interface data such that the interactive user interface displays shipment misalignment data associated with the first entity selected within the first geographic region;
in response to an alert generated based on a determination that a shipment misalignment is detected, modify the modified user interface data such that the interactive user interface displays a notification that shipment misalignment is detected;
modify, in response to the selection of the first entity within the first geographic region, the modified user interface data such that the interactive user interface includes a selectable option to instruct the shipment routing system to ship additional items to the first entity; and
in response to selection of the selectable option via the interactive user interface, generate an instruction to increase or decrease shipment of the additional items to the first entity.
13. The computing system of claim 12 , wherein the first graphical representation of the first geographic region has an appearance that indicates a demand for an item in the first geographic region.
14. The computing system of claim 12 , wherein a first category of items is a first subcategory of a second category of items, and wherein the executable code, when executed, further causes the processor to:
determine, for the first geographic region, a first percentage of sales of the second category of items that are sales of the first category of items using micro-market data stored in a first database;
determine, for the first geographic region, a second percentage of shipments of the second category of items to the first geographic region that are shipments of the first category of items using shipment data stored in a second database; and
generate a first opportunity score that indicates shipment misalignment has occurred in response to a determination that the first percentage is greater than the second percentage.
15. The computing system of claim 14 , wherein the displayed shipment misalignment data comprises the first opportunity score.
16. The computing system of claim 15 , wherein a third category of items is a second subcategory of the second category of items, and wherein the executable code, when executed, further causes the processor to:
receive a selection of the third category of items;
determine, for the first geographic region, a third percentage of sales of the second category of items that are sales of the third category of items using the micro-market data;
determine, for the first geographic region, a fourth percentage of shipments of the second category of items to the first geographic region that are shipments of the third category of items using the shipment data;
generate a second opportunity score that indicates shipment misalignment has occurred in response to a determination that the third percentage is greater than the fourth percentage; and
modify the modified user interface data such that the shipment misalignment data comprises the second opportunity score.
17. The computing system of claim 12 , wherein the one or more entities comprise at least one of a store, a warehouse, or a distributor.
18. The computing system of claim 17 , wherein the store is represented by a first icon depicted in the expanded view of the map, the warehouse is represented by a second icon depicted in the expanded view of the map, and the distributor is represented by a third icon depicted in the expanded view of the map.
19. A non-transitory computer-readable medium comprising one or more program instructions recorded thereon, the one or more program instructions configured for execution by a computing system comprising one or more processors in order to cause the computing system to:
generate graphical representations of a plurality of geographic regions;
generate user interface data for rendering an interactive user interface on a computing device, wherein the interactive user interface includes:
a map representing a large geographic region, wherein the map displays the graphical representations of the plurality of geographic regions at locations within the large geographic region; and
a table displaying information associated with the plurality of geographic regions, wherein the information includes at least one of: names, a number of associated stores, a percentage of unserved stores, total shipments made, a percentage of unserved shipments, a percentage of a category of goods, and an opportunity index;
receive a selection of a first graphical representation of a first geographic region in the plurality of geographic regions;
modify the user interface data such that the interactive user interface displays an expanded view of the map, wherein the expanded view of the map includes an identification of a location of one or more entities located within the first geographic region and hides geographic regions in the plurality of geographic regions other than the first geographic region;
receive a selection of a first entity in the one or more entities located within the first geographic region;
modify the modified user interface data such that the interactive user interface displays shipment misalignment data associated with the first entity selected within the first geographic region;
in response to an alert generated based on a determination that a shipment misalignment is detected, modify the modified user interface data such that the interactive user interface displays a notification that shipment misalignment is detected;
modify, in response to the selection of the first entity within the first geographic region, the modified user interface data such that the interactive user interface includes a selectable option to ship additional items to the first entity; and
in response to selection of the selectable option via the interactive user interface, generate an instruction to increase or decrease shipment of the additional items to the first entity.
20. The non-transitory computer-readable medium of claim 19 , wherein the first graphical representation of the first geographic region has an appearance that indicates a demand for an item in the first geographic region.
21. The non-transitory computer-readable medium of claim 19 , wherein the one or more entities comprise at least one of a store, a warehouse, or a distributor, and wherein the store is represented by a first icon depicted in the expanded view of the map, the warehouse is represented by a second icon depicted in the expanded view of the map, and the distributor is represented by a third icon depicted in the expanded view of the map.