Verified Job
IT / Software / Data Analyst
Power BI DeveloperWFH
IT / Software / Data Analyst
#268242
Remote / WFH
Job Description
Purpose is to understand the business requirement of creating the reporting and dashboard using MS Power BI, VBA and MS Excel.
Skill Set:
1.Excel Part:
Excel Functions (Offset, Indirect, SumProduct, Date &Time functions, Logical Functions, etc.)
Conditional formatting, Data Validation, Pivot Table. Name Manager, Tables, Charts, Combo box and other objects.
2. VBA Part:
Automated Dashboard with good visualization skills,
Loops, User defined functions, Worksheet functions, VBA Events Customize User forms,
Active X object coding, Chart coding, Array, Collections/Dictionary, Add-Ins.
3. Power BI:
Desktop Application- DAX functions, Power Query, Charts Visuals, Data Transformation, Web service, Row Level Security.
Basic knowledge of Python will be the added advantage.
Basic Job Requirements:
1.Good communication skills
2.Minimum 2 to 3 years of experience in similar domain
Skill Set:
1.Excel Part:
Excel Functions (Offset, Indirect, SumProduct, Date &Time functions, Logical Functions, etc.)
Conditional formatting, Data Validation, Pivot Table. Name Manager, Tables, Charts, Combo box and other objects.
2. VBA Part:
Automated Dashboard with good visualization skills,
Loops, User defined functions, Worksheet functions, VBA Events Customize User forms,
Active X object coding, Chart coding, Array, Collections/Dictionary, Add-Ins.
3. Power BI:
Desktop Application- DAX functions, Power Query, Charts Visuals, Data Transformation, Web service, Row Level Security.
Basic knowledge of Python will be the added advantage.
Basic Job Requirements:
1.Good communication skills
2.Minimum 2 to 3 years of experience in similar domain
