How to Transform Excel Data into a Striking Visual Report with Microsoft Power BI

Welcome to this beginner's tutorial on how to use Microsoft Power BI! In this video, I will guide you through importing data from an Excel workbook into Power BI. Power BI is a powerful data visualization tool that allows you to easily create stunning, interactive reports.

First, I will walk you through how to import your Excel workbook into Power BI. We will show you how to connect to your workbook, select the data you want to import and bring it into Power BI. Once you have your data in Power BI, we will then demonstrate how to create visually appealing and interactive reports. I'll explore the different visualization options available in Power BI, including tables, charts, and graphs, and show you how to customize them to fit your needs.

I will also cover some of the essential features in Power BI, such as filtering, grouping, and sorting your data. I'll explain how to create relationships between different tables in your data, which is crucial to building accurate and useful reports.

By the end of this tutorial, you'll have a solid understanding of how to use Power BI and create reports that are visually impressive and provide valuable insights into your data. So if you're new to Power BI or just want to brush up on your skills, this tutorial is for you!

0:00 Introduction to Power BI
1:06 Get data into Power BI
2:25 Transform data
3:01 Making changes to columns in Power BI
6:30 Examining the fields in Power BI
7:00 New Measure - Write Dax Expression - Total Units Sold = SUM(financials[Units Sold])
9:10 New Table - Write Dax Expression - Calendar = CALENDAR(DATE(2020,01,01),Date(2021,12,31))
10:10 Create a relationship between two tables in Power BI
11:22 Add a title in a text box in Power BI
12:27 Add visual first visual, modify it to a line chart
14:32 Add a map chart in Power BI
16:17 Add a column chart
17:24 Filter data more by adding a slicer visual in Power BI
19:10 Customizing your report. Making it look fantastic!
27:57 Changing themes in Power BI
28:37 Sharing your Power BI report with others

Copy and paste these expressions:
Total Units Sold = SUM(financials[Units Sold])
Calendar = CALENDAR(DATE(2020,01,01),Date(2021,12,31))

[SparklesMcFartyPants]

Fantastic video! Your explanations are very clear, moreso than other videos I've watched on the same topic. Thank you very much!

[RakeshKumar-kbyu]

Great thanks.. I was struggling to calculate the data but was unable to do it earlier but now I understand we should measure the columns first..

[derickokwa]

Great tutorial learnt some new concept. Please Sir, can you help with a video tutorial on Data Validation in Power Bi. Thanks a lot.

[janardhannarayana]

Excellent tutorial.
Good for beginners who wants to visual excel data.

[nscqbbc]

Fantastic video. I have been teaching myself and clips like this really help. Thank you

[karenintriagoc]

Thank you! Thank you! Thank you! Great tutorial!

[techdrift]

This is a great teaching video. Would you consider doing a video using student academic results as the datasource. Maybe track these results for each semester and do a comparison?

[jacoojacoo]

Thank you informative, i did the exercise with you. When i entered the slicer on your data i also have "blanks". I checked in the transform data file, but can not see any blanks.

[ashrafallam]

Thanks for this great video.
I have a couple questions Please help me with them
1- Can I make a measure depending on the value of a numerical cell such as greater than 60 say
2- If I can do this can I use that measure for differenr columns.
3- In every Power BI video I watched the explain the sum function but we teachers need to use the count functions.
To clearify my questions I'm a teacher I want to use Power BI to vasualise the class grade book which has different subject
For different exams.
You help is always appreciated.

[StopWhining]

Format Painter can be used in Power BI.

[jacoojacoo]

Looking at you data file, what do you consider as very important tips to keep in mind.

[RakeshKumar-kbyu]

Also, I need help to publish user wise information (not in summary but at line level) data, so anybody can export the data to see the information. Please help

[gator]

Why is power BI automatically sorting my data alphabetically. I want my power bi report to look exactly like the backend excel file that is feeding into it. Any advice?

[tanweerabbasabbas]

Why we need a new measure for units sold. Its already there¿!!!

[potc]

Phone tab need biggest visual s at about an to hv demonnstrate about all SIR;

[SkillSage_Pathways]

Shit. That's too complicated and time consuming. Other channels explain everything in 15 minutes.