Product
Outlier is automated data insights for your entire business.
Book a Demo
Industries
Outlier is automated data insights for your entire business.
Book a Demo
Solutions
Outlier is automated data insights for your entire business.
Book a Demo
Resources
Outlier is automated data insights for your entire business.
Book a Demo

Data Analysis Tools

Data Analysis Tools

This is part 1 of a 5 part series on Data Analysis Tools.

This week I’ll show you how to use a few of the various data analytics tools available to compute simple statistics and visualize your data. There are a number of tools available, and I will cover the following four by showing you how to create some of the metrics and charts I’ve talked about the last few weeks:

  • Microsoft Excel
  • Google Sheets
  • SPSS
  • R

In addition to showing you how to do analysis and charting in each tool, I’ll touch on a few of the pros and cons that I’ve found in my experiences.

It can be hard to decide which tool to use given how many are available. One primary difference between the tools is the degree to which a user is provided a graphical interface with which to interact. Microsoft Excel and Google Sheets are used primarily via their graphical user interface so you can quickly explore and engage with your data – changing one input will immediately update all of your outputs. R, on the other hand, is a full programming language that takes more of an effort to get started using, but once you learn how to code you can do sophisticated analyses and produce powerful visuals. SPSS is a middle ground between these extremes in that it provides users with point-and-click features that beginners will appreciate, but also gives you the code to generate your analysis and plots so you can replicate or edit in the future.

You might not be familiar with all of these tools and be interested in learning how to use a new one. I’ve found the best way to learn is to force myself to conduct a small project using the new tool. When I only study how it works or use sample data, it’s hard to prioritize or persist in my learning. But when I have a real business deliverable on the line, I make the time to learn how to use the new tool.

I find the best way to demonstrate these tools is via a short video. So, go grab some popcorn and enjoy!

Data Analysis Tools: Microsoft Excel

This is part 2 of a 5 part series on Data Analysis Tools.

Today we’ll demonstrate how to use  Microsoft Excel¹ to calculate metrics and make charts via a short video (8 minutes, 20 seconds).

[1] Outlier is not affiliated with Excel and do not receive any benefits from Microsoft if you use their products.

Data Analysis Tools: Google Sheets

This is part 3 of a 5 part series on Data Analysis Tools.

Today I’ll demonstrate how to use Google Sheets¹ to calculate metrics and make charts via a short video (6 minutes, 24 seconds).

[1] I am not affiliated with Google Sheets and do not receive any benefits from Google if you use their products.

Data Analysis Tools: SPSS

This is part 4 of a 5 part series on Data Analysis Tools.

Today I’ll demonstrate how to use  SPSS¹  to calculate metrics and make charts via a short video (7 minutes, 38 seconds).

[1] I am not affiliated with SPSS and do not receive any benefits from IBM if you use their products.

Data Analysis Tools: R

This is part 5 of a 5 part series on Data Analysis Tools.

Today I’ll demonstrate how to use  to calculate metrics and make charts via a short video (8 minutes, 33 seconds).

[1] I am not affiliated with R and do not receive any benefits from the R Foundation for Statistical Computing if you use their products.

Sign up for a single idea in your inbox every Monday, to help you make better decisions using data.

Share this Post