Categories
Choose a category, or scroll down for all posts.
Data Analytics | Excel | Git | Python | SQL | Statistics | Uncategorized
Common Python Errors
September 1st, 2019 by boxplotanalytics_kfr8aiThis post is updated as appropriate, so keep checking back! Table of Contents Errors when installing python with homebrew Error: Permission denied Error: Could not symlik bin Errors when writing/running python code TypeError NameError IndentationError SyntaxError IndexError KeyError ValueError Installing Python Error: Permission denied @ dir_s_mkdir – /usr/local/Frameworks Check out this article for help: https://github.com/Homebrew/homebrew-core/issues/19286 […]
Tables & Linking Data Structures in Excel
September 1st, 2019 by boxplotanalytics_kfr8aiTables are one of the most important features of Excel, but are often overlooked. Tables and keeping analyses in Excel connected, will drastically increase your efficiency in Excel. Let’s start by understanding how they work with PivotTables. We’re going to use an R Dataset called DoctorContacts. Download the .csv file using this link (and save […]
September 1st, 2019 by boxplotanalytics_kfr8ai
DB Browser for SQLite (it’s also called SQLite Browser for short) is an excellent tool for practicing SQL without having to get connected to a real live server. This post will walk through how to install, open, and use SQLite Browser. Install SQLite Browser Go to the SQLite Browser website and choose the download for […]
Git Resources
September 1st, 2019 by boxplotanalytics_kfr8aiResources for Learning Git Atlassian’s GitFlow Page This is a short tutorial article focused on a typical Git sequences. try.github.io A list of Git Resources, broken down by type.
Grouping in PivotTables
September 1st, 2019 by boxplotanalytics_kfr8aiGrouping in PivotTables is a way of combining data to perform analyses without having to use functions. You can group numeric columns to turn them into categories, you can group date columns by date ranges to get even intervals, and you can group text columns to put together similar values. We’ll go through all three […]
Installing & Running Jupyter Notebook
September 1st, 2019 by boxplotanalytics_kfr8aiStep 1: Install Anaconda Go to this download webpage on Anaconda’s site. Choose the correct link for your operating system, and then go through the installation process. Step 2: Prepare a folder for notebooks Choose or create a folder on your computer where you will store all Jupyter notebook files. Make sure you choose a place […]
Make a Bubble Plot in Excel
September 1st, 2019 by boxplotanalytics_kfr8aiMost people don’t know that bubble plots even exist in Excel. In this blog post, we’ll walk through how to take advantage of these very effective charts! They are great for comparing three quantitative variables at once. For a nice intro to bubble plots, check out Hans Rosling’s very famous Ted Talk. If you don’t […]
Python Resources
September 1st, 2019 by boxplotanalytics_kfr8aiPython Resources Driven Data This is a great way to tackle Machine Learning and Python at the same time! I also like Driven Data because it’s a project with a specific goal. I think that’s the best way to learn! Automate the Boring Stuff with Python This is another project-based site that also is […]
Understanding JOINs in SQL
September 1st, 2019 by boxplotanalytics_kfr8aiJoins in SQL Joins are one of the most important (if not THE most important) concepts in SQL. If you take the time to solidly understand how joins work, you’ll be in an excellent place for writing queries. So, let’s dive in! Join Definitions Joining tables in SQL is a way of combining them. It […]
Understanding Multiple JOINs in SQL
September 1st, 2019 by boxplotanalytics_kfr8aiMultiple joins are one of the toughest SQL concepts – in this post we’ll decode them and review some common pitfalls. One of the best ways to learn is with an example. If you’d like to follow along, you can download this zip file that contains the three tables as .csv files here, and import […]
Free Datasets
September 1st, 2019 by boxplotanalytics_kfr8aiA list of freely available data on the web. The first list is sites we think are the best for accessing quality datasets. Below that are additional sources by category. Best Sources Kaggle By far our personal favorite! There are dozens if not hundreds of quality datasets available here. ICPSR You have to create an account, […]
Formatting Charts in Excel
September 1st, 2019 by boxplotanalytics_kfr8aiFormatting charts in Excel is no easy task. It’s time-consuming, and Excel is pretty fussy which doesn’t make things easier. In this post I’ll give general tips for formatting charts, and also go over a few common scenarios. Understand the Parts of a Chart First thing’s first: it’s important to get the syntax down pat […]
Excel File Setup for Analysis
September 1st, 2019 by boxplotanalytics_kfr8aiExcel gives you a lot of flexibility when creating files and starting projects, and we’re often asked what the “best” solution is for keeping things organized. This post will review what we recommend. As with everything in life, there may be a few exceptions where you’ll want to set up your file differently. However, this […]
What is SQL?
August 31st, 2019 by boxplotanalytics_kfr8aiWhat is SQL? Currently, if you Google this question, you’ll get a whole slew of technical articles that aren’t very helpful for understanding just what SQL is and when people use it. We’ll break that down in this blog post. This is a high level overview – if you want to understand how to actually […]
100th Anniversary of Variance
December 28th, 2018 by boxplotanalytics_kfr8aiThis year (2018) is the 100th anniversary of a paper by R. A. Fisher, which introduced the statistical term “variance”. Variance is one of the toughest concepts in statistics, but it’s crucially important. Variance tells you how spread out your data are (yep, “are”; the word “data” is plural!). First, let’s get some terminology out of […]
