# DynamicData > DynamicData is a data consultancy of multidisciplinary freelancers. We help organizations improve reporting, analytics, and decision-making through data strategy, data engineering, and BI platforms (Looker, Snowflake, dbt, and related tools). DynamicData builds modern data stacks: strategy and architecture, pipelines and integrations, and BI/analytics that turn data into actionable insight. Primary contact: victoria+web@dynamicdata.agency. Company profiles: LinkedIn (https://www.linkedin.com/company/dynamic-data-agency/), X/Twitter (https://twitter.com/DynamicDataAgcy). ## Company - [Home](https://dynamicdata.com/): Overview of DynamicData, services, tech stack, success stories, and contact - [Services](https://dynamicdata.com/#services): Data Strategy & Architecture, Data Engineering & Integration, BI & Analytics - [Contact](https://dynamicdata.com/#contact): Contact form and inquiry entry point ## Case studies - [Case studies index](https://dynamicdata.com/case-studies/): All published client case studies - [Herbaly](https://dynamicdata.com/case-studies/herbaly-shopify-server-side-tracking-case-study/): How Dynamic Data built Herbaly a server-side tracking setup that held steady through GA4, iOS 14, and a full Shopify checkout migration. - [Smile Data](https://dynamicdata.com/case-studies/smile-data-multi-tenant-embedded-analytics-case-study/): See how Dynamic Data helped Smile Data turn a single-practice dashboard into a multi-tenant, embedded analytics product for the dental industry, secured by dis… - [A Multi-Brand Distributor](https://dynamicdata.com/case-studies/microsoft-fabric-data-lakehouse-case-study/): See how Dynamic Data gave a major distributor one governed Microsoft Fabric lakehouse for sales, inventory, and customer data across every brand. - [Curio Spice Co.](https://dynamicdata.com/case-studies/curio-spice-data-unification-case-study-in-big-query/): See how Dynamic Data unified 5 years of scattered retail data into one BigQuery warehouse for Curio Spice, enabling clear cross-channel tracking and ROI. - [Unstructured](https://dynamicdata.com/case-studies/case-5/): How Unstructured left Microsoft Fabric bottlenecks behind with a stable, automated Snowflake data stack built by Dynamic Data experts. - [Rob Ramsdell Real Estate](https://dynamicdata.com/case-studies/case-3/): Learn how Dynamic Data transformed market data into curated insights that realtor Rob Ramsdell uses daily as a powerful marketing asset for Boston-area clients. - [Zenus](https://dynamicdata.com/case-studies/case-2/): Discover how Dynamic Data upgraded Zenus' data processing on Google Cloud, for scalable storage, modeling, and near real-time visualization at growth. - [Pima Solar](https://dynamicdata.com/case-studies/case-1/): Learn how Dynamic Data connected CallFire, Go High Level, and JobNimbus so Pima Solar could see the full customer journey and decide with clarity. ## Blog - [Blog index](https://dynamicdata.com/blog/): Articles on BI platforms, data teams, semantic models, and industry events - [We Tried BigQuery Measures: A Semantic Layer That Lives Inside a Graph](https://dynamicdata.com/blog/bigquery-measures-review/): We built a BigQuery measures graph, tested it in Data Studio, and tried to break it. How it works, what we learned, and when it beats other semantic layers. - [Snowflake Expedition 2026: What's Ready for Your AI Agents, and What's Still on the Way](https://dynamicdata.com/blog/snowflake-expedition-2026-ai-agents/): What Snowflake announced at Expedition 2026 for AI agents, sorted by release stage: what's generally available, what's in preview, and what to do now. - [Microsoft Fabric Apps in the Wild: What's Confirmed So Far](https://dynamicdata.com/blog/fabric-apps-confirmed-so-far/): What Microsoft's docs confirm about Fabric Apps (preview): the Rayfin SDK, deployment, the Power BI semantic model template, and what's still open. - [What's Actually Under Your Model? The Snowflake Well-Architected Acid Test](https://dynamicdata.com/blog/snowflake-well-architected-framework-assessment/): Snowflake's Well-Architected assessment runs 67 controls against your account and reports them all in the same even tone. Here's how to read what it gives you. - [We Tried Claude Dashboards: Fast to Build, and Only as Good as the Data Underneath](https://dynamicdata.com/blog/claude-dashboards-first-look/): We tried Claude Dashboards and Claude Motion on a public Spotify dataset: what they do well, how permissions and costs work, and why modeling matters. - [What we Brought Home From dbt Summit 2026: The Announcements Fit Together](https://dynamicdata.com/blog/dbt-summit-2026-takeaways/): Our takeaways from dbt Summit 2026: dbt v2, dbt State, Lake Compute, dbt Wizard, and dbt Charts, plus what other data teams told us in the room. - [Fabric Apps: When a Dashboard Isn't Enough](https://dynamicdata.com/blog/fabric-apps-when-a-dashboard-isnt-enough/): Microsoft Fabric Apps lets you build internal apps next to your data. We built one in 3 hours. Here’s what it costs, where it fits, and when a report wins. - [We tested dbt Charts: our first look at dashboards built inside your dbt project](https://dynamicdata.com/blog/dbt-charts-review/): We ran a proof of concept with dbt Charts, dbt Labs’ YAML and SQL dashboards. How it works, what it does well, and where it still falls short. - [Which map should you use in Data Studio? A guide to the seven map types.](https://dynamicdata.com/blog/seven-map-types-to-use-in-data-studio/): Data Studio has seven map types, and each answers a different question. A guide to geo charts, filled maps, bubble maps, heat maps, and when to use each. - [Your Data Speaks Tables. Your Business Speaks Entities. Bridging the Gap with Microsoft Fabric IQ.](https://dynamicdata.com/blog/microsoft-fabric-iq/): What is Fabric IQ? See how ontology bridges tables and business entities so Data and Operations agents act with shared business context today. - [Context is The Moat: What Snowflake Summit 2026 Taught Me About Building AI That Actually Works](https://dynamicdata.com/blog/what-snowflake-summit-2026-taught-me-about-building-ai-that-actually-works/): Lessons: why context is the moat for AI agents, and how to build systems that don’t fail when they hit real production data. - [Your Data is Finally Ready to Talk Back. Building Semantic Models for AI Agents: A Layered Architecture](https://dynamicdata.com/blog/building-semantic-models-for-ai-agents-a-layered-architecture/): Build a semantic layer for AI agents with a two-layer model: governed meaning plus agent-ready guidance so agents query your data correctly. - [Data Powers AI, Context Makes it Intelligent: Key Takeaways from FabCon '26](https://dynamicdata.com/blog/data-powers-ai-context-makes-it-intelligent-key-takeaways-from-fabcon-26/): Why context makes AI intelligent, and how OneLake unifies data for analytics, governance, and smarter AI agents. - [Stop Taking Polaroids: Why Your CRM Pipeline Needs a Movie Camera](https://dynamicdata.com/blog/stop-taking-polaroids-why-your-crm-pipeline-needs-a-movie-camera/): Most CRM dashboards show “right now,” not how the pipeline changed. Learn why sales needs trend analytics, not static snapshot reporting alone. - [Exploring the new responsive version of Looker Studio: advantages, limitations, and best practices](https://dynamicdata.com/blog/exploring-the-new-responsive-version-of-looker-studio/): Looker Studio mobile dashboards explained: responsive vs. freeform layouts, their limits, and best practices for reports that work on any device. - [My Takeaways from Snowflake Summit 2025: A Faster, Cheaper, and More Open Data Cloud is Here](https://dynamicdata.com/blog/my-takeaways-from-snowflake-summit-2025/): Snowflake Summit 2025 key takeaways: AI, data apps, and what matters for teams modernizing analytics with Snowflake and dbt in practice today. - [BI platforms evaluation: Omni](https://dynamicdata.com/blog/platform-omni/): Omni semantic layer deep-dive: hybrid modeling, dbt integration, workbooks, and who this BI platform is designed for, from analysts to engineers. - [Exciting News from Microsoft Fabric: Transforming Data and AI Platforms](https://dynamicdata.com/blog/exciting-news-from-microsoft-fabric-transforming-data-and-ai-platforms/): Microsoft Fabric announcement roundup: Fabric Databases, Real-Time Intelligence GA, and OneLake catalog, what changes for your data stack now. - [Snowflake Summit 2024: Highlights and Must-Know Updates](https://dynamicdata.com/blog/snowflake-summit-2024-recap/): Missed Snowflake Summit 2024? Here are the key highlights on AI, Arctic, Document AI, and partnerships that matter for enterprise data teams right now. - [Unlocking Data Insights: The Future of Semantic Models](https://dynamicdata.com/blog/the-future-of-semantic-models/): What is a semantic data model? Learn why consistent metrics across BI tools matter, and how semantic modeling changes the dashboard workflow. - [BI platforms evaluation: Metabase](https://dynamicdata.com/blog/bi-platforms-evaluation-metabase/): What is Metabase? Our hands-on review covers features, UI, reporting, pricing fit, and limits, so you know if this open-source BI fits your team. - [BI platforms evaluation: Preset](https://dynamicdata.com/blog/platform-preset/): Discover everything about Preset Cloud, an open-source-based Business Intelligence platform with great potential. Learn about its features, strengths and weakn… - [How to run Data-Driven teams without Dashboards](https://dynamicdata.com/blog/data-driven-teams-without-dashboards/): Learn how to evolve beyond dashboards for more effective data-driven decision-making in big teams. - [BI platforms evaluation: Sigma Computing](https://dynamicdata.com/blog/platform-sigma-computing/): Read our in-depth review of Sigma Computing, a spreadsheet-like interface BI solution for cloud data warehouses. Learn about its features, ease of use, and mor… - [Your checklist for selecting the perfect Business Intelligence platform for your Business](https://dynamicdata.com/blog/selecting-the-perfect-business-intelligence-platform/): Choosing a business intelligence platform? Use this practical checklist to compare BI tools, team fit, and requirements before you buy anything. - [BI platforms evaluation: Mode Analytics](https://dynamicdata.com/blog/mode-analytics-review/): Mode Analytics review: strengths for technical teams, weaknesses and key features. Find out if it's the right BI platform for your business. - [Is your Data Team investment paying off?](https://dynamicdata.com/blog/maximizing-data-team-roi/): Learn how to measure and improve your data team's value to maximize ROI. Understand the impact of pay-per-use and subscription-based models. - [GA4 and the Future of Measurement](https://dynamicdata.com/blog/google-analytics-4/): Learn about the evolution of Google Analytics from Universal Analytics to GA4, its benefits, key differences, and why you should migrate to GA4 soon. ## Optional - [Sitemap](https://dynamicdata.com/sitemap.xml): Full machine-readable list of indexable pages