📒 Achieved | This project enabled our client to analyze financial data of a company database. We had raw data of various companies with various financial parameters. The financial data for several years was repeated in the same row. We developed code to organize and transform this data to be stacked for different years in different rows. We enabled viewing and filtering financial summaries by year, product, sector, country etc. Several searches and slicers were given. We also give a year by year comparison for all companies, where the user could filter by the data by slicers, to view comparative analysis of Capex, EBITDA, Salaries, Employees etc. |
