Technical Analyst

• Work with Power BI to develop reports and provide the required data to stakeholders
• Identify key performance indicators (KPIs) with clear objectives and consistently monitor those
• Analysing data and present data through reports that aid decision-making
• Audit of ITIL process
• Create dashboards and interactive visual reports in Power BI using different data sources like Excel, CSV, SSAS model, SharePoint etc.
• Create relationships between data and develop tabular and other multidimensional data models
• Write and modify DAX functions and M code in Power BI
• Create customize charts and custom calculations as per requirements
• Design, develop and deploy business intelligence solutions as per needs
• SQL querying for best results, use of filters and graphs for better understanding of data
• Work with users and team members at all level for performance improvement and suggestions
• Work on report automation using advanced excel function and VBA.

Key Requirements

• Power BI
• Excel, Advanced Excel
• SQL
• ITIL Foundation (Knowledge or certification)

Good to have skills

• VBA