- Understand business requirements from each department.
- Build Power BI dashboards and MIS reports.
- Connect Power BI to Business Central using OData/API/SQL.
- Design KPIs for management.
- Create automated daily, weekly, and monthly reports.
- Develop drill-down dashboards.
- Optimize report performance.
- Manage user security and report access.
- Train users on dashboard usage.
- Work with ERP partner for additional data requirements.
- Suggest improvements in ERP data capture.
Required skill
- Microsoft Power BI Desktop & Power BI Service
- DAX (advanced)
- Power Query (M Language)
- SQL Server / SQL Queries
- Data Modelling (Star Schema)
- Microsoft Business Central database structure
- APIs & OData integration from Business Central
- Excel Power Pivot
- Microsoft Fabric (preferred)
- Azure Data Services (added advantage)