Using DB Browser for SQLite
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…
Read articleBlog
Ideas & insights
Practical ideas on AI, automation and data for growing businesses.
Git Resources
Resources 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,…
Read article
Grouping in PivotTables
Grouping 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…
Read article
Installing & Running Jupyter Notebook
Step 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…
Read article
Make a Bubble Plot in Excel
Most 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…
Read article
Python Resources
Python 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…
Read article
Understanding JOINs in SQL
Joins 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…
Read article
Understanding Multiple JOINs in SQL
Multiple 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…
Read article
Free Datasets
A 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…
Read article
Formatting Charts in Excel
Formatting 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…
Read article
Excel File Setup for Analysis
Excel 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.…
Read article
What is SQL?
What 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…
Read articleWant this working in your business?
Book a free strategy call and we’ll show you where AI can pay off first.
Book a Strategy Call