Data Analytics Toolbox for 2023

With so much to understand, learning data analytics can be frustrating.

But what if I told you that there are only a handful of important tools that you should prioritize?

Rather than overwhelm yourself and chase the new tool each week, master the foundations:

1. Excel

2. A Business Intelligence Tool

3. SQL

4. A programming language

5. PowerPoint

6. ChatGPT & other AI tools

1. Microsoft Excel

If you didn’t already know, Microsoft Excel has been the undefeated heavyweight champion in the analytics world since November 1987. It continues to be the most widely used tool for numerous reasons.

Even while some people will use Excel more frequently than others, it is still useful tool for creating reports and doing data analysis. While you can perform many data cleaning tasks in Excel, you can also use Power Query as well.

Looking to improve your Excel skills? Try out our free challenges in Data Analysis or Data Visualization.

2. Any BI Tool (Power BI or Tableau)

The GIF is for entertainment only. You cannot go wrong with learning either Tableau or Power BI. But, a huge advantage in Power BI is their built in ETL (Extract, transform, and load) capabilities with Power Query. Unfortunately, doing major cleaning or transformations in Tableau without the added tools of Tableau Prep or Alteryx is not very ideal.

Once you learn how to use a tool, immediately put your focus on data storytelling and dashboard design. The following books are must reads to improve these in demand skills:

3. SQL

Most often, an organization will have their data stored in databases. Making SQL a must know skill. Once you learn how to build the basic queries, transition into more advanced SQL such as:

• Subqueries

• Window functions

• CTEs

• Datetime manipulations

• Query optimization

Expect to have your SQL knowledge questioned during a technical interview as well.

If you’re looking to improve your SQL skills check our free public SQL challenges and our free case studies.

4. A programming language (Python or R)

Like the other one, this GIF is also purely for entertainment. You can build a great career with either tool. But, understand that python is more widely used which is why its more often recommended over R.

While you can do many things with a programming language, (analyze data, clean & transform data, etc), a major value add is your ability to automate processes.

If you build a dashboard, can you also create a process where it’s automatically refreshed with new data each week or month? The ability to automate tasks such as building a data pipeline, can decrease hours of manual work.

Out of every tool on this list, I would focus on a programming language last. As it can have the steepest learning curve.

Looking to improve your programming skills? Check out our Python for Business Analysis workshop, our free challenges in python, and data analysis.

5. PowerPoint

You may find this to be the most unexpected tool on the list. Slide deck and oral presentation skills are very underrated.

Expect to build and present slide deck presentations as you gain more experience. Where you will be exercising your presentation skills to influence decision makers in upper management.

A great way to practice is to create slide deck presentations for your portfolio projects like an example shown here.

While nothing beats actual experience, here are some good books to improve your skills:

6. ChatGPT & Other AI Tools

If you have been worrying about AI taking your job, I have some good news and bad news for you.

The good news: AI won’t be replacing you!

The bad news: Its the analyst who knows how to leverage AI tools to expedite their workflows, produce more value in less time, and learn new things quicker that will.

While there seems to be an AI tool for everything now, I would just leverage the ones that improve your productivity. For example, you can decrease your troubleshooting time using ChatGPT. You can also utilize co-pilot to assist you as well.

Important note: These tools are only as smart as the user. They are not a replacement for knowledge as you still need to have evolving skills of your own.

Next Steps

You may be wondering where you can get even more practice to build up these skills. Well, the community-based learning platform I have been working on will soon be launching this summer.

An all in one place for building in demand skills, an engaged community, mentorship, and live learning events.

The pre sale has officially launched and you can save over 20% on a yearly or lifetime membership.

You can also learn these skills in more depth in my upcoming book Becoming a Data Analyst.

If you have any questions, please reach out.

Very Respectfully,

Kedeisha Bryan