|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/quality-analytics/
课程评论：没有评论
**课程摘要：两种质量分析法捆绑课程** 本課程捆綁包匯集了兩門最受歡迎的課程，為品質管理學生提供新穎且令人興奮的價值。 **第一部分：Excel 資料分析入門** 您將在此部分成為 Excel 大師，掌握從基本的 Excel 導覽和工作表函數，到更有意義和探索性的應用，包括： * **資料視覺化：** 學習製作各種圖表，如長條圖、折線圖、組合圖等，以直觀展示數據。 * **樞紐分析表：** 掌握利用樞紐分析表進行根本原因分析、類別分析和比較分析。 * **統計學應用：** 深入學習包括假設檢定、蒙地卡羅模擬等統計方法。 **第二部分：品質分析的實際應用** 在掌握 Excel 技能後，您將把資料分析技能應用於品質管理的實際業務營運中，學習： * **統計製程管制 (SPC)：** 理解 SPC 的概念及其在提升和預測業務績效方面的作用。 * **Excel 中的管制圖：** 學習在 Excel 中創建管制圖（含數據視覺化和不含數據視覺化），以監控製程穩定性。 * **製程能力分析：** 了解如何評估業務滿足和超越客戶容差與期望的能力。 總之，本課程旨在幫助您精通 Excel 資料分析工具，並將這些知識轉化為提升業務品質和績效的實用能力。
This 2 course bundle includes the best of both worlds as two of the most popular courses in my catalog are combined to bring novel and exciting value to students of quality management. First, students will be introduced to Excel through the data analytics course. Here they will become masters of the Excel environment. Students will learn everything from the basics of excel navigation and worksheet functions, to the more meaningful and exploratory applications of excel such as data visualizations (Bar charts, line charts, combo charts and more), pivot tables for root cause analysis, category analysis and comparative analysis,, statistics including hypothesis testing, monte Carlo simulation and much more. Then, after the mastery of excel, students will take on exciting topics of quality analytics. Students of this course will apply the data analytics curriculum to real world applications of quality management for business operations. Topics within this module include understanding what statistical process control is and how it is used to improve and predict business performance. Topics within this module include control charting in excel (with and without data visualizations) and capability analysis which allows businesses to understand their their ability to meet and exceed their customer tolerances and expectations.
