使用 Excel 分析数据

Mastering Data Analysis in Excel

Part of a 5-course series, the Excel to MySQL: Analytic Techniques for Business Specialization

杜克大学

分享

课程概况

In this course, you will master the Microsoft Excel techniques successful business analysts and business data analysts rely on every day to extract actionable information from business data. Starting with basic Excel functions (it’s ok if you’ve never used Excel before), you will import and work with real world data sets, display your results in charts and graphs, then solve more advanced problems using Excel’s built-in data functions and the Solver plugin. Along the way, you will learn the essential data modeling and predictive analytics concepts that will give you the power to ask the right questions of data and extract the most useful answers.

You will learn the most important type of models, how to pick the best one, depending on the situation, and how to measure a model’s effectiveness to ensure it remains the best available. And you will know how to avoid common pitfalls of modeling, such as “fooled by randomness” and “over-fitting.”

Intermediate Excel users will have the option to test out of the basic Excel module, in order to move to the more advanced materials in later modules.

使用 Excel 分析数据 is course 2 of 5 in the Excel to MySQL: Analytic Techniques for Business Specialization.

In this Specialization, you’ll learn to frame business challenges as data questions. You’ll use powerful tools and methods such as Excel, Tableau, and MySQL to analyze data, create forecasts and models, design visualizations, and communicate your insights. In the final Capstone Project, you’ll apply your skills to explore and justify improvements to a real-world business process.

授课教师

Jana Schaich Borg
Post-doctoral Fellow
Psychiatry and Behavioral Sciences

Daniel Egger
Executive in Residence and Director, Center for Quantitative Modeling
Pratt School of Engineering, Duke University

Udemy
声明:MOOC中国发布之课程均源自下列机构,版权均归他们所有。本站仅作报道收录并尊重其著作权益,感谢他们对MOOC事业做出的贡献!(排名不分先后)
  • Coursera
  • edX
  • OpenLearning
  • FutureLearn
  • iversity
  • Udacity
  • NovoEd
  • Canvas
  • Open2Study
  • Google
  • ewant
  • FUN
  • IOC-Athlete-MOOC
  • World-Science-U
  • Codecademy
  • CourseSites
  • opencourseworld
  • ShareCourse
  • gacco
  • MiriadaX
  • JANUX
  • openhpi
  • Stanford-Open-Edx
  • 网易云课堂
  • 中国大学MOOC
  • 学堂在线
  • 顶你学堂
  • 华文慕课
  • 好大学在线CnMooc
  • 以及更多...

Copyright © 2008-2015 MOOC.CN 慕课改变你,你改变世界