As a data analyst at the Data School Down Under, I’ve had the privilege of working with some of the industry’s leading tools like Tableau, Alteryx, and Power BI. However, in the day-to-day grind of analysis and presentation, I’ve found that certain lesser-known tools can be real game-changers. In this post, I’ll introduce you to some of these invaluable assets that have helped me streamline my workflow and elevate my presentations.

Zoomit: When it comes to presentations, clarity is key. Zoomit by Microsoft allows you to zoom in on specific areas of your screen, annotate, and draw attention to important points during analysis presentations. It’s a simple yet powerful tool that enhances communication and ensures your audience stays engaged. Creating entity-relationship diagrams (ER diagrams) to illustrate the relationships between tables can be a common task for data analysts. This tool simplifies this process with its intuitive interface, making it easy to visualize complex data structures and communicate insights effectively.

Excalidraw: Sometimes, a quick sketch is all you need to convey your ideas. Similar to Lucidchart, Excalidraw is a versatile tool that lets you create diagrams and illustrations on the fly, perfect for explaining processes or brainstorming concepts during team meetings.

DBeaver Community: As data analysts, we often find ourselves working with relational databases like SQL Server, Postgres, SQLite, and Snowflake. DBeaver Community is a robust database management tool that simplifies tasks like creating databases, schemas, and tables, while also providing seamless integration with other tools like Alteryx. Another recent discovery for us at DSAU25 is Supabase. Similar to DBeaver, Supabase offers an intuitive UI for database management, making it accessible to users of all skill levels. Whether you’re a seasoned data engineer or a novice analyst, Supabase empowers you to create and manage databases effortlessly.

In a world where data is king, having the right tools at your disposal can make all the difference. These extra tools may not be as well-known as their mainstream counterparts, but they play a vital role in enhancing efficiency and productivity for data analysts. Give them a try, and see how they can take your analysis to the next level.

Prerana Amatya
Author: Prerana Amatya