Analytics

7 Important Bookmarks for Data Analyst

Bookmark tab on a web browser

The truth is that being an analyst is all about balancing quality versus speed. This manifests itself in finding good tools which help make you more efficient. If there is one thing that analysts all agree upon, it is that no single tool does everything great. One piece of my advice to analysts is to start a collection of online bookmarks.

Here are the Top 7 bookmarks that every analyst should have. Some are useful on a daily basis, and others are situational and rarely used. However, you’ll probably need them someday, and when you do — it’ll save you a lot of time.

#7 Ascii Table Formatter

A table formatter lets you convert a block of copy/pasted data into a much more efficient and aesthetically pleasing format. This comes in handy in a variety of different ways.

Ascii Table Formatter will automatically convert the text without having to click anything; it is instant!

ASCII Table Formatter

#6 SQL Beautifier

When simplifying SQL Code, try using SQL Beautifier.

Normal Code

SQL Code beautifier 1

Formatted Code

SQL Code beautifier 2

#5 JSON Viewers and Converters

Want to quickly browse a JSON structure to see what elements are available? Need to debug why your parsing script is failing? Then I recommend checking out:

#4 Graph Builders

There are plenty of online resources for building quick graphs, but RAWGraphs 2.0 is my favorite. I like it because it has a wide range of lesser-known chart types (like Calendar heatmap and Circle Packing) that otherwise take too long to figure out in Excel.

.Graph builder

#3 SQL Generator

A SQL Generator is basically a template for a SQL query, which lets you customize column names and table structure, choose the operation you want to do, and then construct the syntax for you in various “flavors” of SQL.

Never worry about the subtle differences between DATEDIFF() vs. DATE_DIFF()again! My personal recommendation is Rasgo.

#2 Color Picker for Reports

For picking color code, I use the W3 HTML Color Picker. It has a wide range of colors and color combinations.

#1 Dax Studio

DAX Studio is a tool to write, execute, and analyze DAX queries in Power BI Designer, Power Pivot for Excel, and Analysis Services Tabular.
It includes an Object Browser, query editing and execution, formula and measure editing, syntax highlighting and formatting, integrated tracing, and query execution breakdowns.

Dax

Conclusion

The truth is that being an analyst is all about balancing quality versus speed. A toolkit that helps you cut corners without sacrificing quality is a way to improve your effectiveness.

Thank you for reading.

 

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Arpit Malviya

Arpit Malviya has worked at Perficient as a technical consultant. He has been working in the Power BI & Data Analysis field since 2019.

More from this Author

Follow Us
TwitterLinkedinFacebookYoutubeInstagram