Some time back, I published a Power BI
tutorial playlist on YouTube, which was
based on project-based learning, and it
got very popular. Some people even got a
job just by following those videos.
This inspired me and my friend Hemanand, who
is also data professional, and a Power BI
guru, to build a premium quality paid
course,
and I'm excited to announce that that
course is live now on codebasics.io
It is available at a very affordable
price, something that you would spend on
your family dinner, and
anyone can take this course. Absolute
beginners who want to build a career as
a data analyst, or a data analyst who is
working in the industry and they want to
take
their skills at the next level. This
course will give you all of that. It took
two industry professionals, me and my
friend Hemanand more than six months of
hard work,
to produce this course. We have put our
heart and sweat into this, and I'm hoping
you all are going to love this course.
I'm going to play a quick preview of the
course, and towards the end I will show
you some of the content and will walk
you through the course, chapter by
chapter. I know what you're thinking
right now. You want to build a career in
data analytics and you want to learn
Power BI. But you came across so many
courses on the internet, and you're
thinking what is different about this
particular course. Give me few minutes
to explain this. I am Dhaval Patel. I run a
YouTube channel called Codebasics, where
I teach data science and AI. More than
570 000 subscribers, as of April 2022.
My industry experience is with big tech
companies like Nvidia and Bloomberg, 17
plus years of experience.
I produced this course
with my friend Hemanand, who is also a
Power BI expert. He worked for a company
in U.K. for many years, and we want to
bring a premium quality course here,
where we are not teaching you just the
tool skills. So I always talk about tool
and core skills, where to become a
successful data analyst, you need to be
good in
analytical thinking, business
understanding and communication. So this
course is a project-based learning, where
we will take a real life project, and
we'll solve that project, we'll build
awesome
Power BI dashboards, deployed to cloud. We'll
uh consume the insights that these
dashboards are generating,
and this will complete an end-to-end
project based learning, and this course
is perfect for beginners, as well as
people who already know Power BI and
Tableau both.
This course is not just teaching you
Power BI, it is teaching you
data analysis. It is making you job ready
for
data analysis industry. Sometimes,
learning technology can become boring,
and to address that problem we have
incorporated lot of humor, comics and
fun, creativity elements,
with lot of hands-on learning exercises
and so on, so that you don't get bored
you have very effective learning, and you
can be truly ready for the industry. I am
on codebasics.io website,
and this is the course we are talking
about. So once you make a payment or
enroll,
you'll be able to see the course content.
There are few chapters which are
available for free. So feel free to watch
it, before you decide to pay.
But then once you make a payment, you
will see all these chapters.
So start from, what exactly is data
analytics. I will explain you, as if you
are a child very simple language.
What is Power BI, things like that, and
then since it's a project-based learning,
we start with a problem statement. So
let's say you're working as a data
analyst in electronics consumer goods
company. So I'll explain you the business
model of that company,
and we'll talk about the problems that
they are facing and how using data
analytics, you can bring data informed
decision making.
This will give you a
preview as if you are doing a virtual
internship where a product owner sends
out an email. A project kickoff meeting
happens. They discuss the requirement,
they lay out the plan and so on. So see
here there is a project kickoff meeting.
We talk about project management
techniques such as project charter
and we use a more tool called Mural, to
plot all the project charter related
dimensions into a document.
And then,
we also
cover a lot of business knowledge, domain
understanding. For example this one
covers, the fundamentals of profit and
loss statement, and I explain these
things in a way that, even a small child
can understand it easily.
Then
we go to data collection and exploration
state.
We have used a MySQL database, and this
database has few million records. So it's
not a toy data set. It's a real life
industry use case. Whatever you will find
once you get a job as a data analyst, you
will be working on these type of data
sets.
They mimic a real life situation, okay?
Few million
,few million records easily.
You can download those. See we provide
download files. You can download, import
it into SQL,
and then we cover all the fundamentals
like Star Schema, Facts Fact, SQL,
you know things like that.
And then we go to Power BI. So
how do you do data modeling in Power BI,
how do you do basic
number validation, things like that. So we
cover all of that, and then, uh let me
just, I'm just gonna quickly
play and quickly just,
so that you get an
understanding on what kind of content we
are covering.
We cover lot of fundamentals of DAX,
Power Query. So you'll see this is all
about Power Query data transformation,
and this chapter, chapter number six is
all about
DAX, building
you know visuals, things like that.
And by the way, let me show you the
end
visual, visual that you are going to
create. See you will create a tool like
this, where you will build finance view,
sales view, and so on. And when you go to
finance view, you will
see the whole
view, and we'll talk about what kind of
answers
this
view can give you,
right? You have filters at the top, so on.
Sales view, marketing view, these are the
different
views used by different teams, to get
answers on
different use cases basically.
In chapter number eight,
we continue building these visuals,
and then in chapter nine which is very
important, we talk about the
the design principles. You know like look
and feel, you see like nice,
professional look, blue background
using
good icon. See that we have used so many
icons here.
So we talked about those 15
design rules,
for building an effective dashboard.
And by the way every chapter has a
chapter summary, which kind of summarizes
the chapter's key learning. So even if you
read this chapter summaries, you will
takeaway a lot of useful learning with
you. And then every chapter has quizzes
as well,
so so that you can test out the
knowledge
that you have gained. Chapter number 11
is actually very very important.
We go through
something called like stakeholder
mapping analysis right, so where we
before the stakeholder meeting, we will
map the different stakeholders in our
quadrants.
And
then you know we have used nice like
drama style of situation,
where
a data analyst is looking at
you know his calendar. And then we do
further
discussion on
each of the stakeholders. So for example,
when they were doing this stakeholder
mapping,
uh
data analysts will recall their memories
on these different stakeholders, their
personalities, because see it's all about
expectation and ego management. So these
different stakeholders having different
personalities, when you go work as a data
analyst, you have to learn all these soft
skills.
So im, soft skills are
very very important, okay? And we have
used some humor as well, so you don't get
bored. I know learning technology can
become boring sometimes. So there is lot
of humor and lot of
comic style visuals, that we have used
which you will find it pretty
entertaining as well.
And then see you can learn things only
by doing. So what we do is,
the stakeholder feedback that we have
received, so see here is a stakeholder
meeting,
where different people are
attending and giving feedback.
You will
work on the exercises. So let's say this
is exercise number one, okay? So you see a
quick preview of the stakeholder meeting.
Then
see here here's a meeting with so many
people, and then
we
discuss
like both
both senior and junior data analysts
discuss the approach, and then you work
on the solution. And if you want to see
our solution, what we have done is
in chapter number
[Music]
14,
we have provided videos of all these
solutions.
So don't worry, if you feel like
you're not able to make a progress, we
have provided the entire solution. But at
least you can learn things by doing, and
then we deploy the whole solution to
Power BI service. See in this chapter,
we give you an overview of what exactly
is Power BI service.
How do you deploy, how do you set up
automatic refresh for
MySQL, for
Excel,
the
personal gateway, the organizational
gateway, we talk about all those cool
things. Then we talk about
documentation and maintenance.
And
then comes the most important part, which
is resume and interview tips. So this is not
just Power BI okay, do xyz in Power BI.
This is end-to-end getting your job
ready for data analyst
career. We talk about
project portfolio
okay,
and we give you some idea on how do you
build your own project portfolio, we talk
about resume writing tips.
So we have
me and my friend Hemanand have years of
experience reviewing resumes, okay? So we
talked about a lot of
like resumes, job application tips.
So
you can just study all those things,
here
uh let me see if this
I can just
go a little bit ahead
and kind of show you.
So overall
see you're learning
a lot of practical tips
on how to build effective resumes. So we
have provided even the templates. So we
go through this resume, as if we are the
recruiter because me and my friend both
the course instructors
have years of experience doing real
interviews.
So how do we look at things, so we we
talk about those things. We also provide
you some sample resumes, so you can you
know use them as a template.
And then there is a final test. This test
has a lot of questions. When you finish
it,
you will get a certificate,
okay?
So try it out. The link is in the video
description below. codebasics.io is
the website name,
and
on that you will find this course which
is,
what is the course name?
Power BI data analytics for beginners.
This is for beginners as well as
advanced users, okay? So advanced users if
you are already working as a data
analyst, I am 100% sure you will get lot
of useful insights and career tips and
Power BI learning obviously, from this
particular course.
Let me know if you have any question,
there is a comment section below.