How to Get Started with Power BI
Vložit
- čas přidán 1. 08. 2024
- You want to get started with Power BI, but are not sure how? In this video I show you how to go from Excel to Power BI - step by step. In this complete walkthrough you learn about how to move from a normal pivot table in Excel to Power Pivot and use Power Query for data cleaning. You will see that once you know how they work in Excel, the transition to Power BI is quite straight forward. In Power BI you will learn all the things you need to know to get up and running.
Enjoy this video and subscribe to always stay updated on my favorite Power BI tricks :)
Download file here datatraining.io/powerbi-how-to
--------------------------------
📊 TRAININGS 📊
---------------------------------
Power BI Design 4 Weeks Transformation Program my.datatraining.io/pages/powe...
Power BI Essentials datatraining.io/powerbilearni...
Business User Training datatraining.io/powerbi-busin...
For Custom Trainings and Consulting email directly support@datatraining.io
---------------------------------
⏱️ TIMESTAMPS ⏱️
---------------------------------
00:00 Intro
00:33 Why you want to work with tables
03:38 Creating a basic pivot table
04:41 Matching data into 1 table to use all of it in 1 pivot table
08:39 Linking tables using Power Pivot - Data Model
15:49 Fact table vs dimensions and adding a adding a date table / calendar
17:47 Using DAX: Data Analysis Expressions
19:59 Using Power Query for data cleaning
24:20 Loading data to Power Pivot
27:04 Creating the data model and doing checks in a pivot table
28:52 Run a refresh to import new data
29:57 Visualizing in excel - building an interactive report
35:35 Importing and cleaning data using Power Query in Power BI
39:58 Building a data model in Power BI
43:54 Creating visualizations and a report in Power BI
50:42 Using quick measures for calculations
52:23 Publishing to Power BI Service
53:42 End
---------------------------------
😍 JOIN 😍
----------------------------------
Join bit.ly/4b453bi
Subscribe bit.ly/31MnQGO
Insta / howtopowerbi
LinkedIn / basdohmen
TikTok / how.to.power.bi
X / howtopowerbi
fb / howtopowerbi
Threads www.threads.net/@howtopowerbi
Newsletter datatraining.io/newsletter
---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------
💻 My gear amzn.to/47F21Yc
📚 Power BI books MUST READ! amzn.to/3tUfFcj
💡 General books I recommend amzn.to/48YNo33
🎶 Music for my videos www.epidemicsound.com/referra...
🚀 For growing on CZcams: www.tubebuddy.com/bas
🏄 Stuff I use daily amzn.to/3HqfMQ2
* Above are affiliate links, which means at no additional cost to you, if you make a purchase using these links we will receive a small commission. It supports us and helps us to continue making more How to Power BI videos!
Thanks for being a part of this channel and all your support! 💪 🙏
#HowToPowerBI #PowerBI #DataTraining
#powerbidesktop #powerbitraining #powerbideveloper #DAX - Věda a technologie
your method of teaching is really amazing, I like it, and you provide the information in a simple way that is really appreciated 🙂
I have gone through a lot of videos to learn about Power BI even purchased a course. But when CZcams 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!
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
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!
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:):)
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!
This was very helpful, thanks for these step to step tutorials.
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 was a fantastic overview of some very useful features between excel and power bi. Thank you for the clear explanation
Very clear presentation. Thank you
Thanks so much, as I am now learning PowerBI. Really clear video for beginners
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
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 :):)
I'm enjoying your videos, thanks 🤩
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
AWESOME. Great job..
Now I’m learning new tricks in excel via a power no tutorial. Thanks! :))
:):) glad to hear this Matthew!
Indeed the best intro
Great tutorial and very helpful taking the first steps in Power BI.
Thanks Danny!
Great tutorial. Thanks
:) glad you liked it!
Wow..what a fantastic video!... I have learned a lot...many thanks for your time....thanks a million!
Awesome Mazen!
new updates brings very good tool for powerpoint presentation.now we can directly used our interactive dashboard in PowerPoint
Correct
Wow!! Wow!! This is masterpiece.. You are awesome!!
Simply Brilliant Smoothly Explained n Expressed Indeed 🙌🙌🙌👍👍
Thanks Santosh! 🤩
This was very useful! Thank you.
Thanks 🙏 glad to hear you think so!
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 :):):)
Extremely useful
Thanks Artem!!
Great video!!
thank you ! ☺
Thanks. I appreciate.
You are welcome :)
Excellent Job 👍
Thanks a lot!
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?
Damn bro, these keeps coming!
:):):)
Amazing 👏
Thanks!
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!
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 , 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 CZcams 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
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
Nice 👍👌
Thx tofik!
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?
This was awesome. I know I will review this several times. I would love to get my hands on some raw live data.
Can we exclude weekends in days count calculation.saturday and sunday.
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! :)
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!
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?
Where can I get this excel file for practice?
Please how doi get data files used in this Tutorial ?
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
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
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 CZcams Videos". Clicking through, those CZcams videos do not appear to be called "How to Get Started with Power BI" so the data doesn't seem to be there.
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 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
czcams.com/video/kAMhh776V8w/video.html
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.
czcams.com/video/hmk6PxDtbNs/video.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
What is the video that you recommend to start watching to enter the world of Power BI?
This one :)
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: czcams.com/video/VV7fRIkfVts/video.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 CZcams but who knows :)
boo
?
Not sure why you needed to teach Excel for 30 mins before going into PowerBI...