- What we do
- Who we work with
- Who we are
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:
The customer is always right. Right? Wrong. A supplier-side perspective on ‘the intelligent customer’.
In May 2017, Audit Scotland set out a number of principles to follow for customers in pursuit of a successful digital future. One of the principles was simply to:
“Be an intelligent client.”
The target audience for the recommendations was the public sector in Scotland. But the recommendations apply much more broadly than that – in the private sector, and way beyond Scotland’s shores.
In 2012, Audit Scotland had set out the main attributes for being an “intelligent client”. These were:
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.
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.
Microsoft Cloud Future thinking Collective intelligence Office 365 Intranets Business intelligence (17) Digital Transformation Technical Business Transformation Office Gold Partner 20th Anniversary Change Management CRM Privacy Microsoft Inspire Partners Director's Briefing Websites Public Sector Training
On Wednesday 21st February, don't miss our next event, Open evenings for prospective apprentices