DTC Sales Dashboard
DTC Sales vs Plan dashboard created from POS API
DTC Sales Dashboard Read More »
Wine Sales By Varietal
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.
Wine Sales By Varietal Read More »
Napa Valley Winery Explorer
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/)
Napa Valley Winery Explorer Read More »
Wine Inventory Consolidation
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.
Wine Inventory Consolidation Read More »
Inventory Location
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
Inventory Location Read More »
Key Financial Metrics
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.
Key Financial Metrics Read More »