June 19, 2025
How to Stop Metric Sprawl Across Power BI, Tableau, and Excel with SnowflakeIn a multi-tool analytics world, one of the most persistent challenges facing data-driven organizations is metric sprawl. When business teams use different BI tools each with their own logic and metrics, the result is conflicting numbers, duplicated effort, and a…
June 5, 2025
Implementing a Centralized Semantic Layer for Power BI and Tableau in SnowflakeOrganizations today rely on both Power BI and Tableau to unlock insights from their Snowflake data. But without a centralized approach, things get messy—definitions drift, performance suffers, and costs climb. Despite significant investments in cloud data platforms, data teams still…
May 27, 2025
Why Is Power BI Slow with Snowflake? How to Fix Common Performance ProblemsIf your Power BI dashboards feel more like a waiting game than a real-time tool, you're not alone. Many teams struggle with sluggish performance when connecting Power BI to Snowflake. Dashboards that should load in seconds often take minutes. The…
April 15, 2025
Connect Excel to Snowflake Without ODBC: Smarter Alternatives for Business UsersExcel remains a go-to tool for business users who want quick, flexible access to data. But when it comes to connecting Excel to Snowflake, the traditional route — via ODBC — can be a technical nightmare. Driver installs, authentication headaches,…
April 3, 2025
How a Typical Power BI Customer Can Save Millions in Annual CostsThe Rising Cost Challenge for Power BI Customers Organizations across industries rely on Power BI to drive business intelligence and inform strategic decisions. However, as data volumes increase, so do the associated costs. Businesses often face growing expenses related to…
March 13, 2025
Excel + Snowflake: How AtScale Helps Bridge the Gap Between Data Warehouse and Spreadsheet AnalysisDespite heavy investments in Snowflake's modern data platform, many business users still default to Excel for day-to-day analysis. The result? Stale extracts, inconsistent KPIs, and a frustrating disconnect between centralized data and the tools people actually use. The AtScale semantic…
February 13, 2025
Simplifying Snowflake Access for Excel Users: Implementation StrategiesDespite heavy investment in Snowflake’s modern data platform, many organizations still struggle to give Excel users smooth, efficient access to that data. The result? Data extracts, stale numbers, and inconsistent reporting across the enterprise. This guide outlines innovative implementation strategies…
February 11, 2025
How to Write Report-Scoped DAX Expressions Using AtScale Dimensional ModelsIn my last post, I demonstrated the many advantages of using AtScale Models to power your Business Intelligence workloads, including human-friendly SML syntax, Git integration, multi-tool support, zero-extract Live Connections, and proven BI Modeling capabilities. In this post, I'll demonstrate…
October 21, 2024
How to Optimize Modern Data Models Without Sacrificing Proven BI TechniquesTabular models and the Data Analysis Expression (DAX) language offer Microsoft Power BI users enormous analytic and visualization capabilities. As powerful as these tools are, when using them, it can feel like one is reinventing the wheel to solve basic…
May 23, 2024
Is Fabric and Direct Lake a Game Changer for Microsoft?This blog is part of a series on Microsoft Fabric from Greg Deckler, Vice President at a global IT services firm who leads a practice specializing in Microsoft technologies such as Dynamics 365, Power BI, and Azure. Greg is a…
