Scribd Logo
Upload

Welcome to Scribd!

  • 13 views

    Coursera Microcurso 2

    Uploaded by

    yadhira
    This document summarizes the steps taken in analyzing customer purchase data to address a business problem for a company called Inu + Neko. Key questions are identified to analyze customer purchasing preferences and most popular products over the last 6 months of 2021. Important data is gathered, including best selling products, sales, customer lists, and monthly transactions. Visualizations are created in Tableau and interpreted. Recommendations are provided based on model results to increase dog category products and focus on customer behaviors. The current favorable business state and projections for increasing future sales are described. Further work is recommended around customer satisfaction and product analysis.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Coursera Microcurso 2

    Uploaded by

    yadhira
    13 views14 pages
    This document summarizes the steps taken in analyzing customer purchase data to address a business problem for a company called Inu + Neko. Key questions are identified to analyze customer purchasing preferences and most popular products over the last 6 months of 2021. Important data is gathered, including best selling products, sales, customer lists, and monthly transactions. Visualizations are created in Tableau and interpreted. Recommendations are provided based on model results to increase dog category products and focus on customer behaviors. The current favorable business state and projections for increasing future sales are described. Further work is recommended around customer satisfaction and product analysis.

    Original Description:

    Microcurso

    Original Title

    COURSERA MICROCURSO 2

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document summarizes the steps taken in analyzing customer purchase data to address a business problem for a company called Inu + Neko. Key questions are identified to analyze customer purchasing preferences and most popular products over the last 6 months of 2021. Important data is gathered, including best selling products, sales, customer lists, and monthly transactions. Visualizations are created in Tableau and interpreted. Recommendations are provided based on model results to increase dog category products and focus on customer behaviors. The current favorable business state and projections for increasing future sales are described. Further work is recommended around customer satisfaction and product analysis.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    13 views14 pages

    Coursera Microcurso 2

    Uploaded by

    yadhira
    This document summarizes the steps taken in analyzing customer purchase data to address a business problem for a company called Inu + Neko. Key questions are identified to analyze customer purchasing preferences and most popular products over the last 6 months of 2021. Important data is gathered, including best selling products, sales, customer lists, and monthly transactions. Visualizations are created in Tableau and interpreted. Recommendations are provided based on model results to increase dog category products and focus on customer behaviors. The current favorable business state and projections for increasing future sales are described. Further work is recommended around customer satisfaction and product analysis.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 14

    Course 2 Capstone

    The OSEMN Process


    Your Approach 1 of 4
    Give at least two example questions you would want to answer as an analyst that relates
    to Inu + Neko’s business problem.
    Remember a good question includes a focus on something that is actionable and follows the SMART goal principles (specific,
    measurable, attainable, relevant, & timely).

    ● Analyze customer purchasing preferences over the last 6 months of 2021.


    ● Analyze the company's products that customers bought the most in the last 6 months of 2021.
    Your Approach 2 of 4
    What information do you think would be particularly important to your analysis for Inu +
    Neko?

    ● Most selled products


    ● Total sales
    ● List of customers who previously bought
    ● Monthly transactions
    ● Product for type of animal
    Your Approach 3 of 4
    How would you go about gathering this information?

    1. Clean the data by removing duplicates, correcting inconsistencies, and eliminating columns with missing
    values.
    2. Explore the cleaned data to gain more information about customer behavior and product popularity.
    Your Approach 4 of 4
    What are some potential issues or roadblocks can you see in trying to get this
    information to address Inu + Neko’s business problem?

    Data Quality and Consistency: Ensuring the quality and consistency of the data is crucial for meaningful analysis.
    Inaccurate, incomplete, or inconsistent data can lead to misleading insights.

    Data cleansing and validation: These processes may be required to address any data quality issues before analysis.
    Your Data Visualization
    Using Tableau, create the requested visualization (Placeholder). See Step 2 for additional
    instructions. The CSV is linked here.
    Your Visualization Interpretation 1 of 2
    What does this visualization show about the data?

    In this image you can see a display of total sales in monthly times for 6 months.
    Your Visualization Interpretation 2 of 2
    Does this visualization align with what we’ve seen so far from the data?

    Yes, because we use the data that we mentioned above.


    Recommendations Based on Model Results 1 of 2
    What recommendations would you give Inu + Neko based on the model results?

    From my point of view and with the results they are on the right track with the strategy they are using. I
    would recommend going the same way and still paying attention to the behaviors of their customers to
    know what they like the most and satisfy them.
    Recommendations Based on Model Results 2 of 2
    What recommendations would you give Inu + Neko based on the model results?

    Based on the results, it is recommended to increase and develop new articles for the category of dogs in
    order to continue increasing the utility taking advantage of the preference in the category of dogs.
    Your Final Insights 1 of 4
    What can you say about the current state of the business?

    From my point of view, I see that the company is going in the right direction, since according to the results
    the profit is increasing, so if they continue working like that, their position will be better.
    Your Final Insights 2 of 4
    What projections can you make about the future state of the business?

    Future projections will be very favorable as the picture shows that sales are increasing in this category.
    Your Final Insights 3 of 4
    What would you recommend to Inu + Neko?

    It would be recommended to offer coupons, discounts to old and loyal customers.


    Your Final Insights 4 of 4
    What more work could be done to expand on your analysis?
    (You won’t need to do this but state what would be good next steps for a follow-up analysis.)

    ● Customer satisfaction analysis


    ● Product performance analysis

    You might also like