Power Apps – Site Maintenance
We developed a Power Apps Site Maintenance system with a SQL Server backend (SharePoint and Excel not great for more than 100 records).
Databases
Analysis Services – MDX
Data cube designed with MDX to consolidate mass financial data for self-service BI.
Operational Reporting – SSRS
SQL Server Reporting Services (SSRS) used with database design to generate suite of PDF reports.
Data Integration – SSIS
Hundreds of thousands of records need controlled loading - implemented with SSIS.