How to Get Started with Power BI

Рет қаралды 79,882

Күн бұрын

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 KZfaq: 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

Пікірлер: 101

@kri8tivity 2 жыл бұрын

I have gone through a lot of videos to learn about Power BI even purchased a course. But when KZfaq 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 2 жыл бұрын

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

@michaelt312 2 жыл бұрын

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 2 жыл бұрын

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

@alexrosen8762 2 жыл бұрын

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

@HowtoPowerBI 2 жыл бұрын

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

@markusoestreich8695 2 жыл бұрын

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

@fatimamccullough120 13 күн бұрын

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

@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!

@ezekiel0606 3 ай бұрын

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!

@HansOnProduction1984 Жыл бұрын

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

@musimejmae4734 3 ай бұрын

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

@AR-rk7oz 2 жыл бұрын

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 2 жыл бұрын

Super happy to hear this :) good luck with implementation

@nadsb6170 6 ай бұрын

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

@keziahajah8808 Жыл бұрын

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 :)

@seamushand8439 Жыл бұрын

Very clear presentation. Thank you

@sphnyhptrs 2 жыл бұрын

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 2 жыл бұрын

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

@pabeader1941 2 жыл бұрын

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 2 жыл бұрын

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

@Karen-bm3rj Жыл бұрын

I'm enjoying your videos, thanks 🤩

@dannyvanhove8420 2 жыл бұрын

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

@HowtoPowerBI 2 жыл бұрын

Thanks Danny!

@rschloch Жыл бұрын

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

@HowtoPowerBI Жыл бұрын

:):) glad to hear this Matthew!

@mazenalsakkaf 2 жыл бұрын

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

@HowtoPowerBI 2 жыл бұрын

Awesome Mazen!

@williamfurgurson 8 ай бұрын

AWESOME. Great job..

@AliBuKarrar 2 жыл бұрын

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

@HowtoPowerBI 2 жыл бұрын

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

@kaushiksaha30 10 ай бұрын

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

@santoshkiran5858 2 жыл бұрын

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

@HowtoPowerBI 2 жыл бұрын

Thanks Santosh! 🤩

@theodohmen1782 2 жыл бұрын

Indeed the best intro

@muttch 2 жыл бұрын

This was very useful! Thank you.

@HowtoPowerBI 2 жыл бұрын

Thanks 🙏 glad to hear you think so!

@wasio44 2 жыл бұрын

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?

@milux616 2 жыл бұрын

Great tutorial. Thanks

@HowtoPowerBI 2 жыл бұрын

:) glad you liked it!

@MrLalramchhana 2 жыл бұрын

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

@HowtoPowerBI 2 жыл бұрын

Correct

@user-wi3wx8qp8m 4 ай бұрын

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

@mostafashehata3094 2 жыл бұрын

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 2 жыл бұрын

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

@mostafashehata3094 2 жыл бұрын

@@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

@artemyarosh817 2 жыл бұрын

Extremely useful

@HowtoPowerBI 2 жыл бұрын

Thanks Artem!!

@A_Lul Жыл бұрын

Great video!!

@HowtoPowerBI Жыл бұрын

thank you ! ☺

@shrikantbadge3978 2 жыл бұрын

Thanks. I appreciate.

@HowtoPowerBI 2 жыл бұрын

You are welcome :)

@faliqzulkifli933 2 жыл бұрын

Damn bro, these keeps coming!

@HowtoPowerBI 2 жыл бұрын

:):):)

@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.

@hamzaherom4564 Жыл бұрын

Excellent Job 👍

@HowtoPowerBI Жыл бұрын

Thanks a lot!

@MohamedIbrahim-et4hq 2 жыл бұрын

Amazing 👏

@HowtoPowerBI 2 жыл бұрын

Thanks!

@abdulrahmanalnajjar1496 2 жыл бұрын

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

@HowtoPowerBI 2 жыл бұрын

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

@TerrorPeanut 2 жыл бұрын

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!

@MahrukhTariq___ 3 ай бұрын

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 ?

@tariqkhan9441 3 ай бұрын

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?

@tofikqureshi6507 2 жыл бұрын

Nice 👍👌

@HowtoPowerBI 2 жыл бұрын

Thx tofik!

@gagansingh3481 2 жыл бұрын

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

@HowtoPowerBI 2 жыл бұрын

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

@AkshayKumar-vd5wn 2 жыл бұрын

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

@HowtoPowerBI 2 жыл бұрын

Hahah yes my name is Bas :) super Dutch!

@RajuGowtham518 Жыл бұрын

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

@hagduinithronel5160 Жыл бұрын

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?

@alterchannel2501 9 ай бұрын

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

@HowtoPowerBI 9 ай бұрын

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

@alterchannel2501 9 ай бұрын

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

@toukirrahman3574 11 ай бұрын

Where can I get this excel file for practice?

@ibrahimrahman3320 Жыл бұрын

Please how doi get data files used in this Tutorial ?

@anguswalker7003 4 ай бұрын

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

@HowtoPowerBI 4 ай бұрын

See link in the description

@anguswalker7003 4 ай бұрын

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

@dullestower8773 10 ай бұрын

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 10 ай бұрын

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

@lucasnilsson2952 7 ай бұрын

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 7 ай бұрын

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 kzfaq.info/get/bejne/oad9m8tonJy6aKs.html

@lilaandari0503 2 жыл бұрын

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

@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 Жыл бұрын

kzfaq.info/get/bejne/ntObabOpqdrGfqc.html 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