Likelihood to Recommend If you're already using Office 365, Power BI for O365 is an easy choice. Start playing around with the free version and then easily add individual Pro licenses with little risk. However, if you anticipate using this with many users, it can get expensive quickly.
Read full review If we have very huge data that has to be filtered based on the selection in the workbook filters, then passing the control IDs of the filters as the parameters directly in the SQL query is a great help. This way helps us in optimizing large SQL queries as well. If we want our front end application filters with the Sigma Computing dashboard filters to communicate with each other, we can certainly do that in embedding with the help of the control_ids.
Read full review Pros Easy to make visual dashboards from SQL queries. Previously we had to use a third party application that had to run on a web server that was so complex to setup and run. PowerBI removes all that. Ability to control who/which group has access to each dashboard or report. Ties in well with the rest of the Office 365 ecosystem. Has many connectors to allow pulling data from various systems, both onsite (via gateway) or external (via APIs), and join the data to create a report/dashboard. Ability to show data but also export the data, if permitted. Easy to show PowerBI dashboards on SharePoint or on other websites via embedded code. Read full review Allows end users to easily dive into the data without having direct access to the table in our database management software. Can easily turnaround dashboards that are detailed and visually pleasing. Sigma is intuitive and as new features are rolled out it is easy to adopt and incorporate them into new and existing dashboards. Read full review Cons 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. Read full review Viewer level license is quite limited. These users can't download data or even add filters on datasets. Something to keep in mind. Directly querying the underlying data warehouse will lead to increased usage. Not a big deal on something like Redshift, but your Snowflake consumption will increase, potentially by a lot. Read full review Likelihood to Renew I will continue to recommend this suite to folks looking for a reporting and analytics solution, as I find in MOST cases, it's great at meeting almost every requirement I've been given by a multitude of clients across a range of industries. I've built Capacity Planning solutions that allowed end user input which was then submitted to SharePoint, Executive Dashboards, custom applications, simple analytical tools for teams to easily slice and dice data, and super simple reports as well as some very complicated ones. If you haven't seen the demos online, do a search, and see for yourself - this is a great BI suite! (I do not work for Microsoft, although I do consult out there from time to time. I do occasionally make a recommendation for a different BI reporting tool, but in general, find Excel can accomplish quite a bit for less money and in less time.)
Read full review Sigma has helped us a lot and has become an integral part of our daily workflow. It would be difficult to switch to another platform and have to rebuild the numerous metrics and performance reports that we have already established
Read full review Usability We are satisfied with the functionality and capabilities of Power BI. Product is cost effective and full-fill the reporting requirements of the organization. You can perform most of the report level complex analysis with the help of DAX which makes Power BI very powerful analytic tool. Power BI for Office 365 has gone away and Power BI is the next evolution of it. Power BI comes with your Office 365 E5 subscription or you can purchase licensing for it separately.
Read full review It has a clean and modern interface. However, it is not completely intuitive. I think it would be better and easier to navigate with more Windows style drop down menus and/or tabls. There is a significant learning curve, but that may be due in part to the technical nature of this type of software tool.
Read full review Reliability and Availability Yes, as long as you don’t conduct user error sigma is always up and running and waiting for you to complete your dashboards
Read full review Performance It depends, it loads quickly for smaller dashboards but when loading larger amounts of data it takes more time to do so
Read full review Support Rating as of now there is strong community for Power BI, you can get solution for most of your problems from there. Also you can send your error to Microsoft as well. After every 15 days they release updates to overcome all the issues of defects.
Read full review Support team is helpful in answering questions and providing help with using the UI. There are knowledgeable people within the support team. There are also good online support tools. There are significant community support resources available. There is however lack of a live support. It would be useful to have live phone number or chat to use.
Read full review Implementation Rating Was not involved in implementation
Read full review Alternatives Considered Oracle was nice, super expensive to implement if it's not in use already. JobDiva is choppy and heavy on the system while does not give great reports.
Salesforce is good; remote access is good however their support is terrible
Read full review Sigma is by far the best. It is easiest to learn and easiest to use on a day to day basis. I never have to wait for dashboards to load and it's very easy to understand the variables that are going into my visualizations. Best of all I can manipulate the data within Sigma very easily. In these other platforms data manipulation is difficult or must be done in the data warehouse
Read full review Scalability It is a cloud service offering that is able to expand based on your usage
Read full review Return on Investment 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. Read full review Monitoring health of cloud platform has allowed the company to anticipate issues before they affect customers – Sigma prompted us building a canary monitoring process that provides customer container health. Customer success has used an activity report to discover customers running runaway processes that they were unaware of, creating an alert to contact the customer and prevent an embarrassing situation. Customer success uses the activity report to prompt conversations regarding increases or declines in behavior that led to increasing contract limits or addressing churn concerns. Read full review ScreenShots