Sales Dashboard in Excel and Power BI

Sales Dashboard in Excel and Power BI

We are about to demonstrate to you how to create a fully interactive sales dashboard in Microsoft Excel & Power BI. We will use the same database, and create similar dashboards in Microsoft Excel & Power BI that look almost identical. In general, these are designed to cater to the needs of businesses involved in B2C transactions.

There are a total of 43 minutes and 52 seconds in this YouTube video that demonstrate a complete sales dashboard in Excel that can be created by following these steps:

  1. Dashboard Overview
  2. Datasheets Overview
  3. Prepare Database
  4. Analyze and Prepare Visuals
  5. Design Background
  6. Design Dashboard
  7. Format Visuals

In addition to this, you will learn to change the complete theme of the dashboard by just selecting the standard theme color or the customized one.

There are a total of 16 minutes and 22 seconds in this YouTube video that demonstrate a complete
sales dashboard in Power BI that can be created by following these steps:

  1. Import data to Power BI
  2. Edit Data in Power Query Editor
  3. Create Columns & measures
  4. Create Visuals
  5. Format Dashboard Background
  6. Format Visuals

Common Practice file

Power BI Dashboard Background image

Sales Dashboard in Excel

Sales Dashboard in Power BI

2 comments

    please I need the fdata file for please i need to practice

    You should be a part of a contest for one of the most useful sites on the web. I will highly recommend this website!

Comments are closed.

Shopping cart

0
image/svg+xml

No products in the cart.

Continue Shopping