Mastering your Data Stack — Part 4: Building Your Dashboards
28 January, 2025
Metabase and Panel are the two products we utilized to craft our visualizations for this project Welcome back to our series where we are sharing a step by step walkthrough of our data stack development process. In the previous iteration of this series, we discussed how to transform raw data extracted from your sources into […]
Visualization Theory — The Secret to Game-Changing Dashboards
28 January, 2025
Photo by 1981 Digital on Unsplash If you have been following along with our recent content, you will know we’ve been putting together a Series outlining our tips and tricks for building a world class data stack. While writing the entry on Data Visualization, we found ourselves expounding on the theory behind visualization itself. So, we decided to publish a separate […]
Mastering Your Data Stack — Part 3: How to Transform your Data with dbt
28 January, 2025
A sample DAG from our NHL project — showing the connections and flow of models within dbt Welcome back to our series where we are sharing a step by step walkthrough of our data stack development process. In the previous iteration of this series we walked through how to initialize your selected Data Warehouse and […]
Mastering Your Data — Part 2: Tips and Tricks for Setting up a Best-in-Class Data Pipeline
28 January, 2025
Photo by Shahadat Rahman on Unsplash Welcome back to our series where we are sharing a step by step walkthrough of our data stack development process. If you have not already done so, we highly recommend checking out Part 1 of this series to familiarize yourself with the various components of the modern data stack, and to understand which components […]
Mastering Your Data — Part 1: Selecting the Right Pieces for Your Data Stack
25 October, 2024
This post represents the first in a series of content we will be sharing to walk step-by-step through our data stack development process and provide some guidance to others facing the common problem of consolidating data from disparate locations to drive meaningful insights. Of course, there are a myriad of ways to solve any problem […]
Leveraging Big Data in a Small Business: Unlocking New Opportunities
25 October, 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 […]
Strategies for Implementing Dashboards Effectively
22 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 […]
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 […]
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 […]