data pivot

[/ˈdeɪtə ˈpɪvət/]
nounpl: data pivots
tabela dinâmica
1. A data summarization tool that automatically sorts, counts, totals or gives the average of the data stored in one table or spreadsheet, displaying the results in a second table showing the summarized data
I created a data pivot to analyze sales by region and product category.
Criei uma tabela dinâmica para analisar as vendas por região e categoria de produto.
2. A strategic shift in how data is organized, analyzed, or presented to gain new insights
The company performed a data pivot to focus on customer behavior rather than just transaction volume.
A empresa fez uma mudança estratégica nos dados para focar no comportamento do cliente em vez de apenas volume de transações.
The term 'data pivot' is primarily used in technical and business contexts in both English-speaking countries and Brazil. In Microsoft Excel, the feature is officially called 'Pivot Table,' which led to the Portuguese adoption of 'tabela dinâmica.' The concept became increasingly popular with the rise of business intelligence and data analytics in corporate environments during the 2000s-2010s.
Synonyms / Sinônimos
pivot tablecross-tabulationdata summarizationcrosstab

Regional Variations

General Brazilian
tabela dinâmica
Most common term used in business and technical contexts
São Paulo
tabela dinâmica
Standard usage in corporate environments
Portugal
tabela dinâmica
Same as Brazilian Portuguese; technical term is standardized
General English (USA)
data pivot
Commonly used in Excel and business intelligence contexts

Related Words

spreadsheetdata analysisdata visualizationaggregationOLAP
Look up more words on Fala2Me
The free English-Portuguese dictionary with real Brazilian accents, NYC slang, conjugator and more
Open Fala2Me →