Abhilashayagyaseni/Import-and-transform-data-project

This project is related to data cleaning and transformation

Import-and-transform-data-project

This project contains 'Monthly income and expense data'. In this project 'IMPORT AND TRANSFORM DATA' the data is in '.txt' format and the date is imported and transformed VIA POWER QUERY

• Collected the data 'Monthly income and expense data' in text format
• Creating workbook data connection in excel via power query
• Data cleaning and formatting
• Formatting date column
• Adding conditional formatting
• Creating Pivot table
• Data validation and drop down list
• Using Index and Match Function