Sales Report analysis Using Power BI and Power query

Collect transaction Data from Folder

Collect data from Sheet excel

Merge table’s data

Make measure for total units & Total Revenue & total cost of goods Sold & Total Profit

Get Average daily revenue and Profit

Make Dash Board

Make relations ships between sales rep & Product & transaction