Who is the King of SharePoint BI & reporting tools?

/in , , , /by

Over the past few years, Business Intelligence and Insights in SharePoint has become one of the most desired features especially for enterprise customers. The user voice on improved reporting features for content and usage of SharePoint has led to several ground-breaking tools including Microsoft very own Power BI which is one of the leaders in the market. However, there are lots of other players in the market with innovative auditing and insights capabilities who are trying to become the king of SharePoint BI and reporting kingdom. Each of them comes with a great list of features and provides visually appealing reports as well as innovative ways of data modelling to implement business intelligence in SharePoint. In this article, we will take a look at some of the best BI tools available, there pros and cons and which one deserves to be called the king of SharePoint BI and reporting.

Read more

What went down at the SharePoint Conference Las Vegas 2019

/in , /by

SharePoint conference “SPC” is one of the biggest event in SharePoint world which took place in Las Vegas this year focusing on SharePoint, O365, OneDrive and relative technologies including Yammer, Microsoft Stream and Power BI. It was an action-packed three days full of new feature announcements, workshops and learning sessions which started off with a keynote from Jeff Teper, corporate vice president for OneDrive, SharePoint and Office in which he introduced some of the latest and greatest innovations from Microsoft which allows organizations to improve employee engagement as well as empowering them to achieve more in the modern workplace with Microsoft O356. Below are some of the key features/improvements announced during the conference.

Read more

Power BI using SharePoint List VS SQL Tables

/in , , , , /by

Power BI is a no code analytics and reporting tool from Microsoft which allows business users to generate sleek and customizable reports and interact quickly and easily with their data using simple drag-and-drop features. It is an extremely feature rich yet user-friendly reporting tool which can also be used for creating live dashboards and then sharing them with your colleagues or embed them in your app, website, or SharePoint portal. It is compatible with over 65 different data sources out of the box including both on-premises and cloud products.

Read more

Comparison of BI Tools: Power BI vs Cognos vs Crystal Reports vs SSRS

/in , , , , , , /by

Which is the best Business Intelligence (BI) tool available? Why is it the best and what distinguishable features makes it the best one? What are the alternatives? What is the current client base of this tool? Is this BI tool the right one for your business as well? What should you be looking for when evaluating BI tools? Will your business analyst or end users be capable enough to extract desired information from this tool?

In this blog, we evaluated some of the most popular BI tools out there, provided an overview and compared features, hopefully helping you to make the right choice of BI tool to meet your business requirements. A first step to finding the best tool for your company.

Read more

How to publish SharePoint data to Power BI using the enterprise gateway

/in /by

The enterprise gateway provides the facility to access data into the Power BI that reside on an on-premises network, it validates connection request and allows access to only those users’ requests which meets certain criteria. It also secures data, password and access request by doing encryption and compression of the data which passes through it.

Read more

Power BI Desktop and Power BI Server March 2018 Updates

/in /by

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.

Read more

Power BI with SharePoint data: The Ultimate Guide

/in /by

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 in form of an analysed report or a visualised report. Power BI provides a simple and user-friendly interface that can be used by business and power-users easily. Also, it allows collecting data from wide range of data sources. If you’re a business or power-user who wants to work robustly on data of your organisation, then you will be using Power BI Desktop or Power Bi Desktop Pro which is free to download.

In this blog, we’re going to use Microsoft Power BI tool to collect data from various sources such as SharePoint, web services, OData and SQL Azure. we’ll explore Power BI Desktop tool to build productive and creative reports. Also, we’ll use Power BI service to publish reports and set up automatic data refresh so everyone can see updated information. So, let’s get started!

Read more

POWER BI: SHAREPOINT REAL TIME REPORTS AND DASHBOARDS

/8 Comments/in /by

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 SharePoint online

Read more