Microsoft PowerPivot
The professionals at SaberDBA understand and are skilled at the entire life-cycle of data. From it's inception, to capturing it, to storing it safely and securely, to making it available as needed. This allows us to develop solid information platforms from the ground up. A solid database design, good data management techniques and accurate, understandable presentation of the information the data contains. We know the technologies, the tools and the techniques.
SQL Server Reporting services has been Microsoft's primary reporting tool for the BI stack for many years. It is a visual drap and drop reporting environment that allows developers to produce interactive reports that users can consume in a browser.
Reporting Services can utilize data from a variety of data sources and create reports that offer:
-
drill-through capability
-
export to PDF
-
visuals
-
subscriptions
Even though getting started is easy, SSRS report authoring is a skill that requires both practice and commitment to best practices.
One of the most compelling things about Reporting Services, compared to other competing products, is it's price. It is included with Microsoft SQL Server at no additional charge.
In SQL Server 2016, Microsoft has made a significant investment in updating Reporting Services. It now features an updated user interface as well as other desired features.
Also, Reporting Services 2016 now appears to be taking center stage of the on-premise self-service BI functionality. There's talk of it being able to host Power BI workbooks on-premises! That's great news for organizations that are not yet ready to host their financial and operational reports in the cloud (using the Power BI Service).