
MALIK DON
Data AnalystExcel | SQL | Tableau | Looker | Python
I am passionate about telling stories with data with my growing skillset of data tools for analysis to make better decisions. To accomplish this, I focus on key results, my stakeholders, and great communication with my team to adapt these new insights.
Projects
TABLEAU
RECRUITMENT DASHBOARD
Analysis on recruitment data that visualizes the core metrics to a recruitment team while searching for candidates to fulfill a position.
LOOKER/GOOGLE DATA STUDIO
STR PERFORMANCE ANALYSIS
Dashboard analyzing the the performance of a short term rental business.
Professional Experience
Browse through my professional career by clicking below:
Contact Me
Thanks for Browsing. Let's Stay In Touch!
TABLEAU | RECRUITMENT DASHBOARD
Summary: Hiring performance of a company utilizing replica data.Stakeholders were curious about the volume of candidates to fill open positions within the organization and where the traffic for hires are arriving from. I was responsible for redesigning the data input process and put together this project to analyze and visualize the details more clearly.
Key Insights
- 95% of positions across departments met their hiring goals
- The top hiring traffic came from over 90% direct applications
- The Human Resources department conducted the most interviews compared to other departments.
- Over 70% of candidates needed their years of experience updated in the data input tracker
Skills Used
- Tableau
- Parameters
- Dynamic Filters
- Calculated Fields
- Tooltips
- Storyboard
- Data Extraction
- SQL
- Python
Data Source
Private stakeholder recruitment data restructured for the purpose of this demonstration.The full project can be viewed on my Tableau Public Page
LOOKER STUDIO
STR PERFORMANCE ANALYSIS
Summary: Dashboard analyzing the monthly performance of a short term rental businessGoal: Create internal performance tracker to view the generated revenue across all properties as well as their average nightly price to position themselves correctly in the marketplace.
Key Insights
- The most frequent days booked across all listings were 2 night stays (Weekend Trips)
- Travel started to increase in March, although business is consistent year-round
- Listing #3 had the highest paid nights from its first booking as compared to the others
- 65% of guests were booking at least a week before check-in
- Stakeholder would price their units at least 2 weeks out to reach revenue goals
- Listings for the entire property were more attractive than private room listings
Skills Used
- Looker/Google Studio
- Excel/Google Sheets
- KPIs
- Data Visualization
- Dynamic Filters
Data Source
Private stakeholder data exported from Airbnb restructured for the purpose of this demonstration.