top of page

Dashboards

Using Tableau Prep, Tableau & Excel

The featured dashboards were created with Tableau, with the help of Tableau Prep, and with Excel. The data sets used in the creation of these dashboards reflect the operational activities of two fictitious firms, Bibitor and BCGG, are were designed for data analysis and visualization education. 

Vendor Analysis

Dashboard to assess vendors by gross margin, potential sales, extended cost, and quantities purchased to identify and recommend vendors for audit and desk review.

Created with Tableau Prep and Tableau. 

BibitorVendorAnalysisDashboard2.png

Customer Sales Analysis

Dashboard to analyze customers' sales data by state and city, by sales exceeding a set standard deviation from the mean, and large sales occurring close to quarter end.

Created with Tableau.

BCGGCustomerSalesDashboard4.png

Customer A/R Analysis

Dashboard to monitor customers' accounts receivables, aging buckets and average number of days to complete payment. Created with Tableau.

BCGGCustomerARDashboard1.png

Bibitor Excel Dashboard

Dashboard to monitor monthly variance between budget and actual spending across counties and store locations.

ExcelDashboard10.png
bottom of page