Excel Reporting Automation using SQL Server
Project Overview
Excel Reporting Automation using SQL Server: a Business Central / NAV implementation and support project delivered by Sumit Shede. Designed SQL queries/views for reporting datasets. Industries: Manufacturing, Retail, Distribution.
My Role & Contributions
- Designed SQL queries/views for reporting datasets
- Built Excel reports using Data → From Connection (live DB connection)
- Automated data refresh for real-time reporting
- Created structured reports for business users (sales, inventory, finance)
- Optimized queries for performance
- Coordinated with users for requirement gathering and validation