Simon Macharia Portfolio
Data Analyst skilled in Excel, SQL, Power BI
HR DATA ANALYSIS – SQL SERVER 2022 / POWER BI
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
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 excel](https://www.hisdataproject.com/wp-content/uploads/2023/11/excel.png)
![SQL Server SQL Server](https://www.hisdataproject.com/wp-content/uploads/2023/11/microsoft-sql_server.png)
![msql msql](https://www.hisdataproject.com/wp-content/uploads/2023/11/msql.png)
![power-bi power-bi](https://www.hisdataproject.com/wp-content/uploads/2023/11/power-bi-2.png)
![visual studio visual studio](https://www.hisdataproject.com/wp-content/uploads/2023/11/visual-studio.png)