Welcome to my portfolio! I am Adeyinka Abidemi Akanbi, a passionate and detail-oriented
data analyst/business analyst with a strong background in transforming complex data into actionable
insights.
With expertise in SQL, Python, Power BI, and Excel, I have successfully completed projects that
drive strategic decision-making and operational efficiency. Explore my work to see how I harness the power
of data to uncover opportunities, solve problems, and contribute to meaningful business outcomes.
Let's connect and see how we can leverage data to achieve your goals!
Recent Work
In the BuildMart Business Analytics Dashboard project, I harnessed the power of Excel and Power BI to transform raw sales and customer data into actionable
insights. This project addresses the challenges faced by BuildMart, a leading building materials provider, in reversing their declining revenue and improving
customer satisfaction. By developing a comprehensive BI dashboard, I identified key performance indicators, analyzed trends, and provided strategic recommendations
to enhance operational efficiency and market competitiveness. This project exemplifies my ability to leverage data analytics and visualization tools to drive business
performance improvements.
In this project I cleaned a housing data using SQL. The dataset contained information on housing prices,
features, and location. I used SQL to remove duplicates, handle missing values, and transform data into
the appropriate format. I also used SQL to identify and remove outliers, and to join multiple tables
together to create a comprehensive dataset. By using SQL to clean and prepare the data, I was able to
ensure that the analysis was based on accurate and reliable data. This allowed me to identify meaningful patterns and insights in the data, which helped my client make informed decisions about their real estate investments.
In this project I explored various aspects of the covid data using SQL.The data included information on the number of cases, deaths, and recoveries, as well as demographic and geographic information. Using SQL,I calculated key metrics, such as death percentage and percentage of the population infected and to perform geographic and temporal analyses. Through this analysis, I was able to identify trends and patterns in the data that helped inform public health decisions and resource allocation
during the pandemic. My experience with SQL allowed me to efficiently and effectively analyze large and complex datasets, providing valuable insights into the pandemic's impact.
Get In Touch
Interested in discussing how my skills in data analytics and business intelligence can benefit your team? Let's connect!
Scripts
