Automating Data Management with Azure: Streamlining SQL and Power BI Pipelines

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 […]

Name that Company! Harmonizing Data Standardization Across Campus and Beyond

At 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

Data Analyst, IT Partners, Gies College of Business