Što je Tableau? Korištenje softverskog alata Tableau
David Carter
⚡ Pametni sažetak
Tableau is a data visualization platform used across the Business Intelligence industry to turn raw records into dashboards without programming. This page explains the product suite, licensing roles, how the engine connects to data, practical applications, and a direct comparison against Excel.
Što je Tableau?
Tablo is a powerful and widely used data visualization tool in the Business Intelligence Industry. It helps in simplifying raw data in a very easily understandable format. Tableau helps create the data that can be understood by professionals at any level in an organization. It also allows non-technical users to create customized dashboards.
Analiza podataka vrlo je brza s alatom Tableau, a stvorene vizualizacije su u obliku nadzornih ploča i radnih listova.
Najbolje značajke softvera Tableau su
- Miješanje podataka
- Analiza u stvarnom vremenu
- Suradnja podataka
The great thing about Tableau software is that it does not require any technical or any kind of programming skills to operate. The tool has garnered interest among the people from all sectors such as business, researchers, different industries, etc.
Tableau Software was founded in 2003 and was acquired by Salesforce in 2019. The product names used across the suite changed after that acquisition, so the section below reflects the current naming.
Tableau Product Suite
Tableau Product Suite sastoji se od
- Desktop Desktop
- Tableau Public
- Tableau Prep Builder
- Tableau Cloud (formerly Tableau Online)
- Tableau poslužitelj
- Čitač Tableau
The diagram above splits the five core products along the same line used below: authoring on one side, distribution on the other.
Radi jasnog razumijevanja, analitika podataka u alatu Tableau može se klasificirati u dva odjeljka.
- Razvojni alati: The Tableau tools that are used for development such as the creation of dashboards, charts, report generation, visualization fall into this category. The Tableau products, under this category, are Tableau Desktop, Tableau Public, and Tableau Prep Builder.
- Alati za dijeljenje: As the name suggests, the purpose of these Tableau products is sharing the visualizations, reports, dashboards that were created using the developer tools. Products that fall into this category are Tableau Cloud, Server, and Reader.
Proučimo sve Tableau proizvode jedan po jedan.
Desktop Desktop
Tableau Desktop ima bogat skup značajki i omogućuje vam kodiranje i prilagodbu izvješća. Sve od stvaranja grafikona, izvješća, do njihovog spajanja u kontrolnu ploču, sav potreban posao stvara se u Tableau Desktopu.
For live data analysis, Tableau Desktop provides connectivity to Data Warehouse, as well as other various types of files. The workbooks and the dashboards created here can be either shared locally or publicly.
Tableau Desktop was historically sold as two editions, Personal and Professional, which differed in whether work could be published to a server. Those editions have been replaced by the role-based licensing explained later on this page, and Tableau Desktop now ships as part of a Creator sjedalo.
Tableau Public
To je verzija Tableau posebno izgrađena za isplative korisnike. Riječ "Javno" znači da se stvorene radne knjige ne mogu spremati lokalno; zauzvrat, treba ga spremiti u javni oblak Tableaua koji svatko može vidjeti i pristupiti mu.
Ne postoji privatnost datoteka spremljenih u oblak jer ih svatko može preuzeti i pristupiti im. Ova verzija je najbolja za pojedince koji žele naučiti Tableau i za one koji žele podijeliti svoje podatke s javnošću.
Tableau Prep Builder
Tableau Prep Builder handles the cleaning step that comes before visualization. It provides a visual flow in which rows are filtered, columns split or merged, values standardised, and several sources joined or unioned together.
Each step previews the affected rows, so a data problem is visible while it is being fixed rather than after a chart looks wrong. Finished flows save as a data source that Tableau Desktop opens directly, and they can be scheduled to refresh on Tableau Server or Tableau Cloud.
Tableau poslužitelj
Softver se posebno koristi za dijeljenje radnih knjiga, vizualizacija koje su stvorene u aplikaciji Tableau Desktop u cijeloj organizaciji. Da biste dijelili nadzorne ploče na Tableau Serveru, prvo morate objaviti svoj rad na Tableau Desktopu. Nakon što se rad učita na poslužitelj, bit će dostupan samo licenciranim korisnicima.
Međutim, nije nužno da licencirani korisnici moraju imati instaliran Tableau Server na svom računalu. Oni samo zahtijevaju vjerodajnice za prijavu pomoću kojih mogu provjeriti izvješća putem web preglednika. Poslužitelj Tableau ima visoku sigurnost i vrlo je prikladan za brzo i učinkovito dijeljenje podataka u organizaciji.
Administrator organizacije uvijek će imati punu kontrolu nad poslužiteljem. Hardver i softver održava organizacija.
Tableau Cloud
Tableau Cloud, known as Tableau Online until 2022, is the hosted sharing service. Its functionalities are similar to Tableau Server, but the data is stored on servers hosted in the cloud which are maintained by the Tableau group, so no hardware has to be sized, patched, or upgraded by the customer.
Tableau Cloud connects directly to dozens of cloud-hosted data sources such as MySQL, košnica, Amazon Redshift, Snowflake, Databricks, and Spark SQL, and the connector list grows with each release.
To publish, both Tableau Cloud and Server require the workbooks created by Tableau Desktop. Data that is streamed from web applications such as Google Analytics and Salesforce is also supported by Tableau Server and Tableau Cloud.
Čitač Tableau
Tableau Reader je besplatni alat koji vam omogućuje pregled radnih knjiga i vizualizacija stvorenih pomoću Tableau Desktop ili Tableau Public. Podaci se mogu filtrirati, ali uređivanje i izmjene su ograničene. Sigurnosna razina u Tableau Readeru je nula jer je svatko tko dobije radnu knjigu može vidjeti pomoću Tableau Readera.
Ako želite dijeliti nadzorne ploče koje ste izradili, primatelj bi trebao imati Tableau Reader za pregled dokumenta.
Tableau Licensing: Creator, Explorer, and Viewer
Which products a person can actually open is decided by the licence attached to their account rather than by a separate installer. Since 2018 Tableau has sold three role-based seats, and every deployment mixes them.
| Sjedište | Što uključuje | Tipičan korisnik |
|---|---|---|
| Creator | Tableau Desktop, Tableau Prep Builder, and full web authoring on Server or Cloud. Can connect to new data sources and publish them. | Analyst or developer who builds data sources and dashboards from scratch |
| istraživač | Web authoring on published data sources, editing existing workbooks, creating alerts and subscriptions. No Desktop or Prep Builder. | Power user who reshapes existing dashboards but does not model new data |
| Viewer | Reading published dashboards, filtering, commenting, exporting, and subscribing. No authoring. | Manager or stakeholder who consumes reports |
Most organisations buy a few Creator seats, more Explorer seats, and Viewer seats for everyone else. Tableau Pulse, which pushes metric changes and plain-language explanations to users, is bundled with these seats rather than sold separately.
Kako funkcionira Tableau?
Tableau povezuje i extracts the data stored in various places. It can pull data from any platform imaginable. A simple database such as an excel, pdf, to a complex database like Oracle, baza podataka u oblaku kao što je Amazon Web usluge, Microsoft Azure SQL baza podataka, Google Cloud SQL i razni drugi izvori podataka mogu biti npr.trackreirano od strane Tableaua.
When Tableau is launched, ready data connectors are available which allows you to connect to any database. Depending on the version of Tableau that you have purchased the number of data connectors supported by Tableau will vary. The mechanics of each connection type are covered separately in the guide to Tableau data connections.
Izvučeni podaci mogu biti povezani uživo ili eksternotracted to the Tableau’s data engine, Tableau Desktop. This is where the Data analyst, data engineer work with the data that was pulled up and develop visualizations. The created dashboards are shared with the users as a static file. The users who receive the dashboards views the file using Tableau Reader.
The data from the Tableau Desktop can be published to the Tableau server. This is an enterprise platform where collaboration, distribution, governance, security model, automation features are supported. With the Tableau server, the end users have a better experience in accessing the files from all locations be it a desktop, mobile or email. The component-level detail of that platform is set out in the Tableau architecture slom.
Tableau Upotreba
Slijede glavne upotrebe i primjene Tableaua:
- Business Intelligence
- Statistike
- Suradnja podataka
- Miješanje podataka
- Analiza podataka u stvarnom vremenu
- Prijevod upita u vizualizaciju
- Za uvoz velikih podataka
- Za izradu podatkovnih upita bez koda
- Za upravljanje velikim metapodacima
Because several of these uses overlap with a spreadsheet, the comparison below sets out where each tool is the better choice.
Excel vs. Tableau
I Excel i Tableau su alati za analizu podataka, ali svaki alat ima svoj jedinstveni pristup istraživanju podataka. Međutim, analiza u Tableau je moćnija od excela.
Excel radi s redovima i stupcima u proračunskim tablicama, dok Tableau omogućuje istraživanje podataka u Excelu pomoću značajke povlačenja i ispuštanja. Tableau formatira podatke u grafikone, slike koje su lako razumljive.
| Parametri | nadmašiti | Tablo |
|---|---|---|
| Svrha | Aplikacija za proračunske tablice koja se koristi za manipuliranje podacima. | Savršen alat za vizualizaciju koji se koristi za analizu. |
| Upotreba | Najprikladnije za statističku analizu strukturiranih podataka. | Najprikladniji za brzo i jednostavno predstavljanje velikih podataka koji pomažu u rješavanju problema velikih podataka. |
| Izvođenje | Umjerena brzina bez mogućnosti ubrzavanja. | Umjerena brzina s opcijama za optimizaciju i poboljšanje napretka operacije. |
| Sigurnost | Ugrađena sigurnosna značajka slaba je u usporedbi s Tableauom. Sigurnosno ažuriranje potrebno je redovito instalirati. | Opsežne opcije za zaštitu podataka bez skriptiranja. Ugrađene su sigurnosne značajke poput sigurnosti na razini retka i dopuštenja. |
| Korisničko sučelje | Da biste iskoristili excel do punog potencijala, potrebno je osnovno poznavanje makro i vizualnih skripti. | Alat se može koristiti bez ikakvog znanja kodiranja. |
| Poslovna potreba | Najbolje za pripremu on-off izvješća s malim podacima | Najbolje dok radite s velikim podacima. |
| Proizvodi | U paketu s MS Office alatima | Comes with different versions such as Tableau Server, Tableau Cloud, and Tableau Desktop. |
| Integracija | Excel integrates with a few dozen add-ins and connectors | Tableau integrates with hundreds of native data connectors |
| Istraživanje podataka u stvarnom vremenu | Kada radite u excelu, trebate imati predodžbu o tome kamo vas podaci vode da biste upoznali uvide | In Tableau, you are free to explore data without even knowing the answer that you want. With the in-built features like data blending and drill-down, you will be able to determine the variations and data patterns. |
| Jednostavne vizualizacije | Kada radimo u excelu, prvo manipuliramo podacima koji su prisutni, a zatim se vizualizacija kao što su različiti grafikoni, grafikoni kreiraju ručno. Kako bi vizualizacije bile lako razumljive, trebali biste dobro razumjeti značajke excela. | Dok se u Tableau podaci vizualiziraju od početka. |
Za kraj, Tableau tuče nadmašiti in major areas like the interactive dashboards, visualizations, capabilities to work with large-scale data and many more. Readers weighing a wider shortlist can compare it against other alati poslovne inteligencije i protiv Power BI prije počinjenja.
