从 Excel 到 MySQL:商业分析技术 專項課程
Turn Data Into Value. Drive business process change by identifying & analyzing key metrics in 4 industry-relevant courses.
提供方
您將獲得的技能
關於此 專項課程
無需相關領域的預備知識無需相關經驗。
無需相關領域的預備知識無需相關經驗。
此專項課程包含 5 門課程
数据驱动型公司的业务指标
In this course, you will learn best practices for how to use data analytics to make any company more competitive and more profitable. You will be able to recognize the most critical business metrics and distinguish them from mere data.
使用 Excel 分析数据
Important: The focus of this course is on math - specifically, data-analysis concepts and methods - not on Excel for its own sake. We use Excel to do our calculations, and all math formulas are given as Excel Spreadsheets, but we do not attempt to cover Excel Macros, Visual Basic, Pivot Tables, or other intermediate-to-advanced Excel functionality.
使用 Tableau 展示可视化数据
One of the skills that characterizes great business data analysts is the ability to communicate practical implications of quantitative analyses to any kind of audience member. Even the most sophisticated statistical analyses are not useful to a business if they do not lead to actionable advice, or if the answers to those business questions are not conveyed in a way that non-technical people can understand.
使用 MySQL 管理大数据
This course is an introduction to how to use relational databases in business analysis. You will learn how relational databases work, and how to use entity-relationship diagrams to display the structure of the data held within them. This knowledge will help you understand how data needs to be collected in business contexts, and help you identify features you want to consider if you are involved in implementing new data collection efforts. You will also learn how to execute the most useful query and table aggregation statements for business analysts, and practice using them with real databases. No more waiting 48 hours for someone else in the company to provide data to you – you will be able to get the data by yourself!
提供方

杜克大学
Duke University has about 13,000 undergraduate and graduate students and a world-class faculty helping to expand the frontiers of knowledge. The university has a strong commitment to applying knowledge in service to society, both near its North Carolina campus and around the world.

常見問題
退款政策是如何规定的?
我可以只注册一门课程吗?
有助学金吗?
我可以免费学习课程吗?
此课程是 100% 在线学习吗?是否需要现场参加课程?
完成专项课程后我会获得大学学分吗?
完成专项课程后我会获得大学学分吗?
How often is each course in the Specialization offered?
此专项课程中每门课程的开课频率为多久?
Do I have to take the courses in this Specialization in a specific order?
Will I earn university credit for completing the Excel to MySQL: Analytic Techniques for Business Specialization?
What will I be able to do upon completing the Excel to MySQL: Analytic Techniques for Business Specialization?
What software will I need to complete the assignments?
Will I be able to succeed in this class if I have never taken a statistics, computer science, or programming class?
Will I be able to succeed in this class if I have never had a job in a business-related field?
Will I learn anything new in this class if I have a graduate degree in statistics, computer science, or math?
還有其他問題嗎?請訪問 學生幫助中心。