Microsoft cloud based amazing Reporting tool for
Power BI is being used as a primary reporting tool across whole organization. It provides attractive GUI compare to other existing tools …
Overview
What is Power BI For Office 365 (discontinued)?
Power BI for Office 365 allowed users to model and analyze data, and query large datasets with complex natural language queries. It has been discontinued in favor of other editions of Power BI going forward.
Recent Reviews
Awards
Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards
Popular Features
- Report sharing and collaboration (11)10.0100%
- Drill-down analysis (11)9.090%
- Formatting capabilities (11)9.090%
- Customizable dashboards (11)8.080%
Pricing
N/A
Unavailable
What is Power BI For Office 365 (discontinued)?
Power BI for Office 365 allowed users to model and analyze data, and query large datasets with complex natural language queries. It has been discontinued in favor of other editions of Power BI going forward.
Entry-level set up fee?
- No setup fee
Offerings
- Free Trial
- Free/Freemium Version
- Premium Consulting/Integration Services
Would you like us to let the vendor know that you want pricing?
2 people also want pricing
Alternatives Pricing
What is Spotfire?
Spotfire® is a data visualization platform that utilizes predictive analytics. In addition to data viz, it includes data wrangling capabilities, predictive analytics, location analytics, and real-time streaming analytics. Spotfire® is a business unit of Cloud Software Group, formerly known as…
What is SAP Analytics Cloud?
The SAP Analytics Cloud solution brings together analytics and planning with integration to SAP applications and access to heterogenous data sources. As the analytics and planning solution within SAP Business Technology Platform, SAP Analytics Cloud supports trusted insights and integrated planning…
Features
Return to navigation
Product Details
- About
- Tech Details
- FAQs
What is Power BI For Office 365 (discontinued)?
Power BI for Office 365 allowed users to model and analyze data, and query large datasets with complex natural language queries. It has been discontinued in favor of other editions of Power BI going forward.
Power BI For Office 365 (discontinued) Technical Details
| Operating Systems | Unspecified |
|---|---|
| Mobile Application | No |
Frequently Asked Questions
Power BI for Office 365 allowed users to model and analyze data, and query large datasets with complex natural language queries. It has been discontinued in favor of other editions of Power BI going forward.
Reviewers rate Report Formatting Templates and Integration with R or other statistical packages and Report sharing and collaboration highest, with a score of 10.
The most common users of Power BI For Office 365 (discontinued) are from Enterprises (1,001+ employees).
Comparisons
Compare with
Reviews and Ratings
(215)Attribute Ratings
Reviews
(1-4 of 4)Companies can't remove reviews or game the system. Here's why
March 26, 2015
Power BI worth a look? YES!
Score 10 out of 10
Vetted Review
Verified User
I'm a Senior BI Consultant, and have been developing reports with various tools for many years. I started with Crystal Reports, then Hyperion (Brio) Interactive Reporting, Microsoft SSRS, and then Excel Power Pivot. Once I started developing Excel Power Pivot reports and analytical solutions, I was hooked. When the addition of the other Powers: Power Query, Power View, and Power MAPS, I can say I am one of the biggest evangelists of the Microsoft BI Stack out there, and no, I don't work for Microsoft. I don't often look for work developing Power BI Solutions, the work finds me, and I am always glad to work with a client that knows benefits of utilizing Excel to it's maximum capacity. I mean, everyone already has Excel, and finding resources to support what I've built once I move on to the next project is always fairly painless. I'm glad to leave a maintainable solution in the hands of my client, and Power BI is the only BI Development tool that does ETL, Data Models, Drag and Drop report building, Pivot Tables, and more in an environment that's well known.
- Drag and drop report development
- Flexibility with Power Views, Pivot Tables, ETL, and Data Modeling all in one
- Price
- Power View is still in the early stages, so customization of the look and feel is a bit limited.
It's more agile and less expensive in the long run for the majority of your analytic and reporting needs.
November 04, 2014
Almost there
In our organization, Power BI is used for ad-hoc data analysis and some regular reports, next to other BI tools. Only data analysts use it to compile reports that are easily viewed in Excel by non-Power BI users. It is the tool of choice for combining data from multiple sources.
- Ease of use. Most people have experience working with Excel. If you know how to create pivots, you can use Power BI.
- Data extraction and transformation (ETL). ETL is a joy with Power Query. It is intuitive, simple and a magical experience to transform poor data into something useful.
- Visuals. Power BI is beautiful to behold, especially Power View.
- Maps. The interactive maps are great built-in tools.
- Cost You cannot find anything cheaper than Power BI, unless you want to give it to every user in your company.
- Automatic updates. A choice of a daily or weekly refresh is too slow for this era of real-time updates.
- Speed. It takes a while to load all the data into memory. Data with more than one million records will take a few minutes to refresh. Once it is loaded, it starts being fairly fast.
- Changing queries in Power Query. Although Microsoft is working on it, when you delete a step in Power Query, you might have to rebuild your data model. This defeats the purpose of having a fantastic user interface, in which it is simple to change queries.
Tableau and Qlikview are both faster and have easier many-to-many relationships. However, for the average user, Power BI is much easier as a true Self-service BI. Besides, the cost for Power BI is lower.
November 04, 2014
Just BI
Score 9 out of 10
Vetted Review
Verified User
My organization is not using Office 365 yet. I did the research myself and have a given demo to my organization. We may purchase and use it.
- It's a self service BI. It's very easy to discover, analyze and visualize data.
May 21, 2014
Power BI for Office 365 - A compelling data analytics platform for personal and team use
Score 8 out of 10
Vetted Review
Verified User
We are a Microsoft partner, with my line of business focusing on creating data-driven solutions for our customers, ranging from IT-sponsored enterprise data warehouse initiatives to small team and personal business analytics solutions. My consulting team uses Power BI for primarily two purposes: 1) to create pilot/proof-of-concept solutions for our customers to help launch them on their BI journey; 2) to perform data analytics on larger enterprise data-driven initiatives. The agility of the Excel-based solution, combined with the power of the in-memory PowerPivot data engine, more than meets our need for the these 2 purposes. Our customers appreciate it because it allows them to remain in their very familiar Excel environment.
We are working with mostly finance/accounting departments, and in some cases, business analysts (or "power users") within the business community (sales, marketing, etc.). We are solving finance challenges like Accounts Receivable collections, along with operational challenges such as monitoring year-over-year sales metrics and comparing them to budgets that come from two data locations. In addition, we're solving painful "process issues" like trying to import multiple files into a single data set. We are literally reducing process time from days to minutes!
- Provides flexible and powerful analytics on large datasets. PowerPivot, the in-memory database engine, can handle 100's of millions of rows of data, giving 1-2 second response time for aggregate data analysis.
- Provides an adaptable environment to perform analytics. When combining data together in PowerPivot, you have the ability to create Excel tables, combine them with database queries, and then join that with data coming from a web-service provider.
- Powerful web-based deployment capabilities. SharePoint technologies have been a part of the Microsoft BI solution stack for some time. Office 365 provides a powerful way to deploy the Power BI analytics to a wider audience in a secure way, allowing for flexible access from most any device, whether phone, tablet, or computer.
- Power Query, one of the components of Power BI, is one of my favorite parts of the solution. Basically, you have at your disposal an end-user "ETL" (Extract, Transform, Load) tool, all within Excel. We've reduced multi-step, manual processes to single-click, automatic application of business rules to collect and transform data into a usable format. No need for VLOOKUP any longer with this capability.
- Licensing: Currently, Microsoft has a fixed pricing model for Office 365 users, regardless of role/function of the user. Most organizations have a small number of "power users" that create usable content and many more "consumers" that simply view/run reports created by power users. Microsoft does not differentiate between these users, and thus the pricing limits organizations from large deployments of the software.
- Version incompatibility: Excel 2010 and 2013 workbooks are compatible with each other. However, workbooks created in 2010 that include PowerPivot databases must be upgraded to 2013 format to run in 2013. Subsequently, you cannot open these upgraded PowerPivot workbooks in 2010. This requires ALL users to be on the same version.
- Visualization: Excel charting with PowerPivot workbooks is adequate for many users. Power View also contains a number of GREAT visualizations, including animated bubble charts and a very flexible dashboard/report design canvas. However, compared to some of the other self-service BI solutions, it is still limited in its visualization capabilities.
- As a Microsoft Partner implementing Business Intelligence solutions, Power BI has removed the barrier for our clients to begin the "BI journey". So often, projects get hung up in that early phase of procuring and installing/configuring expensive hardware and software. Just simply getting started and designing a beginning solution has allowed our clients to see results in 1-2 weeks using their data that might have taken months to achieve otherwise.
- One significant ROI example is process improvement. In many cases, individuals or teams are spending days each month gathering data from multiple sources for reporting to their constituents. We are reducing these times to minutes by automating many of the data collection and integration processes that were previously manual.
Pricing and functionality. Tableau Desktop is a very capable self-service business intelligence and analytics solution. The very rich visualization capabilities are far superior to that of Excel and Power BI. However, the pricing for the Power BI desktop is extraordinary. If you own Excel 2010 or 2013, you can download the functionality for free. And more often than not, the visualization capabilities of Excel are quite good enough. Another reason we selected Power BI is the shallow learning curve for users, compared to Tableau and other similar solutions. Excel is very familiar to most data analysts and finance/accounting teams. It is a comfortable environment on which to add powerful analytic capabilities.