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,…
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…
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…
March 21, 2024
Democratizing Your Lakehouse to Excel Users with Databricks SQL and AtScaleWhat’s The Deal With Excel? Excel is the most predominant BI tool in the enterprise because of its versatility, ease of use, and range of capabilities. It is the tool of choice for almost a billion analysts worldwide. However, whenever…
January 16, 2024
Empowering Excel Data Analysis with AtScale: Part 5 – ForecastingDave Langer founded Dave on Data, where he delivers training designed for any professional to develop data analysis skills. Over the years, Dave has trained thousands of professionals. Previously, Dave delivered insights that drove business strategy at Schedulicity, Data Science…
December 19, 2023
Empowering Excel Data Analysis with AtScale: Part 4 – Categorical AnalysisDave Langer founded Dave on Data, where he delivers training designed for any professional to develop data analysis skills. Over the years, Dave has trained thousands of professionals. Previously, Dave delivered insights that drove business strategy at Schedulicity, Data Science…
December 14, 2023
Empowering Excel Data Analysis with AtScale: Part 3 – Distribution AnalysisDave Langer founded Dave on Data, where he delivers training designed for any professional to develop data analysis skills. Over the years, Dave has trained thousands of professionals. Previously, Dave delivered insights that drove business strategy at Schedulicity, Data Science…
December 12, 2023
Enhancing Data Governance: Optimizing the Fusion of AtScale Semantic Layer and Alation Data Intelligence PlatformIn today's organizational landscape, ensuring the precision, comprehensiveness, and reliability of data stands as a pivotal element for success. Achieving robust data governance necessitates leveraging a suite of indispensable tools that oversee data integrity, fortify security, and enhance usability. In…
November 30, 2023
Empowering Excel Data Analysis with AtScale: Part 2 – Time Series AnalysisDave Langer founded Dave on Data, where he delivers training designed for any professional to develop data analysis skills. Over the years, Dave has trained thousands of professionals. Previously, Dave delivered insights that drove business strategy at Schedulicity, Data Science…
