In this tutorial, I will walk a though, how to import an Excel file to Power BI desktop and how to do a simple analysis with Excel data through Power BI.
Step 1: Install Power BI desktop on your computer: Download
Step 2: Open the Power BI desktop and load the Excel file. Download Sample Excel file.
Step 3: It will load the Excel file, then check the Excel sheet you want to load and press LOAD.
Step 4: Now your Excel sheet loaded to Power BI.
Ex 1: Get Sum of Marks for each Student in a graphical way
1. Drag and drop the 'Names' column to the working area
2. Drag and drop the 'Marks' column to the working area (inside the names box)
3. Select 'Stacked Column' option and you'll be getting following nice output
4. Now sort the marks
5. Go to 'Format', Select data labels ON
6. Here's your output
Hope you enjoy the tutorial.
Step 1: Install Power BI desktop on your computer: Download
Step 2: Open the Power BI desktop and load the Excel file. Download Sample Excel file.
Step 3: It will load the Excel file, then check the Excel sheet you want to load and press LOAD.
Step 4: Now your Excel sheet loaded to Power BI.
Ex 1: Get Sum of Marks for each Student in a graphical way
1. Drag and drop the 'Names' column to the working area
2. Drag and drop the 'Marks' column to the working area (inside the names box)
3. Select 'Stacked Column' option and you'll be getting following nice output
4. Now sort the marks
6. Here's your output
Hope you enjoy the tutorial.
I think Power BI is actually a very powerful and useful business analytic tool for solving complex database operations.Its utility with excel operations can also be justified.
ReplyDeletePowerbi Read Rest