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 […]
Tag: Sahar Pani
Sahar Pani
Tags: Presenter, Sahar PaniData Reporting Specialist, IT Partners
Automating Data Management with Azure: Streamlining SQL and Power BI Pipelines
Tags: Lauren Gray, Sahar Pani, SessionDescription: 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 […]
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 […]