WorldSmart is a solution provider to more than 1,600 supermarkets, with more than 20,000 terminals and self-checkouts. The company established a Data Analytics and Insights division in 2015, comprising data scientist and business intelligence analysts to provide probability and regression analysis to drive loyalty, basket size and foot traffic.
WorldSmart is a Microsoft Silver Partner and early adopter of Microsoft SQL Server 2016
I designed a Retail Management System (RMS) database collection and data warehouse to consolidate all retail verticals, including Rental, Hardware, Dining, Apparel, Forecourt, Pharmacy, Grocery, Hospitality and Gaming.
Data models were based on a combination of the following, but mostly Dynamics and ARTS
Microsoft Dynamics AX 2012 R3
National Retail Federation ARTS Data Models
Global Standards One (GS1 Australia)
ISO, FIPS, ANSI, IEEE, UNSPSC
National Geospatial-Intelligence Agency
Australian Bureau of Statistics, Australian Bureau of Meteorology
Food Standards Australia
Independent Gaming Corporation.
I later commissioned an abridged version of the RMS for the company’s Data Analytics and Insights Division.
Required consolidating different databases and design of data pipelines, both streaming and batched from subsidiary companies and third parties.
Statistical inference engine to impute, clean, and enrich data, leveraging available quality rules, value correlations and reference data. Uniquely identifies a person from multiple profiles. Postal Addresses are standardised and geocoded. 84% basket items linked to master Item table.
The Customer Relationship Management (CRM) model combines nine dissimilar Loyalty schemes and one Income Management scheme.
The application tracks an individual’s grocery, liquor, petrol, pharmacy, hardware purchases and slot machine player profile.
Item Content Management (ICM) model contains a cleansed master Item table based on the GS1 Global Trade Item, Global Product Categorisation, DataBar and International Federation for Produce Standards (IFPS).
Comprising
OnLine Transaction Processing (OLTP) database
Extract-Transform-Load staging database, numerous C# CLR assemblies
Logging Database, Data Interchange, Connectors
Data Warehouse and Analysis Services for Reporting and Power BI Visualisation.
Platform
Telstra Private Cloud
Microsoft SQL Server 2016 Enterprise
SQL Server Analysis Services tabular instance
Power BI, Azure, SQL Server Reporting Services
Statistics
2.5 million Customer Accounts
980 Organisations, 269 x Legal Entity's, 711 x Retail Channels
4.2 Billion Journal Items, over 2.5 million journal items per day
2.1 million Global Trade Items (barcodes)
72% of scanned items linked to Food Standards Nutrition Panel Calculator
Geocoded Postal Addresses linked to Australian Bureau of Statistics Census Data
Organisation Postal Addresses linked to Australian Bureau of Meteorology Station Weather Observations
Independent Gaming Corporation data feed for Gaming Machine / Player analysis
GS1 Australia Trusted Data Service and SmartMedia data feed
Microsoft SQL Server Analysis Services validated and refreshed every 30 minutes
Core Models
Organisation Model
Customer Relationship Management
Inventory and Warehouse Management
Procurement and Sourcing
Human Resources
Accounting
Logistics
Digital Asset Management
Item Content Management (ICM)
Categorisation
Nutrition
Retail Assortment
Merchandising
Planograms
Offers
Loyalty
Data Import Export Framework
Electronic Data Interchange and Business Rule Framework.
Comments