商业与金融建模 專項課程
Build Business and Financial Models。 Use spreadsheet models to make data-driven financial decisions
本專項課程介紹
Wharton's Business and Financial Modeling Specialization is designed to help you make informed business and financial decisions. These foundational courses will introduce you to spreadsheet models, modeling techniques, and common applications for investment analysis, company valuation, forecasting, and more. When you complete the Specialization, you'll be ready to use your own data to describe realities, build scenarios, and predict performance.
製作方：
5 courses
按照建議的順序或選擇您自己的順序。
項目
旨在幫助您實踐和應用所學到的技能。
證書
在您的簡歷和領英中展示您的新技能。
課程
- Beginner Specialization.
- No prior experience required.
第 1 門課程
Fundamentals of Quantitative Modeling
計劃開課班次：Jul 23- 課程學習時間
- 4 weeks of study, 1-3 hours/week
- 字幕
- English, Russian
課程概述
How can you put data to work for you? Specifically, how can numbers in a spreadsheet tell us about present and past business activities, and how can we use them to forecast the future? The answer is in building quantitative models, and this course is designed to help you understand the fundamentals of this critical, foundational, business skill. Through a series of short lectures, demonstrations, and assignments, you’ll learn the key ideas and process of quantitative modeling so that you can begin to create your own models for your own business or enterprise. By the end of this course, you will have seen a variety of practical commonly used quantitative models as well as the building blocks that will allow you to start structuring your own models. These building blocks will be put to use in the other courses in this Specialization.您可以選擇只參加本課程。 了解更多。
第 2 門課程
Introduction to Spreadsheets and Models
當前班次：Jul 16- 課程學習時間
- 课程周期：4周 学习时长：每周1-3小时
- 字幕
- English, Portuguese (Brazilian)
課程概述
The simple spreadsheet is one of the most powerful data analysis tools that exists, and it’s available to almost anyone. Major corporations and small businesses alike use spreadsheet models to determine where key measures of their success are now, and where they are likely to be in the future. But in order to get the most out of a spreadsheet, you have know how to use it. This course is designed to give you an introduction to basic spreadsheet tools and formulas so that you can begin harness the power of spreadsheets to map the data you have now and to predict the data you may have in the future. Through short, easy-to-follow demonstrations, you’ll learn how to use Excel or Sheets so that you can begin to build models and decision trees in future courses in this Specialization. Basic familiarity with, and access to, Excel or Sheets is required.您可以選擇只參加本課程。 了解更多。
第 3 門課程
Modeling Risk and Realities
計劃開課班次：Jul 23- 課程學習時間
- 课程周期：4周 学习时长：每周1-3小时
- 字幕
- English, Portuguese (Brazilian)
課程概述
Useful quantitative models help you to make informed decisions both in situations in which the factors affecting your decision are clear, as well as in situations in which some important factors are not clear at all. In this course, you can learn how to create quantitative models to reflect complex realities, and how to include in your model elements of risk and uncertainty. You’ll also learn the methods for creating predictive models for identifying optimal choices; and how those choices change in response to changes in the model’s assumptions. You’ll also learn the basics of the measurement and management of risk. By the end of this course, you’ll be able to build your own models with your own data, so that you can begin making data-informed decisions. You’ll also be prepared for the next course in the Specialization.您可以選擇只參加本課程。 了解更多。
第 4 門課程
Decision-Making and Scenarios
當前班次：Jul 16- 課程學習時間
- 课程周期：4周 学习时长：每周1-3小时
- 字幕
- English
課程概述
This course is designed to show you how use quantitative models to transform data into better business decisions. You’ll learn both how to use models to facilitate decision-making and also how to structure decision-making for optimum results. Two of Wharton’s most acclaimed professors will show you the step-by-step processes of modeling common business and financial scenarios, so you can significantly improve your ability to structure complex problems and derive useful insights about alternatives. Once you’ve created models of existing realities, possible risks, and alternative scenarios, you can determine the best solution for your business or enterprise, using the decision-making tools and techniques you’ve learned in this course.您可以選擇只參加本課程。 了解更多。
第 5 門課程
Wharton Business and Financial Modeling Capstone
計劃開課班次：Sep 10- 字幕
- English
畢業項目介紹
In this Capstone you will recommend a business strategy based on a data model you’ve constructed. Using a data set designed by Wharton Research Data Services (WRDS), you will implement quantitative models in spreadsheets to identify the best opportunities for success and minimizing risk. Using your newly acquired decision-making skills, you will structure a decision and present this course of action in a professional quality PowerPoint presentation which includes both data and data analysis from your quantitative models. Wharton Research Data Services (WRDS) is the leading data research platform and business intelligence tool for over 30,000 corporate, academic, government and nonprofit clients in 33 countries. WRDS provides the user with one location to access over 200 terabytes of data across multiple disciplines including Accounting, Banking, Economics, ESG, Finance, Insurance, Marketing, and Statistics.您可以選擇只參加本課程。 了解更多。
製作方
Sergei Savin
Associate Professor of Operations, Information and Decisions
Senthil Veeraraghavan
Associate Professor of Operations, Information and Decisions
Richard Waterman
Professor of Statistics
Richard Lambert
Professor of Accounting
Robert W. Holthausen
Professor
Don Huesman
Managing Director, Wharton Online
FAQs
More questions? Visit the Learner Help Center.
