DataManagement_DENR-EMB.pptx grade 11 and 12

ppt

1. Data Intelligence: The Key to Success in the Digital Age By Jonathan O. Jacobo Director, Digital Transformation Office Director, Administrative Management Services USTP System

2. Learning Objectives: Define data and datatypes Explain the importance of data management and database management Discuss real-world examples of data management and database management in use Identify the latest technologies for optimizing data, data analytics, and visualization Practical Use of AI in data and information management

3. Data VS Information? Data is any raw, unprocessed fact or observation. It can be in the form of numbers, text, images, audio, or video. Information is processed data that has been organized and interpreted in a way that makes it meaningful.

4. Data gathered while using your Cellphone Scenario Data gathered Taking a picture Image data, date and time, location, camera settings Using a navigation app Location data, speed, direction of travel Using a social media app Activity data (posts viewed, people interacted with, content shared), device information (IP address, operating system), network information (cellular network, Wi-Fi networks) Using a streaming app Viewing history, content watched, watch time, device information, network information Making a phone call Phone number dialed, call duration, time and date of call, device information, network information Sending or receiving a text message Phone number texted, text message content, time and date of message, device information, network information Using a fitness tracking app Location data, steps taken, calories burned, heart rate, other health data Using a weather app Location data, current weather conditions, forecast Using a ride-sharing app Location data, pickup and drop-off locations, estimated time of arrival

5. Data gathered while using your Cellphone Cellphone sensors can also collect the following environmental data: Ambient light level Ambient noise level Air quality Temperature Humidity Atmospheric pressure Magnetic field strength Acceleration Rotation

6. “Some cellphone apps are listening while you are using the phone for marketing, advertisement, and exploitation” This is because some apps have access to your phone's microphone and can record audio even when the app is not open.

7. Examples of Companies and Businesses that Rely on Data Google - uses data to improve its search engine, target advertising, and develop new products. Amazon - uses data to recommend products to customers, optimize its supply chain, and improve its customer service. Netflix - uses data to recommend movies and TV shows to customers, develop new content, and improve its streaming service

8. Datatypes Datatypes are used to classify different types of data. Some common datatypes include: Integer: A whole number, such as 123 or -456 Float: A number with a decimal point, such as 3.14 or -5.678 String: A sequence of characters, such as "Hello, world!" or "This is a sentence." Boolean: A value that can be either true or false

9. Data Management Data management is the process of collecting, storing, organizing, and using data. It is important to manage data effectively in order to get the most out of it. . Data Method to gather data Technology used How data is used Air quality data Air quality sensors Internet of Things (IoT) devices To monitor air quality and inform public health decisions Water quality data Water quality sensors IoT devices To monitor water quality and ensure the safety of drinking water Soil moisture data Soil moisture sensors IoT devices To monitor soil moisture levels and inform irrigation decisions Weather data Weather stations Satellites, ground-based stations, radar To forecast weather conditions and inform public safety decisions Climate data Weather stations, satellites, ocean buoys Satellites, ground-based stations, ocean buoys To study long-term climate trends and inform climate change mitigation and adaptation strategies

10. Data Management Data management is the process of collecting, storing, organizing, and using data. It is important to manage data effectively in order to get the most out of it. . Data Method to gather data Technology used How data is used Noise levels Noise sensors IoT devices To monitor noise levels and reduce noise pollution Traffic congestion data Traffic sensors IoT devices To monitor traffic congestion and improve traffic flow Energy consumption data Smart meters IoT devices To monitor energy consumption and reduce energy waste Waste management data Waste bins with sensors IoT devices To optimize waste collection and reduce environmental impac

11. Database VS Database Management Database management is the process of using a database to store and manage data A database is a collection of data that is organized in a way that makes it easy to access and use. Database Type Real-world Applications Relational database management system (RDBMS) E-commerce websites, social media platforms, banking systems, and other applications that need to store and manage large amounts of structured data NoSQL database Applications that need to store and manage large amounts of unstructured or semi-structured data, such as big data analytics applications, social media applications, and content management systems Cloud database Applications that need to be scalable and accessible from anywhere in the world, such as web applications and mobile applications On-premises database Applications that need to be highly secure and have low latency, such as financial trading systems and healthcare systems In-memory database Applications that need to perform real-time data processing, such as fraud detection systems and stock trading systems

12. RDBMS and SQL A relational database management system are made up of rows and columns, and each row represents a single record. is a type of database that stores data in tables. Tables are the most common type of database used today. SQL – Structured Query Language (See- quel )

13. RDBMS and SQL Popular RDBMS Company Database Server Proprietary/FOSS Applications Oracle Oracle Database Proprietary ERP, CRM, e-commerce, and other enterprise applications MySQL MySQL Open source Web applications, e-commerce, and other content-managed websites Microsoft SQL Server Proprietary ERP, CRM, and other enterprise applications PostgreSQL PostgreSQL Open source Web applications, e-commerce, and other content-managed websites IBM DB2 Proprietary ERP, CRM, and other enterprise applications SQLite SQLite Open source Mobile applications, embedded systems, and other applications where a lightweight database is needed SAP SAP HANA Proprietary ERP, CRM, and other enterprise applications

14. RDBMS and SQL Example: Air Monitoring System

15. RDBMS and SQL Example: Climate Monitoring System

16. Latest Technologies for Optimizing Data, Data Analytics, and Visualization Cloud computing - used to store, process, and analyze large amounts of data. Big data analytics - used to analyze large and complex datasets to identify patterns and trends. Internet of Things (IoT) - is a network of physical objects that are embedded with sensors, software, and other technologies for the purpose of connecting and exchanging data with other devices and systems over the internet. Data visuaVization - used to create interactive charts and graphs that make it easy to understand data. Artificial Intelligence (AI) - used to develop machine learning models that can predict future outcomes based on historical data.

17. Data Visualization Data visualization is the process of transforming data into visual representations, such as charts, graphs, and maps. powerful tool for data analysis and communication. Understand complex data patterns and relationships Communicate data insights to others Make data-driven decisions

18. Data Visualization

19. Data Visualization Apps Tableau - has a number of AI-powered features, such as Explain Data, which provides insights into the factors that are driving trends and patterns in your data. Tableau also has a feature called Smart Insights, which automatically identifies interesting and relevant insights in your data. Power BI - has a number of AI-powered features, such as Quick Insights, which automatically generates visualizations and insights from your data. Power BI also has a feature called AI Insights, which uses machine learning to identify patterns and anomalies in your data. QlikView - has a number of AI-powered features, such as Insight Advisor, which uses machine learning to identify insights in your data. QlikView also has a feature called Cognitive Engine, which allows you to create visualizations and insights using natural language queries. ThoughtSpot - is an AI-powered analytics platform that allows you to explore and analyze your data using natural language queries. Domo - is a cloud-based business intelligence platform that uses AI to generate visualizations and insights from your data.

20. Practical Use of Artificial intelligence (AI) Applications of AI Practical use Virtual assistants (e.g., Siri, Alexa, Google Assistant) Help users with tasks such as setting alarms, reminders, and timers; playing music; controlling smart home devices; and providing information about the weather, news, and traffic. Recommendation systems (e.g., Netflix recommendations, Amazon recommendations) Suggest products, movies, and other content that users are likely to be interested in. Fraud detection systems (e.g., credit card fraud detection) Identify and prevent fraudulent transactions. Self-driving cars Transport people and goods without the need for human drivers. Image recognition systems Identify and classify objects in images and videos. This can be used for a variety of tasks, such as facial recognition, object detection, and medical diagnosis. Natural language processing (NLP) systems Understand and generate human language. This can be used for a variety of tasks, such as machine translation, text summarization, and chatbots. AI-powered search engines Provide more relevant and informative search results. AI-powered medical diagnosis and treatment systems Help doctors diagnose diseases and recommend treatments more accurately and efficiently. AI-powered education tools Provide personalized learning experiences and feedback to students. AI-powered customer service tools Help customer service representatives provide better support to customers. AI-powered entertainment systems Generate creative content, such as music, stories, and poems, and play games with users.

21. Practical Use of Artificial Intelligence (AI) Chat-based AI Strength Weakness ChatGPT Generative capabilities, factual accuracy, human-like responses Can be biased or generate harmful content Bard (Google AI) Vast knowledge base, ability to answer questions in a comprehensive and informative way, ability to generate different creative text formats Still under development, can sometimes generate incorrect or misleading information Perplexity Ability to have open ended conversations, ability to learn and adapt over time Can be slow at generating responses YouChat Engaging and informative responses, ability to generate different creative text formats Can be less accurate than other AI models KoalaChat Friendly and compassionate responses, ability to provide support and companionship Can be less versatile than other AI models Jasper Chat Ability to generate high-quality marketing copy, ability to create personalized content Can be expensive to use Replika Ability to form emotional bonds with users, ability to provide companionship and support Can be addictive or harmful to users Mitsuku Ability to engage in complex and interesting conversations, ability to generate different creative text formats Can be biased or generate harmful content Cleverbot Ability to have humorous and creative conversations, ability to learn from its interactions with users Can be less informative than other AI models XiaoIce Ability to generate realistic and engaging conversations, ability to provide companionship and support Only available in Chinese LaMDA (Google AI) Ability to generate human-quality text in response to a wide range of prompts and questions, ability to follow instructions and complete requests thoughtfully Still under development, can sometimes generate incorrect or misleading information Meena (Google AI) Ability to carry on conversations that are more human-like and engaging, ability to learn and adapt over time Still under development, can sometimes generate incorrect or misleading information

22. Practical Use of Artificial Intelligence (AI) In Software Development, these AI chat applications can be very helpful for programmers of all skill levels. They can help you to write code faster and more efficiently, and they can also help you to learn new programming languages and concepts. MS.NET IDE Copilot/GitHub Copilot:  GitHub Copilot is an AI assistant that helps developers write code faster and more efficiently. It can suggest code completions, generate entire functions, and even help with debugging. CodeT5:  CodeT5 is an AI model that can translate code between different programming languages and can also generate code from natural language descriptions. Tabnine :  Tabnine is an AI code completion tool that can suggest code completions, generate entire functions, and even help with debugging. Replit Ghostwriter:  Replit Ghostwriter is an AI code completion tool that can suggest code completions, generate entire functions, and even help with debugging. OpenAI Codex:  OpenAI Codex is a powerful AI model that can generate code, translate languages, and answer questions in an informative way.

23. Conclusions Data is the new currency, one of the most valuable assets that a business has. By managing data effectively and using the latest technologies, businesses can gain insights that can help them make better decisions and improve their bottom line. Data intelligence is the ability to collect, analyze, and use data to make better decisions.

24. Thank you!