Skip to content

AnalystHub-Hub/Household-Expense-Analysis-With-Microsoft-Excel

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

7 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Household-Expense-Analysis-With-Microsoft-Excel

Follow link to have a glance at the complete project Read More

Logo

Objective 🕮

In this project, I Prepared, cleaned, Analyzed and Visualized Household Expenses to Identify how much money is spent on daily activities and feeding using microsoft excel.

I will answer:

  • How much household heads makes and what percentage is used in various expenses
  • What household Item/product takes the most expenditure.
  • Categorizing household heads by gender, age, marital status with respect to expenditure.
  • Identifying property distribution between homes relative to cost of maintenance.

Microsoft Excel Tools used in project

  • DAX
  • Power Query
  • Power Pivot
  • Pivot Table and Chart