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.
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.
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.
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.
Tableau SQL Excel
In this project, I used SQL Server to explore global COVID-19 data and then exported some tables to excel so I can use them in Tableau to create a dashboard with different visualizations.
SQL
In this project, I used SQL Server to clean and transform row data and make it more usable for analysis.
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.
SQL
In this project, I used basic SQL commands like
SELECT, FROM, WHERE, ORDER BY, and JOIN.
