Python for Managers (Online)

Program and analyze real world data with python

Become a

Data-Driven Manager

Preview program for free
Course Dates

STARTS ON

September 15, 2022

Course Duration

DURATION

2 months, online
6-8 hours per week

Course Fee

PROGRAM FEE

US$2,600 US$2,392 or get US$260 off with a referral

Course Information Flexible payment available
program fee

US$2,600 US$2,392

Pay by

Python: An Effective Language Of Business

It is sometimes argued that people in business-oriented roles don’t need to know technical skills since they can outsource programming to a development team, but this is an outdated and dangerous way of thinking. Leaders and managers, including those with MBAs, don’t need to be taught to be full-blown programmers, but they need to learn how technical concepts apply to business uses.

Python is designed to be easy to read while still being very powerful, which makes it a great language for beginners to learn. It’s the fastest-growing programming language out there and is becoming an integral part of many professions, from finance and insurance to technology, healthcare, retail, and ecommerce. Consider these facts:

Despite a slump due to the pandemic, job postings for managers with python skills have gone up by 25% in 2020 according to EMSI data.

(SOURCE: EMSI EMPLOYMENT DATA)

According to a Bloomberg report, the language Citigroup wants its incoming investment bank analysts to know is Python.

(SOURCE: BLOOMBERG REPORT)

"There are two kinds of people: those who understand technology and those who don’t. People who understand technology can design and control the very structure of the world around them. People who don’t understand it are controlled by those who do."

- Mattan Griffel, Faculty Co-Director; Adjunct Assistant Professor of Business at Columbia Business School

Key Takeaways

  • Learn the fundamentals of coding in Python with a focus on practical business applications
  • Read and write scripts
  • Build the capacity to organize and interpret data that extends far beyond Excel’s capabilities
  • Learn how to combine multiple data sources for better insights
  • Learn to communicate effectively with programmers whether you hire, manage, or collaborate with them
  • Explore the practical applications of web scraping and APIs

Who Is This Program For?

Designed for experienced professionals interested in learning practical coding skills to leverage the massive data stream their company already generates or data that they would like to collect, this program offers valuable instruction in the most popular and fastest-growing programming language. Python can help any professional solve business problems, plan for the future, and communicate more fluently with coders and developers. No prior coding experience is required. It is best suited for professionals in the following roles:

Senior Managers and Executives
Ideal for senior management with more than 10 years of experience in data-saturated industries such as IT, healthcare, and banking and financial services, who seek to establish an artificial intelligence or machine learning roadmap for their organization. Participants seek to gain a practical understanding of Python and wish to interact in more meaningful ways with data scientists and analysts by sharing the language of Python. Representative roles include:

  • Chief Executive Officer
  • Chief Operating Officer
  • Chief Financial Officer
  • Chief Security Officer
  • Director
  • Managing Director
  • Head of Finance
  • Head of Marketing
  • Head of Analytics
  • Head of Strategy
  • President
  • Vice President

Risk Managers, Traders, & Bankers
Ideal for professionals with 6-20+ years in the financial services industry who are interested in finance-related applications of Python such as forecasting and algorithmic trading, allowing them to react swiftly to market changes. Likely participants hold a business, finance, or statistics degree and want to be armed with the latest technological tools to gain or maintain a competitive edge. Representative roles include:

  • Risk Manager
  • Trader
  • Portfolio Manager
  • Compliance Manager
  • Investment Banker
  • Investment Accounting Manager
  • FP&A Manager

Mid- to Senior-Level Technology Managers
Ideal for professionals with 11-20 years of experience who are tasked with creating a technology strategy for their organization as well as building and deploying technology to serve their enterprise. Drawing from many industries, participants often work in the tech field. They collaborate with colleagues who are fluent in multiple programming languages and would like to improve their communications with developers. They seek a foundation for a future in AI or machine learning and want to add a popular language to their skillset. Representative roles include:

  • Chief Technology Officer
  • Technology Director
  • Engineering Director
  • Product Manager
  • Product Director
  • Project Manager
  • IT Manager

Analysts
Ideal for junior professionals with 1-5 years of experience working as an analyst or for mid-career analysts with 5-15 years of experience. Working in any industry, analyst participants often are already fluent in some programming languages (such as R, SQL, or VBA). They analyze data, produce reports, and build dashboards for their organizations. They seek to advance from data to big data and want to keep pace with trends in the swiftly evolving data science ecosystem. Representative roles include:

  • Data Analyst
  • Data Scientist
  • Analytics Manager
  • Senior Manager, Data and Analytics
  • Analytics Director
  • Vice President of Analytics

Consultants
Ideal for professionals with 6-20+ years of experience in the consulting industry who develop strategies for clients’ specific business challenges. Looking to base solutions on the latest data and technology advancements, participants seek to leverage Python’s capabilities to solve business problems, progressing beyond MS Excel to create reports, dashboards, and models for their clients. Representative roles include:

  • Consultant
  • Principal Consultant
  • Business Consultant
  • Consulting Partner
  • Operations Advisor
  • Consulting Director

Learning Journey

Python for Managers (Online) will help you build the capacity to organize large volumes of data and combine data from disparate sources, so you can make better business decisions.

Program Topics

The goal of this curriculum is to present a hybrid of Python fundamentals and hands-on practice in the application of Python. You will learn how to connect to APIs, scrape data from websites, and access and analyze large volumes of data efficiently and effectively.

Introduction:

Welcome to the Program and Orientation

As you begin your exploration of Python’s capabilities, you will start by setting up your development environment.

Week 1:

Python Fundamentals Part 1

You will review the evolution and purpose of Python, gain an understanding of your development environment, customize your command line, practice command line prompts, start building a mental map of Python concepts, and practice coding with basic Python scripts.

Week 2:

Python Fundamentals Part 2

In this module, you will work with If statements, Else and Elif statements, logic structures, lists, and For loops.

Week 3:

Python Fundamentals Part 3

You will gain an understanding of the role of dictionaries, functions, and import, practice writing code for dictionaries and functions, and refactor code for efficiency and simplicity.

Week 4:

Intro to Pandas in Python

In this module, you will be introduced to data in Python, review Jupyter, work on data without Pandas, explore Panda series data frames, understand columns and rows, and read data.

Week 5:

Analyzing Data with Python

You will filter data, edit data frames, understand how duplicated and missing values impact data hygiene, gain an introduction to combining data, and construct full orders in a case study of New York restaurants.

Week 6:

APIs and Web Scraping with Python

In this module, you will explore examples of APIs, use Python to connect to an API, develop an understanding of HTML, and learn how to use web scrapers in Python to pull information from a page.

Week 7:

Applying APIs and Web Scraping

Skills you will master in this module include loading nutrition data, scraping the data, joining it all together, connecting to Weather API, creating a Weather data frame, and aggregating data.

Week 8:

Tying It Together

Your culminating module focuses on advanced data aggregation, aggregating with time, making pretty plots, and your final project.

Introduction:

Welcome to the Program and Orientation

As you begin your exploration of Python’s capabilities, you will start by setting up your development environment.

Week 5:

Analyzing Data with Python

You will filter data, edit data frames, understand how duplicated and missing values impact data hygiene, gain an introduction to combining data, and construct full orders in a case study of New York restaurants.

Week 1:

Python Fundamentals Part 1

You will review the evolution and purpose of Python, gain an understanding of your development environment, customize your command line, practice command line prompts, start building a mental map of Python concepts, and practice coding with basic Python scripts.

Week 6:

APIs and Web Scraping with Python

In this module, you will explore examples of APIs, use Python to connect to an API, develop an understanding of HTML, and learn how to use web scrapers in Python to pull information from a page.

Week 2:

Python Fundamentals Part 2

In this module, you will work with If statements, Else and Elif statements, logic structures, lists, and For loops.

Week 7:

Applying APIs and Web Scraping

Skills you will master in this module include loading nutrition data, scraping the data, joining it all together, connecting to Weather API, creating a Weather data frame, and aggregating data.

Week 3:

Python Fundamentals Part 3

You will gain an understanding of the role of dictionaries, functions, and import, practice writing code for dictionaries and functions, and refactor code for efficiency and simplicity.

Week 8:

Tying It Together

Your culminating module focuses on advanced data aggregation, aggregating with time, making pretty plots, and your final project.

Week 4:

Intro to Pandas in Python

In this module, you will be introduced to data in Python, review Jupyter, work on data without Pandas, explore Panda series data frames, understand columns and rows, and read data.

Preview Program For Free

Featured Case Study

Work with more than 2.5 million rows of simulated data from a New York Restaurant Group.

This New York restaurant group has eateries across New York City and Boston with a decidedly locavore flavor. They are rethinking every aspect of creating a meal from seed to service. Their mission is to embrace a deeper connection to our food system, supporting minority-run and small-scale farms along the way. They even started their own farm operations in upstate New York as a way to deeply understand the demands of the entire supply chain.

In one year alone, they purchased over 2 million pounds of produce from their 65 local farms. Do you think that creates a lot of data to analyze? Yes it does. In fact, using the restaurant data of more than 2.5 million sales transactions, you’ll apply your new-found Python skills to address some fundamental business questions such as:

  • Which restaurant locations are the top performers and which are the weakest?
  • How popular is delivery service in each of the locations?
  • What are the average number of transactions per day by location and overall?
  • Which locations are busier at lunch time and therefore require a different staffing regime?
  • What was the ROI of the marketing investment made for a large special event in NYC on June 24?
  • How did order volumes compare on the special event day as compared to “normal” busy days in the summer months?

Later in the program, we’ll access Census data and connect to an API for weather data to analyze how demographics and weather affect sales. Finally, you’ll scrape information from this New York restaurant group website to learn more about how product offerings are organized and help determine which location is best for launching a new brand of healthy drinks.

Using this data set, you will use Python to help make decisions on where to invest and to know what’s working.

Program Experience

Decorative image relating to text that follows

Tutorials to Set-Up Development Environment

Decorative image relating to text that follows

Real-World Questions on Real-World Applications

Work with an Actual API

Case Study with Simulated Data from a New York Restaurant Group

Bite-Sized Learning

Dedicated Program Support Team

Mobile Learning App

Peer Learning and Feedback

Past Participant Profile

On your journey to learning Python with Columbia Business School Executive Education, you’ll be in good company. Past participants come from a wide range of industries, job functions, and levels.

Representative Companies:

  • Amazon.com, Inc.
  • Bloomingdale's Inc.
  • Citigroup Inc.
  • Cognizant
  • Dell Inc.
  • Deutsche Bank AG
  • Facebook, Inc.
  • Hilltop Securities, Inc.
  • HSBC Holdings plc
  • Johnson & Johnson
  • KPMG International Cooperative
  • McKinsey & Company
  • Microsoft Corporation
  • Morgan Stanley
  • Ralph Lauren
  • S&P Global, Inc.
  • The Goldman Sachs Group, Inc.
  • Unilever

Representative Job Titles:

  • Partner
  • CEO
  • COO
  • CTO
  • Director
  • President
  • Vice President
  • Consultant
  • Global Head of Valuation
  • Chief Performance Manager
  • Fraud Analytics Manager
  • IT and Risk Compliance Manager
  • Project Manager
  • Senior Credit Analyst
  • Business Analyst
  • IT Manager

Participant Testimonials

“The best parts of the course were the program content and the continued challenge exercises which help in getting some practice. The program videos are very well made and detailed which makes it easier to get a grasp on Python. Overall a great learning experience and well worth the effort.”

— Somdutta Sinha, Senior Data Scientist, Visa Middle East FZ LLC, United Arab Emirates

“The videos and assignments were a great way to put into practice what we had learned. Additionally, the final assignment was a great wrap up incorporating real-world scenarios.”

— Corinne Sosa, Senior Analytics Associate, Merkley+Partners, United States

“I wanted to tap into some large public data sets and web scrape sites through this program. By the time we were about halfway through the program, I was already beginning to tackle my dream project. So excited that this small step into Python has opened the door to so many applications in my current role.”

— Ryan Lane, Area Vice President - Strategy and Analytics, Gallagher, United States

“I am very interested in the part of mathematical models, I love the module on Pandas In Python.”

— Israel Lopez Vallejo, Fraud Analytics, Banco Azteca, Mexico

Program Faculty

Profile picture of course faculty Mattan Griffel

Mattan Griffel

Faculty Co-Director; Adjunct Assistant Professor of Business at Columbia Business School

Mattan Griffel is an adjunct professor and Y Combinator-backed entrepreneur. A co-founder of One Month, which offers online bootcamps for coding, Professor Griffel has experience teaching business professionals who want to expand their technical skills. Forbes selected... More info

Profile picture of course faculty Daniel Guetta

Daniel Guetta

Faculty Co-Director; Associate Professor of Professional Practice in the Discipline of Decision, Risk and Operations; Director, Center for Pricing and Revenue Management and Business Analytics Initiative

As a professor of business analytics and director of the Center for Pricing Revenue Management and Business Analytics Initiative, Daniel Guetta straddles both the Columbia Business School... More info

Certificate

Certificate

Upon completion of the program, participants will receive a certificate of participation from Columbia Business School Executive Education and one day toward a Certificate in Business Excellence.

Preview Program For Free

Your verified digital certificate will be issued in your legal name and emailed to you, at no additional cost, upon completion of the program, as per the stipulated requirements. All certificate images are for illustrative purposes only and may be subject to change at the discretion of the Columbia Business School Executive Education.

FAQs

  • How do I know if this program is right for me?

    After reviewing the information on the program landing page, we recommend you submit the short form above to gain access to the program brochure, which includes more in-depth information. If you still have questions on whether this program is a good fit for you, please email learner.success@emeritus.org, and a dedicated program advisor will follow-up with you very shortly.


    Are there any prerequisites for this program?

    Some programs do have prerequisites, particularly the more technical ones. This information will be noted on the program landing page, as well as in the program brochure. If you are uncertain about program prerequisites and your capabilities, please email us at learner.success@emeritus.org for assistance.


    Note that, unless otherwise stated on the program web page, all programs are taught in English and proficiency in English is required.


    What is the typical class profile?

    More than 50 percent of our participants are from outside the United States. Class profiles vary from one cohort to the next, but, generally, our online certificates draw a highly diverse audience in terms of professional experience, industry, and geography — leading to a very rich peer learning and networking experience.


    What other dates will this program be offered in the future?

    Check back to this program web page or email us at learner.success@emeritus.org to inquire if future program dates or the timeline for future offerings have been confirmed yet.

  • How much time is required each week?

    Each program includes an estimated learner effort per week. This is referenced at the top of the program landing page under the Duration section, as well as in the program brochure, which you can obtain by submitting the short form at the top of this web page.



    How will my time be spent?

    We have designed this program to fit into your current working life as efficiently as possible. Time will be spent among a variety of activities including:



    • Engaging with recorded video lectures from faculty
    • Attending webinars and office hours, as per the specific program schedule
    • Reading or engaging with examples of core topics
    • Completing knowledge checks/quizzes and required activities
    • Engaging in moderated discussion groups with your peers
    • Completing your final project, if required

    The program is designed to be highly interactive while also allowing time for self-reflection and to demonstrate an understanding of the core topics through various active learning exercises. Please contact us at learner.success@emeritus.org if you need further clarification on program activities.



    What is it like to learn online with the learning collaborator, Emeritus?

    More than 250,000 professionals globally, across 80 countries, have chosen to advance their skills with Emeritus and its educational learning partners. In fact, 90 percent of the respondents of a recent survey across all our programs said that their learning outcomes were met or exceeded.

    A dedicated program support team is available 24/5 (Monday to Friday) to answer questions about the learning platform, technical issues, or anything else that may affect your learning experience.


    How do I interact with other program participants?

    Peer learning adds substantially to the overall learning experience and is an important part of the program. You can connect and communicate with other participants through our learning platform.

  • What are the requirements to earn the certificate?

    Each program includes an estimated learner effort per week, so you can gauge what will be required before you enroll. This is referenced at the top of the program landing page under the Duration section, as well as in the program brochure, which you can obtain by submitting the short form at the top of this web page. All programs are designed to fit into your working life.

    This program is scored as a pass or no-pass; participants must complete the required activities to pass and obtain the certificate of completion. Some programs include a final project submission or other assignments to obtain passing status. This information will be noted in the program brochure. Please contact us at learner.success@emeritus.org if you need further clarification on any specific program requirements.


    What type of certificate will I receive?

    Upon successful completion of the program, you will receive a smart digital certificate. The smart digital certificate can be shared with friends, family, schools, or potential employers. You can use it on your cover letter, resume, and/or display it on your LinkedIn profile.
    The digital certificate will be sent approximately two weeks after the program, once grading is complete.


    Can I get the hard copy of the certificate?

    No, only verified digital certificates will be issued upon successful completion. This allows you to share your credentials on social platforms such as LinkedIn, Facebook, and Twitter.


    Do I receive alumni status after completing this program?

    No, there is no alumni status granted for this program. In some cases, there are credits that count toward a higher level of certification. This information will be clearly noted in the program brochure.


    How long will I have access to the learning materials?

    You will have access to the online learning platform and all the videos and program materials for 12 months following the program start date. Access to the learning platform is restricted to registered participants per the terms of agreement.

  • What equipment or technical requirements are there for this program?

    Participants will need the latest version of their preferred browser to access the learning platform. In addition, Microsoft Office and a PDF viewer are required to access documents, spreadsheets, presentations, PDF files, and transcripts.


    Do I need to be online to access the program content?

    Yes, the learning platform is accessed via the internet, and video content is not available for download. However, you can download files of video transcripts, assignment templates, readings, etc. For maximum flexibility, you can access program content from a desktop, laptop, tablet, or mobile device.

    Video lectures must be streamed via the internet, and any livestream webinars and office hours will require an internet connection. However, these sessions are always recorded, so you may view them later.

  • Can I still register if the registration deadline has passed?

    Yes, you can register up until seven days past the published start date of the program without missing any of the core program material or learnings.


    What is the program fee, and what forms of payment do you accept?

    The program fee is noted at the top of this program web page and usually referenced in the program brochure as well.

    • Flexible payment options are available (see details below as well as at the top of this program web page next to FEE).
    • Tuition assistance is available for participants who qualify. Please email learner.success@emeritus.org.

    What if I don’t have a credit card? Is there another method of payment accepted?

    Yes, you can do the bank remittance in the program currency via wire transfer or debit card. Please contact your program advisor, or email us at learner.success@emeritus.org for details.


    I was not able to use the discount code provided. Can you help?

    Yes! Please email us at learner.success@emeritus.org with the details of the program you are interested in, and we will assist you.


    How can I obtain an invoice for payment?

    Please email learner.success@emeritus.org with your invoicing requirements and the specific program you’re interested in enroling in.


    Is there an option to make flexible payments for this program?

    Yes, the flexible payment option allows a participant to pay the program fee in installments. This option is made available on the payment page and should be selected before submitting the payment.


    How can I obtain a W9 form?

    Please email us at learner.success@emeritus.org for assistance.

  • What is the policy on refunds and withdrawals?

    You may request a full refund within seven days of your payment or 14 days after the published start date of the program, whichever comes later. If your enrolment had previously been deferred, you will not be entitled to a refund. Partial (or pro-rated) refunds are not offered. All withdrawal and refund requests should be sent to admissions@emeritus.org.



    What is the policy on deferrals?

    After the published start date of the program, you have until the midpoint of the program to request to defer to a future cohort of the same program. A deferral request must be submitted along with a specified reason and explanation. Cohort changes may be made only once per enrolment and are subject to availability of other cohorts scheduled at our discretion. This will not be applicable for deferrals within the refund period, and the limit of one deferral per enrolment remains. All deferral requests should be sent to admissions@emeritus.org.

Financing Options

Climb Credit*

We offer financing options with our partner, Climb Credit*. Click here to learn more.
*Applicable for US Residents

Flexible Payment Options For All

Flexible payment options allow you to pay the program fee in installments. Click here to see payment schedule.

Preview this program for free

Early registrations are encouraged. Seats fill up quickly!

Flexible payment options available. Learn more.