Finance Data Hub home
Finance Data Hub
Snowflake, Jedox and Excel VBA for FP&A
Initializing search
    • Home
    • Snowflake
    • Jedox
    • VBA
    • Downloads
    • About
    • Home
    • Snowflake
      • Month-end actuals
      • Plan vs actuals
    • Jedox
      • Management report export
      • Snowflake to Jedox load
      • Relational extracts
      • Automated value emails
        • Builder
        • Check your email script
      • Business Rule Studio
      • Rule Studio worker setup
    • VBA
      • Month-close checks
      • New Outlook email macros
    • Downloads
    • About

    FINANCE DATA HUB

    Build the FP&A pack without the manual work

    Tested Snowflake SQL, Jedox Integrator jobs and Excel VBA, each with sample data you can download and run.

    Start with Plan vs actuals → Browse downloads
    Three mascots standing together: Snowflake in a blue hoodie, Jedox in a purple blazer with his arms around the others, and VBA in a green cardigan, waving

    Who it's for

    • FP&A analysts Stop rebuilding the pack by hand.

    • Controllers Trust that no row went missing.

    • Data people Copy tested SQL, Groovy and VBA.

    Follow the data, step by step

    1. 1 Snowflake

      Plan vs actuals

      Join budget and actuals without losing a row.

    2. 2 Jedox

      Snowflake to Jedox load

      Clear the slice, then load fresh actuals into the cube.

    3. 3 Jedox

      Automated value emails

      One Integrator job sends every owner their numbers.

    Latest posts

    • Create your own emailJedox · Builder Oct 9, 2026
    • Automated value emailsJedox · Groovy Oct 9, 2026
    • Snowflake to Jedox loadJedox · Integrator Oct 9, 2026
    • Plan vs actualsSnowflake · SQL Oct 9, 2026

    Why it matters

    Same sample data, three joins:

    605inner join

    696left join

    701full join✓ no rows lost

    Rows kept by each join. Only the full join keeps all 701.

    Next
    Snowflake SQL for FP&A
    Balazs · Finance Data Hub
    Made with Material for MkDocs