从 Excel 到 MySQL:商业分析技术

Excel to MySQL: Analytic Techniques for Business

Drive business process change through identifying and analyzing key metrics in four industry-relevant courses.




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.

第 1 门课程


下一班次:9月 28 — 11月 2
Commitment The course is 4 weeks long and is estimated to take learners 3-5 hours/week.


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.

You’ll get a clear picture of the vital but different roles business analysts, business data analysts, and data scientists each play in various types of companies. And you’ll know exactly what skills are required to be hired for, and succeed at, these high-demand jobs.

Finally, you will be able to use a checklist provided in the course to score any company on how effectively it is embracing big data culture. Digital companies like Amazon, Uber and Airbnb are transforming entire industries through their creative use of big data. You’ll understand why these companies are so disruptive and how they use data-analytics techniques to out-compete traditional companies.

第 2 门课程

使用 Excel 分析数据

开始于 October 2015


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.

第 3 门课程

使用 Tableau 展示可视化数据

开始于 November 2015


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.

In this course you will learn how to become a master at communicating business-relevant implications of data analyses. By the end, you will know how to structure your data analysis projects to ensure the fruits of your hard labor yield results for your stakeholders. You will also know how to streamline your analyses and highlight their implications efficiently using visualizations in Tableau, the most popular visualization program in the business world. Using other Tableau features, you will be able to make effective visualizations that harness the human brain’s innate perceptual and cognitive tendencies to convey conclusions directly and clearly. Finally, you will be practiced in designing and persuasively presenting business “data stories” that use these visualizations, capitalizing on business-tested methods and design principles.

第 4 门课程

使用 MySQL 管理大数据

开始于 December 2015


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!

Big data is here to stay. Increasing numbers of businesses will collect increasingly large sets of data with the hope that data will yield novel insights into how to improve businesses. Analysts that understand how to access this data – this means you! – will have a strong competitive advantage in this data-smitten business world.


从 Excel 到 MySQL:商业分析技术毕业项目

开始于 January 2016


In this Capstone project you will use data analysis to recommend a method for improving profits for your company, Watershed Property Management, Inc. Watershed is responsible for managing thousands of residential rental properties throughout the United States. Your job is to persuade both Watershed’s management team and its current clients to pursue a new strategy for managing properties that will increase their profits. To do this, you will:

–Draw upon your new MySQL database skills to extract business metrics from a real-world real estate demographics database.
–Implement data analysis in Excel to identify the best opportunities for Watershed to increase revenue, maximize profits, and reduce risk.
–Articulate a significant and innovative business process change for Watershed based on your data analysis, that you will recommend to company executives.
–Storyboard the goal and rationale behind your business process change recommendation, focusing on critical business metrics.
–Create data visualizations with Tableau that illustrate your storyboarded arguments.
–Design and present a professional quality PowerPoint presentation that will persuade Watershed management to follow your vision for the future.


注册总价格 $295
1数据驱动型公司的业务指标 $59
2使用 Excel 分析数据 $59
3使用 Tableau 展示可视化数据 $59
4使用 MySQL 管理大数据 $59
5从 Excel 到 MySQL:商业分析技术毕业项目 $59


一次性支付所有课程可享受 10%。

Online learning to jumpstart your future.
  • Coursera
  • edX
  • OpenLearning
  • FutureLearn
  • iversity
  • Udacity
  • NovoEd
  • Canvas
  • Open2Study
  • Google
  • ewant
  • FUN
  • IOC-Athlete-MOOC
  • World-Science-U
  • Codecademy
  • CourseSites
  • opencourseworld
  • ShareCourse
  • gacco
  • MiriadaX
  • openhpi
  • Stanford-Open-Edx
  • 网易云课堂
  • 中国大学MOOC
  • 学堂在线
  • 顶你学堂
  • 华文慕课
  • 好大学在线CnMooc
  • 以及更多...

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