analysthub-hub / household-expense-analysis-with-microsoft-excel Goto Github PK

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

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.

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