Hello, I'm Tendai, a Data Analyst. I am passionate about identifying business challenges through data and applying analytical techniques to facilitate informed decision-making. My expertise lies in data cleaning using Power Query, conducting thorough data quality assessments, and skillfully transforming raw data to extract actionable insights. I am dedicated to using data analytics tools and methodologies to contribute meaningfully to the decision-making processes within a business.
At the outset of a new project, there's often an eagerness to dive in and start the hands-on work. However, the danger lies in assuming we know exactly what the client needs without delving into their requirements.
Picture this: the client needed a report, but as analysts, we might prematurely envision a dazzling dashboard. The key to successful project initiation lies in the process of requirement gathering, with a pivotal emphasis on asking the right questions.
ETL stands for Extract, Transform, Load, and it's a process used by organizations to manage their data. In simple terms, ETL helps gather data from various sources (like websites or databases), clean and organize that data to make it suitable for analysis, and then store it in a central location, such as a data warehouse, where it can be analysed to gain valuable insights.
This project demonstrates a clear and straightforward ETL process for gathering and analyzing data from Amazon.co.uk. The process involves three main steps: collecting the data, cleaning it, and then storing it in a database for further analysis.
Click to view projects
Click to view projects
Click to view projects
Click to view projects
Click to view read
Worked closely with Chami Group, a team led by Goylette Chami (MPhil PhD Associate Professor), to conduct in-depth research on Schistosomiasis and its impact in Uganda. The project included assessing the accessibility of health-carefacilities. R programming language was used to transform raw data into 6 insightful visualisations, including geospatial maps highlighting the locations of health centers and drug stores. Applied geospatial data to develop 4 insightful chloropleth maps, showcasing population density and the accessibility of health centers. Presented findings to 8 fellow researchers. Successfully managed tasks and deadlines, actively participated in progress meetings to ensure effective communication and collaboration.
To conduct my analysis I utilised data provided by Chami group & by sourcing data from the Ministry of Health - Republic of Uganda.
• Examined healthcare facility availability for the Ugandan population ,focusing on 3 municipalities: Mayuge, Buliisa,and Pakwach.
• Explored healthcare preferences, uncovering that across surveyed areas, 64% of establishments were drug stores, while 36% were health facilities.
• Wrote a comprehensive report discussing the epidemiology of the disease and quantified findings, contributing to the broader understanding of healthcare dynamics in the region.