balasubramanian-pg/mba-sem-3

This repository contains all the PowerPoint presentation encompassing all Sem 3 topics in Business Analytics and Finance.

You can use either Tableau or Excel for your presentation. I personally use Excel for rough drafts and suggestions, then repeat the same in Tableau. The model answer for task 1 must be backed by your own research which makes the solution authentic and personal

Task 1 Data Quality Assessment

Assessment of data quality and completeness in preparation for analysis Customer Demographic Customer Addresses Transactions data in the past 3 months

Task 2 Data Insights

Targeting high value customers based on customer demographics and attributes. Sprocket Central Pty Ltd is a long-standing KPMG client whom specialises in high-quality bikes and accessible cycling accessories to riders. Their marketing team is looking to boost business by analysing their existing customer dataset to determine customer trends and behaviour.

Task 3 Data Insights and Presentation

Using visualisations to present insights What are the trends in the underlying data? Which customer segment has the highest customer value? What do you propose should be Sprocket Central Pty Ltd ’s marketing and growth strategy? What additional external datasets may be useful to obtain greater insights into customer preferences and propensity to purchase the products?