Leveraging Big Data in a Small Business: Unlocking New Opportunities

10 July, 2024

In today’s data-driven world, big data isn’t just for big businesses & corporations. Small businesses can also tap into the power of big data to gain valuable insights, make informed decisions, and drive growth. That said, many small business owners may feel overwhelmed by the sheer volume of data and the complexity of big data […]


Unraveling Nested JSON with dbt and BigQuery: A Hands-On Guide

10 July, 2024

If you’re like me, you might find that working with JSON data can often feel like trying to untangle a ball of wool. Nested structures are common in JSON files and can become particularly convoluted when they contain multiple levels of nested data. In the past, I’ve spent hours creating CTEs in SQL to solve […]


How to Access Your NetSuite Data in the Places You Need it Most

10 July, 2024

Accessing Your NetSuite Data in BI Tools like Domo or database IDEs like DataGrip NetSuite contains critical information about the finances and operations of your business. When it comes to keeping track of all of this information, NetSuite offers a powerful analytics tool called SuiteAnalytics, which enables you to explore and analyze your data within […]


Strategies for Implementing Dashboards Effectively

10 July, 2024

Uncluttering your Data Reporting: Proven Techniques to Build Dashboards that Drive Decisions Photo by Stephen Dawson on Unsplash Introduction: In today’s data-driven business landscape, dashboards have become indispensable tools for decision-makers. They provide a visual overview of key performance indicators (KPIs) and actionable insights that guide strategic planning. However, crafting an effective dashboard isn’t just about putting together […]


How to Configure BigQuery and Looker to Upgrade Your Analytics

27 November, 2023

The combination of Google BigQuery and Looker is one of our favorites when it comes to setting up a solid data warehouse and business intelligence foundation for your business. BigQuery’s robust data warehouse capabilities, paired with Looker’s interactive data visualization tools, offer businesses a best-in-class opportunity to glean actionable insights from their data. This guide […]


ChatGPT — A New Era of Problem Solving

27 November, 2023

Those of us who were born right on the cusp of the digital age bear a unique distinction — we can remember what school was like both before and after ubiquitous internet access! As a kid, I spent countless hours in the school library receiving instructions on how to find the right research books to […]


How To Get Your Business’s Google Reviews into BigQuery & Looker Studio

27 November, 2023

Customer reviews are invaluable resources that can provide keen insights into customer satisfaction, business performance, and areas for improvement. For businesses using Google My Business, the wealth of Google review data is often untapped when it comes to analytics. One powerful way to analyze your Google review data (or the Google review data of your […]


5 Tips for Transitioning from Finance to a Career in Data

14 September, 2023

Photo by Stephen Dawson on Unsplash By this time of year, thousands of recent grads have begun a career in Finance. For many young professionals, this career path will stick — and that’s great! A career in Finance brings a lot of early exposure to different companies, industries, and management styles. If you’re like me though, it might […]


How to Break into the World of Data Analytics

14 September, 2023

“Start where you are. Use what you have. Do what you can.” — Arthur Ashe In today’s increasingly data-driven world, the field of data analytics offers a multitude of exciting career opportunities. Whether you’re a recent graduate, or a professional looking to transition into a new field, getting into data analytics can seem challenging at […]


SQL for Analytics: Best Practices and Common Pitfalls

11 September, 2023

SQL (Structured Query Language) is a powerful tool in the world of analytics. It allows analysts to retrieve, manipulate, and analyze data stored in relational databases, offering deep insights into various aspects of business performance. However, as with any powerful tool, there are best practices to follow and pitfalls to avoid. This blog post aims […]