Basic Guidelines

Welcome to DatViz AI, a data analytics application powered by OpenAI model ChatGPT4. Using natural conversation, you can ask DatViz AI to simplify or summarize your data, calculate summary statistics, and generate clear and intuitive visualizations. It can be used in any field requiring quick data analysis and visualization. DatViz AI can also be integrated into decision-making and planning processes in business, government, not-for-profit, education and research institutions.

For the initial launch, users are given free 7,000 credits (or tokens). When your credits run out, you will have to wait for the next month to get a new loading of 7,000 credits. When the Professional Plan is completed, you will have an option to either wait for the following month or upgrade to Professional Plan. The number of credits you use depends on the number of words used in prompts and length of output. A regular chart will use up 200 credits.

To use DatViz AI effectively, you should be familiar with your data, understand the context in which it was collected, and have some basic understanding of statistics. It is also important to have clear goals for analyzing your data.

Source of Sample Data is Retail_Transaction_Dataset.csv (from Kaggle) but has been mocked up to include some meaningful variables for meaningful analysis such as locations "Long" and "Lat" and "Marketing Promotions".

Uploading Your Data File

1. First and foremost, if you have sensitive information in your dataset, we suggest either deleting that column or using some record ID that will camouflage the data, but stilll make sense to your data visualization and analysis.

2. Ensure Your Data is Clean: Remove missing values, typographical errors, and superfluous characters. Although data cleansing will be introduced in future updates, if you can, address outliers outside of DatViz AI, then re-upload your data.

3. Use Only One Header: Your data should have a single, clear header, and all columns must have a label.

4. Column and Row Organization: Columns represent variables, and rows represent observations.

5. Name Columns Properly: Use short, meaningful names for each column.

6. Column Name Sensitivity: DatViz AI is not column name and character sensitive, but it is advisable to use the exact names from your header.

7. Longitude and Latitude columns: To enable geomapping, ensure Latitude (Lat) and Longitude (Long) columns are present in your data.

Data Exploration

DatViz AI provides the user an instant data exploration output describing your data comprehensively. By clicking on the "statistics" icon, it will show the number of rows, columns and missing values. It also shows the variables and their data types such as quantitative and qualitative, continuous and discrete.

Moreover, it calculates summary statistics of all numeric variables given in a table format.

Data Visualization

Data visualization is the art and science of turning raw data into visual representations that are easy to understand and interpret. Here is why data visualization is heart of data analysis:

1. Simplifies complex data and helps condense large and complex datasets into visual formats like charts, graphs, and maps that are easier to understand.

2. Enables identification of Patterns and Trends: By visualizing data, you can quickly spot trends, correlations, and outliers that might not be obvious in raw data.

3. Makes Data Accessible: Visualization makes data more accessible to a wider audience, including those who might not have a technical background.

4. Facilitates Decision Making: Visual data aids in faster and more informed decision-making by highlighting key insights and metrics.

5. Tells a Story: Effective visualizations can tell a compelling story with data, making it easier to communicate findings and insights to others.

DatViz AI provides sample prompts to help you in data visualization, but you should be able to write your own prompt.