Data Analysis, Visualizations, Dashboard and Application Development using Google Sheets, Apps Script and Data Studio
I specialize in building dashboards with spreadsheets, with a focus on Google Sheets and Google Data Studio. Over the past few years, I’ve built many dashboards for myself and clients, bringing together disparate data sources into beautiful-looking, functional dashboards for that ultimate business overview.
I utilize Google Apps Script to customize spreadsheets and extend their functionality. For example, see this scoring template that posts scores to students via Slack or email.
I’m available for consulting and coaching, to advise on issues relating to spreadsheet design and development.
I’ll work with you to solve your problems, on a budget and schedule that works for you.
Why work with me?
I have over a decade of experience working with Excel and Google spreadsheets, in my prior career as a Forensic Accountant and more recently as a freelance spreadsheet developer.
I’ve been developing spreadsheet applications for many years, using VBA back in the day, but now exclusively focussed on using Google Apps Script.
In addition, I’ve written 50+ articles on this site, including many how-to tutorials on working with data in Google sheets.
Helping small businesses understand data better
I work with individuals and small- to medium-size businesses who are looking to better understand and visualize their data. I can assist with data analysis, charting and creating dashboards, using a variety of specialist tools and techniques suitable for the job.
I take on small and large projects as an independent consultant.
Why is data important?
Nowadays even small businesses generate large volumes of data. Understanding that data and using it to your advantage can put you one step ahead of the competition, but that requires time and expertise, which diverts resources away from what you do best, your core business.
Data can give you new insights into your business and help you make informed choices, leading to potential improvements in your bottom line. Dashboards are a fantastic asset, giving you a real-time, high-level overview of your business.
– Performing data analysis and creating visualizations for a startup during their 3-day digital product sale. This helped focus marketing efforts by identifying best channels and times for promotions, as well as providing all members of the team with a near real-time, high-level view of sales progress.
– Creating dashboards showing key financial metrics and sales agent metrics for a real estate firm. Helped client move from viewing rows of data in a spreadsheet to seeing that data in a visual format. The sales agent dashboard consisted of weekly, monthly and yearly leaderboards, on display to the whole team, to show progress and motivate the team.
– Analysis of customer order data to calculate estimated lifetime value, retention rates and churn, for a food delivery startup. Tasks included data cleaning, writing custom queries in MySQL to calculate a number of different metrics, including retention, churn and lifetime value, creating data visualizations and report writing.
How it works
To get started, I need to learn about your business and vision for using your data. The quickest way is to provide some details in the short form below. From there, I’ll get in touch and if I believe we’re a good match and I can assist you, then we’ll connect to discuss the particulars of your project and take it from there.
[contact-form][contact-field label=’First Name’ type=’name’ required=’1’/][contact-field label=’Last Name’ type=’name’ required=’1’/][contact-field label=’Email’ type=’email’ required=’1’/][contact-field label=’What services are you interested in?’ type=’textarea’ required=’1’/][contact-field label=’Any other questions?’ type=’textarea’/][/contact-form]