How to Get Started with Power BI

[@kri8tivity]

I have gone through a lot of videos to learn about Power BI even purchased a course. But when KZbin recommended your video, I turn out to a fan of your teaching, the way you introduced everything. Watching your videos for a couple of weeks and this is your may be longest video. But How it come to end tells about your teaching. Thank you Bas for helping everyone...

[@HowtoPowerBI]

You are right- by far the longest video ;) thank you so much abut this comment :) truly appreciate it!

[@michaelt312]

Such a logical step by step presentation. Many presenters are too busy showing us how much they know. Meanwhile, you focus on how much you teach. Thank you!!

[@HowtoPowerBI]

Thanks Michael for this insightful feedback! Much appreciated:):)

[@markusoestreich8695]

I knew how it all connects and ultimately how power BI is the tool to use. But I still watched the video. The way you explain it and get there is exceptional! Well done and I will share this with a couple people that need to understand that. It’s just so important and sooo much more motivating when you know the background … very well done! Thank you

[@alexrosen8762]

Your level and your teaching skills are just amazing. Another great tutorial. Thanks!

[@HowtoPowerBI]

Thanks Alex :) always looking for your feedback :):)

[@ezekiel0606]

I've seen a lot of courses. I've been specializing in Power BI for years. This is the best starter guide bar none. I always send it to anyone who wants to give PBI a try. Thanks for the amazing video!

[@pabeader1941]

This is the first video that I have shared to the folks that I am mentoring. I have watched 100s of videos from other presenters and yours is the first.

[@HowtoPowerBI]

Thanks! Yahhhhhh!!! Super happy to hear this :)

[@musimejmae4734]

This was very helpful, thanks for these step to step tutorials.

[@keziahajah]

I just stopped halfway through this tutorial to write this comment. Bas, this was masterfully articulated and excellently delivered. I love that you went through all of the basics quickly and gave a lot of value. I discovered your channel yesterday and have been through many videos already. I especially loved the navigator page videos. Thank you so much for providing these excellent tutorials. You are a star!!!

[@HowtoPowerBI]

Comments like this make my, thank you so much :)

[@mikeberry9932]

This video was excellent. I was already comfortable with power query, and it had me wanting to learn more about power pivot and power BI. Can't wait to put this to work!

[@sphnyhptrs]

Well put together!!! Even though I'm not a beginner to Power BI, I was hooked from the beginning to the end of your video!!

[@HowtoPowerBI]

That comment totally made my day! Thanks a lot :):)

[@wasio44]

Hello Bas, i'm not sure if you're mentioning it : in your video, you build from scratch a new data model in power bi via power query. but is it possible to *load* the previously build data model in excel/power pivot/power query directly in power BI?

[@KhaledShouman]

your method of teaching is really amazing, I like it, and you provide the information in a simple way that is really appreciated 🙂

[@AR-rk7oz]

I was struggling with how it all went along. Your video was an excellent learning tool. Your enthusiasm is fabulous and contagious and I will definitely be watching all the other videos. Cant wait to put it into practice,

[@HowtoPowerBI]

Super happy to hear this :) good luck with implementation

[@sushantneo]

Hi Bas, It was a pleasure watching your video! I’ve just started following you and learning Power BI, and I have to say, I’ve become a big fan of your work. However, I’d like to point out a couple of steps that I feel could have been approached differently: 1. In the “FcFinancial” data table, it didn’t seem necessary to remove the “Department” column (at 37:47), as it can later be automatically linked to the “Department” column in the “Department” table in the model view. 2. Instead of renaming the column “Department.1” to “Department” (at 37:55), you could rename it to “DepartmentKey,” which would allow it to automatically link to the “Department” table to “DepartmentKey” in the model view. I hope this feedback is helpful. Looking forward to more of your content! Best regards, Sushant (India)

[@nadsb6170]

Thanks so much, as I am now learning PowerBI. Really clear video for beginners

[@rschloch]

Now I’m learning new tricks in excel via a power no tutorial. Thanks! :))

[@HowtoPowerBI]

:):) glad to hear this Matthew!

[@HansOnProduction1984]

This was a fantastic overview of some very useful features between excel and power bi. Thank you for the clear explanation

[@mostafashehata3094]

Great , Keep up the good work , Can you please make a series of Dax measures , I can work with Dax measures but I want to deeply understand the complex measures measures for example the ones you used in building income statement

[@HowtoPowerBI]

Right now it is not on the agenda for the KZbin but who knows :)

[@mostafashehata3094]

@@HowtoPowerBI No problem I appreciate your efforts and help getting people to learn a brilliant stuff from you, I understand that you are busy too Just keep it in your mind, you will get a lot of people form the level they can do some work from example to a level that makes them finding solutions, Thanks for all your valuable information

[@MrLalramchhana]

new updates brings very good tool for powerpoint presentation.now we can directly used our interactive dashboard in PowerPoint

[@HowtoPowerBI]

Correct

[@tariqkhan9441]

Great video! I don't know if this is a dumb question or not but how did you create the slicer panel at 34:30?

[@MahrukhTariq___]

Hi! Great video. Can you help me with the issue that I'm not able to use size field as it's not even present for the map visual. It only has latitude, longitude, legend and tooltips but not size, any way to get it ?

[@kaushiksaha30]

Wow!! Wow!! This is masterpiece.. You are awesome!!

[@mazenalsakkaf]

Wow..what a fantastic video!... I have learned a lot...many thanks for your time....thanks a million!

[@HowtoPowerBI]

Awesome Mazen!

[@Karen-bm3rj]

I'm enjoying your videos, thanks 🤩

[@theodohmen1782]

Indeed the best intro

[@AnnaelleFarnos-Simon]

Great video ! How would you create a pivot chart as in Excel but in PowerBI ? I usely use Matrix in PowerBI but I would like to create visual starting from this Matrix as in Excel.

[@dannyvanhove8420]

Great tutorial and very helpful taking the first steps in Power BI.

[@HowtoPowerBI]

Thanks Danny!

[@seamushand8439]

Very clear presentation. Thank you

[@TejaswiniChunchu]

Hello, I'm non IT back ground but I willing to learn Power BI. I have gone through few of your videos that your explanation and real time scenarios are good. Would you please guide me how to learn quickly from beginning?. Thanks in Advance

[@santoshkiran5858]

Simply Brilliant Smoothly Explained n Expressed Indeed 🙌🙌🙌👍👍

[@HowtoPowerBI]

Thanks Santosh! 🤩

[@abdulrahmanalnajjar1496]

Thanks Alex ... You really have a great way of explaining Do you have any courses?

[@HowtoPowerBI]

Thanks :) yeah i have Power BI learning path, have a look in the video description for the link

[@AliBuKarrar]

Thank you so much for your amazing videos.. keep going. You are the best

[@HowtoPowerBI]

Thanks Ali! super motivated to keep going with the comments like yours :):):)

[@TerrorPeanut]

We get a lot of data from third parties in the 'Data combined' format with no keys. Do you know the easiest way to reverse engineer the lookup tables (account, product etc)? Power Query seems to take a while adding the generated keys to the raw data. Sql works well but ideally I'd want something more basic. Sorry if its a bit out of scope but I've been trying to get something workable for ages!

[@RajuGowtham518]

Can we exclude weekends in days count calculation.saturday and sunday.

[@williamfurgurson]

AWESOME. Great job..

[@tsxplora5420novraineneos]

Is it possible to make a Gantt chart in Power BI? Or at least make a report in Power BI on progress of tasks in Gantt chart. Anyone knows?

[@hamzaherom4564]

Excellent Job 👍

[@HowtoPowerBI]

Thanks a lot!

[@milux616]

Great tutorial. Thanks

[@HowtoPowerBI]

:) glad you liked it!

[@A_Lul]

Great video!!

[@HowtoPowerBI]

thank you ! ☺

[@faliqzulkifli933]

Damn bro, these keeps coming!

[@HowtoPowerBI]

:):):)

[@fatimamccullough120]

This was awesome. I know I will review this several times. I would love to get my hands on some raw live data.

[@muttch]

This was very useful! Thank you.

[@HowtoPowerBI]

Thanks 🙏 glad to hear you think so!

[@toukirrahman3574]

Where can I get this excel file for practice?

[@artemyarosh817]

Extremely useful

[@HowtoPowerBI]

Thanks Artem!!

[@lucasnilsson2952]

I do have a question, (I'm a student from Finland), is it possible to combine real map regions into one, to create your own areas of interest on a map? I have managed to create my own custom map and drawn my areas onto it, that's all good and well. But, since these areas aren't "custom" or "made up", they are a combination of real world reagions, how could I for example, combine 3 western regions of a country on a map to make them act and respond as one single region and name that region "West"? I've been struggling with this for quite a while now, is there an answer?, is there already a video on it?

[@HowtoPowerBI]

You can use the shape map visual and import a geojson file that has a custom map here is the video Turn Any IMAGE into an INTERACTIVE VISUAL in Power BI kzbin.info/www/bejne/oXKwmZttbJuJbtk

[@anguswalker7003]

I cannot seem to find the data download for this video on your website.

[@HowtoPowerBI]

See link in the description

[@anguswalker7003]

@@HowtoPowerBI It takes you to landing page with a link to "download files related to my KZbin Videos". Clicking through, those KZbin videos do not appear to be called "How to Get Started with Power BI" so the data doesn't seem to be there.

[@rabihyounes747]

@@anguswalker7003 same issue, did you figure it out ?

[@gagansingh3481]

Hi sir could ypu make a complete long video covering all the power bi advance techniques in one video or in parts

[@HowtoPowerBI]

Currently its not on my list, but there are many advanced videos on my channel- have a look! :)

[@ibrahimrahman3320]

Please how doi get data files used in this Tutorial ?

[@dullestower8773]

Where is the source file for this one. Cannot see it on your web site under the heading "How to Get Started with Power BI".

[@dullestower8773]

Found it under "Start with Power Bi | Step by Step from Excel to Power Bi"

[@MohamedIbrahim-et4hq]

Amazing 👏

[@HowtoPowerBI]

Thanks!

[@shrikantbadge3978]

Thanks. I appreciate.

[@HowtoPowerBI]

You are welcome :)

[@AkshayKumar-vd5wn]

I read some of the comments and is your name Bas? That's cool. Like the legendary fighter Bas Rutten.

[@HowtoPowerBI]

Hahah yes my name is Bas :) super Dutch!

[@di44ito]

Hi I'm looking for a way to combine min and sum. I have a big table.with sales amount for every day and for different products. I want to sum the amount of sales by product by date and to find the date with minimum amound sold. For example for product A for the last month i have sales every day and on 10.10.2022 i have the least amoun of sales which is 3. I want to show in a table the least amound sold by date by product for every month from the beggining of 2016 until now.

[@HowtoPowerBI]

kzbin.info/www/bejne/np7OZ4OuedmVhNU in this video it shows how to find the max/min

[@di44ito]

Thanks, but i'm not sure that i explained what o wanted to do right. I have a row with 1 sale for a particular date and then a row with 2 sales for the same date i first want to sum this sales and then to find the date with minimum amound sold for every month from 2016 until now. I did the first part with a measure for sum sales amount and i showed it in a table by products and years and months and then used this table to create a visual. Now i have to get this total by date and show the date with the least amount sold and the amont itself. In excel i have done this buy making a pivot table for the first part and then copied this table and used it for a new pivot table that showes the min by dates for a particular product.

[@di44ito]

I hope that i explained it better this time. I'm just starting to use power bi in my job and i'm the first person to use it so pretty much i have to teach myself and i'm just a begginner and can't combine measures the right way yet. I tried to use my measure for sum in a new measure for minx, but it showed me the minimum for the whole period and not the minimum for every month.

[@HowtoPowerBI]

@@di44itothe measure for max at month level is explained in the vid, Minute 3

[@alterchannel2501]

Great video. Why is my PowerBi green and not yellow like everybody's else?

[@HowtoPowerBI]

Everybody’s else is now also green (power BI changed it some time ago)

[@alterchannel2501]

@@HowtoPowerBI i see, i prefered it yellow, i've aleays hated that excel green 🤷 thank you

[@lilaandari0503]

I need help with putting a pivot table in a report I'm building if anyone could help I would really appreciate it thank you

[@tofikqureshi6507]

Nice 👍👌

[@HowtoPowerBI]

Thx tofik!

[@matiaslopeza5405]

What is the video that you recommend to start watching to enter the world of Power BI?

[@HowtoPowerBI]

This one :)

[@MrLalramchhana]

but real world data is messy..double headers etc etc..hope i can see more data clean up technique.😅

[@HowtoPowerBI]

Right! have a look at some of my previous videos starting here: kzbin.info/www/bejne/jIeal4V_oMuJqtU

[@MrLalramchhana]

@@HowtoPowerBI actually i learn alot from you and guyinacube,curbal etc 👍

[@MrLalramchhana]

can you do more charticulator and map using mapbox

[@HowtoPowerBI]

@@MrLalramchhana right now it is not on the list for KZbin but who knows :)

[@sjp6780]

boo

[@HowtoPowerBI]

?

[@defaultdefault812]

Not sure why you needed to teach Excel for 30 mins before going into PowerBI...