This is a Complete BI project from scratch and include both (OLTP) And OLAP Data warehousing.
Olist is an enterprise that engages with multiple merchants for marketing their products online and charges a commission for each product that is ordered.
Project Goal : constructing dashboards that facilitate the analysis of data and assess the performance of sellers via key performance indicators (KPIs).
project Tools (SQL For Data cleaning & exploration And building OLTP Schema, SSIS For Data integration And building Data warehouse (OLAP), SSRS for paginated reports, Power BI for dashboards, Tableau for dashboards).
In this project, I built dashboards using Power BI that Analyze company's data To determine the reasons of employees Attrition,furthermore I generated random names using MS SQL server with external data!
Project tools (Power BI using Power Query for data cleaning and transformation , Dax For measures).
drill-through and filter pages were implemented to improve the charts with additional details and information.
This is a Complete BI project from scratch and include both (OLTP) And OLAP Data warehousing.
In this project, we build dashboards that Analyze telecommunication company's data To determine the reasons of churning out from it!
project Tools (SQL For Data cleaning & exploration, SSIS For Data integration, SSAS for creating cubes, SSRS for paginated reports, Power BI for dashboards, Tableau for dashboards).
As a former player of the online game "League of legends",I recently came across some data related to the game and decided
to use my skills to analyze it for fun and learning.
This project involves the use of Excel & Power BI,
Excel for data cleaning & Exploration, power Query for preparation. DAX was utilized for measure creation. In addition,
I added relevant images to make it more engaging and easier to understand
and various filters were added to enhance usability
in this project, we build dashboards that Analyze telecommunication company's data To determine the reasons of churning out from it!
This project involves the use of Power BI,specifically Power Query for data cleaning, exploration, and preparation. DAX was utilized for measure creation. In addition,
Drill Through functionality was implemented to provide users with more detailed information, and various filters were added to enhance usability.
Exploring covid 19 Data using MS SQL server.
Cleaning Nashville Housing data using MS SQL server.
