What we’re about
Data and analytics are an important strategic advantage for companies in the greater Des Moines area today and for years to come. Organizations are already growing their analytics departments and universities are preparing students for the workforce to meet this need. This meet-up will connect those in the analytics community in Des Moines, regardless of technology or tool.
This group is open to anyone interested in entering or currently in the data or analytics field. This includes data analysts, reporting analysts, business intelligence analysts, data scientists, and analytics leaders as well as students, faculty and others who support the analytics community.
At the events you will get an opportunity to meet others in the Des Moines analytics community and also hear from local experts regarding topics of visualization, data wrangling, analytics methods, analytics culture, and building analytics skills.
Upcoming events
1
•OnlineExcel - Preventing Spreadsheet "Spaghetti" For The Analyst
OnlineDespite 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 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.
35 attendees
Past events
102
