For this project, I transformed a very messy dataset of over 7,000 doctors across various specialties into a clean, accessible resource for my two older brothers, who are oral surgery residents planning to work in North Carolina. They wanted an easy way to view oral surgeons by county, so I focused on extracting and cleaning only the relevant data for visualization in Power BI.
To make this data usable, I performed extensive data cleaning in SQL. You can read the code here. This included handling inconsistent naming conventions, removing duplicates, standardizing entries, and creating staging tables to safely test changes before applying them to the main table.
Additionally, I discovered that many rows contained misplaced data. Specifically, certain values were in the wrong columns, so I had to extract those values, populate the correct rows, and shift the data accordingly.
This project solidified the importance of staging tables into my brain. They allowed me to experiment and avoid accidental data loss or errors in the primary data set.
After thorough testing, I generated a structured table with accurate and consistent data suitable for visualization.
In Power BI, I created an interactive dashboard where users can view a map with clickable bubbles representing different counties in North Carolina. Selecting a county reveals a table listing all oral surgeons in that area along with key contact information. Additionally, I added a drill-through feature: by right-clicking on a surgeon's name, users can access a detailed page with more information about that surgeon.
Due to the sensitive nature of the data, I created a separate dummy table with altered information to protect privacy (the version you see). This version allows others to explore the dashboard without accessing real data, while my brothers receive a copy with the actual information.
This dashboard is not the prettiest, but management told me that they were very pleased...
Thanks for reading.