Projects
Below are a few work examples from CREG & Ames Community School District. In addition to several years working primarily in Excel for reporting purposes, I gained skills in Power Query, Power BI and recently Looker Studio to visualize data to share a story.
The following two projects were created in response to leadership looking for insights into safety. It utilizes an Odata connection in Power Bi, and the data models includes 3-5 tables.
Business Intelligence for CREG
Business Analyst
Business Intelligence for CREG
Business Analyst
Business Intelligence for CREG
Business Analyst
This report brings together two data sources - a forecasted spreadsheet and actual data from a warehouse. It is a lookback on where production came in compared to forecast.
Business Intelligence for CREG
Business Analyst
In this project, I worked with a small team that included SME's for system data, to create KPI/metrics for a production team. My role was the creation of the report in Power BI.
Projects
The following two projects were created in response to leadership looking for insights into material loss. It utilizes an Odata connection in Power Bi, and the data models includes 3-5 tables.
Business Intelligence for CREG
Business Analyst
Business Intelligence for CREG
Business Analyst
*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*
Process Improvements and Documentation for Ames CSD
By streamlining staff changes process, the process became more efficient, leading to a reduction in errors while ensuring consistency of employee onboarding and staff changes.
District Information Manager
Business Intelligence for Ames CSD
District Information Manager
This is an example of a live enrollment dashboard, using an ODBC connection to the Infinite Campus active students table. Rather than manually pulling reports and updating a google sheet, leadership and staff view live information with just a few clicks with the mouse.