SALES ANALYSIS OF ABC PRIVATE LIMITED
- As a Business Analyst at Company ABC Private Limited, I formatted and cleaned a provided dataset by applying appropriate borders, font size, and alignment, as well as by formatting and changing date values in certain fields.
- I then used Pivot Tables to analyze quantities ordered by country and quarter for 2019, 2020, and 2021, and created categorical representations of the table based on Status, Product Line, and Sales.
- Technologies/concept:
Formatting cells and data using the Formatting toolbar. Cleaning data using various Excel functions such as the Text to Columns feature, Find and Replace function, and the Trim function. Creating Pivot Tables to summarize and analyze data.