Microsoft's cloud-based business intelligence service is celebrating a major user growth milestone with a handful of new features, including the ability to import data from an Excel spreadsheet and turn it into live-updating charts and graphs.
Power BI now has more than 5 million subscribers, who are using the service to take in business data and create dashboards they can use to better understand their businesses. Starting Tuesday, those subscribers will be able to use an Excel connector to easily "pin" live-updating data from the Excel desktop app to a Power BI dashboard.
Both that feature, and one that allows users to analyze data from Power BI in Excel, were previously available for beta testing and are now generally available.
The service will also get role-level security for cloud models and direct query. One user with access to a set of company data in Power BI can create one dashboard that will show users a subset of information based on what they're allowed to see.
To help organizations understand how their employees are using Power BI, Microsoft by the end of the month will also add tenant-level usage reports that will show how people are using different features of the service, including reports and dashboards. It's an important feature because licensing Power BI Pro costs $9.99 per user every month.
In addition to the Power BI news, Microsoft Research also released SandDance, a new data visualization tool that takes information and shows data points as cubes on a three-dimensional graph. It's currently available in beta for Windows and Power BI, and aims to make it possible for people to look at data in interesting ways, like showing where events occur on a map, and then stacking data points on locations to show where they occur most frequently.
The news comes as Tableau, one of Microsoft's competitors in the cloud-based business intelligence space headquartered in nearby Seattle, has seen its stock hammered following missed revenue projections.
Next read this:
- Top 9 challenges IT leaders will face in 2020
- Top 5 strategic priorities for CIOs in 2020
- 7 'crackpot' technologies that might transform IT
- 8 technologies that will disrupt business in 2020
- 7 questions CIOs should ask before taking a new job
- 7 ways to position IT for success in 2020
- The 9 new rules of IT leadership
- 20 ways to kill your IT career (without knowing it)
- IT manager’s survival guide: 11 ways to thrive in the years ahead
- CIO resumes: 6 best practices and 4 strong examples
- 4 KPIs IT should ditch (and what to measure instead)