Final Project GuidelinesPlease use this format to submit your final work The paper must follow all the guidelines as instructed in order to obtain full creditRemember that our team of tutors is availa

behaving and what they are interested in.

ANSWERS

1. It would be highly beneficial for Can Coll to carry out a Big Data project. Big Data is a term used to describe the massive amount of structured and unstructured data that is generated every day. The characteristics and particularities of Big Data, such as its volume, velocity, variety and veracity, make it difficult to process, analyse and manage with traditional data management tools. However, the benefits of Big Data are immense as it allows companies to gain valuable insights into their customers, operations, competitors and markets, which in turn helps them make better decisions, improve their products and services, reduce costs and increase revenue. In addition, using Business Intelligence tools will enable Can Coll to analyse and visualise data in a more user-friendly and interactive way, making it easier for them to identify patterns, trends and opportunities.

2. To know their current client portfolio, Can Coll would need to collect different types of data such as demographic, psychographic, behavioural and social media data. Demographic data includes information about the age, gender, income, education, occupation and location of their clients. Psychographic data refers to the values, beliefs, attitudes, interests and lifestyles of their clients. Behavioural data includes information about the purchase history, frequency, value and preferences of their clients. Social media data includes information about the online activity, interactions and feedback of their clients on social networks. Within each typology, the data that would be analysed would be:

• Demographic data: age, gender, income, education, occupation, location.
• Psychographic data: values, beliefs, attitudes, interests, lifestyles.
• Behavioural data: purchase history, frequency, value, preferences.
• Social media data: online activity, interactions, feedback.

3. The goals to achieve based on the data that needs to be analysed are:

• Identify the most profitable and loyal customer segments.
• Understand the needs, preferences and expectations of each customer segment.
• Create personalised offers, promotions and experiences for each customer segment.
• Increase customer satisfaction, loyalty and retention.
• Improve the effectiveness and efficiency of marketing, sales and service operations.
• Monitor and measure the performance and impact of customer-related activities.

4. The type of database that would be used to store the information would be a relational database. A relational database is a type of database that organises data into one or more tables, where each table has a unique key that identifies its rows. This type of database is suitable for storing structured data, such as customer information, as it allows for easy retrieval, manipulation and querying of data. In addition, relational databases provide data integrity, consistency and security, which are important factors when dealing with sensitive and confidential data.

5. After knowing their clients through a Big Data project, Can Coll could adopt a more personalised and individualised approach to their services. Some changes or activities that they could carry out are:

• Create customised packages and experiences for each customer segment based on their preferences and needs.
• Offer personalised recommendations, suggestions and promotions to each customer based on their purchase history and behavioural data.
• Provide personalised service and attention to each customer based on their feedback and interactions.
• Develop targeted marketing campaigns and communications that resonate with each customer segment based on their psychographic and social media data.
• Monitor and respond to customer feedback and complaints in real-time to improve their satisfaction and loyalty.
• Measure and analyse the impact and effectiveness of their customer-related activities to continuously improve their service and operations