When Seeking Alpha set up our data warehouse, we had an easy time choosing Vertica as our SQL database backend.
We had a much harder time finding a good front end. We saw many different tools, including traditional BI systems and cloud-based visualization services. But none met our core requirements:
1) Minimal learning curve for all users
2) Extremely easy sharing between users at international locations
3) Extremely easy visualization
4) Automated detection and alerts about data errors
5) Automated alerts about important developments
6) No separate login required
7) Low cost
8) No server maintenance overhead
9) Scalable to any level we ever need
10) Platform-agnostic, able to serve our PC and Mac users
11) Flexible and extensible to handle evolving needs
We spec’ed and developed our own internal system, using Google Docs spreadsheets as the core component. This allows any user with basic spreadsheet skills to create auto-updating data tables, visual dashboards, and alerts for exceptional conditions, and to share anything created with users company-wide. Everything created is fully integrated with our company’s Google Docs system, which is our primary tool for documents and spreadsheets. Error detection, data backups, and many other administrative functions are all handled within the Google Docs platform.
This presentation will explain the architecture, advantages, and limitations of our system. We have found it cheap, easy, and extremely flexible, and hope others agree.
I am a hands-on data science leader excited about the potential of data mining and analysis tools to make a real difference in business, public health, medical research, and clinical practice. I am interested in working in organizations that leverage these technologies to succeed in business and improve global health.
I am passionate about the technologies I use, but also about the people I work with. I have been privileged to recruit, train and manage an exceptional team, and to be managed by insightful mentors. Collaborating with them is a constant source of excitement and inspiration for me.
Comments on this page are now closed.
For exhibition and sponsorship opportunities, email firstname.lastname@example.org
For information on trade opportunities with O'Reilly conferences, email email@example.com
For media-related inquiries, contact Maureen Jennings at firstname.lastname@example.org
View a complete list of Strata + Hadoop World contacts
©2015, O’Reilly UK Ltd • (800) 889-8969 or (707) 827-7019 • Monday-Friday 7:30am-5pm PT • All trademarks and registered trademarks appearing on oreilly.com are the property of their respective owners. • email@example.com
Apache Hadoop, Hadoop, Apache Spark, Spark, and Apache are either registered trademarks or trademarks of the Apache Software Foundation in the United States and/or other countries, and are used with permission. The Apache Software Foundation has no affiliation with and does not endorse, or review the materials provided at this event, which is managed by O'Reilly Media and/or Cloudera.