Data Analysis Training for Beginners - AI Academy Week 4 PDF

# UPPER COASTAL PLAIN COUNCIL OF GOVERNMENTS ## DATA ANALYSIS TRAINING FOR BEGINNERS ### AI Academy Week 4 ### www.ucpcog.org # Introduction Understand the basics of data analysis. Learn how ChatGPT simplifies data-related tasks. Gain hands-on experience with ChatGPT. Develop skills to create...

# UPPER COASTAL PLAIN COUNCIL OF GOVERNMENTS ## DATA ANALYSIS TRAINING FOR BEGINNERS ### AI Academy Week 4 ### www.ucpcog.org # Introduction Understand the basics of data analysis. Learn how ChatGPT simplifies data-related tasks. Gain hands-on experience with ChatGPT. Develop skills to create meaningful visualizations from data. Explore practical examples to build confidence. Take away tips and resources for further learning. # UNDERSTANDING DATA ANALYSIS Definition: The process of examining, organizing, and summarizing information to find patterns and insights. Examples: - Tracking expenses to identify overspending categories. - Summarizing survey responses to uncover key themes. - Analyzing sales data to find monthly trends. Tip: Always ask, "What do I want to learn from this data?" # WHY SHOULD WE CARE? Using Artificial Intelligence (AI) data analysis tools can reduce the amount of time it takes human staff to go through lengthy reports. The time saved can be redirected elsewhere in the organization to focus on higher-level tasks. | Data Awareness | Effective Communication | | ---------------------------------------------------------------------- | ------------------------------------------------------------------- | | AI can quickly identify trends from the key metrics in any report. | AI can create summarized information to explain the data in any report it can read. | # THE SIMPLE STEPS Reports that contain data can be read b AI, and then quickly summarized for the user. Start the process by gathering your data files, upload them to the AI, and then asking... "Please summarize the data found in the report(s), and then give me ideas for visual charts or graphs that can be generated from it.” If you don't need a visual, you can simply ask the AI to summarize the information and provide a short description about the key metrics. | | | ----------- | | Define your goal: What do you need to know? | | Organize your data: Lists, tables, or categories. | | Identify patterns: Look for trends, averages, or outliers.| | Draw conclusions: What does it all mean? | # REAL-WORLD APPLICATION: UNDERSTANDING GENRES Scenario: Analyze a Data File A company wants to identify popular genres. You have a data file that has information from an Apple TV survey, and you can upload it to AI for analysis. Task: Summarize the top genres ChatGPT or GovAl Input: 'Count the number of movies for each genre and rank them.' ChatGPT or GovAl Output: 'Drama: 8,126, Comedy: 4,638, Romance: 2,694.' Tip: Be specific with instructions like 'rank genres by popularity.' # REAL-WORLD APPLICATION: UNDERSTANDING GENRES Additional Prompt: Create a Chart Prompt: Create a chart that identifies the top five genres. # CLASS EXERCISE Pull up Week 4 class agenda - look down at the reading and resources section, and click the link for "appletv.csv" to download the file - Open your ChatGPT or GovAl account, start a new chat, press the paper clip icon to upload appletv.csv to the AI. - Enter this prompt: “List movies rated 8.0+ and sort by number of countries available. Once done, you will perform these additional actions: - Create a bar chart to identify the top five titles available in the most countries. - Create a bar chart to identify the top five titles by the highest average IMDB rating." # DATA ANALYSIS KEY THEMES | | | ----------- | | Data analysis helps make better decisions. | | Visualizations make insights more impactful. | | Practice asking clear, actionable questions. | In order to get the best performance from data analysis in AI, remember to give it files that have complete and labeled data! You can ask AI to identify any missing data, and then run an analysis with missing or incomplete data omitted. # WHAT IS IDEOGRAM? AI Text to Image Generation A prompt-driven image generation AI for creating custom visuals. Key Image Generation Features: - Generate high-quality images quickly. - Customize elements, colors, and styles. - Create visuals with or without embedded text. - Basic plan is $8 a month to create up to 1,600 images. # HOW LOCAL GOVERNMENTS CAN USE IDEOGRAM Professional-grade images, with text and realistic people, can be generated for any scenario imaginable. - Public Awareness - Local Planning - Social Media - Training Presentations # EXAMPLES | | | | | :---------------------------------------------------------------------------------- | :--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | :------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | | Prompt: A photo of a staff training session. A group of people are sitting in a room with a whiteboard. The man standing at the whiteboard is pointing to the text he wrote there. | Prompt: A vibrant and eye-catching event poster for the "Summer Music Festival" at "Sunshine Park", "Downtown City on August 12, 2024, from 3:00 PM to 11:00 PM". The design features a lively color palette of yellow, orange, and blue, with images of musical instruments, food trucks, and summer activities like sunbathing and beach volleyball. | Prompt: A high-quality YouTube thumbnail image with a portrait view of a male spokesperson looking straight ahead at the viewer, and he has with a warm and friendly smile. He is wearing a blue shirt, and glasses. Behind him, there is a clock and a calendar on the wall. The background is a serene nature scene with tall trees and a sky. The main text is "Effective Time Management" and the subtext is "Strategies for Course Creators". The font is bold and sans-serif. | # SIGNING UP FOR IDEOGRAM Visit: https://ideogram.ai Use a Google or Apple email address to register. Create your account, and log into the lobby. # IDEOGRAM LOBBY The lobby is rated PG-13, and features images made by the entire community. # CREATING YOUR IMAGE # CRASH COURSE ON IMAGE SIZE | | | | ------------- | -------------------------------------------------------- | | 5:4 | Post Feed | | 4:3 | Post Feed | | 3:2 | Post Feed | | 1.91:1 | FB Cover | | 1:1 | Square Post | | 9:16 | Story | | 4:5 | Portrait | | 3:4 | Post Feed | | 16:9 | Landscape/ Youtube | | 2:3 | FB Vertical | | 2:1 | Twitter Post | | 3:1 | Twitter Header | | | | | ------------- | ------ | | Instagram | 1:1 | | TikTok/Youtube | 9:16 | | Shorts | | | Youtube | 16:9 | # INSTANT RESULTS! # IMAGE REVISIONS You can choose to use your previous image as a guiding example, and select how closely it should be used. If you don't like your result, select Remix and generate new versions. # LET'S TRY IDEOGRAM! Prompt Example: 'A bustling rural farmers market with colorful stalls, fresh produce, and a 'Farmers Market Open Today!' banner across the top.' Use Case: Social media promotions or flyers for events. # Q&A SESSION # THANK YOU FOR YOUR PARTICIPATION