Business intelligence

Want to push data directly to the cloud using the Power BI API but not sure where to start? Our handy guide will help you get the basics under your belt.

Power BI can connect to a wide variety of systems to collect data to drive reports and dashboards. But what if we want to consolidate data from multiple locations, such as a large number of dynamically created SharePoint lists, into a single dataset?

You might be tempted to first consolidate this data into a location such as Azure SQL, before connecting to that SQL database from Power BI. However, this isn’t actually necessary, as we can use Power BI’s own API to create a dataset into which we can push data directly, removing the need for a separate database.

This blog post outlines the steps involved in using the Power BI API to manage data. These are:

An understanding of how proposed solutions can meet the demands of the business

Arrangements to share learning and experiences across and outside the organisation.

But these attributes all feel very dry, functional and transactional. They speak nothing of the customer-supplier relationship, of the emotive connection – a meeting of minds, mutual trust and professional respect.Continue reading this post »

Visualising data on maps is a powerful way of communicating information, but it’s always been difficult to achieve. Now Power BI gives everyone the chance to go places with their data.

One of the most powerful ways to visualise data is spatially. Used appropriately, map-based data visualisations can make otherwise-invisible connections obvious, bringing your data to life in a very immediate and visually-compelling way.

This kind of visualisation has long been difficult to create, needing expensive and complex software. Fortunately, Power BI now offers two easy-to-use map visualisations that bring this capability within anyone’s reach.

About our blog

Here you’ll find insight on CompanyNet’s work, what’s happening in enterprise software, and the future of the workplace. It’s written by a variety of CompanyNet staff. If you’d like to talk to us about anything you see here, just drop us a line.