Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Databases Introduction to Window Functions

Brendan Whiting
seal-mask
.a{fill-rule:evenodd;}techdegree seal-36
Brendan Whiting
Front End Web Development Techdegree Graduate 84,738 Points
Posted by Brendan Whiting
.a{fill-rule:evenodd;}techdegree seal-36
Brendan Whiting
Front End Web Development Techdegree Graduate 84,738 Points

Database setup help.

How do we do the part where I put the data into PostgresSQL and connect it to Mode Analyitics? Are there alternative tools where I could just upload the csv and play around with some SQL and not have to worry about installing things locally?

1 Answer

Dave McFarland
STAFF
Dave McFarland
Treehouse Teacher
Dave McFarland
Dave McFarland
Treehouse Teacher

Brendan Whiting

You can use Mode without worrying about setting up Postgres.

  1. Create a free account on Mode: https://modeanalytics.com/signup
  2. Create a new Mode Report
  3. For the "data source" select the Mode Public Warehouse
  4. Use the treehouse.chess_data_matches table
Mark Chesney
Mark Chesney
11,747 Points

Hi Dave,

Thanks for this procedure. This was a little tricky after step 1. I finally found the New Report, even though it sure wasn't obvious -- took me five minutes. Anyway, thanks!

Janko Bauer
Janko Bauer
13,358 Points

Thanks !!!