Module-3: Data to decision – AI powered analytics & Storytelling

Module-3

Data to decision – AI powered analytics & Storytelling.  

Here we learn how to transform raw data into clear, actionable insights using AI.

 

AI Data Cleaning & Analysis Checklist:

Here we learn Data driven decision, data analysis to make the services better & grow.

Cleaning data means finding & fixing the mistakes. Before using any AI, tool don’t share any sensitive data, customer details, personal information.

For E.g. - Suppose in ChatGPT you upload one excel file and ask like clean the data in uploaded excel, format specific and fix the errors.

 

For more specific we need to use PROMPT. Like:

Data format should be in DD-MM-YYYY format, each column value should be in Capital Letters, Trim the spaces, sort data alphabetically, remove duplicate data

Once AI changes done, pls cross verify the output, don’t blindly trust on AI.

 

AI Data Cleaning & Analysis Checklist:  

Dirty Data = Bad Decisions	AI to the rescue – Cleaning & Analysis
Inaccurate Analysis	Identify Missing Values
Poor Predictions	Standardise Formats
Wasted Time & Resources	Clean Test Fields & Remove Duplicate Fields
Misleading Insights	Identify Patterns
Flawed Business Strategies	Always Double check AI Output

 

Data Detective Using AI:

Here we learn how to clean and prepare data with AI.

Using ChatGPT – you easily upload excel and with proper prompt framework, you can clean and correct data as per your requirement. ChatGPT is good for external data analysis.

Using Copilot- You also set proper data. Copilot correct data and visualise the same. You also create chart based on excel data. Copilot is excellent with excel.

Exploratory Data Analysis: Key steps with AI

AI + Spreadsheet:

Here we learn how Copilot work on excel to completely transform the data. It helps to clean analysis and visualise the data.

When you open any excel then right-side copilot icon – click and work on it.

You can also create chart based on excel data.

 

From Data to Story:

Suppose your audience are in different countries, and you want to present data in their own language tone. Then ChatGPT help us to understand the data in their own language using prompt framework.

 

Visual story telling with ChatGPT:

Suppose you are a marketing team & you want to visualize the best graphic representation to attract customers. Then ChatGPT helps you with best visualization & also use for report generation process. This helps you with your story telling different audiences.

Always double check AI generated output, don’t blindly trust. Be accurate.

Building Impactful Data Stories with AI:

 

Data for presentation:

Here we learn how ChatGPT is used for your PPT, it helps you to prepare the slides with visualization effects using prompt framework. You can mention specific information to generate each slide. You can also use copilot for this presentation purpose.

 

 

Presentation – Copilot in PowerPoint:

When you start the PowerPoint presentation, select copilot icon at top, mention all the details what you want to generate the slides, also you can select the reference document. Once you get slides information then simply click on the generate button. You can modify the specific slides as per your choice.