Demonstration projects
Portfolio
This portfolio contains demonstration projects created to show my approach and developing skills in SQL, Excel and Shopify website design. Each project uses a fictional business and sample data. They are not completed client projects.
-
Demonstration Project
Monthly Sales Analysis Using SQL
Scenario: a fictional online shop wants to understand how its sales change from month to month, using a sample orders dataset.
Planned approach: organise the sample order data, write SQL queries to summarise monthly revenue and order counts, and highlight basic sales patterns.
-
Demonstration Project
Excel Sales Report and Dashboard
Scenario: a fictional small business has a messy sales spreadsheet and wants a clear summary it can share.
Planned approach: clean and organise the sample data, use basic formulas to calculate totals and averages, and create charts that present the information clearly.
-
Demonstration Project
Shopify Store Design for a Fictional Small Business
Scenario: a fictional small business needs a simple, professional Shopify store to present its products online.
Planned approach: using an existing Shopify theme, design the homepage, organise the navigation and arrange the product pages.
Have a project in mind?
Whether it is a data or reporting task or a Shopify website design project, tell me what you are trying to achieve and I will let you know whether I can help.