Looker vs. Power BI For Office 365 (discontinued)

When you need to create a centralised dashboard for multiple stakeholders that blends cross-channel reporting. As an SEO agency reporting for clients - Looker is a great solution. It's less appropriate depending on the intended users. For instance, in my experience Looker reports have been under-utilised because they're not accessed regularly, provide too much noise or often simple PDF reports are preferred

Incentivized

If you want to create a visual dashboard or report that utilises various data sources then PowerBI can do this. It is great in that it takes your on-premises data and stores it on Microsoft servers where it can interact with it faster, reducing load on your own servers, while being efficient in what it transfers out. We have found it not well suited if you wanted to publish a simple report to many staff as they may all need a Pro license which can get expensive. Even if embedding the report onto a shared platform like SharePoint, it will not display if the users doesn't have a PowerBI Pro license.

Incentivized

• It is very easy to start a new dashboard and configure what you want to display by just selecting/dragging from the list of available columns.
• It is intuitive, mainly if you use other Google services like Google Sheets.
• The look and feel is modern and nice.
• It it very useful to have an immediate visual overview of the data in a spreadsheet.

Incentivized

• 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.

Incentivized

• I wish I could get more granular in the Google ad data, such as down to the campaign type, instead of having to see only all campaigns.
• The setup can be time-consuming if you're not using the product regularly.
• Editing the dashboard requires a few logins; I wish it was more seamless.

Incentivized

• Like many Microsoft products, you can get by with a small understanding of the product, but to truly realize the entire potential does take a while to learn.
• Hooking up SQL databases to the cloud version is a more complex than just querying right into the database from the desktop version.

Incentivized

We are very haooy with Looker, it provides us with all the funciomalities we need for both the day to day oerformance tracking and longer periods reporting. It is easy to use for account managers, configurable and customizable for soecialists and what is most imoortant, our clinets generally really love it

Incentivized

If I were a small business owner, I would likely use Power BI for Office 365 for the sheer fact that I would get the Office licensing I need, along with powerful capabilities. As a Microsoft Partner, we continue to see Microsoft invest heavily in the Power BI capabilities, and will continue to implement and support BI solutions around this product, as we believe this is in the best interest of our clients.

Looker is relatively easy to use, even as it is set up. The customers for the front-end only have issues with the initial setup for looker ml creations. Other "looks" are relatively easy to set up, depending on the ETL and the data which is coming into Looker on a regular basis.

Incentivized

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.

Incentivized

No objections

Incentivized

Somehow resources heavy, both on server and client. I recommned at least 50Mbs data rate and high performance desktop comouter to be abke to run comolex tasks and configure larger amount of data. On the other hand, the client does not need to worry when viewing, the performance is usually ok

Incentivized

Never had to work with support for issues. Any questions we had, they would respond promptly and clearly. The one-time setup was easy, by reading documentation. If the feature is not supported, they will add a feature request. In this case, LDAP support was requested over OKTA. They are looking into it.

Incentivized

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.

Incentivized

Very satisfied, easy to implement

Incentivized

In my opinion, Looker is no Power BI. It is good, but I think Power BI is amazing. That said, in my experience, Power BI is nowhere near as easy to setup and report on Google services as Looker is. We plan to continue using Power BI for c-suite and corporate reporting, especially for internal databases, but will gladly use Looker for our marketing information for AdWords, Analytics, Search Console, and YouTube.

Incentivized

One main competitor of Power BI is Tableau. Tableau has been around longer than Power BI so it can feel a little more refined in areas, however Power BI is catching up quickly. Tableau can be more expensive than Power BI. If you want more features and more refinement, and don't mind extra cost, then Tableau may be a better choice. But if you want something that's integrated with many things in O365, and are satisfied with fewer bells and whistles, Power BI may be the better option.

Incentivized

• Other than some people not liking the numbers, I don't see any negative impacts; we haven't experienced that.
• The reports help us unravel the story of our users and how they are sifting through our pages.
• Our clients enjoy seeing the numbers to understand better what stands out on their sites.
• The reports have helped us see what campaigns are working and where we need to tweak things.
• The reports have enabled us to have better conversations with stakeholders about how their web pages should be modified, edited, etc., to reflect the data.

Incentivized

• 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.