1 / 12

Exploring Public APIs with MongoDB and Analytica

Exploring Public APIs with MongoDB and Analytica. Nosh Petigara nosh@ analytica.com @ noshp. Today. MongoDB and public APIs What is Analytica ? Demo Analytica shell (twitter data) Analytica for Excel ( StackOverflow data). MongoDB and public APIs. Most APIs talk JSON

osgood
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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

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

More Related