As promised our second resume project
challenge is out. All you do is go to
codebasics.io click on resume
projects and you will see that challenge
here. Challenge number two. Last month we
did the first challenge which was
providing insights in for revenue team
in hospitality domain. This one is in
FMCG domain you are solving some supply
chain issue. What problem are you solving?
Well we have given a detailed
description. We are using AtliQ Mart
and imaginary FMCG manufacturer company
and they are facing certain data
transparency issues. So you have to help
this company by building BI dashboard.
You can use Power BI, Tableau whatever
tool we don't care. You will get the data
set from here, so if you click on
download button you will download a zip
file which you will extract obviously
and you will see all these files. Now now
these files have dimension table and
fact table so this is following usual
star schema and
here if you click on this PDF file this
gives you a domain knowledge, a business
understanding of supply chain. Now if you
are looking for a job as a data analyst
or a data scientist
if you go work in any FMCG company or
any other company this supply chain uh
fundamentals could be really helpful.
Domain knowledge is kind of a big thing
nowadays.
So if you have these skills they're
going to be helpful. So here in this
document we have given you the
definition of various term. For example
what is OTIF okay? So we have given simple
definition here
then
you have to look at the stakeholder
meeting, and we have done some this in a
fun way where the stakeholders are
having a meeting okay?
Bruce Haryali is a director of AtliQ
Mart, Tony Sharma is the head of supply
chain and Peter Pandey is the data
analyst you want to be Peter Pandey who is
solving complex data analysis problems
with ease okay? So he's listening to the
stakeholder meeting conversation so you
read this conversation and try to get an
idea on the requirements. In the last
resume challenge project we gave you a
ready-made dashboard now we want to take
you to the next level. It's like a video
game right if you want to up your level
where just by hearing this conversation,
you have to figure out what kind of
dashboard these stakeholders want and
the reason I'm doing this is because
when you go work in a company, these
stakeholders will sometimes give you
vague requirements and all that. So you
have to learn the art of hearing this
vague requirements and translating them
into something concrete. Now if you feel
stuck do not worry. We have this other
document where Peter Pandey
our genius data analysts have taken
notes. So you can use this rough notes to
build your dashboard. So I'm hoping
you're getting an idea,
you first go to this page, read all this,
try to get an understanding on what this
challenge is about. Second step is listen
to this stakeholder conversation try to
get an idea on what they want to build
and if needed we have given you notes
for further help. And based on this you
have to build a single dashboard okay,
one page Power BI, Tableau whichever tool
you use build a nice dashboard and we
want to see your creativity. Last time we
give you all the mock-ups and this time
we want to try uh your creativity the
dataset looks something like this so
I'm going to show you a couple of files.
So let's say these are customers okay uh
these are all the customers that they
have in different cities of India and
then you have different products right?
You have milk you have Amul Ghee and
curd I know you all like Amul products
and then
you have orders aggregate okay? So these
are the orders.
Now this dataset we generated it to
mimic the real life situation okay? Now
if you have question uh and if you need
help you can click on Discord channel
here and you can ask the question. There
are so many community members who will
help you okay so there's a separate
channel to help you with your resume
project challenge. Now what are the
benefits number one is you are learning
data analytics through real life project
okay, and you're not only learning Power
BI and data analysis you are also
learning business understanding, domain
knowledge these are very very important
things for a data science career. Top
three submission will also get an
attractive prize, they will also get 30
percent scholarship on our premium Power
BI course. So if you are not come across
our course this is a premium high
quality course with a lot of fun, real
life dataset one and half million
records this makes you job ready okay?
This course has everything that you need
to become job ready for data analyst
career. You'll get 30 scholarship on this
premium course you'll also get an
appreciation certificate. So many people
participated in first Challenge and they
all got appreciation certificates we
also have winners. I want to show you how
people did an amazing job by not only
building the dashboard but by putting
that on LinkedIn. For example Ashish Babaria, he
put a nice LinkedIn post and he built an
amazing dashboard. Look at this dashboard
beautiful! This is for the project
challenge one and I want to just show
you some of the examples from that
challenge,
and then you also put a nice
presentation together. See he's
highlighting all the key metrics and
what kind of insights he generated. Now
see if some recruiter looks at this
LinkedIn post they are going to be
impressed for sure. Again Ashish is
probably going to get an interview call.
Similarly Naveen also did
amazing job he wrote a nice LinkedIn
post,
he actually recorded a video of a
presentation and
he discussed his insight, what insights
he generated
as if he's presenting you know against
the stakeholders. Folks if you just sit
alone in a room and just learn Power BI
or any other technical tools that alone
is not going to help you. You have to
learn business understanding, you have to
learn presentation skills, you need to
know how to Market yourself on LinkedIn.
So write this kind of LinkedIn post
you know people will like see 208 people
like this post. That's beautiful!
195
these impression will go to some
recruiters LinkedIn feed and they will
spot your challenge. So these things can
really help you get a job and all of
this is free. There is no money, nothing.
All you need is a willpower so
participate in this today download the
dataset. Now if you don't know Power BI,
some people ask me this question okay I
don't know Power BI. How can I
participate? Do not worry you have to do
just one thing go to YouTube search Code
basics sales insights okay and you will
find this particular project playlist it
will take you maybe three or four hours
to learn this. It's very easy you learn
it and then straightaway you can
participate in this challenge. Now if you
need further help and if you need
premium learning, then you can buy our
course okay? So there is no prerequisite
you could be in HR domain, you could be
you could be a salesperson, you could be
a teacher in the school and you want to
let's say build a career in data
analysis this is the opportunity. This is
totally free and you're getting a very
high quality learning and also an
opportunity to showcase your talent. Once
you have built the dashboard, you can
enter your URL of let's say let's say Ashish Babaria right he
posted this this particular thing you
can copy the link and you can just copy
paste and submit the solution. This is
how you can submit the solution the
deadline is October 31. You have more
than enough time even if you don't know
Power BI don't worry. See you can spend
three hours right? If you're serious
about your career you want to build a
career in data science industry are you
serious about that spend three to four
hours on this and then immediately start
working on this challenge. It's not as
hard as you think it is. All you need is
to take that first step. See the art of
getting things done is to act. So act
today and I wish you all the best.
[Music]