Our blog

In this blog post we will look at SSRS 2016/2017 with SharePoint 2016 in detail and in particular: What SSRS is and how it fits into the Microsoft BI stack The various components that make up the SSRS toolset What’s new in SSRS 2016/2016 How to set-up SSRS to be used with SharePoint 2016 How to write a SharePoint 2016 Report using the OOB connectivity How to configure SSRS 2016 SharePoint integrated mode with SharePoint 2016 Using SSRS to report on SharePoint Online and SharePoint […]
[read article]

04 Apr 2018 | Share:

This month Microsoft have released a new production ready version of Power BI Report Server as well as a updates to Power BI Desktop with new visuals and a variety of connectors moving to general availability. Power BI Report Server Updates March 2018 This month Microsoft have released a new production ready version of Power BI Report Server that includes bookmarking, syncing slidcers and quick measures. Bookmarking allows you to capture the currently configured view of a report page, […]
[read article]

20 Mar 2018 | Share:

When it comes to a reporting solution, Crystal Reports is the de facto standard in the reporting world. In this blog we will cover how we can generate a Crystal report based on data from a SharePoint List. To do this we will first export the data from the SharePoint list to SQL Server using SQList. Once the data is exported in SQL Server, we will use Crystal Reports to create reports using the exported data. The data export process from SharePoint lists to SQL Server can be configured to be […]
[read article]

18 Mar 2018 | Share:

Tableau is one of the most renowned and accepted Business Intelligence tool for visually analysing the data by organisations all over the world. Tableau allows its users to create and distribute an interactive dashboard depicting the trends, variations, and density of the underlying data either in the form of graphs or charts. Tableau can connect to almost all types of data sources for fetching data. Data sources can be files, relational and Big Data; once the data is fetched it can be […]
[read article]

23 Feb 2018 | Share:

Nowadays, we deal with huge amount of raw data to make business decisions using Business Intelligence technology that helps in accelerating and improving decision-making, optimizing business processes, gaining new revenues and competitive advantage over business entrants. There are many BI tools are available in the market such as Tableau, Qlik, Power BI etc. Microsoft Power BI is a cloud-based service that enables to collect, filter, combine, analyse and visualise and finally publish your data […]
[read article]

12 Feb 2018 | Share:

Microsoft Power BI provides a powerful way to visualise SharePoint data and build reports and dashboards on SharePoint lists and libraries. With the introduction of a Power BI web part (and the embed code) we can now also integrate these Power BI assets in our SharePoint sites. In this blog post we will cover how to: Create a Power BI report on  a SharePoint list Configure the Power BI report to use direct query on the SharePoint data to keep the report up to date Embed the Power BI report in […]
[read article]

13 Oct 2017 | Share:

We are proud to announce a new release of SQList which provides even greater flexibility when exposing your SharePoint lists and libraries as a set of normalised SQL Server Tables. Version 5.4 of SQList is a minor update from ver. 5.x.x, you can, therefore, upgrade for free if you have a licensed version 5.x.  There are no breaking changes in this update. There are some great new features in our SQList 5.4 release, namely:  Support for SQL Server Temporal Tables SQL Server 2017 […]
[read article]

12 Jul 2017 | Share:

Highlights of the Microsoft SharePoint Summit 2017 Microsoft unveiled plans for SharePoint, Onedrive and Offiec365 during the SharePoint Virtual Summit today (May 16th) Here’s a summary of some of the announcements and reaction to those [View the story “Highlights of the SharePoint Summit” on Storify] […]
[read article]

16 May 2017 | Share: