Category: BI

Techtarget.com defines Business Intelligence (BI) is a technology-driven process for analysing data and presenting actionable information to help executives, managers and other corporate end users make informed business decisions.

BI encompasses a wide variety of tools, applications and methodologies that enable organizations to collect data from internal systems and external sources; prepare it for analysis; develop and run queries against that data; and create reports, dashboards and data visualizations

Therefore, the Business Intelligence category is full of handy tips, tricks and advise. Check out some of the Step by Step blogs or learn with our eBooks, How To videos and Webinars.

Pro Data Mashup for Power BI
Pro Data Mashup for Power BI
Ebooks

Not a member? Sign up here to access all content. By delving into this free 80 page chapter, you’ll gain insights into connecting Power BI Desktop with various databases and data warehouses. Not only that, but you’ll also learn that Power BI Desktop conveniently offers pre-built connections to most databases commonly found in corporate settings.… READ MORE

Integrate Power BI Reports in SharePoint Online
Integrate Power BI Reports in SharePoint Online
Blog Posts

We have been waiting for this for soooo long! I’m very happy to announce the availability of the Power BI report web part for SharePoint Online! The new web part Microsoft is releasing today enables SharePoint authors to embed Power BI reports directly in SharePoint Online pages with no code required! In the sample below I… READ MORE

Latest on the ESPC Community
Latest on the ESPC Community
Blog Posts

Grow and enhance your skills with the European SharePoint, Office 365 & Azure Community. Joining the ESPC Community, gives you access to the online resource centre at sharepointeurope.com, providing the best, free content on SharePoint, Azure and Office 365. Topics covered include Microsoft Teams, SharePoint, SharePoint Framework, Office 365 Groups, OneDrive, PowerApps & Flow, Security,… READ MORE

How to extract tables from Powerpoint using just Power Query
How to extract tables from Powerpoint using just Power Query
Blog Posts

I’ve been using my solution to extract tables from Powerpoint a lot recently.  However, I’ve come across some situations where what looks like a table is actually an embedded Excel worksheet. This can be quite useful in Powerpoint as it provides the ability to create subtotals and apply other formulae. You can add these sort of… READ MORE

Archiving in SharePoint
Archiving in SharePoint
Blog Posts

In this article I’ll describe built-in archiving  in SharePoint / Office 365. I’ll cover topics like on how you can use Site / Library based retention to fulfil company or legal requirements. Background It’s often the case that we’re creating a SharePoint site for a project. Typically, they last for a specific amount of time,… READ MORE