OVERVIEW
To provide hands-on fundamental knowledge and new skillsets to upskill participants on the interaction and convergence of AI and IOT (AIOT at work place to support their industries to embarked into digitalization applying one of the most important technology for Fourth Industrial Revolution (4IR) in operation, communication, and data management as well as recognizing smart solution requirements and possibilities for improving monitoring, maintenances, work efficiency, workflow and productivity thru AI integration.
Over the course of two days, this training program will cover the essential principles of data management and visualization, with a particular focus on IOT and AI ERP systems. Participants will gain a foundational understanding of IOT and AI and will have the opportunity to engage in hands-on learning with ERP sample data software, learning to integrate an IOT system to collect sensor data, process it using power software, and deliver the processed data to an IOT platform. In the final project, participants will work on integrating an AI-induced IOT gateway system and platform that is relevant to their industry, using Google Spreadsheets for data collection and storage, as well as data visualization and analytics.
LEARNING OBJECTIVE
The learning objectives for this training program are as follows:
- Gain a foundational understanding of IoT and its applications in data collection and exchange.
- Learn how to integrate IoT devices with Excel to collect real-time data for analysis and visualization.
- Understand how to analyze and interpret data from IoT devices using Excel’s data analysis tools.
- Learn how to create dynamic and interactive dashboards in Excel using data from IoT devices.
- Explore case studies and examples of how IoT data can be used to improve manufacturing efficiency, quality control, energy consumption, and building automation.
- Understand the basics of data visualization in Power BI and how it can be used to create real-time, interactive dashboards from IoT data.
To use IoT data in Excel for data visualization, you would first need to collect and store the data from your IoT devices using an appropriate IoT platform or application programming interface (API). You can then import the data into Excel and use its built-in data visualization tools, such as charts and graphs, to create interactive dashboards that allow users to explore and analyze the data in real-time. Additionally, Excel users can also integrate their data with other business systems and software, such as Power BI, to create even more advanced dashboards and reports.
LEARNING OUTCOME
By the end of the training, participants should be able to confidently create and manipulate large data sets, create custom charts and graphs, analyze data using advanced statistical functions and tools, automate repetitive tasks using macros, collaborate with others on Excel 365 workbooks, and have a basic understanding of Power Query and Dashboard Reporting & Visualisation.
WHO SHOULD ATTEND
The target audience for the above training program would be professionals working in the manufacturing industry who are interested in learning how to collect, analyze, and visualize data from IoT and ERP sources. This would include individuals who work in manufacturing operations, supply chain management, quality control, logistics, and other related fields. It would also be suitable for data analysts and IT professionals who work with data in the manufacturing industry. The program would be designed to accommodate participants with a range of skill levels, from beginners to advanced users.
SAMPLE
ERP system for clothing manufacturing and cutting machines and sewing, you can extract data from the system and use Excel for data analysis and visualization. Here are some steps to get started:
- Identify the data that you need to extract from the ERP system, such as production data, inventory data, sales data, etc.
- Export the data from the ERP system into Excel. Most ERP systems allow you to export data in a standard format, such as CSV or Excel format.
- Clean and transform the data using Excel’s data cleansing and transformation tools. This includes removing duplicates, filtering, sorting, and converting data types.
- Analyze the data using Excel’s built-in data analysis tools, such as pivot tables, charts, and graphs. You can use these tools to identify trends, patterns, and outliers in the data.
- Create data visualizations using Excel’s chart and graphing tools. This includes creating bar charts, line charts, scatter plots, and more.
- Once you have created your data visualizations in Excel, you can use Power BI to create more advanced dashboards and visualizations. Power BI is a powerful business intelligence tool that allows you to create interactive dashboards, reports, and visualizations that can be shared with others.
COURSE OUTLINE
Day 1: Introduction to IoT and Big Data
- Overview of IoT and its applications
- Understanding big data and its importance in IoT
- Types of data generated by IoT devices
- Challenges in managing and analyzing big data in IoT
Big Data Analytics in IoT
- Introduction to big data analytics in IoT
- Data processing and storage techniques for big data in IoT
- Real-time analytics for IoT data
- Tools and technologies for big data analytics in IoT
IoT Data Visualization and Reporting
- Introduction to data visualization in IoT
- Creating dashboards for IoT data
- Best practices for IoT data reporting and communication
- Tools and technologies for IoT data visualization and reporting
Applications of Big Data in IoT
- Understanding the business value of big data in IoT
- Case studies of successful big data implementations in IoT
- Applications of big data in various industries, such as manufacturing, healthcare, and smart cities
- Developing a big data strategy for IoT implementation
Hands-On Workshop
- Hands-on practice with tools and technologies for managing, analyzing, and visualizing big data in IoT
- Group project to develop a big data solution for an IoT use case
- Presentation of group projects and feedback
Topic: Introduction to IoT and ERP Data Collection for Manufacturing Module 1: Overview of IoT in Manufacturing
- Definition of IoT and its use in manufacturing
- Examples of IoT in manufacturing
- Benefits of IoT in manufacturing
- Module 2: ERP Data Collection for Manufacturing
What is ERP?
- Types of data collected by ERP systems
- Importance of ERP in manufacturing
- Module 3: IoT and ERP Integration
- Importance of integrating IoT and ERP data
- Tools and methods for integrating IoT and ERP data
- Case studies of successful IoT and ERP integration in manufacturing
- Module 4: Big Data Analysis in Manufacturing
Day 2: What is big data?
- Types of big data in manufacturing
- Tools and methods for analyzing big data in manufacturing
Topic: Exploring Tools for Data Visualization in Excel 365 and Power BI”
Module 1: Introduction to Excel 365 and Power BI
- Overview of Excel 365 and Power BI (Business Intelligent)
- Differences between Excel and Power BI
- Benefits of using Excel and Power BI for data visualization
- Module 2: Excel 365 Data Visualization Techniques
- Creating charts and graphs in Excel
- Using conditional formatting to highlight data trends
- Using PivotTables and PivotCharts for data analysis
- Module 3: Power BI Data Visualization Techniques
Introduction to Big Data in IoT and Power Query
- Overview of Big Data in IoT and its applications
- Introduction to Power Query and its features
- Importing data from various sources into Excel
- Using Power Query to clean and transform data
Advanced Power Query Techniques for Big Data in IoT
- Working with complex data structures
- Combining data from multiple sources
- Creating custom functions and transformations
- Managing and optimizing data connections
- Using Power Query to create automated workflows
Overview of Power BI Desktop
- Connecting to data sources
- Creating interactive reports and dashboards in Power BI
- Module 4: Real-Time Dashboard Reporting with Power BI
Introduction to real-time reporting in Power BI
- Setting up data refresh intervals
- Publishing reports and dashboards to Power BI service
- Module 5: Final Project
Big Data Analysis and Visualization with Power BI
- Introduction to Power BI and its features
- Connecting to Big Data sources with Power BI
- Building interactive dashboards and reports
- Using advanced data modeling techniques
- Publishing and sharing Power BI reports
Throughout the course, there will be hands-on exercises and real-world examples to reinforce the concepts and techniques covered. By the end of the course, participants will have a solid understanding of how to use Power Query and Power BI to effectively analyze and visualize Big Data in IoT.
Participants will work in groups to create a final project using data from a sample manufacturing company
They will collect data from IoT and ERP sources and analyze it in Excel and Power BI to create an interactive dashboard report with real-time updates
This 2-day training program will cover the fundamentals of IoT and ERP data collection for manufacturing, the integration of IoT and ERP data, and the analysis of big data in manufacturing. Participants will also learn the best practices for data visualization in Excel 365 and Power BI and how to create interactive dashboard reports with real-time updates. The final project will provide hands-on experience in collecting, analyzing, and visualizing data from IoT and ERP sources to create an interactive dashboard report.
