Profile: Advanced Excel and Power BI specialist
Experience: 23 years
Salary : 33.6
Roles:
- Extract clean and transform data from various sources using Power Query in Excel and Power BI.
- Perform advanced data analysis using Excel functions like
INDEXMATCH
SUMIFS
and array formulas to generate key insights. - Create automated interactive reports and dashboards in Power BI to track business performance and key metrics.
- Develop and maintain data models in Power BI to create meaningful and actionable reports for business users.
- Build advanced visualizations and dashboards that tell a compelling story and provide insights into business trends.
- Automate manual reporting processes and streamline workflows using Excel macros Power BI templates and scheduled data refreshes.
- Identify opportunities for improving data quality and reporting efficiency across the organization.
Qualification: Bachelors
Advanced excel,Vlookup,Hlookups,Pivot Tables,power query,xlookup,Data Modeling,What-if Analysis