Project: Tableau Sales Data Analysis

Challenge: No visibility in terms of sales volume comparisons and performance over different periods of time in the Tableau dashboard (i.e sales growth rates for year-to-date, quarter-to-date, month-on-month, etc.)

Outcome: Development of new dynamic KPIs that enabled time-based comparisons among different periods giving maximum flexibility and customization within the Tableau dashboard, so users could slice and dice the data according to their current needs.

Project: Financial Ratios Automation & Visualization

Challenge: Time-consuming Excel updates to the financial statement, balance sheet and cash flow ratios and related charts.

Outcome: Revamped and automated the whole Excel document in such a manner that future financial data releases will automatically update ratios and charts. In addition, fully-dynamic and presentation-ready charts have been development, so that any financial metrics can be displayed on the fly to show correlations and comparisons.

Project: Accounts Payable Data Analysis

Challenge: First Tableau installation within the company and inability to extract valuable insights from the data for the Accounts Payable department.

Outcome: Quick turnaround by joining multiple data tables into one data source to develop a master Tableau dashboard. The dashboard portrayed a clear overview of data errors negatively affecting working capital and identified areas for financial and operational improvements, giving managers an holistic view of the department's performance and act accordingly.

Testimonials

Project: Drilling Optimization & Performance

Challenge: Multiple million-row datasets available but very difficult to handle and extract useful information.

Outcome: Developed a Tableau data source that automatically unions the datasets and combines them in way that can be easily and quickly analyzed. From the newly created data source, several interactive dashboards have been built to allow the client to model their view and graphics according to their current needs. The dashboards also portray insightful key performance indicators and analyze machinery performance, highlighting areas with room for improvement.