Power BI tutorial for beginners - 2022 - Step by step

#powerbi #tutorial #efficiency365
Learn Power BI in one hour. No prior knowledge of Power BI is required. We cover sign-up, installation, data import, data clean up, report creation, sharing and more.
Step-by-step authoritative explanation by Dr Nitin Paranjape - Microsoft MVP since 18 years.
Download files and follow step by step.
efficiency365.com/wp-content/...
This zip file contains three files:
1. Location Master.xlsx
2. Simple Txn 2022.csv
3. Demo1.pbix (completed Power BI Report)
Contents
---------------
00:00 - Introduction
00:34 - Sign in and Install Power BI
03:44 - Power BI Desktop Menus
04:20 - View all Data Sources
05:14 - Import Transactions CSV
06:02 - Clean up transaction file
09:49 - Import Location data from Excel file
13:01 - Create relationship between tables
14:31 - Field List
15:07 - Hide unwanted columns
16:23 - Shaping data
16:56 - Set Data Categories
18:59 - Set default summarization
20:27 - Save file as PBIX
20:50 - Report tab Menus and Panes
21:42 - Date Hierarchy
22:21 - Create a visual
23:44 - Create card visual to show total amount
26:48 - Add Transaction Count card
27:47 - Create Pie chart
30:16 - Create Column Chart
31:42 - Add Data Labels
32:09 - Create a Map
35:26 - Cross Filtering
37:08 - Map Auto Zoom
37:33 - Rectangle selection in map
38:58 - Add a slicer
40:59 - Using Bookmarks for storytelling
43:54 - Sharing Power BI reports
44:50 - Publish to Power BI portal
45:58 - Share report from Power BI portal
49:12 - Sharing the dataset with others
50:24 - Use Power BI dataset inside Excel
51:41 - Refreshing the data and report
51:58 - Summary
Buy Dr Nitin's latest book
-----------------------------------------
Efficiency Best Practices for Microsoft 365
130 best practices everyone must know
Work Smarter, Grow Faster
s.efficiency365.com/bk
Dr Nitin Paranjape is the pioneer in maximizing work efficiency in a modern work scenario.
Dr Nitin's Office Masterclass
----------------------------------------------
hi.switchy.io/mms
Udemy Courses by Dr Nitin Paranjape
--------------------------------------------------------------
Pivot Table Advanced - hi.switchy.io/22B1
Excel to Power BI - swiy.io/pivotsh
Learn more from 1000+ blog articles by Dr Nitin Paranjape
Efficiency 365 blog: efficiency365.com/blog
LinkedIn : / nitinparanjape
Twitter : / drnitinp
Production
--------------------
Music and Effects: elements.envato.com/
Created using Camtasia: www.techsmith.com/video-editor
AI based captions: videoindexer.ai (Microsoft service)

[@jkumar8590]

We need a dedicated wholesome video on Dax and time intelligence functions

[@user-ox4zj8xx7o]

For a beginner this video really going to be very helpful, such a simple and good way of teaching. Thank you Sir...

[@efficiency365]

Thanks @user-ox4zj8xx7o. Check out my other best practices videos as well. Efficient Tasks Management - kzbin.info/www/bejne/rH2poYqMm7qZh5o Microsoft Teams - 15 Best Practices - kzbin.info/www/bejne/jWm4l6uVr9N-rqs Smart and Effective Email - 5 powerful ways - kzbin.info/www/bejne/bH-od4aDpq2ah6c Outlook Calendar Best Practices : Part 1 - kzbin.info/www/bejne/favWgqGbmM90h9E and Part 2 - kzbin.info/www/bejne/ppLHfHturthoedU OneNote - Best Practices - kzbin.info/www/bejne/o16XcoxnmLKcbtU Microsoft 365 Best Practices - kzbin.info/www/bejne/oYemkIyZgZqCmLc Word Tables Best Practices - The ultimate guide - kzbin.info/www/bejne/q5audHuug7qCoaM Cheers. Doc.

[@rai2032]

Excellent and enjoyed a lot with the tutorial ...

[@efficiency365]

Thanks @shivdevrai5256. Check out my other best practices videos as well. Efficient Tasks Management - kzbin.info/www/bejne/rH2poYqMm7qZh5o Microsoft Teams - 15 Best Practices - kzbin.info/www/bejne/jWm4l6uVr9N-rqs Smart and Effective Email - 5 powerful ways - kzbin.info/www/bejne/bH-od4aDpq2ah6c Outlook Calendar Best Practices : Part 1 - kzbin.info/www/bejne/favWgqGbmM90h9E and Part 2 - kzbin.info/www/bejne/ppLHfHturthoedU OneNote - Best Practices - kzbin.info/www/bejne/o16XcoxnmLKcbtU Microsoft 365 Best Practices - kzbin.info/www/bejne/oYemkIyZgZqCmLc Word Tables Best Practices - The ultimate guide - kzbin.info/www/bejne/q5audHuug7qCoaM Cheers. Doc.

[@jessykiriyanthan2597]

Your video helped me a lot. Thank you very much for making the start look so easy. Please keep posting..

[@efficiency365]

Thanks Jessy Kiriyanthan for the feedback. Explore more Excel, Power BI and Analytics videos on this channel kzbin.info/aero/PL-UPeBWRvha2O2TF6vfVw4lfS4honS407 Check out my online courses Excel to Power BI s.efficiency365.com/upbi Pivot Tables s.efficiency365.com/mtyt Learn 130 essential efficiency best practices - read my latest book - s.efficiency365.com/bk Let me know if you want me to cover any specific topics as well. Cheers. Dr Nitin (doc) Paranjape.

[@shamsshams9762]

Great explanation, thanks

[@efficiency365]

Thanks for your feedback. Do explore my blog at efficiency365.com/blog Check out my My Udemy courses Excel to Power BI s.efficiency365.com/upbi Pivot Tables s.efficiency365.com/upt Learn 130 powerful efficiency best practices across Office 365 - read my latest book - s.efficiency365.com/bk Also let me know if you would like me to cover any topics relevant to you. Cheers. Dr Nitin (doc) Paranjape.

[@jkumar8590]

Extraordinary. I became addict to your videos. Pl design a course with an end to end project, as no comprehensive, quality and affordable course available on earth. Kudos to Doc

[@efficiency365]

Thanks. Check out my Udemy course Excel to Power BI s.efficiency365.com/upbi

[@jkumar8590]

Thank you doc for instant reply

[@shwetkumar1719]

Thank you very much sir for this simple and very helpful video really loved the way you teach

[@efficiency365]

Thanks Shwet Kumar. More coming soon.

[@shwetkumar1719]

@@efficiency365 Sir I have a question when we share the dataset that you show in the last part of the video with the end users or any organization people can use the same data set to create the report accordingly. But for that, we need to have the id of the same domain? also, can I share that data set with any other people, and how? I mean that I want to share that with my friend then how can we do that? Is it possible to share with my friend or it works only with-in organizational people?

[@shwetkumar1719]

Sir is this can be done when I give access to anyone as Member/contributor then it is possible? and give them an account with the same domain?

[@vinodkrishna8295]

Nice video Sir, would like to learn power query and power bi bit more in detail, do you have course available on-line.

[@efficiency365]

Thanks This is the Udemy course. Excel to Power BI hi.switchy.io/uxlpbi See the data clean up playlist for Power Query hi.switchy.io/fyidc

[@chandrakantha648]

Hi Sir, my data has a date column with different data DDMMYYYY and MMDDYYYY etc can this be rectified in power query ?

[@efficiency365]

If it is a one-time task: select the data column Data tab > Data Tools group > Text to column command > (accept default) Next button > (accept default) Next button > Select "Date" radio button and "DMY" from date format drop down OK Data is now in date format, apply formatting to display as you need If you need to use PowerQuery: Import data into PowerQuery. Select the DDMMYYYY column Add Column menu (tab) - Colum From Examples - Selected Columns Type few dates based upon your data in the format 2020-06-14. It will display "ghosts" of it's best guesses. Once they look ok, hit enter and it will convert the data to Date format. Confirm that the conversion is correct. Delete the source column. If you want to know the exact syntax, look at the formula generated by Column by Example and learn the functions.

[@jkumar8590]

Doc pl consider a tutorial on time intelligence function with dax

[@efficiency365]

Thanks. Working on it. Just published a video on daily opening and closing balances. Have a look. kzbin.info/www/bejne/foizkqR9gK6NnNk

[@jkumar8590]

@@efficiency365 very very pleasant surprice

[@thebhaskarjoshi]

Please make a video on Power BI Service

[@efficiency365]

Which aspect of Service?workspaces, AI, Dataflows, Sharing, Security, Content packs, Quick Analysis, datamart, Excel integration?

[@thebhaskarjoshi]

@@efficiency365 A Quick Walkthrough like sharing reports, creating apps, managing & sharing workspaces etc. because now many of us know Power BI Desktop but very less no. of people know how to work with Power BI service online that very essential for a power bi user.

[@efficiency365]

Got it. Will work on it. Thanks.

[@azaddeenazom1464]

Resolution is low.plz upgrade it

[@efficiency365]

Thanks. This is a long video (53 minutes). I have started an instant premier. Then I realized that KZbin has not yet finished processing the HD and 4K video yet. That was a mistake. I will keep it in mind next time. In any case, after 1 hour or so, the 4k version will be available on KZbin.

[@easyoffice5016]

No Stream available in KZbin while playing this video.

[@efficiency365]

I don't understand what "stream not available" means. Can you explain pls? Watch this video after another hour or so. The 4K version is still being rendered by KZbin. I have no control over that process.