Projects
Here are my projects that I worked on and currently working on
Excel SQL R
In this case study, I performed data analysis for a fictional bike-share company in order to help them attract more riders. Along the way, I performed numerous real-world tasks of a junior data analyst by following the steps of the data analysis process: Ask, Prepare, Process, Analyze, Share, and Act.
Excel
In this project, I cleaned and transformed the data. Later on, I created pivot tables and charts,
Finally I organized a dashboard with charts and slicers.
SQL
In this project, I used basic SQL commands like
SELECT, FROM, WHERE, ORDER BY, and JOIN.
SQL
In this project-based course, I built a billing report and a club member roster by using SQL statements.
SQL
In this project-based course, I gained hands-on experience and learnt how to create and maintain relational databases such as MySQL, Oracle and MS Access. Concepts covered include database and table creation, primary keys and foreign keys.
SQL
In this project, I used SQL Server to clean and transform row data and make it more usable for analysis.
Power BI
In this project-based course, I learned the basics of using Power BI Desktop software by analyzing data on credit card defaults.
Power BI
In this Power BI case study, I used Power Query to investigate and clean the data to find out what skills are most in-demand for data scientists, data analysts, and data engineers. I then used DAX to build insightful visualizations of my findings. Finally, I created a business dashboard so that I can answer questions for the DataSearch team.
PowerBI
In this project, I used Power Query to clean and transform my data then I created a dashboard to summarize the survey.
Tableau SQL Excel
In this project, I used SQL and Excel to clean and transform my data then I created a dashboard with Tableau.
