8 projects that interact and work directly with SQL
2 projects that interact and work directly with Power Bi
5 projects that interact and work directly with Python (Machine learning, NLP)
Toeic 850
Google Data Analytics Professional Certificate
Danny seriously loves Japanese food so in the beginning of 2021, he decides to embark upon a risky venture and opens up a cute little restaurant that sells his 3 favourite foods: sushi, curry and ramen.
Danny’s Diner is in need of your assistance to help the restaurant stay afloat - the restaurant has captured some very basic data from their few months of operation but have no idea how to use their data to help them run the business.
Danny was scrolling through his Instagram feed when something really caught his eye - “80s Retro Styling and Pizza Is The Future!”. Danny was sold on the idea, but he knew that pizza alone was not going to help him get seed funding to expand his new Pizza Empire - so he had one more genius idea to combine with it - he was going to Uberize it - and so Pizza Runner was launched!
Subscription based businesses are super popular and Danny realised that there was a large gap in the market - he wanted to create a new streaming service that only had food related content - something like Netflix but with only cooking shows!
Danny launched a new initiative, Data Bank which runs banking activities and also acts as the world’s most secure distributed data storage platform! Customers are allocated cloud data storage limits which are directly linked to how much money they have in their accounts.
Data Mart is an online supermarket that specialises in fresh produce. In June 2020 - large scale supply changes were made at Data Mart. All Data Mart products now use sustainable packaging methods in every single step from the farm all the way to the customer. Danny needs your help to analyse and quantify the impact of this change on the sales performance for Data Mart and it’s separate business areas.
Clique Bait is an online seafood store. In this case study - you are required to support the founder and CEO Danny’s vision and analyse his dataset and come up with creative solutions to calculate funnel fallout rates for the Clique Bait online store.
Balanced Tree Clothing Company prides themselves on providing an optimised range of clothing and lifestyle wear for the modern adventurer! Danny, the CEO of this trendy fashion company has asked you to assist the team’s merchandising teams analyse their sales performance and generate a basic financial report to share with the wider business.
Danny created Fresh Segments, a digital marketing agency that helps other businesses analyse trends in online ad click behaviour for their unique customer base. Clients share their customer lists with the Fresh Segments team who then aggregate interest metrics and generate a single dataset worth of metrics for further analysis.
You are a Data Analyst working for an e-commerce company named X. You are tasked with preparing a presentation to present an overview of the company's business and operations to date for Sales and Operations Managers.
You are a Data Analyst working for an retail company based on The Contoso BI Demo dataset. You are tasked with preparing a presentation to present an overview of the company's business and operations to date for Sales and Operations Managers.
Based on a data set about the behaviors, characteristics, and services that customers have used of a telecommunications services sector and internet service providers. Build machine learning algorithm models to predict customer churn rates.
Analyze new and old customers: Identify the difference between new and old customers. By using criteria such as number of purchases, order value....
RFM clustering: Use RFM analysis (Recency, Frequency, Monetary) to classify customers into groups based on the following criteria: time of last purchase (Recency), number of purchases (Frequency ) and order value (Monetary).
Crawl data about games from websites, then based on information about the gameplay or plot of the game, perform text analysis using machine learning methods related to natural language , to identify games with similar gameplay or storylines. Finally, build a recommendation application. When the user chooses a game, the system will automatically suggest 5 other games with the most similar gameplay or plot.
Based on short passages from users, perform analysis and classification to identify user emotions expressed in that passage.
Crawl data user posts from facebook websites
This project proposes a method that combines machine learning and natural language processing (NLP) to automatically analyze and cluster users based on text topics, thereby recommending suitable products for each group, building community...
