Overview

...

Data related to cask is scattered around different sources. The goal of this application is to collect and aggregate that data to provide unified access and generate useful statistics.

sources

• SalesforceGoogle
• analyticsWeb Beacons
• Social media analytics (Youtube, LinkedIn, Twitter)Github
• Meltwater
• Pro Ranking (SEO)
• Github web-hooks
• AWS s3 access logs

...

• UI should allow refining all metrics to different time granularities (Hourly, Daily, Weekly, Monthly, Every three months, Every year)

• Visualize metrics in the form of Dashboard (Widgets - Line, Bar, Pie, Scatter, ...)

• Dashboard and backend should support overlaying week-over-week, month-over-month or year-over-year for any metric

• Backend should  allow for raw querying of data through SQL commands

...

• Email and text notifications can be sent using SendGrid or Amazon SNS service

• Users can unsubscribe or subscribe using front end backed by apis

• Generate daily and weekly digest report and email them to stakeholders

• Export data into PDF/Excel available for download in UI

...