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…
November 28, 2023
Empowering Excel Data Analysis with AtScale: Part 1 – The ScenarioDave 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…
June 23, 2022
How to Use Excel for Analytics in the CloudDespite having a billion users, Excel is not always thought of as a business intelligence (BI) tool. Yet Excel remains by far the predominant BI consumption platform in enterprise data because its formulas and functions make it a powerful tool…
October 7, 2021
How to Leverage the Power of AtScale with Ad Hoc Analysis in ExcelNo matter how sophisticated and agile an enterprise BI program may be, there is always a need to go deeper than canned reports and dashboards. Business analysts’ primary role is to figure out what the data is saying and support decision…
