Microsoft SSIS SSAS, and SSRS

Microsoft has products for data integration (SSIS), analytics (SSAS), business intelligence (SSRS), and visualization. These tools can be deployed either stand-alone or as part of a Sharepoint system. They can be fully integrated with the MS Office desktop products such as Excel.

Icon provides Microsoft BI platform services to architect your SQL Server system in a scalable, extendable and secure fashion. We work with business users, subject matter experts and technical staff to identify and articulate requirements, evaluate your data architecture and technical environment and align the software tools with business-user needs for effective information delivery.

We can help your company to get the most out of Microsoft BI solutions including architecture, planning, system design, development, and lifecycle management.

SQL Server Integration Services (SSIS)

Microsoft Integration Services is a platform for building enterprise-level data integration and data transformations solutions. Use Integration Services to solve complex business problems by copying or downloading files, loading data warehouses, cleansing and mining data, and managing SQL Server objects and data.

Integration Services can extract and transform data from a wide variety of sources such as XML data files, flat files, and relational data sources, and then load the data into one or more destinations.

Using SSIS, Icon can help you implement an appropriate information management foundation that can deliver integrated, accurate, and timely data across your organization.

Our consulting services address the following areas using SSIS:

  • Integration of data from multiple, heterogeneous data sources
  • Data cleansing and profiling to improve data quality
  • Master data management
  • Metadata management to ensure data lineage and history
  • Management of information throughout its lifecycle to enhance governance and compliance

SQL Server Analysis Services (SSAS)

Analysis Services is an analytical data engine used in decision support and business analytics. It provides enterprise-grade semantic data models for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.

SSAS provides online analytic processing (OLAP) of data from disparate data sources. SSAS allows users to analyze data with a host of tools including SSRS and Excel. In addition, SSAS enables the discovery of data patterns that may not be immediately apparent through the data mining features built into the product.

Icon can help to prepare and populate the data that drives the SSAS system and to design and develop the SSAS cubes to organize your data.

SQL Server Reporting Services (SSRS)

SQL Server Reporting Services (SSRS) provides a set of on-premises tools and services that create, deploy, and manage mobile and paginated reports.

Icon offers SQL Server Reporting Services (SSRS) consulting services to help empower your users to make effective, informed decisions based on trusted data and delivered in formats appropriate for the user.

SQL Server Reporting Services offers an updated suite of products:

  • “Traditional” paginated reports brought up to date, so you can create modern-looking reports, with updated tools and new features for creating them.
  • New mobile reports with a responsive layout that adapts to different devices and the different ways you hold them.
  • A modern web portal you can view in any modern browser. In the new portal, you can organize and display mobile and paginated Reporting Services reports and KPIs. You can also store Excel workbooks on the portal.