Description: This presentation showcases how to leverage Azure to automate data pipelines, including SQL and Excel, to provide data reports and Power BI dashboards. In the presentation, we detail two projects built by the Data Strategy, Analytics, and Reporting team at Gies College of Business to improve data management and information access. First, we will […]
Tag: Lauren Gray
Name that Company! Harmonizing Data Standardization Across Campus and Beyond
Tags: Krista DeLeeuw, Lauren Gray, Marian Pan, Patrick Nowlan, SessionAt IT Partners in the Gies College of Business, we’ve been tackling the challenge of standardizing company names for some time now. As we process data from various sources, we encounter a wide range of discrepancies, inconsistencies, and duplications in company name formatting and hierarchies. Currently, our efforts to clean and standardize these names are […]
Lauren Gray
Tags: Lauren Gray, PresenterData Analyst, IT Partners, Gies College of Business
Data Analytics from Scratch at Gies College of Business
Tags: Colin Ruud, Krista DeLeeuw, Lauren Gray, Sahar PaniEstablished in July 2022, Gies College’s Data Strategy, Analytics, and Reporting (DSAR) unit was charged with serving the College’s growing data needs. Given the opportunity to design its model from the ground up, we implemented a consultant + specialist model, with a centralized data workflow and a defined system of building data products, including Power […]