I have gone through a lot of videos to learn about Power BI even purchased a course. But when RUclips 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...
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!!
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
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!
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!!!
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.
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!
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,
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?
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
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 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
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 ?
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.
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!
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?
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 ruclips.net/video/kAMhh776V8w/видео.html
@@HowtoPowerBI It takes you to landing page with a link to "download files related to my RUclips Videos". Clicking through, those RUclips videos do not appear to be called "How to Get Started with Power BI" so the data doesn't seem to be there.
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.
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.
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.
I have gone through a lot of videos to learn about Power BI even purchased a course. But when RUclips 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...
You are right- by far the longest video ;) thank you so much abut this comment :) truly appreciate it!
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!!
Thanks Michael for this insightful feedback! Much appreciated:):)
Your level and your teaching skills are just amazing. Another great tutorial. Thanks!
Thanks Alex :) always looking for your feedback :):)
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
your method of teaching is really amazing, I like it, and you provide the information in a simple way that is really appreciated 🙂
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!
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!!!
Comments like this make my, thank you so much :)
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.
Thanks! Yahhhhhh!!! Super happy to hear this :)
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!!
That comment totally made my day! Thanks a lot :):)
This was very helpful, thanks for these step to step tutorials.
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!
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,
Super happy to hear this :) good luck with implementation
new updates brings very good tool for powerpoint presentation.now we can directly used our interactive dashboard in PowerPoint
Correct
Thanks so much, as I am now learning PowerBI. Really clear video for beginners
Now I’m learning new tricks in excel via a power no tutorial. Thanks! :))
:):) glad to hear this Matthew!
This was a fantastic overview of some very useful features between excel and power bi. Thank you for the clear explanation
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?
Indeed the best intro
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
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
Right now it is not on the agenda for the RUclips but who knows :)
@@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
Wow..what a fantastic video!... I have learned a lot...many thanks for your time....thanks a million!
Awesome Mazen!
This was awesome. I know I will review this several times. I would love to get my hands on some raw live data.
Very clear presentation. Thank you
Wow!! Wow!! This is masterpiece.. You are awesome!!
Great tutorial and very helpful taking the first steps in Power BI.
Thanks Danny!
Thank you so much for your amazing videos.. keep going. You are the best
Thanks Ali! super motivated to keep going with the comments like yours :):):)
Simply Brilliant Smoothly Explained n Expressed Indeed 🙌🙌🙌👍👍
Thanks Santosh! 🤩
I'm enjoying your videos, thanks 🤩
AWESOME. Great job..
Damn bro, these keeps coming!
:):):)
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 ?
Great video!!
thank you ! ☺
Excellent Job 👍
Thanks a lot!
Great tutorial. Thanks
:) glad you liked it!
Thanks. I appreciate.
You are welcome :)
This was very useful! Thank you.
Thanks 🙏 glad to hear you think so!
Extremely useful
Thanks Artem!!
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?
I read some of the comments and is your name Bas? That's cool. Like the legendary fighter Bas Rutten.
Hahah yes my name is Bas :) super Dutch!
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.
Amazing 👏
Thanks!
Hi sir could ypu make a complete long video covering all the power bi advance techniques in one video or in parts
Currently its not on my list, but there are many advanced videos on my channel- have a look! :)
Thanks Alex ... You really have a great way of explaining
Do you have any courses?
Thanks :) yeah i have Power BI learning path, have a look in the video description for the link
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?
Can we exclude weekends in days count calculation.saturday and sunday.
Nice 👍👌
Thx tofik!
Great video. Why is my PowerBi green and not yellow like everybody's else?
Everybody’s else is now also green (power BI changed it some time ago)
@@HowtoPowerBI i see, i prefered it yellow, i've aleays hated that excel green 🤷 thank you
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!
Where can I get this excel file for practice?
Please how doi get data files used in this Tutorial ?
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?
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
ruclips.net/video/kAMhh776V8w/видео.html
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".
Found it under "Start with Power Bi | Step by Step from Excel to Power Bi"
I cannot seem to find the data download for this video on your website.
See link in the description
@@HowtoPowerBI It takes you to landing page with a link to "download files related to my RUclips Videos". Clicking through, those RUclips videos do not appear to be called "How to Get Started with Power BI" so the data doesn't seem to be there.
What is the video that you recommend to start watching to enter the world of Power BI?
This one :)
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
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.
ruclips.net/video/hmk6PxDtbNs/видео.html in this video it shows how to find the max/min
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.
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.
@@di44itothe measure for max at month level is explained in the vid, Minute 3
but real world data is messy..double headers etc etc..hope i can see more data clean up technique.😅
Right! have a look at some of my previous videos starting here: ruclips.net/video/VV7fRIkfVts/видео.html
@@HowtoPowerBI actually i learn alot from you and guyinacube,curbal etc
👍
can you do more charticulator and map using mapbox
@@MrLalramchhana right now it is not on the list for RUclips but who knows :)
boo
?
Not sure why you needed to teach Excel for 30 mins before going into PowerBI...