exploring public apis with mongodb and analytica n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Exploring Public APIs with MongoDB and Analytica PowerPoint Presentation
Download Presentation
Exploring Public APIs with MongoDB and Analytica

Loading in 2 Seconds...

  share
play fullscreen
1 / 12
osgood

Exploring Public APIs with MongoDB and Analytica - PowerPoint PPT Presentation

166 Views
Download Presentation
Exploring Public APIs with MongoDB and Analytica
An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Exploring Public APIs with MongoDB and Analytica Nosh Petigara nosh@analytica.com @noshp

  2. Today • MongoDB and public APIs • What is Analytica? • Demo • Analytica shell (twitter data) • Analytica for Excel (StackOverflow data)

  3. MongoDB and public APIs • Most APIs talk JSON • MongoDB’s native JSON import • APIs vary wildly (internally and between one another) • MongoDB is schema-free • Data import is only half the battle • MongoDB’s query language and aggregation framework

  4. Some data sets to explore • Twitter API (JSON) • https://dev.twitter.com/ • Crunchbase API (JSON) • http://developer.crunchbase.com/ • Stackoverflow (JSON and CSV) • http://data.stackexchange.com/ • NYTimes (JSON, XML) • http://developer.nytimes.com/docs

  5. Importing data sets • Streaming JSON directly into MongoDB • curl https://stream.twitter.com/1/statuses/sample.json–uUSERNAME:PASSword| ./mongoimport –d twitter –c tweets • Importing JSON files • ./mongoimport –d mydb –c mycollfile.json • CSV • ./mongoimport–d db –c coll --type csv --headerlinemyfile.csv

  6. Analytica • Analytics & reporting platform for MongoDB • Natively understands JSON/document hierarchy • Tailored for analytics (not querying) • Works directly on MongoDB • Discovery, analysis, visualization cycle • In private beta [http://analytica.com]

  7. What can you do with Analytica? Inspect and extract data Augment your data model Calculate & aggregate Filter and transform data Join collections

  8. Demos • Today • Twitter stats [using the Analytica Shell] • Stackoverflowcommunity analysis [using Analytica for Excel] • Not shown • REST API • Analytica web (Coming soon)

  9. Demo 1: Twitter data

  10. Some other examples

  11. Demo 2: StackOverflowUser Profiles

  12. Next steps • Private beta • http://analytica.com • Get in touch • nosh@analytica.comor info@analytica.com • @analytica_inc on twitter