Business Intelligence i SharePoint

Sammanfattning: The goal for this thesis work was to develop Business Intelligence (BI) for an IT consultant company. LexiConsult is an IT consultant company in the Lexicon-group which offers expertise within Office (templates, database, spreadsheets, Outlook etc.) but also SharePoint development and services like support, documentation etcetera. We have investigated the functionality in SharePoint and MS SQL Server and have also evaluated which possibilities these platforms offer in terms of creating a BI-solution for LexiConsults needs. SharePoint offers a variety of different tools and services for BI but none of these where available in the Office365-version which LexiConsult uses. Another solution was therefore suggested where the reports should be published on a web hosting company. We have also studied critical success factors when implementing BI in an IT consulting company. The result is a set of BI-reports developed for SQL Server Reporting Services (SSRS), which the staff of LexiConsult can access via their SharePoint site. The reports are designed for monitoring and analysis of the economy with e.g. key performance indicators, drill-down of the revenue in different aspects such as by time period, per employee, per customer etcetera. The reports provides vital knowledge that can be used for decision support, e.g. which customers and which types of projects is the most profitable and should be given priority. Have the consultants had high occupancy rate lately and what is the forecast for the future? Should more consultants be hired? Some of the reports are restricted from access by others than management of the company, and some are accessible by all employees. Data is queried from the SQL-database to the company’s system for booking and invoicing as well as their SharePoint site. This data is transformed to information which should give knowledge about the company and its finances. The result of the thesis work is of interest both within the company and as a product targeting their customers.