Select Page

Simon Macharia Portfolio

Data Analyst skilled in Excel, SQL, Power BI

HR DATA ANALYSIS – SQL SERVER 2022 / POWER BI

human resources

This project dives deep into the realm of data analysis using SQL and Power BI to uncover important human resource insights that can greatly benefit the company.

Featuring eye-catching dashboards offer crucial HR metrics like employee turnover, diversity, recruitment efficacy and performance evaluations. These help HR professionals make informed decisions and strategic workforce planning.

PIZZA SALES ANALYSIS – SQL SERVER / POWER BI

This project comes in 4 CSV files. In this project, I’ve used Microsoft SQL server 2022 to uncover valuable insights to help the pizza outlet make important decisions to increase sales.

The data is presented using Power BI and includes KPIs and other questions important to uncovering these insights.

WORLD POPULATION – POWER BI / POWER QUERY / DATA SCRAPING

World Population

This project explores world population by continents and countries. The data is scraped directly from the internet from 3 web pages (given below). We then load this data in power BI, clean and transform it in Power Query, then present our findings in an interactive Power BI dashboard.

Tools I Use in My Projects

excel
SQL Server
msql
power-bi
visual studio