| SQL Reporting Services (SSRS) | | https://www.procentrix.com/Lists/Capabilities Master List/DispForm.aspx?ID=20 | SQL Reporting Services (SSRS) | Deliver enterprise Web-enabled reporting solutions that draw content from a variety of data sources. Design reports to be published in various formats and centrally manage security and subscriptions. | | iconItem | 0 | | | |
| PowerPivot Solutions | | https://www.procentrix.com/Lists/Capabilities Master List/DispForm.aspx?ID=25 | PowerPivot Solutions | Implement data analysis solutions that deliver unmatched computational power directly within Microsoft Excel or SharePoint. Solutions can process massive amounts of data in seconds, loading the largest data sets from virtually any source. | | iconItem | 0 | | | |
| Analysis Services (SSAS) | | https://www.procentrix.com/Lists/Capabilities Master List/DispForm.aspx?ID=19 | Analysis Services (SSAS) | Deliver online analytical processing (OLAP) solutions from near real-time Operational Data Stores to Data Warehouse sources. Empower business users to drill-down or drill-through aggregated business measures over multiple dimensions. Enable KPIs (Key Performance Indicator reporting), pattern identification, and trend analysis using specialized data mining algorithms. | | iconItem | 0 | | | |
| Server Integration Services (SSIS) | | https://www.procentrix.com/Lists/Capabilities Master List/DispForm.aspx?ID=18 | Server Integration Services (SSIS) | Plan and implement data integration strategies that utilize SQL Server Integration Services. Design and implement solutions to Extract, Transform, and Load information from disparate applications, databases (e.g., SQL, Oracle), SharePoint sites, or documents in support of your business intelligence/data warehouse efforts. | | iconItem | 0 | | | |
| Installation, Optimization and Administration | | https://www.procentrix.com/Lists/Capabilities Master List/DispForm.aspx?ID=17 | Installation, Optimization and Administration | Align technical designs with business needs to provide the right level of security, performance, failover, and scalability. Interested in Cloud computing? Procentrix can assist you in determining if SQL Azure will provide a more cost-effective data solution over a traditional on-premise infrastructure. | | iconItem | 0 | | | |
| Database Design | | https://www.procentrix.com/Lists/Capabilities Master List/DispForm.aspx?ID=16 | Database Design | Design database schemas and structures, either relational or dimensional, that support your Online Transaction Processing (OLTP) or Online Analytical Processing (OLAP) needs. Whether supporting a single line-of-business application or a large, complex data warehouse, Procentrix can help you design a database that fits your needs. | | iconItem | 0 | | | |