This winery has inventory spread over 11 locations and were spending several hours per month reconciling transfers, sales, and current stock with physical inventories. TEKreset automated extracting data from all locations and loading it into the dashboard 4 times daily. Now staff have access to the latest information using the computer or mobile phone.
Query current inventory location information trapped in a legacy ERP system without any database access via an interactive dashboard with the help of Power BI and Power Apps
This data was extracted and anonymized from a working ERP system. The client was looking for an easy way to track financial metrics across their 3 lines of business. Page 1 has month end data and Page 2 has 5 year trends.
This data was extracted and anonymized from an ERP system tracking winery sales by varietal over time. Page 1 shows profits by months for year selected and Page 2 shows sales across geography.
Napa Valley is home to some of the most beautiful wineries in the world. This data mashup uses multiple open data sources and to explore wineries in Napa: Napa County GIS data catalog (http://gis.napa.ca.gov/giscatalog/): Global Wine Scores (https://www.globalwinescore.com/) Napa Green (https://napagreen.org/)
