Gather data from different departments.
Put the data in a format that is easy to read.
Analyse the data from the point of view of the briefing that has been provided vis a vis the goals of the analysis.
Present data to the management in the language that they understand.
Prepare monthly reports on sales inventory market share etc.
Requirements
- Strong proficiency in Microsoft Excel with efficiency in understanding Macros and other tools.
- Strong proficiency in handling multiple projects and multiple tools when it comes to data handling.
- Strong proficiency in handling vast amounts of data.
- Ability to clean data especially when it comes in multiple formats.
- Experience in live projects that have been in place for at least one year.
- Familiarity with Tableau and Power BI.
- Knowledge of machine learning libraries like Pandas etc will be huge plus.
- Strong ability to develop mini dashboards for the management as per their requirements.
- Strong clarity of thought when it comes to determining what the final output needs to look like.
- Ability to understand excel sheets that are prepared by other department members.
- Ability to deduce what is wrong in an excel sheet.
Sales & marketing
Education
Marketing