Difference between revisions of "Excel Importing Guide/en"

From TaticView
Jump to: navigation, search
(Created page with "A normalização de dados (quando cabeçalhos podem ser convertidos em dados de uma coluna) resultará em melhores análises.")
(Updating to match new version of source page)
 
(27 intermediate revisions by the same user not shown)
Line 1: Line 1:
−
As instruções abaixo irão ajudá-lo a formatar corretamente seus arquivos Excel para importação no TaticView.
+
<languages/>
  
  
−
'''É possível baixar um arquivo de exemplo formatado corretamente em: [http://wiki.taticview.com/taticfiles/Sales.xlsx Sales.xlsx]'''
+
The instructions below will help you make sure your Excel file is formatted correctly to be imported as a TaticView datasource.
  
−
'''Se após seguir o guia, ainda ocorrerem problemas de importação, verifique [[Importing Problems/pt-br|Problemas de Importação]].'''
 
  
 +
'''You can download a sample file here: '''[[Special:FilePath/Sales.xlsx|Sales.xlsx]]'''
  
−
'''Cabeçalhos'''
+
'''If you still have problems importing, try [[Importing Problems]].'''
  
−
Cabeçalhos não são obrigatórios, mas se estiverem presente devem estar em uma única linha (a primeira) e não estarem em células mescladas.
+
 
 +
'''Headers'''
 +
 
 +
Headers are not mandatory, but if present they should be contained in just one row (the first one) and not be in merged cells.
  
  
Line 16: Line 19:
  
  
−
'''Evite Múltiplas Tabelas'''
+
'''Avoid Multiple Data Tables'''
  
−
Apenas uma tabela por planilha pode ser importada. Se os dados de diferentes tabelas não podem ser consolidados, então elas devem ser importadas como diferentes fontes de dados.
+
Only one table by spreadsheet can be imported. If the data in two different tables can not be joined, they must be imported as two separated datasources.
  
  
Line 25: Line 28:
  
  
−
'''Corrija/Remova Linhas/Colunas Vazias'''
+
'''Fix/Remove Empty Rows/Columns'''
  
−
Remova ou corrija (adicionado ao menos um cabeçalho) linhas e colunas totalmente em branco.
+
Remove or Fix (by adding at least a header) to full empty rows and columns.
  
  
Line 34: Line 37:
  
  
−
'''Remova Células Mescladas'''
+
'''Remove Merged Cells'''
  
−
Os dados não devem estar contidos em células mescladas. Todas células devem ser separadas e os valores repetidos para cada célula.
+
Data should not contain merged cells for repeated values. All cells must be unmerged and values must be repeated for each cell.
  
  
Line 43: Line 46:
  
  
−
'''Remova Linhas Totalizadoras'''
+
'''Remove Aggregate Rows'''
  
−
Os arquivos não devem conter linhas totalizadoras (agregadoras) como total e média.O TaticView fará todos os cálculos necessários em tempo de execução.
+
Files should not contain aggregation rows cells for repeated values. Delete that rows, as TaticView will make all necessary aggregations in run-time.
  
  
Line 52: Line 55:
  
  
−
'''Remova Elementos Externos'''
+
'''Remove All Table External Items'''
  
−
Os arquivo a serem importados devem conter apenas a tabela de dados. Toda informação não relacionada, como informações, imagens, gráficos devem ser removidos antes da importação.
+
Files should only contain the data table to be imported. All non-related data, as main headers, images, charts, must be removed prior to importing.
  
  
Line 61: Line 64:
  
  
−
'''Verifique Campos Númericos'''
+
'''Check for Invalid Numeric Data'''
  
−
Colunas numéricas devem ser formatadas de acordo no Excel. Campos numéricos (de valor) não podem conter textos ou símbolos. Células sem data, devem estar em branco ou com zero (0).
+
Numeric columns should be formatted in Excel prior to uploading the file. This can be done by using the “Convert to number” feature in Excel for all numeric fields. [[Value]] data fields can not contain text or symbols, as they cannot be aggregated. When data is not available, cells may be left blank or as zero (0).
  
  
Line 70: Line 73:
  
  
−
'''Normalize seus Dados'''
+
'''Normalize your Data'''
  
−
A normalização de dados (quando cabeçalhos podem ser convertidos em dados de uma coluna) resultará em melhores análises.
+
Normalization of data (where column headers can be converted into attribute values) will result in better analysis. To do this, first convert metric names to represent attribute values, and then consolidate all metric columns into a single column of data.
  
  
 
[[File:normalization_wrong.png|link=]] [[File:normalization_right.png|link=]]
 
[[File:normalization_wrong.png|link=]] [[File:normalization_right.png|link=]]
 +
 +
 +
'''Check the order of the worksheet'''
 +
 +
If the file (XLS or XLSX) has more than one worksheet (tab), make sure that the worksheet to be imported is the first one in the file. TaticView considers only the first worksheet (tab) of the file, ignoring the others. In the example below, we show how the order of the worksheets should be, so that we can import the '''Sales''' worksheet.
 +
 +
[[File:spreadsheet_order_wrong.png|link=]] [[File:spreadsheet_order_right.png|link=]]

Latest revision as of 02:28, 5 October 2022

Other languages:
English • ‎português do Brasil


The instructions below will help you make sure your Excel file is formatted correctly to be imported as a TaticView datasource.


You can download a sample file here: Sales.xlsx

If you still have problems importing, try Importing Problems.


Headers

Headers are not mandatory, but if present they should be contained in just one row (the first one) and not be in merged cells.


Headers wrong.png Headers right.png


Avoid Multiple Data Tables

Only one table by spreadsheet can be imported. If the data in two different tables can not be joined, they must be imported as two separated datasources.


Multipletables wrong.png Multipletables right.png


Fix/Remove Empty Rows/Columns

Remove or Fix (by adding at least a header) to full empty rows and columns.


Emptyrowcolumns wrong.png Emptyrowcolumns right.png


Remove Merged Cells

Data should not contain merged cells for repeated values. All cells must be unmerged and values must be repeated for each cell.


Mergedcells wrong.png Mergedcells right.png


Remove Aggregate Rows

Files should not contain aggregation rows cells for repeated values. Delete that rows, as TaticView will make all necessary aggregations in run-time.


Summaryrows wrong.png Summaryrows right.png


Remove All Table External Items

Files should only contain the data table to be imported. All non-related data, as main headers, images, charts, must be removed prior to importing.


Unrelatedinfo wrong.png Unrelatedinfo right.png


Check for Invalid Numeric Data

Numeric columns should be formatted in Excel prior to uploading the file. This can be done by using the “Convert to number” feature in Excel for all numeric fields. Value data fields can not contain text or symbols, as they cannot be aggregated. When data is not available, cells may be left blank or as zero (0).


Nonnumeric wrong.png Nonnumeric right.png


Normalize your Data

Normalization of data (where column headers can be converted into attribute values) will result in better analysis. To do this, first convert metric names to represent attribute values, and then consolidate all metric columns into a single column of data.


Normalization wrong.png Normalization right.png


Check the order of the worksheet

If the file (XLS or XLSX) has more than one worksheet (tab), make sure that the worksheet to be imported is the first one in the file. TaticView considers only the first worksheet (tab) of the file, ignoring the others. In the example below, we show how the order of the worksheets should be, so that we can import the Sales worksheet.

Spreadsheet order wrong.png Spreadsheet order right.png

Retrieved from "http://wiki.taticview.com/index.php?title=Excel_Importing_Guide/en&oldid=29864"