You understand your business far better than anyone else and as such any Business Intelligence solution should allow for the rapid creation of reports and content that will be focused to your immediate needs.

Having a B.I. solution that requires extended wait time whilst a new reporting requirement is designed, developed and published will quickly loose its appeal and result in the use of less managed ad-hoc solutions being implemented to fill the void.

Microsoft SharePoint Server provides the ability to quickly generate and publish new content using technologies such a SQL Server Report Builder and Excel Services that empower the business user to create their own content and publish it to the required audiences via the managed environment of the corporate portal.

With the advent of Microsoft SharePoint 2010, Microsoft Office 2010 and SQL Server 2008 R2, the new PowerPivot tool allows for the manipulation and presentation of information from huge data sets which would previously only have been possible be implementing a major data warehousing architecture.

Myriad Technologies can assist you in choosing and implementing the appropriate tool (or tools) to allow your organisations B.I. environment to be a responsive and proactive as the business practices it reports on.

SQL Server Report Builder 2.0/3.0

Report Builder delivers intuitive report authoring capabilities to end users.  In addition to offering an enhanced authoring experience for business users, Report Builder 2.0 benefits power users that are looking for a sophisticated authoring environment.

Incorporating the Office paradigm into the design, end users can leverage their existing experience with Microsoft Office applications to quickly and easily design presentation quality reports

Enable users to customize and update all existing reports, regardless of where they were initially designed enabling organizations to derive increased value from more advanced reports, through end user customization

Excel Services

Excel Services is a new server technology included in Microsoft Office SharePoint Server 2007. This shared service enables you to load, calculate, and display Excel workbooks on Office SharePoint Server 2007.

Using Excel Services, you can easily reuse and share Excel workbooks on Office SharePoint Server 2007 portals and dashboards. For example, financial analysts, business planners, or engineers can create content in Excel and share it with others by using an Office SharePoint Server 2007 portal and dashboard—without writing custom code. You can control which data is displayed, and you can maintain a single version of your Excel workbook.

PowerPivot

PowerPivot refers to a collection of applications and services that provide an end-to-end approach for creating data-driven, user-managed business intelligence solutions in Excel workbooks.

PowerPivot integrates with Excel and SharePoint. In an Excel environment, PowerPivot for Excel provides a familiar authoring and analytical experience on the workstation. In a SharePoint farm, PowerPivot for SharePoint is the set of server-side applications, services, and features that support team collaboration on business intelligence data. SharePoint provides the platform for collaborating and sharing business intelligence across the team and larger organization. Workbook authors and owners publish and manage the business intelligence that they develop to their SharePoint sites.