AxioWorks Blogs
AxioWorks news, product updates, useful articles, hints and tips on how to make the most of your SharePoint data and Power BI Reports.
-
Who is the king of SharePoint BI and reporting tools?
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…
-
How to publish SharePoint data to Power BI using the enterprise gateway
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.
-
SharePoint 2016 and SSRS 2016/17: The ultimate guide
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…
-
Using Tableau to report on SharePoint lists and libraries: A step-by-step guide
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…
-
Power BI with SharePoint data: The ultimate guide
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…
-
Power BI: SharePoint real time reports and dashboards
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…
-
How to import SharePoint libraries into Power BI and create links to the documents
If you have tried to import from SharePoint to power BI you have probably realised you can import Lists and folders but not libraries. In this post, which is based on a video by Ruth Pozuelo Martinez who is a microsoft MVP we’ll look at the Ruth’s suggested steps for doing the following: Export the…
-
5 ways to export SharePoint data to SQL Server
Find out how to export SharePoint data to normalised SQL Server tables and then use the power of SQL reporting services to generate reports with AxioWork’s SQList.
-
Case study: Streamlining Medical Trial Data Analysis in the Pharmaceutical industry
Find out how one pharma company unlocked near real-time data querying and reporting capabilities, leveraging their existing tools and expertise without disrupting their SharePoint or SQL Server environment.
-
Using SSIS to Export Lists from SharePoint to SQL Server – An Alternative Approach
Find out how to export SharePoint List data to SQL server easily with SQList from AxioWorks.