Responsibilities:
- Develops interactive dashboards in Power BI, creates visualizations for data analysis, and adjusts key metrics (KPIs) and filters
- Works with Power Query in Excel, performs cleaning, transformation and combining of data from various sources
- Integrates reports with SharePoint, sets up automatic data updates and access for the team
- Optimizes relationships between tables, creates relational data models and links them by keys (employee and supplier IDs)
- Automates reporting processes, ensures regular updating and publication of dashboards
- Analyzes business indicators, generates reports for making management decisions based on data from Excel, SharePoint and other sources
- Knowledge of Power BI, Excel