Data Analysis Challenge: Analyze Customer Spending Pattern

[Guest theoyinbooke]

 

 

 

Quick Question

 

 

How Good are you with answering business questions using Microsoft Power BI? You don't have to rate yourself on any scale, I have a challenge for you.

 

 

 

Consider the use case described below and the accompanied data, carry out a detailed analysis using Microsoft Powr BI. This is the only way to convince me how good you are with answering business questions.

 

 

 

 

 

 

 

Use Case Description

 

 

 

 

 

 

 

SellCheapy Retail is a chain of department stores that sells a wide range of products, including bikes and different components. Despite having a large customer base, the company has been struggling to increase sales in recent years. The management team is looking to use data analysis to understand customer spending patterns and make changes to their sales and marketing strategies to improve performance.

 

 

 

The company collected data on customer demographics, purchasing history, and other relevant information over the course of a year. The data includes information on the products purchased, the price paid, and the date of purchase, etc.

 

 

 

You are required to work with this data and provide solutions to the business problem.

 

 

 

 

 

 

 

Challenge Dataset

 

 

 

 

 

 

 

You are to use the Adventureworks Dataset 2019 OLTP version for this challenge. More details about adventureworks database can be found in the attached file to this blog post (see at the end of the blog).

 

 

 

To learn how to setup adventureworks database on your PC, watch this video

 

 

 

 

 

 

 

 

 

 

Project Documentation

 

 

 

 

 

 

 

We have an upcoming series to help you get the best from this effort. We will show you how you can properly document and showcase your project using GitHub. Do watch out by visiting this post again for the event link. Link will be available in few days time.

 

 

 

More Challenge

 

 

You can complete our dedicated Cloud Skills Challenge

 

 

 

 

 

Connect with Others

 

 

 

 

 

 

 

You are not alone working on this project. use the hashtag #GitHub4Me while sharing on twitter and LinkedIn for your content to become more discoverable. Use it while posting your questions, use it while answering other people's questions.

 

 

 

 

 

Earn Badges and Trophies

 

 

 

 

 

 

 

Earn Badges and trophies from Microsoft when you complete a module and learning path respectively. This is another way to show a recruiter, your potential employer, or your current employer of your commitment to continuous learning.

 

 

 

Click here to participate in the cloud skill challenge. You can as well click on the image above

 

 

 

 

 

Amazing FREE Offer for Student: GitHub Student Pack

 

 

 

 

 

 

 

The GitHub Student Pack is FREE for verifiable STUDENTS and help you learn using real-world development tools. You get to use GitHub Pro while you are a student, enjoy amazing valuable offers from GitHub Partners, etc...

 

Click here or on the image above to claim this offer.

 

 

 

 

 

Project Submission

 

 

You will be wondering how you get to submit your project. For now, you should share your work by taking screenshot and using the hashtag #GitHub4Me while posting on Twitter and LinkedIn. We have an upcoming Live session to guide you on how to properly showcase and document your work on GitHub. Once we are done with that session, you will be able to go through the process and make your project portfolio worthy by documenting it on GitHub.

 

 

 

We will also provide the Link for you to submit your documented project. Since we want you to get the best from this effort, the most missing part is how you communicate your final work through documentation, this is where you will shine brighter this time.

 

 

 

We are excited for you already and can't wait to see what you get to do at the end. Kindly check back this blog for details about the forthcoming Live sessions.

 

 

 

 

 

 

 

Additional Resources

 

 

Microsoft Student Hub - https://aka.ms/learnstudent

 

FREE Advance Certifications for Nigerians - https://aka.ms/NGFreeCertification

 

FREE Learning Resources to Help You Kickstart Your Tech Journey - Begin Now!

 

FREE Certification for Students Around the Globe - Learn More

 

FREE Certification for Students in the UK - Learn More Here

 

Continue reading...