JOB SummaryCollect, clean, and analyze large datasets using Excel and Power BI to identify trends, patterns, and correlations.Proven experience as a Data Analyst with expertise in Excel and Power BI.DUTIES AND RESPONSIBILITIESStrong analytical skills with the ability to interpret complex data sets.Proficiency in data visualization techniques and dashboard creation using Power BI. ( Optional )1. Proficiency in data manipulation: Ability to clean, organize, and manipulate large datasets using functions like VLOOKUP, INDEX-MATCH, CONCATENATE, and TEXT functions.2. Data visualization: Skill in creating visually appealing and informative charts, graphs, and pivot tables to present data insights effectively.3. Statistical analysis: Knowledge of statistical functions such as AVERAGE, STDEV, CORREL, and regression analysis to analyze data trends and relationships.4. Pivot tables: Ability to create and manipulate pivot tables to summarize and analyze data from different perspectives.5. Data modeling: Skill in creating data models and scenarios to perform what-if analysis and forecast future trends.6. Conditional formatting: Ability to apply conditional formatting rules to highlight important data points and trends in the dataset.QualificationsMinimum Qualifications-MS Office Excel-Math’s knowledge.-Analytical thinking skills.-To be thorough and pay attention to detail.-Verbal communication skills.-The ability to think clearly using logic and reasoningPreferred Qualifications-MS Office Power BI.- Statistical visualization.
