Mercy Ogero Portfolio

As a skilled Data Analyst with experience in statistical analysis, and data visualization, I am eager to leverage my expertise to make a significant impact in data science. I possess a detail-oriented and analytical approach, which enables me to identify trends, patterns, and insights that inform strategic decision-making. My proficiency in data cleaning, transformation, and visualization using tools such as SQL, Excel, and Tableau makes me a valuable asset to any organization. I have experience collaborating with interdisciplinary teams to achieve project goals, and my excellent communication skills allow me to convey complex data-driven insights to diverse audiences. I am dedicated to staying up-to-date with the latest industry trends and continuously expanding my skills and knowledge in data analytics. I am excited to bring my passion and expertise to a dynamic and innovative organization where I can contribute to the team's success and help drive business growth. @MercyTheAnalyst

SQL and Excel Project with interactive dashboard

In this project, I begun by importing data to MS SQL Server Database Management, creating a Dababase, writing simple and complex SQL queries and lastly, creating a SQL document. The project focused on data cleaning, processing, analysis and dashboard creation in Excel.

SQL Data Cleaning Project

Project Introduction: The SQL data cleaning project involved analyzing a dataset related to Nashville housing. This dataset was sourced from a real estate database, aiming to improve data quality and consistency for better insights. Problem Definition: The analysis addressed issues such as inconsistent date formats, missing property addresses, and data duplication, aiming to enhance the accuracy and completeness of the housing dataset. Steps and Tools: Utilized SQL queries for data manipulation and transformation. Standardized date formats, filled missing property addresses, and addressed duplication using CTEs and various SQL functions. Microsoft SQL Server Management Studio was chosen for its robust query capabilities. Welcome to my Tableau Visualizations Portfolio, where data transforms into captivating stories and insights. As a passionate data enthusiast with a keen eye for translating raw information into visually engaging and meaningful dashboards.

Tableau Projects

Welcome to my Tableau Visualizations Portfolio, where data transforms into captivating stories and insights. As a passionate data enthusiast with a keen eye for translating raw information into visually engaging and meaningful dashboards. In a world inundated with data, the ability to distill complex information into clear, actionable visuals is a skill that sets professionals apart. Throughout my career, I have honed this skill using Tableau, a powerful tool that allows me to weave narratives, uncover patterns, and make data-driven decisions more accessible. This portfolio is a curated collection of my most impactful Tableau visualizations, each a testament to my dedication to turning data into a powerful asset for organizations. From interactive dashboards that reveal trends at a glance to compelling data stories that drive decision-making, these visualizations showcase my ability to convey the story behind the numbers..

Location


Nairobi, Kenya

Phone

(254) 799825033

Email

ogeromerci@gmail.com

Social