Effective teamwork is about lifting others up, and I had an opportunity to do just that when I mentored a colleague struggling with data cleaning and Power BI.
At my previous role as a Senior Data Science Consultant, I worked on a data analytics project where a colleague from a different team was responsible for building Power BI dashboards. However, they struggled with data cleaning, preprocessing, and structuring the data efficiently for visualization. Their challenges were leading to inaccurate reports, slow performance, and stakeholder frustration due to delays.
The colleague was not familiar with best practices for data cleaning and was spending too much time manually fixing data inconsistencies instead of using efficient preprocessing techniques. Additionally, they were unfamiliar with Power BI’s advanced data modeling features, leading to incorrect aggregations and report inconsistencies.
To help them, I implemented a structured mentorship approach by using different learning and support strategies:
Hands-On Learning: Instead of overwhelming them with theory, I conducted live working sessions where we cleaned sample datasets together using Python (Pandas) and Power Query.
Breaking Down Data Cleaning: I introduced them to automated data preprocessing techniques (e.g., handling missing values, standardizing formats) to reduce manual work by 50%.
Building a Power BI Framework: I showed them how to structure their data models properly, use DAX functions for dynamic calculations, and create efficient relationships between tables.
Step-by-Step Documentation: I created a beginner-friendly guide outlining common data cleaning issues and solutions, along with Power BI best practices, so they could refer to it later.
Follow-Up & Continuous Learning: I scheduled weekly check-ins to review their progress, answer questions, and troubleshoot issues, ensuring they became independent and confident in their work.
This approach
Reduced their data cleaning time by 60%, making their workflow more efficient.
Improved report accuracy, leading to faster and more reliable insights for stakeholders.
Boosted their confidence in Power BI, enabling them to take ownership of dashboard development
independently.
Strengthened cross-team collaboration, fostering a supportive learning culture in the organization.
This experience reinforced my belief that mentorship is about empowering others with the right tools and
mindset rather than just providing answers.
I learned that tailoring training to an individual’s learning style—combining hands-on practice,
documentation, and continuous support—is the most effective.