Welcome to you QuestPond YouTube channel! Definitely you guys must have seen the title
of this video power BI is one of tools from which can enter in to the IT industry very easily you
have to work out Power BI tool but when compared with the programming or scripting or app building
then our power BI is far easy to work and enter. There is no need to know the programming
or scripting language. From the top it looks very easy
to enter in to the power BI field but many Power BI developers fail to crack the technical round.
Why is it like that? Now a days the company needs super employ who does the multitasking
and knows the multiple technologies and even just knowing the power BI it will not help you
because an interviewer in technical round a senior Power BI expert will not just ask you the
questions related to Power BI but also on other topics which are required for Power BI jobs.
In this video I am going tell you the five important points based on the
topics which we surely help you to crack the technical round of Power BI. Trust me guys
if you follow just these five points you can crack any company s Power BI job very easily no matter
you are fresher or experienced guy. Request you to watch this video completely before going for
Power BI Interviews really this video will help you to crack your Power BI Interview.
Let s get started with the point no. 1. Power BI is all about doing the Data analysis and
data presentation. Definitely you need to know is data warehousing part too
that is the mother of all databases SQL Server. The point no. 1 you must know SQL Server along
the T-SQL this is the point no. 1 very important point.
If you don t know the SQL Server and writing the SQL queries also then definitely you cannot
apply for the Power BI job. SQL Server is like a base foundation Power BI job
you should know SQL Server in and out with the proper writing queries along with this
you should also know how to create the databases in SQL Server, how to create tables in SQL Server,
how to write the stored procedure, how to write the function, how to do the Normalisation,
how to do the Denormalization, how to write the SQL joins.
You should have knowledge of inner join, left join, right join, object explorer, how to write
views, you should have a complete knowledge of SQL Server end to end.
Because Power BI is all about doing the data analysis and
data presentation playing with the data. If you don t know the SQL Server, if you
don t know how to write the T-SQL and if you not answering the SQL Server Questions and Answers
properly with the proper technical words then definitely it will create a negative impact in the
interviewer s mind that you don t know the base of the database also and to have a Power BI job you
should have a strong database skills. Request you that answer each and every questions of
SQL Server properly with the proper technical words. Prepare for the SQL Interview Questions and
Answers series before going to your Power BI job this is all about the point No. 1.
If you are liking the content of our video then show us your love by liking our video and if you
are new to our channel then please subscribe to our channel because your 1 like and 1 subscribe
keep us motivated to create more technical videos on Power BI and on other technologies.
If you find this video useful then share this video with your friends or with your colleagues.
Let s get back our video and let s talk about Point no. 2 - You should have a knowledge
of Business Intelligence tools that is Microsoft business intelligence tool.
Why should have a knowledge of business intelligence tools?
Let s understand it with a scenario, before doing data analysis we need to organise the raw data
and dump this row data into the data warehouse. Suppose if you are doing the data analysis for
any food court company which is spread across the various countries then definitely you can expect
lot of data from various countries. Example - From India you will get a text file,
from Australia you will get a CSV file and from US you will get
excel file. As you can see we got the data of the same food court company in a different format.
Here it is in the text file here it is CSV file and here it is an excel file.
Definitely this data will come with lot of data related or format related issues.
Before doing the data analysis we need to solve all these format problems and do the data
transformation, do the data type transformation when the data type will come from text file
it will be different, from the CSV again will be different from the excel again it will different.
First we have to the data type transformation make it uniform so we can dump all this transformed
data in to this data warehouse. In our case SQL Server is our data
warehouse. Once we transfer all this data we can dump this data in to our data warehouse.
Now to do this entire process we need a BI tool that s we have MSBI that is Microsoft business
intelligence tool with MSBI integration services we can easily extract the data, transform the data
and finally load the data that is the properly transform data we can load it to data warehouse.
In an interview we can expect lot of questions related to MSBI. Prepare for MSBI interview
questions and answers series especially for SSIS and SSRS. SSIS is an integration services
tool and SSRS is a reporting services tool. Also learn more about ETL tool, dimensions,
facts, measures, star schema, snowflakes, cubes, multi-dimensional, tabular report.
Prepare for all this and prepare for MSBI interview questions and answers series
before going for Power BI interviews. Let s talk about point no. 3 - knowing
the Power BI End to end - Power BI with a Power Query, DAX, Visualization, Power BI Services.
You should know the Power BI End to end means what?
Just knowing the Visualization and creating a presentation will not help you.
You need to know the Power BI End to end that is a Power BI is based on the four pillars.
You need to have a proper knowledge of Power Query i.e. the Power Query functions like append, merge,
removing duplicates, parameters, M functions and there are like thousands of M functions
categorised as per text, number, date string table excel and so on and then we have a DAX
which will again help us to enlist Power of Power BI and help us end doing the data analysis.
Prepare for the DAX functions which are categorised into
logical, Arithmetic, Time intelligence, table, string and many more.
Also what is calculated measures, what is calculated columns, tables, relationships,
what is parameter and so on. Once you are done with the DAX then finally
with the Visualization types like tables, slicer, bar, chart, line chart and so
on and finally the Power BI Services. Knowing the dashboard, row level security,
data gateways, publishing the report to the Power BI Services and so on.
Prepare for Power BI Interview Questions and Answers series End to end because you
are applying for a Power BI Job you should have a End to end knowledge of Power BI.
Let s talk about point no. 4 - this point I will not stress you more
but if you can prepare it will be very great. Knowing Azure cloud services, I am not expecting
that you should know the Azure cloud services entirely but like for example we have A-Z 900
which covers the basics of Azure we have Azure Data factory which is the cloud based ETL and
data integration services tool to create the workflows for moving and transforming the data.
We have azure data lakes for analysis, to store the data of any size, shape,
speed, and do all types of processing and analytical across the platforms and languages.
We have Azure analysis services for creating cubes. For applying Power BI job you should have
a basic of Azure knowledge like we have just spoken i.e. the A-Z 900, Azure Data factory,
Azure data lakes and if you can cover the DP-900 also will be very great but we don t need to
cover the Azure cloud services entirely we just need to focus on these points only because if
an interviewer will ask you the questions related azure then he is going to ask you related to this
point only that is Azure basic, A-Z 900, DP-900 or he will ask you about data factory or data lakes.
This is only the role you guys have to play in the Azure cloud services there is no need to
know more about Azure cloud services extra if you have mentioned the Azure cloud services in
your resume definitely it will create a great impact because you will become a prefer choice
for interviewer to select because you know the Azure and now every company s moving towards the
cloud services, they need a candidate who has a prior knowledge of Azure cloud services.
Please prepare for Azure cloud services, hence I have added this point as the Point
No. 4. This is optional but this is very important point
if you can add this part in your resume, you will have your job as a Power BI guy.
Let s talk about the point No. 5 - Prepare for Tableau. This is again a Visualization tool
and optional but yes if you know this optional also it will create a great impact
in your resume and in your Interview because it is very booming in the market so Interviewer can
ask you few questions on this expect you to have a little knowledge on Tableau. Tableau software
is a Visualization tool that helps us to make the big data small and small data inside full
and actionable. It is very powerful and fastest growing data Visualization tool in BI market.
Interviewer or a company can expect you to have knowledge on Tableau. Read more about Tableau
and just focus on Tableau Interview Questions and Answers only because it s very
easy and again a Visualization tool. It is okay if you don t know entire Tableau
but atleast you can answer little questions it will be very great,
this is all about the Point No.5. These are the 5 Points which you need to remember
before going for Power BI Interview. You guys must be wondering how to get all this interview
questions and answers videos on the topics which we have just cover right now in this video.
You guys must be thinking like from where to get all this material.
Visit our website i.e. www.questpond.com Here you will find the SQL Videos, Azure Videos
i.e. fundamental Videos, Power BI Videos, Tableau Videos, MSBI Videos.
We have all the videos along with the interview questions and answers series, with the
frequently asked Interview Questions and Answers. You can simply buy these videos from our website.
There is a buy option here. Start preparing 10-15 days before going for Power BI Interview
so that you can cover all these topics whatever the 5 points which we have spoken in this video.
We also have free videos in case if you want to see the quality of our videos,
we do have the free videos on our YouTube channel. Links of those videos I will provide
in the below description box of this video you can watch and decide to go for more videos
to go for this buy now option or not. I will leave this to your personal choice and requirement.
Thank You Very much for watching this video and in case if you have any queries regarding the
Power BI Interview feel full to post your doubts in the below comment section of this video.
I will be very Happy to personally answer your doubts and queries.
Thank You Very Much, Happy Job Hunting .!!!