Transforming & Visualizing Data with SQL and Power BI at Health Catalyst
.png)
I use this project with permission from the company where I work as a Data Analytics Engineer. Summary Health Catalyst is a healthcare consulting firm with 1,000 employees, 1/3 of which are data engineers who consult at hospitals and clinics. The business case for my work is that management has to decide how all of these engineers are allocated to clients. I worked closely with management to iterate constantly according to their needs and feedback, resulting in over 20 versions of the project over a 3 month period. I also worked with stakeholders to validate data and get access to new data when needed. I was able to present a finished dashboard to senior management using advanced SQL, ETL tools, and Power BI. The project was managed by myself using agile techniques including a Kanban board with tasks, daily standups, points meetings to assign value to tasks and retrospectives to discuss project progress. Project Overview The project was completed in stages, though these were done itera...