Hands-On Power BI Tutorial 📊 Beginner to Pro 2023 Edition [Full Course] ⚡

👉 Want more On-Demand Learning? - Start With The FREE Learn With The Nerds Stream Plan: prag.works/lwtn-trial
Class files
✔️ prag.works/202302-LWTN-files
Install Power BI Desktop
✔️ tinyurl.com/33rcb3rn
Download the certificate of completion after you finish this course:
📄 prag.works/202302-LWTN-cert
✔ Event Overview:
This free live event is designed for those who have little experience with Power BI to give a better understanding of how end-to-end solutions can be designed. This course covers how to load data with Power BI Desktop, how to use some basic DAX, and create amazing visualizations on your data. Power BI is an impressive, one -stop reporting and analytical tool. You can connect and shape your data, as well as build reporting solutions that help drive decision making.
What you’ll learn:
✔️ Connect and organize your data
✔️ Create data cleansing processes in Power BI
✔️ Organize your data model
✔️ DAX Basics
✔️ Build Interactive Reports
✔️ Deploy and share your solution
If you enjoy this Learn With the Nerds and are interested in formal training on DAX, Power BI, Power Apps, Azure, or other Microsoft products you can use the code "Devin30" to get an extra 30% off at check out when purchasing our On-Demand Learning classes from pragmaticworks.com/pricing/
Other Resources:
Data Source for session
✔️ www.fdic.gov/bank/individual/...
Data Modeling for Power BI by Mitchell Pearson
✔️ • Data Modeling for Powe...
Data Modeling (Star Schema) in Power BI by Manuel Quintana
✔️ • Data Modeling (Star Sc...
Power BI Administration by Manuel Quintana
✔️ kzread.infoQCdAI0XSaZ8
DAX by Mitchell Pearson
✔️ • 👉Beginner Power BI DAX...
Additional Resources on FORMAT Function
✔️learn.microsoft.com/en-us/dax...
Date Dimension
✔️ devinknightsql.com/2015/06/16...
DAX Guide
✔️ dax.guide/
DAX code used in this session:
Calendar = CALENDARAUTO()
Year = YEAR([Date])
Month Number = MONTH([Date])
Month = FORMAT([Date], "mmmm")
Total Banks = COUNTROWS('Failed Banks')
00:00:00 Introduction
00:08:52 Phases of a Power BI Project
00:20:30 Transforming the Data - Power Query
01:05:30 Building a Data Model
01:16:29 DAX Basics
01:51:47 Creating Relationships
02:15:13 Data Visualizations
02:56:53 Publishing the Report
Next event:
Data Storytelling with Power BI - Lunch with Nerds with Allison Gonzalez
✔️ prag.works/data-storytelling-...
-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
Next step on your journey:
👉 On-Demand Learning - Start With The FREE Community Plan: tinyurl.com/2ujujsb5
🔗Pragmatic Works On-Demand Learning Packages: pragmaticworks.com/pricing/
🔗Pragmatic Works Boot Camps: pragmaticworks.com/boot-camps/
🔗Pragmatic Works Hackathons: pragmaticworks.com/private-tr...
🔗Pragmatic Works Virtual Mentoring: pragmaticworks.com/virtual-me...
🔗Pragmatic Works Enterprise Private Training: pragmaticworks.com/private-tr...
🔗Pragmatic Works Blog: blog.pragmaticworks.com/

Let's connect:
✔️Twitter: / pragmaticworks
✔️Facebook: / pragmaticworks
✔️Instagram: / pragmatic.works
✔️LinkedIn: / pragmaticworks
✔️KZread: / pragmaticworks

Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: (904) 638-5743
Email: training@pragmaticworks.com
#PowerBI #DAX #PragmaticWorks #DevinKnight #Training #Microsoft#Tech #FreeConference #LearnWithTheNerds
**Any sales mentioned in the video may no longer be valid. Offers are subject to change with/without notice and are for a limited time only.

Пікірлер: 413

  • @PragmaticWorks
    @PragmaticWorks Жыл бұрын

    👉 Important files: ◉ Download student files - prag.works/202302-LWTN-files ◉ Certificate of Completion - prag.works/202302-LWTN-cert

  • @chalsesikombe692

    @chalsesikombe692

    Жыл бұрын

    Very good

  • @reinventten9599

    @reinventten9599

    9 ай бұрын

    2:20:06 saved

  • @ceooflonelinessinc.267

    @ceooflonelinessinc.267

    9 ай бұрын

    Thank you for this lesson!!!

  • @adekunlemercy7631

    @adekunlemercy7631

    8 ай бұрын

    thanks

  • @TruMe2

    @TruMe2

    7 ай бұрын

    Saved....Thank you! Can't wait to finish

  • @TheNehaSahoo
    @TheNehaSahoo9 ай бұрын

    Okay so I've just seen 28 minutes of this video and i couldn't resist myself from posting this comment. I had to stop the video and drop this comment. The level of patience this guy has... OH MY GOODNESS. I have never seen a yt tutorial to be this slow and clear and spoon fed. I mean whatttttttt.... I am seeing this video on 2x but still this is soooooo clear. Thank you so much for this video. Thank you ❤

  • @desktopdatacrunching4032

    @desktopdatacrunching4032

    9 ай бұрын

    Thank you for the kind words!

  • @wakzyon

    @wakzyon

    28 күн бұрын

    I write a lot of Runbooks, my rule of thumb is treat everyone like a noob, spoon feeding does get irritating if you have done this for a while and bashed your head against your keyboard long enough that the "F" and "J" indents are permanently imprinted on your forehead. to Learn the topic and then someone tells you something that you "Think" is common knowledge. I prefer his approach, it covers everything and what is 3 hours compared to 300+ hours learning it the hard way, sometimes looking at the combo list is better than figuring it out, especially if you have a 4 hour SLA.

  • @Marseaplage

    @Marseaplage

    13 күн бұрын

    For me as non-english speaker is really easy to understand him, thank you so much for sharing your knowledge 🤗🤗

  • @saktibiswal6445
    @saktibiswal64459 ай бұрын

    Thanks for the awesome initial explanation. 19:30 - 4 phases of reporting in Power BI. 1:17:50 - Creating a date table using DAX. 1:33:00 - FORMAT function in DAX. Ends at 1:33:43. 1:52:00 - Creating relationships between datasets. 1:56:25 - One to many relationship data model. 2:00:15 - Fix the sort order(of column Month) of the visual. 2:03:07 - Fix the sort order in Data Model. 2:07:09 - Calculated Columns & Measures. The last punch tip was awesome.

  • @olayomiadams7556
    @olayomiadams7556Ай бұрын

    This instructor is a definition of a born teacher! I have never felt so addicted to learning a complex tool. You made this lesson so simple to follow and understand, you're the best!!!This is very rich content you have on here! Keep it up!!!

  • @sreeramch
    @sreeramch6 ай бұрын

    Love the way you go in-depth explaining each and every component. This is one of the best course I found on youtube. Thank You Devin

  • @qww760
    @qww760 Жыл бұрын

    I am halfway through and can't believe high-quality content like this is free. I will be watching a ton of videos from your channel for sure.

  • @YourGirlPratiksha
    @YourGirlPratiksha Жыл бұрын

    omg i love how he is explaining from the scratch. literally not skipping a single thing. love this tutorial

  • @eugenemunkasu7990
    @eugenemunkasu79909 ай бұрын

    Just wanted say a heartfelt "thank you" for this course🙏🏾. As of a week ago, I didn't even know of Power BI but I now have a decent amount of knowledge to start with and build on - definitely a great and powerful software..and the delivery of the course, sublime👌🏽. Will be sure to watch all the videos in the provided links to learn even more. In addition, the certificate is such a wonderful bonus, you're most kind. Thanks again😊

  • @Elbranto1
    @Elbranto1 Жыл бұрын

    Thank you so much for this session, looking forward to seeing more

  • @johnharville8007
    @johnharville8007 Жыл бұрын

    Absolutely fantastic training....thank you so much. Your technique is superb, you speak very clearly, and I love how you use the ZoomIt tool to zoom in/out and otherwise highlight and attribute the things on your screen that you want to call attention to. Well done sir, thanks again.

  • @mrlutton
    @mrlutton7 ай бұрын

    As someone who used to teach Tableau every day, I can say with confidence that you are one of the very best software instructors I have seen or found on KZread. Thank you for the great work!

  • @kpakpomoevi1603

    @kpakpomoevi1603

    7 ай бұрын

    Do you know which software he used to highlight word in Red

  • @PragmaticWorks

    @PragmaticWorks

    6 ай бұрын

    It's called Zoomit@@kpakpomoevi1603

  • @francisabu6463

    @francisabu6463

    5 ай бұрын

    Mr Luton.. Do you recommend any tableau certificates?

  • @hari_madh

    @hari_madh

    Ай бұрын

    Where can I learn tableau better @mrlutton?

  • @AdewaleFranklin
    @AdewaleFranklin Жыл бұрын

    Thank you so much for this great work! Just what I needed right now. Thank you again😊👏

  • @lzyong306
    @lzyong3067 ай бұрын

    Best tutorial on the web I can find, will definitely recommend to my coworkers.

  • @martyc5674
    @martyc5674 Жыл бұрын

    Great Video-- I picked up a few bits-- the tooltip @ the end was great 👍👍

  • @thomaswreh1042
    @thomaswreh10427 ай бұрын

    Sincerely this is absolutely amazing, great, and a source of wealth acquired just from clicking! Thanks to the LWTN team!

  • @chenchenfu3948
    @chenchenfu3948 Жыл бұрын

    I like this session. It quickly helps me get a generic look and feel about Power BI as a beginner

  • @003kashif
    @003kashif8 ай бұрын

    Absolutely marvelous lecture...so clear and lucid with so much of patience...

  • @YuddieUganda
    @YuddieUganda21 күн бұрын

    This is one of the best instructors I ever encountered. He makes learning so easy. Thank you

  • @romanababar2875
    @romanababar28755 ай бұрын

    Thank you so much. It's really helpful for an individual like me to gain knowledge from a start point. Its simple, clear and easy to understand. Great work here !!!!

  • @iTechiee
    @iTechiee Жыл бұрын

    Wow what a great instructor. After many years of school this by far has been the best instructor ever.

  • @Nightwing2022
    @Nightwing202216 күн бұрын

    So when I started this course, i was a bit nervous because a part of me felt i wouldnt be able to sit down for three hours🤣 oh well i did and i was hooked and only had to rewind two times. Now excited to take more courses. Thank you

  • @lyanisitti9378
    @lyanisitti93786 ай бұрын

    You are the best, I followed the tutorial like a grade 4 child and I am happy, I can even mentor my colleagues on Power BI. Kudos

  • @jaded.9915
    @jaded.9915 Жыл бұрын

    Amazing session! Great teaching style. I learned so much. Thank you so much. I will follow your channel.

  • @user-nv3xi2rk7p
    @user-nv3xi2rk7p2 ай бұрын

    Wonderful tutorial for a power bi beginner! Explicit, detailed and organized!

  • @user-eh9gh8bd1i
    @user-eh9gh8bd1i Жыл бұрын

    A great introductory course! Thank you, I learned so much :)

  • @MrJensmile1999
    @MrJensmile19992 ай бұрын

    This was greatly needed for me, and I greatly appreciate you taking the time to do this training.

  • @quinphan5672
    @quinphan56724 ай бұрын

    Thank you so much! No one has explained the materials as well as you. I pin you as my favorite now!!!😊 You are knowledge and made it very clear and easy to understand. Please continue to post more tutorials…

  • @krutheekaacharya2251
    @krutheekaacharya22517 күн бұрын

    I am from data background but beginner to Power BI. You are proof that a good teacher is all you need to spark interest in the topic. Thank you for making this session informative and easy to understand.

  • @KenT-oq9nx
    @KenT-oq9nx4 ай бұрын

    Thank you so much for this tutorial. I found this to be a great resource and the instructor did a great job in explaining things. Much appreciated!

  • @shilpiverma1728
    @shilpiverma1728 Жыл бұрын

    Thanks for hosting this session, I'm a total newbie and got to learn a lot by this session.

  • @clarose0963
    @clarose096310 ай бұрын

    This is one of the best training courses I have seen on-line. I will look for more from this resource. EXCELLENT!

  • @jilalumustefa2276
    @jilalumustefa2276 Жыл бұрын

    great people and great class thank you guys

  • @saulmukwayo2699
    @saulmukwayo269910 ай бұрын

    Very exciting presentation and as a bigginer,my confidence has improved.Than you so much.Straight to the point coverage of information.

  • @julzanderson05
    @julzanderson05 Жыл бұрын

    What an excellent course! Very well presented and nice pace! Ty!!

  • @song7684
    @song768411 ай бұрын

    Thank you so much! Thanks to you, now I know how I can utilize this useful tool in a right way!

  • @qww760
    @qww760 Жыл бұрын

    Thank you! I am excited to finally learn about this :)

  • @Caiofernando-wd9vh
    @Caiofernando-wd9vh Жыл бұрын

    É disto que eu estava precisando, grata !!!

  • @sonjaboes3138
    @sonjaboes313811 ай бұрын

    Thank you for this great video and your clear explanation, even for me learning this for the first time!

  • @simmissim5736
    @simmissim57367 ай бұрын

    This was super easy to work with and extraordinary well explained!

  • @itzboyon6983
    @itzboyon6983Ай бұрын

    I just finished the first hour of this tutorial. So far I am really enjoying your presentation and teaching style.

  • @nielsdevries9175
    @nielsdevries91753 ай бұрын

    Amazing tutorial, love how you explain every little step and option!

  • @sahilvinaysahni
    @sahilvinaysahni9 ай бұрын

    That's a great approach. Instead of just focussing on visualization, he has explained background workings of data transformation and model view. Answered many questions that took me months and months to figure out.

  • @kpakpomoevi1603

    @kpakpomoevi1603

    7 ай бұрын

    Do you know which software he used to highlight word in Red

  • @rcasturi55
    @rcasturi557 ай бұрын

    You are a great teacher Devin. Thanks .

  • @qww760
    @qww760 Жыл бұрын

    You are an excellent instructor!

  • @mnemmy9
    @mnemmy92 ай бұрын

    Phenomenal session, thank you so much for being so generous with your knowledge!

  • @ahmedkamiss7643
    @ahmedkamiss7643Күн бұрын

    Absolutely fantastic tutorial, thank you! If you are stuck in Windows 2000 and are too lazy to move on but have no choice, this is highly recommended!

  • @preciousgabriel7003
    @preciousgabriel70035 ай бұрын

    It was really a great experience following you all through this PBI course, thank you.

  • @amalia940
    @amalia9405 ай бұрын

    this was so great, such relaxed learning...and really learning! thank you very much, one of the best learning sessions ever

  • @giannipiccirillo8130
    @giannipiccirillo81302 ай бұрын

    Thank you so much Mr. Knight for this useful lesson!

  • @jingyiwang5113
    @jingyiwang51132 ай бұрын

    I really need Power BI skills when doing my job. This video is really helpful!

  • @lisahudson4368
    @lisahudson43685 ай бұрын

    Thank you for this training. I really learnt a lot, and will be looking at other videos to learn additional skills.

  • @olgademenina8096
    @olgademenina8096 Жыл бұрын

    Thank you very much, it's amazing presentation!

  • @rofo7704
    @rofo7704 Жыл бұрын

    What a data source selection. Following this through a month later and we have some fresh data at the top of FDIC failed banks! Good thing we connected to it via the web so when the source added its first new row in 3 years our reports live updated to match. ;)

  • @YourGirlPratiksha

    @YourGirlPratiksha

    Жыл бұрын

    woah!!!!

  • @jordantoups3248
    @jordantoups3248Ай бұрын

    very helpful course. thank you much. i will be checking out the 3-hour data modeling course for power bi you mentioned in the video.

  • @chrissunny1073
    @chrissunny10739 күн бұрын

    You have made a complex equation simple. Thanks for your availability

  • @dihanperera77
    @dihanperera773 ай бұрын

    Amazing step by step video, really appreciate it. I actually learnt a lot 👍🏾

  • @femi3896
    @femi38968 ай бұрын

    Amazing tutorial. Thank you!

  • @ehteerk
    @ehteerk9 ай бұрын

    2:5:16 i was able to do this also by dragging the month number column into x axis along with month . then sort in asending order

  • @vandanpandya9587
    @vandanpandya95874 ай бұрын

    Thank you for the intuitive power BI video!

  • @TheInbetweenTarot
    @TheInbetweenTarot5 ай бұрын

    This was excellent! Thank you so much from Manchester, UK 🙏🏻

  • @saajisebastian1611
    @saajisebastian16112 ай бұрын

    Excellent Tutorial ..!! Thanks for the detailed explanation ...helped tremendously

  • @arntimo
    @arntimo Жыл бұрын

    Thank you very much for this helpfull course!

  • @rogerfleming3165
    @rogerfleming3165 Жыл бұрын

    Excellent introduction to Power BI.

  • @sobankhalid8307
    @sobankhalid83079 күн бұрын

    Man , Im in love with this guy's teaching. What a session. Even at 2x, I didnt miss a single thing.

  • @darylvincent7058
    @darylvincent7058 Жыл бұрын

    fantastic course - great teacher

  • @stev8686
    @stev86867 ай бұрын

    Simply wonderful, much love!

  • @Adventurous_Choice
    @Adventurous_Choice Жыл бұрын

    Thanks for this. It was worth 3hrs of my time!

  • @user-rb5ni7od7l
    @user-rb5ni7od7l Жыл бұрын

    Absoluately loved this Tutorial and will continue to watch others from Pragmatic Works! Way to go to the entire team!

  • @claytontherrien7583
    @claytontherrien75837 ай бұрын

    Excellent lesson. Easy win! Thank you!

  • @a.achirou6547
    @a.achirou6547 Жыл бұрын

    Waou !! You are an amazing trainer with outstanding teaching skills. Thank you for your effort and putting together this session.

  • @omenukorchibuike
    @omenukorchibuike11 ай бұрын

    Awesome Tutorial! Really insightful!

  • @j.a.gersalia3802
    @j.a.gersalia38029 ай бұрын

    Wow! A great training. Thank you.

  • @hokagejiraiya1
    @hokagejiraiya12 ай бұрын

    the best tutorial of PBI ever. very granular approach Kudos🐐

  • @lawalgabriel1174
    @lawalgabriel117410 ай бұрын

    This training is packed with Knowledge and simplicity for better understanding. Thank you for making it a great experience

  • @user-zx3xg5jp1o
    @user-zx3xg5jp1o9 ай бұрын

    A great introductory course! Thank you, I learned so much :). A great introductory course! Thank you, I learned so much :).

  • @timweldon8820
    @timweldon88209 ай бұрын

    Great Introductory Course i learn a lot, thank you.

  • @DanielFerreira596
    @DanielFerreira596Ай бұрын

    With markets tumbling, inflation soaring, the Fed imposing large interest-rate hike, while treasury yields are rising rapidly-which means more red ink for portfolios this quarter. How can I profit from the current volatile market, I'm still at a crossroads deciding if to liquidate my $125k bond/stocck portfolio

  • @Erickruiz562

    @Erickruiz562

    Ай бұрын

    For the average citizen, the tactics are rather demanding. In actuality, most of them are effectively completed by experts who possess the necessary knowledge and skill set to carry out such occupations.

  • @JanineJ.Cromwell

    @JanineJ.Cromwell

    Ай бұрын

    Yes, I've been in constant touch with a Financial Analyst for approximately 8 months. You know, these days it's really easy to buy into trending stocks, but the task is determining when to sell or keep. That's where my manager comes in, to help me with entry and exit points in the industries I'm engaged in. Can’t say I regret it, I’m 40% up in profits just in 5months with my initial capital of $160k.

  • @BeverleeR.Ziegler

    @BeverleeR.Ziegler

    Ай бұрын

    Although my knowledge of the business is limited, it seems that this is the ideal time to enter the market based on my understanding of supply and demand in the economy. The consistent price variations, which shouldn't be an issue, are the only thing stopping me. But I really need a counselor; could you please assist me?

  • @JanineJ.Cromwell

    @JanineJ.Cromwell

    Ай бұрын

    @@BeverleeR.Ziegler I work with Alicia Ann Jordan, who is a licensed fiduciary. Just look up the name. All the information you need to work with a letter to set up an appointment is included.

  • @SofiaAraujo_--0

    @SofiaAraujo_--0

    Ай бұрын

    Thank you! I checked out Alicia Ann Jordan's credentials on her website and it seems quite good! Hopefully, she's taking in fresh applicants because I sent her an email.

  • @joesutach1381
    @joesutach13819 ай бұрын

    One of the best course easy to understand and beneficial in each tools comprehensively

  • @duonghuyen4725
    @duonghuyen47253 ай бұрын

    Thank you! Very much appreciated.

  • @OmarFaruk-wi9vo
    @OmarFaruk-wi9vo11 ай бұрын

    It's super. when you have small time to recape BI then it's guide you like a private tutor.

  • @AJ-et3vf
    @AJ-et3vf Жыл бұрын

    Awesome video! Thank you!

  • @Dongnanjie
    @Dongnanjie13 күн бұрын

    Thank you sir. This is such a great lesson on power bi.

  • @shiwinstudioproduction1658
    @shiwinstudioproduction16585 ай бұрын

    Thank You. Very simple to learn this.

  • @mohamadebrahimi4486
    @mohamadebrahimi44863 ай бұрын

    Thanks for the to the point tutorial.

  • @amrhassan8137
    @amrhassan81375 ай бұрын

    Very nice tutorial on PowerBi, clear and easy explanation. Thanks Devin

  • @shanthiiyanperumal1694
    @shanthiiyanperumal1694Ай бұрын

    Amazing tutorial! Very informative and easy to learn. Thanks for your patience and knowledge 🌟✨

  • @davebatuli5261
    @davebatuli52619 ай бұрын

    Good day, very insightful course. I would please like to know what software do you use to highlight keys areas on the screen and even add notes for us to screenshots. That would really be helpful for me to know.

  • @masaudamin6699
    @masaudamin66997 ай бұрын

    Briliantly explaination. Thank you!

  • @UsuallyUnique
    @UsuallyUnique3 ай бұрын

    Thank you very much for this excellent and engaging tutorial.

  • @user-up6wd6em5u
    @user-up6wd6em5u Жыл бұрын

    THANKS A LOOOOOOT! I have taught myself all about DA online. Your 3 hour Power BI tutorial is really helpful for beginners. your explanations were insightful, easy to understand and gave me the courage to continue exploring this powerful software

  • @user-dl5by2lq5w
    @user-dl5by2lq5w3 ай бұрын

    Great starting video. Thanks!

  • @ehteerk
    @ehteerk9 ай бұрын

    50:45 for editing the M query produced by AI to create a new column using from-> Add Column -> Column For Example -> From ALL and customised column

  • @albertenbe1663
    @albertenbe16638 ай бұрын

    Thank you. Its very helpful

  • @jedediahlewis
    @jedediahlewis9 ай бұрын

    These tutorials are fantastic. If you ever want to expand your content I'd also love to see Devin do voiceovers of Tobias Funke in Arrested Development and other David Cross roles. Just one subscriber's opinion but Pragmatic might want to test the market, seems like there's real potential there.

  • @etraxiz

    @etraxiz

    8 ай бұрын

    Now all I can think about throughout this tutorial is Never Nudes, thanks a lot!

  • @user-ou7dq1bu9v
    @user-ou7dq1bu9vАй бұрын

    Thanks for sharing this knowledge. Your contents are amazing 🚀

  • @azikejuliet5666
    @azikejuliet566611 күн бұрын

    Thank you so much Sir. Well taught.

  • @thomaswreh1042
    @thomaswreh10427 ай бұрын

    Absolutely meaningful, a beginner's course that's a mighty stepping stone.

  • @user-wk5rn4fz2h
    @user-wk5rn4fz2h3 ай бұрын

    you are a great teacher sir, respect and u ll see me keep coming to your videos more often now

  • @hamzehmahmod9706
    @hamzehmahmod970611 ай бұрын

    Hello Daven, great video.. I have a technical question if you don't mind me annoying you... is there a way to connect the video's progression (Frame or which second it is at) with my data? For example.. lets say the report is about a building being constructed from start till finish, and in power bi I have a chart of dates (X) and completion % (Y) that mirrors that... then I have a video simulation of the building being built, and I want to connect the progression of the video with the progression of the chart somehow.. Can you advise me on that?

  • @KitLau-ux6re
    @KitLau-ux6re Жыл бұрын

    Great video! Enjoyed every sec