August 19, 2025
Ultimate Guide to Optimizing Power BI Query Performance in SnowflakePower BI and Snowflake are a powerhouse combo for modern business intelligence. But performance issues can creep in—especially with DirectQuery mode. If your dashboards are slow to load or your queries are hitting limits, you're not alone. This guide breaks…
August 12, 2025
The Definitive Guide to Making Snowflake Data Available in ExcelExcel continues to be the world’s most used analytics tool, with more than 750 million users globally. On the other hand, Snowflake has become a leading cloud data platform for enterprise-scale data management. Bridging these two platforms — while preserving…
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…
