top of page

Insights
![Stop Pulling QuickBooks Reports Client-by-Client - Here's the Faster Way [Pineapple Analyst AI]](https://i.ytimg.com/vi/XGe9Z5rvQcU/mqdefault.jpg 1x, https://i.ytimg.com/vi/XGe9Z5rvQcU/maxresdefault.jpg 2x)
01:11

44:31

44:22
![The 2-Step Framework to Move Bookkeeping Clients Into Advisory Services [Pineapple Analyst]](https://i.ytimg.com/vi/HR0QNGV7oOY/mqdefault.jpg 1x, https://i.ytimg.com/vi/HR0QNGV7oOY/maxresdefault.jpg 2x)
04:55

46:00

42:42

41:51

00:46
Search
How to Measure ROI from Analytics
Analytics ROI comes down to one formula: (Value of decisions made faster or better, minus the fully loaded cost of the analytics work) divided by that cost. If the ratio is positive, the investment paid for itself. If it's flat or negative, you're paying for reporting, not for decisions. That sounds simple. It's the "value of decisions" side that owners get wrong, because it's not the dashboard's subscription fee that matters - it's what changed because someone could see the

Jack Tompkins
1 day ago4 min read
Â
Â
Â
Do You Need a Data Warehouse to Build Dashboards?
No. Most small businesses don't need a data warehouse to build dashboards. If you're working with one or two source systems and don't need to preserve history the source system throws away, you can build clean, reliable dashboards by connecting directly to your existing tools - QuickBooks, HubSpot, Stripe, whatever you're running - with a BI tool like Looker Studio or Power BI. A data warehouse becomes necessary when data volume grows past what live connections can handle, wh

Jack Tompkins
4 days ago5 min read
Â
Â
Â
Fractional Analyst vs. Full-Time Hire: What It Actually Costs
A fully loaded data analyst hire runs about $135,873 a year. See the full cost breakdown against a fractional analyst retainer, plus when hiring full-time is the right call.

Jack Tompkins
Aug 244 min read
Â
Â
Â


More Strategy from Less Meetings: 10 Steps to Implement a Data-Driven Culture for Better, Faster Client Actions
We give off a very fun vibe at Pineapple 🍍. It’s intentional, it’s how we like to work, and it’s part of the reason why clients continue...

Jack Tompkins
May 3, 20255 min read
Â
Â
Â


How to Use One Date Filter for Multiple Data Sources in Looker Studio (Without Linking Tables)
Easily Use One Date Filter Across Multiple Data Sources in Looker Studio | Looker Studio Expert Tips How To: Set ONE Date Filter for...
Brittany
May 1, 20253 min read
Â
Â
Â


Master Advanced Dashboard Creation in Google Looker Studio: Our Newest Online Course
Dashboards are the backbone of data-driven decision-making. They help businesses track key metrics, analyze trends, and optimize...
Brittany
Apr 23, 20254 min read
Â
Â
Â


How to Set Up Row-Level Security in Google Looker Studio
Only show the right data to the right people—automatically. Let's start with the basics: What is RLS? Row-level security acts as a...
Brittany
Apr 14, 20254 min read
Â
Â
Â


How to Build Class-Level Dashboards in QuickBooks Using Google Looker Studio
Running a small business can be a wild ride. You’ve got revenue coming in from multiple places, constant expenses, and keeping track of...
Brittany
Oct 23, 20245 min read
Â
Â
Â


How to Add a Forecast to Your Dashboard: A Step-by-Step Guide With Video Tutorial (Google Looker Studio)
Check out our Google Looker Studio Consulting Add-Ons page. Incorporating a forecast into your dashboard can be tricky, but it’s an...
Brittany
Oct 10, 20243 min read
Â
Â
Â


Master Next Year's Projections with Google Sheets & Dashboards (Looker Studio)
Check out our Google Looker Studio Consulting Add-Ons page. Forecast Your Future With a Projections Dashboard Everyone knows the...
Brittany
Sep 5, 20243 min read
Â
Â
Â


From Complex to User Friendly: Why We Chose Looker Studio Over Tableau and Power BI
Check out our Google Looker Studio Consulting Service page . What is Google Looker Studio? Looker Studio is a user-friendly business...

Jack Tompkins
Aug 13, 20249 min read
Â
Â
Â


Dashboards with Google Looker Studio - And Why We Prefer it Over Other Big Names Like Tableau and Microsoft Power BI
Check out our Google Looker Studio Consulting Service page . Dashboards with Google Looker Studio: Our Favorite Tool for Easy Data...
Brittany
Jul 24, 20244 min read
Â
Â
Â


Drowning in Data, Starving for Insights? Here's Why You Need a Business Intelligence Consultant
Check out our Business Intelligence page. From customer interactions to sales figures, and marketing campaigns to website traffic,...
Brittany
Mar 7, 20243 min read
Â
Â
Â


3 Ways Custom HubSpot Dashboards Drive Business Success
Running a business in today's market is hard. Staying ahead requires more than just keeping up—it's about making informed decisions that...
Brittany
Mar 7, 20243 min read
Â
Â
Â


8 Reasons Why Our Xero Dashboard is Perfect for Bookkeepers
If you're like us, you probably appreciate the beauty of organized financial data. But let's be real, the traditional methods of dealing...
Brittany
Feb 1, 20243 min read
Â
Â
Â


4 Reasons Why Our SaaS Products Are the Perfect Solution: Ditch the One-Size-Fits-All "Generic" Dashboards
If I were to take a poll and ask how many of you have ever stared at a dashboard that felt about as insightful as a blank sheet of paper,...
Brittany
Jan 4, 20243 min read
Â
Â
Â


5 Key Elements of Pineapple Consulting's Data Strategy Audit That Will Transform Your Business
There are two types of people in this world: The ones who got excited when their teacher announced a group project... and those who were...
Brittany
Jan 2, 20243 min read
Â
Â
Â


How AI is Transforming Dashboard Creation: Insights from a Data Analyst
Artificial Intelligence (AI). To some, that phrase is scary because of the large shadow it casts on their profession. To others, the...
Brittany
Nov 21, 20233 min read
Â
Â
Â


How to get a Fully Customized HubSpot Data Dashboard: Pineapple Consulting Firm
Let's talk about HubSpot. HubSpot is a pretty well-known platform in the CRM world and is becoming a staple for businesses keen on making...
Brittany
Oct 5, 20233 min read
Â
Â
Â


7 Reasons Why Our QuickBooks Online Dashboard is Perfect for Bookkeepers
As a bookkeeper, you know the value of precision and organization in managing financial data. You probably have also felt at times that...
Brittany
Aug 31, 20233 min read
Â
Â
Â
Insights
bottom of page
