What is a Local Database, and How to Get Setup?
Getting started with a database, and beginning to learn SQL can be difficult. We definitely experienced this challenge in our analytic education journeys, and have witnessed it first-hand teaching analytic classes. So, we pulled together a brief video walking through the context of a database + a tutorial on getting a local database setup. Let us know what you think!Read Full Article
Data for Practicing SQL
We built two (2) different datasets to encompass a motivating hypothetical that's based of personal experience. This is an abridged version of a practical dataset both Serge and I have had to interact with at work. In total, there's only one hundred twenty five (125) rows of data, but that's all you'll need to get up and running with SQL and/or continue to hone your skillset.Read Full Article
The Best Way to Present a Spreadsheet to a Group
Here's a three (3) step formula for getting the most out of presenting a spreadsheet to others...
Read Full Article
Average Annual Return of 25%, but $0 of Growth?
Imagine you have $1,000,000 in an investment account (one day, right). Over the course of two years you generate the following returns: Start of Year 1 to End of Year 1: +100%. Start of Year 2 to End of Year 2: -50%. What is your average annual return?Read Full Article
The Difference Between: Absolute, Basis Point, Multiple, Percent, and Percentage Point Change
There’s a lot of ways to articulate the amount of change between two or more numbers. Very often an explanation can be interpreted in more than one way, and/or hide important elements of truly how much something has changed. Unfortunately there is no one right answer, but we do think there is an answer - and it’s to use all metrics of change, all of the time. In doubt, better to give too much information than less.Read Full Article
A Beginner's Guide to Data
We put our first product in motion today by launching on Udemy, and we couldn't be more excited! The course is titled: A Beginner's Guide to Data, and it's the analytics context we wish we had, when we first started. Use the link provided to visit the official Udemy page and receive a 50% discount (automatically applied).Read Full Article
A Fresh Perspective: Big Data
Here at The San Francisco Data School we find the term Big Data to be ambiguous, and evolutionary. Both adjectives are being used optimistically. As in, we think there should be more than one interpretation (ambiguous), and that those interpretations should be refined over time (evolutionary).Read Full Article