After choosing the correct floor plan for composition, relationship, geographic data, chimney / conversion, aliases travel betwixt categories, the adjacent question and reply mobility is really Tableau turns information into that view. Tableau fundamentals matter because analysts are expected to explicate the architecture flow, halfway dashboard features, and particularly LOD expressions successful applicable dashboarding interviews.
- Tableau Architecture Flow moves from Data Source - DB, CSV, API - to Data Engine, VizQL Engine, Visualization, and Dashboard.
- Data Engine uses Hyper Extract earlier the VizQL Engine converts activity into Visual Query Language.
- Visualization is built done Marks and Shelves, while Dashboard includes Actions and Filters.
- Calculated Fields are civilization formulas wrong Tableau utilizing IF, CASE, STRING, and DATE functions.
- LOD: FIXED computes astatine a circumstantial magnitude sloppy of position level of item and is HIGH - astir asked.
- LOD: INCLUDE and LOD: EXCLUDE are some precocious question and reply value features for much granular aliases little granular calculations.
- Table Calculations, Sets, Parameters, Dashboard Actions, and Data Blending information retired the applicable Tableau characteristic set.
Tableau Architecture Flow
The large image successful Tableau starts pinch the information root and ends pinch dashboards that support actions and filters. The architecture travel is useful successful interviews because it shows really earthy inputs specified arsenic DB, CSV, and API information move done Tableau earlier becoming interactive ocular analysis.
Tableau Features Analysts Must Know
Tableau fundamentals are champion understood arsenic a characteristic map: what each characteristic does, erstwhile to usage it, and really important it is successful interviews. Level of Detail, aliases LOD, expressions merit typical attraction because FIXED is marked HIGH - astir asked, while INCLUDE and EXCLUDE are besides precocious importance.
How LOD Expressions Fit Practical Dashboarding
LOD: FIXED computes astatine a circumstantial magnitude sloppy of position level of detail. A applicable illustration is customer-level gross connected order-level data: {FIXED [Cust_ID]: SUM([Revenue])}.
LOD: INCLUDE adds a magnitude to the calculation much granular than the existent view. It is useful for mean orders per customer wrong each region.
LOD: EXCLUDE removes a magnitude from calculation little granular than the existent view. It is useful erstwhile comparing an individual merchandise to class average.
How Other Tableau Features Support Analysis
Calculated Fields create civilization formulas wrong Tableau utilizing IF, CASE, STRING, and DATE functions. They are utilized for derived metrics not successful root information and are a mean question and reply value characteristic pinch basal expectation.
Table Calculations are post-aggregation calculations specified arsenic Running Total, % Difference, Rank, and Index. They are utilized for YoY%, moving revenue, and cumulative cohort retention.
Sets create move groupings based connected conditions, specified arsenic conception apical 10% customers and comparison In-set vs Out-of-set. Parameters create user-controlled inputs that alteration position dynamically, specified arsenic selecting metric Revenue / Units / Orders from a dropdown.
Dashboard Actions see Filter, Highlight, and URL actions connected personification interaction. Data Blending combines information from aggregate sources without a database join, specified arsenic a superior information root from DB and a secondary root from an Excel reference table.
Structuring a Tableau Fundamentals for Analysts Interview Answer
"Walk maine done Tableau Architecture Flow and explicate which Tableau features matter astir erstwhile building an expert dashboard."
Do not database Tableau features without their usage cases. Interview answers go stronger erstwhile each characteristic is tied to what it does, erstwhile to usage it, and its question and reply importance.
The astir predominant correction is treating each Tableau features arsenic as important successful interviews. LOD: FIXED is HIGH - astir asked, while Dashboard Actions and Data Blending are Low, truthful missing the LOD favoritism tin costs points.
Conclusion
Tableau fundamentals are an architecture travel positive a applicable characteristic map: information moves from root to dashboard, and analysts usage features specified arsenic Calculated Fields, LOD expressions, Table Calculations, Sets, Parameters, Dashboard Actions, and Data Blending to build useful views. The last takeaway is to explicate Tableau done flow, characteristic purpose, usage case, and question and reply importance.
English (US) · 
Indonesian (ID) ·