This presentation highlights a project where our team needed to automate the integration of an Excel file stored in SharePoint into SQL, refreshing the data daily to provide estimated enrollments. While this task may seem simple at first glance, it required careful planning and infrastructure setup.We began by establishing a secure connection between SharePoint and […]
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 […]
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 […]
Data Analyst, IT Partners, Gies College of Business
Established 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 […]