How to Use Mode

Getting started with Mode

In this guide, you'll learn how to sign up for Mode and create your first data analysis project using SQL and visualisation tools. You'll be ready to explore data and create insightful dashboards in just a few minutes.

Step 1: Sign up and set up

1. Go to mode.com.
2. Click on the "Sign Up" button in the top right corner.
3. Enter your email address and create a password, or sign up using Google or Microsoft.
4. Confirm your email by clicking the link sent to your inbox.
5. Log in to your new account.

Step 2: Your first SQL query

1. Once logged in, click on the "New Report" button on the dashboard.
2. Select "SQL" from the options presented.
3. In the SQL editor, enter a simple query like SELECT * FROM your_table LIMIT 10; (replace your_table with your actual table name).
4. Click the "Run" button to execute your query.
5. After the results load, click "Visualize" to create a chart or graph from your data.
6. Choose your preferred visualisation type, adjust any settings, and click "Save" when you’re satisfied.

Step 3: Get better results

• Use the "Filters" panel on the left to refine your data. This allows you to focus on specific segments without altering your original query.
• Explore the "Visualisation" settings to customise colours, labels, and chart types for clearer presentation.
• Collaborate by clicking the "Share" button to send your report to team members via email or by generating a shareable link.

Pro tip

Take advantage of the "Templates" feature in the report creation area. This saves time by allowing you to start with pre-built queries and visualisations that you can modify to fit your needs.

Common mistake to avoid

Don’t forget to save your work frequently. It's easy to lose progress if you navigate away from your report without saving. Use the "Save" button often to ensure your changes are not lost.