In the rapidly growing world of today, when technology is expanding at a rate like never before, there are plenty of tools and skills to explore, learn, and master. In this digital and data age, Business Information and Intelligence have climbed up the ladder of important business skills to a great extent, if

在當今快速發展的世界中，當技術以前所未有的速度發展時，有許多工具和技能可供探索，學習和掌握。 在這個數字和數據時代，商業信息和情報在很大程度上提升了重要商業技能的階梯，如果

Business Intelligence can be weighed as important organizational competence these days! Organizations now propel their business far ahead of their competitors by potentially boosting brand awareness, internal engagement, organizational efficiency, and profitability with the help of BI.

如今，商業智能可被視為重要的組織能力！ 企業現在可以借助BI潛在地提高品牌知名度，內部參與度，組織效率和盈利能力，從而將業務推向領先于競爭對手的地方。

The BI and analytics industry is expected to soar to a value of $26.50 billion by the end of 2021

到2021年底，BI和分析行業的價值預計將飆升至265億美元

Moreover, companies that use BI analytics are five times more likely to make swifter, more informed decisions. In that case, it is quintessential to embolden Business Intelligence skills. In this story, I have listed the top BI tools used in industries in 2020. There are a lot of BI tools existing and being used today but below are the most popular ones, in alphabetical order.

此外，使用BI分析的公司做出更快，更明智的決策的可能性是原來的五倍 。 在這種情況下，增強商務智能技能至關重要。 在這個故事中，我列出了2020年工業中使用的頂級BI工具。當今有很多BI工具正在使用，但按字母順序排列的是以下最受歡迎的BI工具。

Let’s get to know them…!

讓我們認識他們吧！！

1. Google Data Studio (1. Google Data Studio)

First rolled out in 2016, Google Data Studio might be the free, web-based suite that Google has to offer but Google’s user-friendly, intuitive design to business intelligence might be one of its strongest selling points.

Google Data Studio可能于2016年首次推出，它可能是Google必須提供的免費的，基于網絡的套件，但Google對商業智能的用戶友好型直觀設計可能是其最大的賣點之一。

Pros: Works great with data sourced from Google, like Google Analytics, Search Console, AdWords, YouTube analytics, and others. You can literally pull in any data you’d like from a Google Sheet.

優點：與Google來源的數據(例如Google Analytics(分析)，Search Console，AdWords，YouTube分析等)非常兼容。 您可以從字面上從Google表格中提取所需的任何數據。

Cons: Does not really help good to pull a big selection of pre-built connectors for data from other sources. Requires a lot to make working with a wide range of data types easy.

缺點：從其他來源獲取大量預建連接器來收集數據并沒有幫助。 要輕松處理各種數據類型需要很多工作。

As for visualization and analysis capabilities, Data Studio offers a fair number of options compared to other analytics suites. One other potential drawback of Data Studio is the fact that it’s entirely web-based. Sharing is easy for those who are willing to head to the link you provide, but you won’t be able to export to a pdf or any other common reporting format, and automated report delivery is limited.

關于可視化和分析功能，與其他分析套件相比，Data Studio提供了很多選擇。 Data Studio的另一個潛在缺點是它完全基于Web。 對于愿意訪問您提供的鏈接的人來說，共享很容易，但是您將無法導出為pdf或任何其他常見的報告格式，并且自動報告的發送受到限制。

什么銷售Google Data Studio？ (What sells Google Data Studio?)

1. Data Studio has many 3rd party connectors to connect & pull data from in the likes of Amazon Seller, Stripe, Facebook Ads, eBay, and Twitter
   Data Studio具有許多第三方連接器，可用于連接和提取Amazon Seller，Stripe，Facebook Ads，eBay和Twitter等數據
2. Google Data Studio is free!
   Google Data Studio是免費的！
3. Real-time analytics & filtering
   實時分析和過濾
4. Easy sharing & collaboration
   輕松共享和協作

2. IBM Cognos Analytics (2. IBM Cognos Analytics)

The quintessential business intelligence suite by IBM — Cognos Analytics is a cloud-based BI and analytics platform.

IBM的經典商務智能套件-Cognos Analytics是基于云的BI和分析平臺。

Cognos Analytics imports data from a wide variety of sources to help create interactive dashboards, visualizations, and reports. Its users are diverse; from enterprises in multiple industries and from small to large businesses.

Cognos Analytics從各種來源導入數據，以幫助創建交互式儀表板，可視化文件和報表。 它的用戶多種多樣； 來自多個行業的企業，從小型企業到大型企業。

IBM defines Cognos Analytics as an AI-infused decision-making tool. A very distinguishing feature of this platform is the use of a mobile app to view charts, receive alerts, and get real-time updates.

IBM將Cognos Analytics定義為注入AI的決策工具。 該平臺的一個非常獨特的功能是使用移動應用程序來查看圖表，接收警報并獲取實時更新。

什么銷售Cognos Analytics？ (What sells Cognos Analytics?)

1. Convenient team sharing of content via web, email, and Slack
   方便的團隊通過Web，電子郵件和Slack共享內容
2. Storytelling with data with a large number of format options
   具有大量格式選項的數據講故事
3. Allows install and access on-premise or cloud
   允許在本地或云中安裝和訪問
4. Shares reports & dashboards through webpage, email or Slack
   通過網頁，電子郵件或Slack共享報告和儀表板
5. Uses machine learning to assess and combine related sources
   使用機器學習評估和組合相關資源
6. Creates interactive dashboards, visualizations, and reports with AI recommendations
   創建具有AI建議的交互式儀表板，可視化和報告

3.旁觀者 (3. Looker)

I never knew a BI tool like Looker existed until last week when I came across three entry-level full-time Data Analyst positions from Disney, Warner Media, and a local startup demanding proficiency with Looker. When I looked into Looker, it had to make it to the list of BI tools to know.

直到上周，當我遇到迪斯尼，華納媒體和一家本地初創公司要求精通Looker的三個入門級全職數據分析師職位時，我才知道像Looker這樣的BI工具已經存在。 當我查看Looker時，它必須進入BI工具列表才能知道。

Looker is a browser-based business intelligence platform, simple to use, easy to choose, customize, and create a variety of interactive visualizations, providing a variety of graphs and charts to choose from. I am coming across a lot of comparisons between Tableau and Looker now.

Looker是一個基于瀏覽器的商業智能平臺，易于使用，易于選擇，自定義并創建各種交互式可視化效果，并提供多種圖形和圖表供您選擇。 我現在在Tableau和Looker之間遇到了很多比較。

The best feature I find about Looker is the drag and drop dashboard creation, which would prove to be a great help to non-technical users. Visualizations and reports are accessible on all devices and can be exported outside the Looker dashboard for collaboration with others too, a good feature to have?

我發現Looker的最佳功能是拖放式儀表板的創建，這將對非技術用戶提供極大的幫助。 可視化和報告可以在所有設備上訪問，并且可以導出到Looker儀表板外部以與其他人協作，這是一個很好的功能嗎？

什么銷售Looker？ (What sells Looker?)

1. Connects to user SQL database or similar data warehouse
   連接到用戶SQL數據庫或類似的數據倉庫
2. Provides a proprietary LookML syntax for query optimization
   提供專有的LookML語法以優化查詢
3. Creates real-time visualizations available on all devices
   創建在所有設備上可用的實時可視化
4. Provides drag and drop features for dashboard creation
   提供用于創建儀表板的拖放功能
5. Allows access on web and mobile devices
   允許在網絡和移動設備上訪問
6. Installs on-premise or in a Looker-hosted cloud
   在本地或由Looker托管的云中安裝
7. Provides the capability to export visualizations for collaboration with others
   提供導出可視化文件以與他人協作的功能

4. Microsoft Power BI (4. Microsoft Power BI)

Microsoft’s leading offering in the business intelligence tools space, Power BI, is designed to be useful for business analysts and data scientists.

微軟在商業智能工具領域的領先產品Power BI旨在對商業分析師和數據科學家有用。

I heard of Power BI in 2017 when I was interning with Larsen & Toubro, using Power BI for revenue expense analysis across departments, employee efficiency, real-time data processing for welding, and arching shifts.

我在2017年與Larsen＆Toubro進行實習時聽說過Power BI，使用Power BI進行部門間的收入支出分析，員工效率，實時焊接數據處理和拱形移位。

With a simple drag-and-drop interface, PowerBI offers a sense of resemblance or familiarity to users of MS Excel. Power BI is a no-code platform and probably the reason behind its big hit. PowerBI has a great library of pre-built connectors, not as extensive as some of the other tools listed here, but Power BI will be a great add-on for any Windows-centric data workflow, especially in combination with Azure.

通過簡單的拖放界面，PowerBI為MS Excel用戶提供了相似或熟悉的感覺。 Power BI是一個無代碼平臺，可能是其大受歡迎的原因。 PowerBI具有功能強大的預構建連接器庫，但不如此處列出的其他一些工具那么廣泛，但Power BI將是任何以Windows為中心的數據工作流的出色附加組件，尤其是與Azure結合使用時。

The Microsoft blog on Why Power BI explains very clearly and justifies why PowerBI is a de facto to Data Scientists. Power BI easily connects to, models, and visualizes data, creating memorable reports personalized with KPIs for a brand.

Microsoft關于Power BI為何為何的博客非常清楚地說明了理由，并證明了PowerBI為什么是數據科學家的事實。 Power BI可以輕松地連接，建模和可視化數據，創建具有品牌KPI個性化的難忘報告。

In my personal experience, PowerBI tends to lag on very large data sets, so you may want to look elsewhere if your data is really big.

以我個人的經驗，PowerBI往往會滯后于非常大的數據集，因此，如果您的數據確實很大，您可能希望在其他地方查找。

什么出售PowerBI？ (What sells PowerBI?)

1. Provides web-based business intelligence specializing in analytics
   提供專注于分析的基于Web的商業智能
2. Range of platform choices: Power BI, Power BI Pro, and Power BI Premium
   平臺選擇范圍：Power BI，Power BI Pro和Power BI Premium
3. Collects, connects and stores all data sources, on-premises or in the cloud
   收集，連接和存儲本地或云中的所有數據源
4. Allows moving to more intensive suite products as the enterprise grows
   隨著企業的發展，允許轉向更密集的套件產品
5. Creates real-time visualizations available on all devices
   創建在所有設備上可用的實時可視化
6. Provides the capability to export reports for collaboration with others
   提供導出報告以與他人協作的功能
7. Provides solutions for enterprises of all sizes, in diverse industries
   為不同行業的各種規模的企業提供解決方案

5. Qlik和QlikSense (5. Qlik and QlikSense)

Think of pie charts, line charts, pivot tables, bar charts, and more 📊, QlikView is a tool that is widely used across domains in the industry.

考慮餅圖，折線圖，數據透視表，條形圖以及更多其他內容，QlikView是一種在行業中廣泛使用的工具。

QlikView again is a Business Intelligence cum data discovery tool when the goal is to create guided analytics applications and dashboards for targeted business challenges. The software enables users to uncover data insights and relationships across various variables.

當目標是創建針對目標業務挑戰的指導性分析應用程序和儀表板時，QlikView還是一種商業智能暨數據發現工具。 該軟件使用戶能夠發現各種變量之間的數據見解和關系。

There has been quite a debate on the popularity of QlikView. While Tableau has big brands in the pocket, QlikView uses an in-memory data model making it capable of manipulating huge data sets instantly with accuracy which is Tableau’s scope of improvement.

關于QlikView的流行性已經有很多爭論。 盡管Tableau擁有眾多知名品牌，但QlikView使用內存數據模型，使其能夠即時準確地處理大量數據集，這是Tableau的改進范圍。

特征 (Features)

1. Allows access on-premise and cloud mobile and website services
   允許訪問內部部署以及云移動和網站服務
2. Provides a unified interface for gathering and manipulating data
   提供用于收集和處理數據的統一界面
3. Assists users with AI-driven suggestions to create analytics
   協助用戶提供AI驅動的建議以創建分析
4. Creates click and go visualizations and interactive reports
   創建即點即用的可視化和交互式報告
5. Centralizes analytics and apps to enable collaboration
   集中分析和應用程序以實現協作
6. Allows for advanced analytics calculations from R and Python
   允許使用R和Python進行高級分析計算

6. SAP HANA (6. SAP HANA)

SAP HANA (High-Performance Analytic Appliance) is an RDBMS, developed and marketed by SAP. Its primary function as a database server is to store and retrieve data as requested by supporting applications.

SAP HANA(高性能分析設備)是RDBMS，由SAP開發和銷售。 它作為數據庫服務器的主要功能是根據支持應用程序的請求存儲和檢索數據。

SAP HANA, an ETL based replication uses SAP Data Services to migrate data from SAP or non-SAP source to target the HANA database. Businesses using SAP in their biosphere use HANA to process massive amounts of real-time data in a short time.

SAP HANA是基于ETL的復制，它使用SAP數據服務從SAP或非SAP源遷移數據，以HANA數據庫為目標。 在生物圈中使用SAP的企業使用HANA在短時間內處理大量實時數據。

Because SAP is a closed-source ecosystem, HANA might not be a tool for independent Data Scientists but for business or careers in SAP, HANA can be a good skill to flaunt.

因為SAP是一個開源生態系統，所以HANA可能不是獨立數據科學家的工具，而是SAP的業務或職業，HANA可以成為炫耀的好技能。

7. SAS (7. SAS)

SAS — Statistical Analytical System

SAS —統計分析系統

Alike R, SAS is a tool developed for advanced data analysis and complex statistical operations. It is a closed-source proprietary tool that offers a wide variety of statistical capabilities to perform complex modeling. SAS is mostly used by large scale organizations and professionals due to its high reliability.

與R一樣，SAS是為高級數據分析和復雜的統計操作而開發的工具。 它是一種開源專有工具，具有多種統計功能，可以執行復雜的建模。 SAS由于其高可靠性而被大型組織和專業人員廣泛使用。

While SAS is not a tool best suited for beginners and independent data science enthusiasts it SAS is tailor-made to meet advances business demands, if you are looking to specific Data Science roles in your career, a good knowledge of SAS would gleam your profile.

盡管SAS并不是最適合初學者和獨立數據科學愛好者的工具，但SAS是為滿足不斷發展的業務需求而量身定制的，如果您正在尋找職業中特定的數據科學角色，則對SAS的深入了解將使您的個人資料閃閃發光。

SAS has been an undisputed market leader in the enterprise analytics space, however, to compare its capabilities with Python or R, SAS may seem difficult to model and visualize data with. Plus, the learning curve is tricky, difficult sometimes, and is mostly used by large corporations with huge budgets.

SAS在企業分析領域一直是無可爭議的市場領導者，但是，要比較其與Python或R的功能，SAS似乎很難建模和可視化數據。 另外，學習曲線有時很棘手，有時很困難，并且主要用于預算巨大的大型公司。

8.畫面 (8. Tableau)

Tableau is a very popular and powerful data visualization tool used in Business Intelligence these days. Data analytics is rapid and robust with Tableau. With the visualization dashboards and worksheets, Tableau covers simplifying raw data into a very easily understandable format, cleaning data, and identifying underlying trends and patterns.

Tableau是當今在商業智能中使用的非常流行且功能強大的數據可視化工具。 使用Tableau，數據分析既快速又可靠。 借助可視化儀表板和工作表，Tableau涵蓋了將原始數據簡化為非常易于理解的格式，清理數據以及識別潛在趨勢和模式的過程。

For quite some time now, big firms like PepsiCo, Verizon, Charles Schwab, Coca-Cola, Chipotle are using Tableau to leverage their data and make conclusive informed decisions. A tool like a Tableau is a must-know for anyone interested in a Data Science or Data Analytics career.

相當長一段時間以來，百事可樂，Verizon，查爾斯·施瓦布，可口可樂，Chipotle等大公司都在使用Tableau來利用其數據并做出明智的決定。 像Tableau這樣的工具對于對數據科學或數據分析職業感興趣的任何人都必須知道。

特征 (Features)

1. Provides on-premise, public and fully hosted business intelligence solutions
   提供本地，公共和完全托管的商業智能解決方案
2. Installs on-premise, public cloud, Tableau cloud
   安裝本地公共云，Tableau云
3. Allows access on web and mobile devices
   允許在網絡和移動設備上訪問
4. Delivers intuitive, self-service analytics for users without technical knowledge
   為沒有技術知識的用戶提供直觀的自助服務分析
5. Integrates data from many sources, either on-premise or cloud-based
   集成來自本地或基于云的許多來源的數據
6. Creates real-time visualizations in a few clicks
   只需單擊幾下即可創建實時可視化

9. TIBCO Spotfire (9. TIBCO Spotfire)

Spotfire was a business intelligence company based in Somerville, Massachusetts that was bought by TIBCO in 2007 (Wikipedia). Spotfire comes with the same general visualization capabilities as Tableau or QlikView.

Spotfire是一家位于馬薩諸塞州薩默維爾的商業智能公司，于2007年被TIBCO收購(維基百科)。 Spotfire具有與Tableau或QlikView相同的常規可視化功能。

While Tableau Public and Power BI Desktop is free to use, TIBCO Spotfire pricing starts at $650.00 per year, per user. There is no free version which might make it a less popular amongst independent Data Scientists. However, I recently came across this story on how Accor Hotels used TIBCO Spotfire to improve customer experience, and faster, easier, simpler integration.

盡管可以免費使用Tableau Public和Power BI Desktop，但TIBCO Spotfire的起價為每位用戶每年$ 650.00。 沒有免費的版本可能會使它在獨立的數據科學家中不那么受歡迎。 不過，我最近碰上了這個故事的雅高酒店如何使用TIBCO Spotfire中，以改善客戶體驗，以及更快，更方便，更簡單的集成。

TIBCO, an originally global leader in integration and analytics had a huge clientele with Spotfire in the kitty. You can visit the TIBCO customer list here.

TIBCO是最初在集成和分析領域的全球領導者，擁有大量客戶，其中有Spotfire。 您可以在此處訪問TIBCO客戶列表。

10. Zoho分析 (10. Zoho Analytics)

Zoho, a web-based online office suite offers a self-service business intelligence platform called Zoho Analytics. It is a cloud-based platform with an option for on-premise installation. Zoho connects to a wide variety of sources to collect data. It can auto-merge data from popular business software or via Zoho’s self-service tools. The data stays in the US data center.

Zoho，基于Web的在線辦公套件，提供了一個稱為Zoho Analytics的自助式商業智能平臺。 它是一個基于云的平臺，具有用于本地安裝的選項。 Zoho連接到各種來源以收集數據。 它可以從流行的商業軟件或通過Zoho的自助服務工具自動合并數據。 數據保留在美國數據中心。

Zoho Analytics has 500 thousand businesses in its kitty, about 2M users, and 50M reports. From my research, I found Zoho Analytics to have the most comprehensive 3rd party connectors — 500+ out-of-the-box integrations for business apps! Do check this tool out.

Zoho Analytics擁有50萬家企業，大約200萬用戶和5000萬報告。 根據我的研究，我發現Zoho Analytics具有最全面的第三方連接器-500多種針對業務應用程序的現成集成！ 請務必檢查該工具。

特征 (Features)

1. Allows access to on-premise, mobile, and cloud
   允許訪問本地，移動和云
2. Requires minimal expertise
   需要最少的專業知識
3. Collects data from many sources and allows automatic synchronization
   從許多來源收集數據并允許自動同步
4. Provides drag and drop tools to create dashboards, visualizations, and reports
   提供拖放工具以創建儀表板，可視化文件和報告
5. Shares reports and dashboards through the web page and app
   通過網頁和應用程序共享報告和儀表板
6. Provides a workspace for collaboration
   提供協作的工作空間

That’s it from my end for this blog. Thank you for reading! I hope this helped! Do let me know what BI tool you are looking up to learn or explore.

從本篇博客的結尾我就是這樣。 感謝您的閱讀！ 希望對您有所幫助！ 讓我知道您正在尋找學習或探索的BI工具。

Disclaimer: The views expressed in this article are my own and do not represent a strict outlook.

免責聲明：本文中表達的觀點僅屬于我個人觀點，并不代表嚴格的觀點。

認識你的作者 (Know your author)

Rashi is a graduate student at the University of Illinois, Chicago. She loves to visualize data and create insightful stories. When not rushing to meet school deadlines, she adores writing about technology, UX, and more with a good cup of hot chocolate.

Rashi是芝加哥伊利諾伊大學的研究生。 她喜歡可視化數據并創建有洞察力的故事。 當不急于按時上課時，她會喝一杯熱巧克力，喜歡寫有關技術，用戶體驗等的文章。