In this video, we’ll show you how to transform a simple table of sales data into a beautiful, interactive dashboard — all with the help of ChatGPT.
How to prepare your data (CSV → JSON conversion).

- How to get visualization ideas from ChatGPT (charts, graphs, pie charts, etc.).
- How to generate and download HTML code for your dashboard.
- How to upload your data and instantly see clear insights.
- How to customize the design and verify your dashboard results with Excel.

👉Prompt 1
This is the structure of my sales data in JSON format. Understand the structure and suggest five key data visualization metrics that would be the best fit to create an interactive sales dashboard. Also explain why we should use each one?

👉 Prompt 2
Now, I want you to create an interactive sales performance dashboard with the five key visualizations using HTML and JavaScript. Use the latest version of Plotly.js CDN and include an upload feature so that we can upload the JSON file. It should generate the dashboard based on the uploaded data.
Note: I need to upload the sales data from my local computer, and it should create the dashboard based on that data.

👉 Prompt 3
Provide this as an HTML downloadable file?

👉 Prompt 4
From the dashboard you created, change the style to glass morphism. Then, adjust the padding width of the charts to 40%, and change the background color to icy blue. Can you also provide this as a downloadable HTML file?

Do like, Subscribe, if you like this dashboard !

#ExcelDashboards #ChatGPTExcel #AIDashboards #SmartDashboards #DataVisualization #AIProductivity #AutomationTools