Regardless of whether you are on a free or paid account, you have two options:
-Public: Upload data or use data that is already in a database that Mode hosts. All data and analysis done here is visible to anyone. This is most commonly used with the SQL tutorials that others have posted about here.
-Private: Connect your database to Mode and do analysis on your own data. This is only visible to people you add to your Mode Organization. In fact, making your private data accessible to people outside your Organization is a paid feature and comes with more granular permission controls.
We have tried to make this as clear as possible in the product and ToS, but looks like we missed on the latter. We will revise to make it clearer.
Hey! I'm Mode's CEO. We host a database that contains all the data for tutorials. You can also upload CSVs to this database and do analysis to share with others, but the data and analysis are publicly visible. This is a feature we have had for awhile.
The paragraph below the one you cited says "The private function is available in two versions: (i) free of charge (with limited functionality) and (ii) as a premium paid Service (“Premium Service”)." This is the thing that's new today -- you can now work with private data for free.