This is one of my favorite posts of the year to write, because it’s my chance to reflect and look back at the whole year, and celebrate the wins and learn from my mistakes. It’s a chance to assess growth (both for the business and personally) and think about where I want to go in 2019.
2018 was extremely rewarding, but also extremely challenging at times.
Life and business are both moving forwards again and I go into 2019 full of optimism.
Starting with the highlights:
2018 highlights
Online courses
This year I created and launched three new courses:
In terms of the overall school metrics, The Collins School of Data continues to grow and has now seen over 9,000 students enroll in a course. (Thank you! š)
Website
Continued growth of this website, benlcollins.com, which now sees over 200k pageviews/month and 125k users/month, and will reach around 1.7 million pageviews for the year š¤Æ
What’s been really pleasing has been to see it grow over the course of the year:
I published 22 pieces of new content on the site, which is less than previous years but there were some long posts among them. I was proud of the content I published this year, particularly these three posts:
The social media statistics article, about how to import social media stats into Google Sheets with IMPORT formulas, continues to have a lively debate in the comments section, with nearly 300 comments and counting. This has been super fun to see.
I attended the Craft and Commerce Conference in Boise, Idaho in June 2018. I met some interesting folks and picked up some super relevant knowledge from Mariah Coz‘s workshop on course launches
I attended the Google Next 18 Conference in San Francisco in July 2018. I finally got to meet a whole bunch of folks I’ve been chatting with online for years, in person, which was great. The Google Sheets product team announced lots of cool new features coming to Google Sheets (some of which are now live, like the 5 million cell limit)
Investing in Design in 2018
I found a talented designer on peopleperhour.com to create some new course logos for my online courses:
Compare that to the old course logos:
Worth every penny! I was really pleased with how they turned out and they’re so much stronger visually than the old screenshot logos I was using initially.
This is definitely something I want to continue to invest in this coming year.
Stamping my personality on the office
I invested a little bit of time and money to make the office more personal, so it was somewhere I’d want to spend time and feel inspired when I was there.
I hung a few pictures on the walls and built a LEGO Saturn V rocket model to go on top of the bookcase (can you spot it?):
Saving the best for last, non-work highlights included:
Watching my boys grow! It’s the most rewarding and challenging thing I’ve ever done
A weekend hiking in Boulder, Colorado with my wife Lexi. We both felt super energized and happy after a weekend of hiking in the mountains. I absolutely love it out there!
Getting back to a semi-regular running schedule since September, after a health scare earlier in the year (see below). Still far short of where I want to be, but I’m making forward progress again.
The crazy walk we did at Brooker Creek Preserve, where almost the entire 5 mile trail was between ankle and knee deep under water!
I read 20 books this year, which is my highest tally since having children. I attribute some of that to the increased amount of time spent convalescing when I was sick. Highlights this year included:
I had pneumonia earlier in the year that took forever to kick, and made for some nervous months and LOTS of doctor visits. I was basically sick, to varying degrees, most of the days between March and June. I got sick again in September but since then I’ve felt (mostly) back to normal (whatever that is).
Being a two working-parent household doesn’t get any easier (well, it has a little bit since both boys are sleeping through the night). My wife and I are both ambitious and love our work, but balancing being a good dad, a good husband and working hard on my business is still super hard. You end up always feeling like you’re not doing a good enough job at any of them, and it’s mentally exhausting.
I missed some of my targets this year. I didn’t hit my overall course revenue goal (I got close), but being sick for so long meant I launched one less course than I’d planned. That’s life though! Can’t make any excuses, just got to keep working hard and do better in 2019.
Looking forwards to 2019
My goals for 2019:
Create a follow-up Apps Script course to the free Apps Script Blastoff! course I launched in December. I plan to launch this new course in March 2019
Create two other courses. The shortlist at the moment includes: 1) “Beyond Sheets” on what to do when your data outgrows Google Sheets, 2) Regular Expressions in Google Sheets, 3) a Data Studio course, and 4) Google Sheets for Educators
Attend the Google Next 19 conference (give me a shout if you’ll be there!)
Continue to grow the community on this site and the online school
Hold more webinars in 2019, on Google Sheets and Apps Script topics
Personally, I want to deepen my digital analytics and marketing knowledge, particularly GTM, GA and paid Ads, and also continue experimenting with data science and Google Cloud topics. Specifically, I’ll try to find time to work through this book: Data Science on the Google Cloud Platform
Thank you
Of course, none of this would be possible without you readers.
Thank you for giving me this opportunity to share my experiences and knowledge, and carve out this teaching niche. My mission to create a world class resource for learning Data Analysis on the Google platform is just getting started.
Finally, good luck to all of you with your own endeavors and all the best for 2019!
This is a guest post from Tomi Mester of data36.com
Back in 2011, during my college years, I got my first-ever job (an internship) at a cool IT startup. I got to do all kinds of interesting tasks but mostly it was data analysis.
The process was simple:
I received data from the developers in .csv format
I imported it into Excel
I crunched the data there
I sent the beautiful charts to my manager
We learned a lot about user behaviour, trends, and how we reached (or didn’t reach) our goals. I loved it – except for one thing: I always had to wait days (sometimes weeks) for the developers to export the data for me from the company’s SQL database.
That was my #1 reason to learn SQL!
I did so. And ever since then Iāve been a huge fan of this simple and elegant data language.
Why?
Because knowing SQL allowed me to do better, more detailed data analyses – more easily and faster. And I strongly believe that it can be extremely useful for everyone else who works in data analytics and who uses different spreadsheet tools in their day-to-day job.
“If you can’t measure it, you can’t improve it.” – Peter Drucker
Disclosure: Some of the links in this post are affiliate links, meaning I’ll get a small commission (at no extra cost to you) if you signup.
Trying to have conversations about saving, spending and planning for retirement is infinitely more difficult and more stressful without accurate numbers in front of you.
You fall back on anecdotes and feelings because you have nothing else to go on.
Conversations start with phrases like: “it feels like we haven’t spent much on eating out this month” and they don’t get any better from there.
My wife and I have two beautiful boys, aged 2 and 4, and we’re both ambitious with our careers and work full-time. Life is crazy, crazy busy for us right now.
We’ve found it challenging to find time to manage our family finances, so we’ve been in this position of flying blind without a financial tracking plan in place. We’ve had those frustrating conversations, knowing that if we had better insights into our financial habits we could do a much better job at financial planning.
I want to show you how we changed that.
How we created a system in Google Sheets for tracking our spending habits.
It now only takes us about 10 or 15 minutes each week, so we can focus on understanding our financial situation better, and maximize our saving.
Enter Tiller
Tiller is an amazing tool that connects our bank accounts and credit cards securely to Google Sheets (or Excel), and automatically updates them on a daily basis.
It means we can see all of our financial transactions in one place and do our own custom analysis in Google Sheets.
It’s been transformative for our family’s sanity and helped us get on top of our spending and hit our saving goals.
Tiller has a suite of Google Sheet templates available too, covering spending, saving, budgeting and net worth tracking, so that you can visualize your financial data immediately.
Of course, you can also build your own solutions to answer whatever questions you have.
It costs $79/year, which is tremendous value since you’re getting a fully customizable, automated personal finance tool.
How to setup Tiller with Google Sheets
Tiller is a third-party tool so you have to create an account with them, which is done securely through your Google account credentials.
This is what your homepage looks like, and where you add accounts or create new Google Sheet templates:
Once you add the bank accounts and credit cards you want to track, you can go ahead and create a new Google Sheet:
Click Create and the magic happens! ?
After a short while, you can click over to your new Google Sheet, populated with all of your transaction data!
How we use Google Sheets to track our spending habits
We’ve setup categories to group our transactions, so that we can see how much we’re spending on different things at a high-level. For example, we group all restaurant expenses together into an “Eating Out” category, which allows us to see how much we spend eating out.
You want enough categories to differentiate items in a meaningful way, but not too many that you end up with too much granularity. The whole idea is to summarize transactions into something more manageable.
Each week my wife or I will jump into the Tiller Sheet and categorize any new transactions. It’s as simple as selecting the category from the drop-down menu in Transactions tab in the blank cell next to the transaction name:
You can even use Tiller’s new Autocat tool to now automatically categorize transactions for you.
Creating custom reports with Tiller and Google Sheets
I’m going to share our solution for tracking our spending habits.
It allows us to understand how we’re spending our money and identify ways to reduce it.
I created a summary table in our Tiller Google Sheet, which shows our family spending by category. It takes the data we’ve categorized in the transactions tab, which is automatically updated by Tiller, and summarizes it.
The transactions are summarized by categories in the rows, and by months across the columns. Columns A and B contain checkboxes, which I use to control which spending categories to show in my charts.
This table alone gives us more insight into our spending habits than anything the bank gives us. Every single transaction is included and categorized, by us not the bank.
In my case, I’ve used a QUERY function in cell C3 to retrieve, aggregate and pivot my transaction data:
=QUERY(QUERY(Transactions!A1:O,"select C, sum(D)*-1 group by C pivot K"),"offset 1",0)
Visualizing our spending habits in Google Sheets
I added the checkboxes in columns A and B, so there’s a way for my wife and I to choose categories to focus on.
The checkboxes can be individually checked or unchecked and they feed into other data tables that only show the data for the checked items.
Our mortgage, car lease and utility payments remain largely the same month-to-month. We know we have to pay them every month, so we don’t necessarily need to see them every time. (That’s not to say they’re not important, but trying to visualize all your categories at once will just clutter your charts to the point of being useless. )
However, seeing our discretionary spending — things like travel and eating out for example — helps us understand our spending habits and find ways to save more money in a healthy way.
We’re currently using two charts to track our spending habits:
Chart 1: Current monthly spend vs. Average monthly spend
The first is a monthly breakdown by category, showing actual spend this month (blue) against the average amount we spend in this category each month (red):
(Chart shows fictional data.)
Chart 2: Discretionary Spend by Month
The second is a look at our discretionary spending over the past few months, so we can see how selected categories are trending (chart shows fictional data):
The combination of the monthly category breakdown table and these two simple charts gives us tremendous insight into our spending habits.
Knowing how we’re spending our money gives us tremendous peace of mind.
It’s helping us to minimize our unnecessary spending and maximize our saving.
Note: I’m not a financial expert and this post does not provide financial advice. It simply shows some techniques for working with and presenting data in Google Sheets.