Insights

Gemini in Google Sheets can make formulas a lot more streamlined and take the guess work out of it. Check this out for data prep! More on us: https://www.pineapplecf.com/featured

LTV is hugely important, but not always straightforward. We walk you through the calculation of it, in Looker Studio, using Shopify data, for a subscription based company. Ecommerce dashboards: https://www.pineapplecf.com/ecommerce-dashboards Ecommerce data-driven value left on the table: https://pineapplecf-value-estimator.replit.app/ Free Data Strategy Snapshot: https://www.pineapplecf.com/data-strategy-audit Coupler link: https://www.coupler.io/?ref=nge0mtv

New! AI function in Google Sheets has been super cool to write lengthy case statements for SQL, and a whole lot else. More on us here: https://www.pineapplecf.com/featured

Custom Shopify Dashboards are so incredibly helpful! Especially when you layer in Recharge data too for subscriptions. Get all of it tied together in Looker Studio and you've got a highly effective data-driven machine! The backend process to do this isn't too difficult and it can be fully automated to create a Shopify dashboard exactly like this (or one fully customized to your business). Custom Shopify dashboards: https://www.pineapplecf.com/ecommerce-dashboards Learn more about our Fractional Analyst service here: https://www.pineapplecf.com/fractional-analyst More on our business: https://www.pineapplecf.com/featured Build your own dashboard: https://www.pineapplecf.com/advanced-gls-dashboard-building-course

Uploading a CSV with errors to BigQuery can be incredibly annoying - here's a way to spot the errors and correct for them! Learn more about Pineapple Consulting Firm: https://www.pineapplecf.com/featured Useful Links: → Quickbooks Dashboard: https://www.pineapplecf.com/quickbooks-online-performance-dashboard → Fractional Analyst: https://www.pineapplecf.com/fractional-analyst Learn to Build Your Own Dashboard: → Advanced course: https://www.pineapplecf.com/advanced-gls-dashboard-building-course --- Related Content — * How to Build a QuickBooks KPI Dashboard – https://youtu.be/AboWqx0pw0U * Is a Dashboard Worth the Investment? – https://youtube.com/shorts/C_nsM7QZbNM Subscribe for more small business dashboard tips Join Our Newsletter to stay up to date on all things data - https://www.pineapplecf.com/contact #CFODashboard #FractionalAnalyst #ClientKPIs #LookerStudio #SmallBusiness

Uploading a CSV to BigQuery has a lot of use cases and it's incredibly simple to do (video coming soon on how to handle CSV errors too)! Learn more about Pineapple Consulting Firm: https://www.pineapplecf.com/featured Useful Links: → Quickbooks Dashboard: https://www.pineapplecf.com/quickbooks-online-performance-dashboard → Fractional Analyst: https://www.pineapplecf.com/fractional-analyst Learn to Build Your Own Dashboard: → Advanced course: https://www.pineapplecf.com/advanced-gls-dashboard-building-course --- Related Content — * How to Build a QuickBooks KPI Dashboard – https://youtu.be/AboWqx0pw0U * Is a Dashboard Worth the Investment? – https://youtube.com/shorts/C_nsM7QZbNM Subscribe for more small business dashboard tips Join Our Newsletter to stay up to date on all things data - https://www.pineapplecf.com/contact #CFODashboard #FractionalAnalyst #ClientKPIs #LookerStudio #SmallBusiness

Linking up Google Sheet to BigQuery has a lot of use cases and it's incredibly simple to do (twist to make it as easy as possible with the best results in here)! Learn more about Pineapple Consulting Firm: https://www.pineapplecf.com/featured Useful Links: → Free One KPI Tool: https://www.pineapplecf.com/kpi-one-big-thing → Quickbooks Dashboard: https://www.pineapplecf.com/quickbooks-online-performance-dashboard → Fractional Analyst: https://www.pineapplecf.com/fractional-analyst Learn to Build Your Own Dashboard: → Advanced course: https://www.pineapplecf.com/advanced-gls-dashboard-building-course --- Related Content — * How to Build a QuickBooks KPI Dashboard – https://youtu.be/AboWqx0pw0U * Is a Dashboard Worth the Investment? – https://youtube.com/shorts/C_nsM7QZbNM Subscribe for more small business dashboard tips Join Our Newsletter to stay up to date on all things data - https://www.pineapplecf.com/contact #CFODashboard #FractionalAnalyst #ClientKPIs #LookerStudio #SmallBusiness

Linking up Google Sheet to BigQuery has a lot of use cases and it's incredibly simple to do (twist to make it as easy as possible with the best results in here)! Learn more about Pineapple Consulting Firm: https://www.pineapplecf.com/featured Useful Links: → Free One KPI Tool: https://www.pineapplecf.com/kpi-one-big-thing → Quickbooks Dashboard: https://www.pineapplecf.com/quickbooks-online-performance-dashboard → Fractional Analyst: https://www.pineapplecf.com/fractional-analyst Learn to Build Your Own Dashboard: → Advanced course: https://www.pineapplecf.com/advanced-gls-dashboard-building-course --- Related Content — * How to Build a QuickBooks KPI Dashboard – https://youtu.be/AboWqx0pw0U * Is a Dashboard Worth the Investment? – https://youtube.com/shorts/C_nsM7QZbNM Subscribe for more small business dashboard tips Join Our Newsletter to stay up to date on all things data - https://www.pineapplecf.com/contact #CFODashboard #FractionalAnalyst #ClientKPIs #LookerStudio #SmallBusiness