Name: Excel - Preventing Spreadsheet "Spaghetti" For The Analyst
Start: 2025-12-12T11:30:00-06:00
End: 2025-12-12T12:30:00-06:00

Despite the growing maturity of business intelligence platforms, MS Excel remains the main tool of choice for reporting and analytics in many organizations. Bad habits like creating Excel "spaghetti" solutions that abuse formula generation (lookups/if..then..else, etc), formatting overload, and manual steps result in inefficient, multi-megabyte spreadsheets that frustrate analysts with time consuming activities that have the potential to be error-prone.

In this session [Rob Garelick](https://www.linkedin.com/in/rob-garelick/) will:

* Understand the primary outcomes and causes that result from that from Excel “spaghetti” solutions.
* Discuss good disciplines coupled with Power Query and Power Pivot to be part of the Analyst’s toolbelt.
* Review realistic business cases that demonstrate how Excel Power Query and Power Pivot can be applied along with other tools within Power Platform (Power Automate, Power Apps, SharePoint/OneDrive). Together, they complement each other in aspects of data retrieval, cleanup, consolidation, time intelligences, dynamic formulas (e.g. DAX), and automation.

Jenny Schmidt

Robert Garelick

Des Moines Data & Analytics

DesMoinesData and Analytics

Technology

Data Visualization

Database Professionals

Data Mining

Machine Learning

Data Science

Data Management

Business Intelligence

Professional Development

Business Strategy

Big Data

Data Analytics

Knowledge Sharing

Professional Networking

Predictive Analytics

Excel - Preventing Spreadsheet "Spaghetti" For The Analyst

Business Analytics

Microsoft Excel

Online event

Share

Des Moines Data & Analytics

Excel - Preventing Spreadsheet "Spaghetti" For The Analyst

Des Moines Data & Analytics

Details

Members are also interested in