How to transform Excel data into a striking visual report with Microsoft Power BI

Welcome to this beginner's tutorial on using Microsoft Power BI! In this video, I'll walk you through importing data from an Excel workbook to Power BI. Power BI is a powerful data visualization tool that lets you easily create beautiful, interactive reports.

First, I'll walk you through how to import your Excel workbook into Power BI. We'll show you how to connect to your workbook, select the data you want to import, and import it into Power BI. Once you have your data in Power BI, we'll then show you 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 meet your needs.

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

By the end of this tutorial, you will fully understand how to use Power BI and create visually impressive reports that will provide valuable insights into your data. So if you are new to Power BI or simply want to brush up on your skills, this tutorial is for you!

Another Power BI lesson here: https://youtu.be/wM0Vpq5Vu_I

Download Power BI here: https://powerbi.microsoft.com/en-us/desktop/
Download Excel practice data: https://bit.ly/PowerBI_practice_data

00:00 Introduction to Power BI
1:06 Get data in Power BI
2:25 Transform data
3:01 Make changes to columns in Power BI
6:30 p.m. Reviewing fields in Power BI
7:00 a.m. New measurement – Write the Dax expression – Total units sold SUM (financial [Units sold])
9:10 New table – Write a 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 to a text box in Power BI
12:27 Add the first visual, change it to a line chart
14:32 Add a map chart in Power BI
16:17 Add a histogram
17:24 Further filter data by adding a slicer visual in Power BI
7:10 p.m. Customizing your report. Make it fantastic!
27:57 Change theme in Power BI
28:37 Share your Power BI report with others

Copy and paste these expressions:
Total units sold SUM(financial data[Units sold])
Calendar CALENDAR(DATE(2020,01,01),Date(2021,12,31))

Please take the opportunity to connect and share this video with your friends and family if you find it useful.