Skip to main content

Update on Remote Instruction To attend in-person courses, you must meet UC COVID-19 vaccine and testing requirements. Learn how.

Close
The following fields are required:
Error has occurred. Please reload this page and try the operation again.
  • Agents
  • Student Login
  • Instructor Login
Extension
      • Areas of Study
        • Art and Design
        • Behavioral Health Sciences
        • Business
        • Construction and Sustainability
        • Education
        • Humanities and Languages
        • Sciences, Mathematics
          and Biotechnology
        • Technology and
          Information Management
        • Writing, Editing and
          Technical Communication
      • Online Learning
        • Online Courses and Certificates
      • Custom Programs
        • For Universities and Organizations
      • Events
        • Information Sessions
        • Free and Low Cost Events
      • Academic Services
        • Enrollment
        • Transcripts
        • General Information
        • Community Guidelines
        • Locations
      • Course and Program Information
        • Latest COVID-19 Information
        • Online Course Policies
        • Certificates, Programs and CEUs
        • Concurrent Enrollment
        • Career Services
        • International Student Services
      • Student Aid
        • Disability Support Services
        • Financial Assistance
      • Voices
        • Voices Home
        • Educator Insights
        • Student Stories
        • Professional Pathways
        • Industry Trends
      • Events
        • Information Sessions
        • Free and Low Cost Events
  • Berkeley Global

Introduction to Data Analytics

COMPSCI X407.9

17484859
Delivery Options Online
Get an overview of advanced Excel, SQL and R to perform analysis on huge sets of data. Learn the theory behind formulating statistical models using regression analysis. You also study segmentation theory and methods such as k-means clustering used for data mining and analysis.

Prerequisites:

Required

  • Knowledge of math as covered in a first semester undergraduate course. Need to fulfill this prereq? Take a course in:
    • Math for Management MATH X402
  • Proficiency with Microsoft Excel

Course Outline

Expand or collapse section

Course Objectives

  • Understand basic statistical concepts
  • Work on advanced MS Excel skills for data analysis Interpret data and charts from different sources
  • Develop linear regression models
  • Segment different sets of data
  • Understand R and SQL coding

What You Learn

  • Basic statistics: mean, median, variance, standard deviation
  • Spreadsheets techniques: Charts, Pivots, VLOOKUP and filtering
  • Segmentation methods: Cluster analysis, K-means, Bayes
  • Regression: Linear, R-squared, F & T-Tests, ROC Curve
  • Common data analysis tools
  • SQL coding
  • Introduction to R

How You Learn

  • Lectures
  • Analysis of case studies
  • Group discussions
  • Review of homework problems
  • Assigned textbook chapters
  • Homework assignments

Is This Course Right for You?

This course is ideal for managers, junior analysts, engineers or anyone who wants to develop the skills to comprehend huge sets of data to make informed business decisions.

Loading...

Sections

Section 026

Start Anytime

Type: Online, Start Anytime

Instructor:

  • Stephan Sorger

Cost: $995.00

See section 026 Details

Type Online, Start Anytime

Dates
Start Now, you have 180 days to complete this course once enrolled.

Delivery Options

Online

Available for Credit

2 semester units

Section Notes

Online, enroll anytime. This continuous enrollment course begins when you enroll. You have a minimum of 60 days and a maximum of 180 days to complete the course.

Section Materials

  • (Mandatory)

    Marketing Analytics: Strategic Models and Metrics by Stephan Sorger

    © 2013 CreateSpace ISBN 1481900307 Textbook ISBN: 9781481900300

Summer enrollment opens on March 21!

This course applies to the following programs:

Certificate Program in Financial Planning and Analysis

Expand or collapse section

Core Courses

  • Corporate Financial Analysis and Modeling
  • Enterprise Risk Management
  • Financial Statement Analysis
  • International Finance

Electives

  • Basic Corporate Finance
  • Business Valuation
  • Cost Accounting
  • Intermediate Corporate Finance
  • Introduction to Data Analytics
  • Financial Accounting
  • Managerial Accounting
  • Presenting Quantitative Data Effectively

Learn More About this Program

Professional Program in Data Analysis

Expand or collapse section

Data Analysis Courses

  • Introduction to Data Analytics
  • Introduction to R: Data Exploration and Visualization
  • Python for Data Analysis and Scientific Computing
  • Data Analytics and Visualization
  • Practical Statistics for Data Scientists Using R

SAS Analytics Courses

Data Management Courses

  • Introduction to Databases
  • Introduction to SQL
  • Business Intelligence With SQL Server
  • Data Mining Using SQL

Learn More About this Program

Certificate Program in Software Development and Programming

Expand or collapse section

Core Course

  • Introduction to Computers and Programming

Software Development Lifecycle Courses

  • Software Project Management
  • Software Quality Assurance

Data and Databases Courses

  • Introduction to Data Analytics
  • Introduction to Databases
  • Data Mining Using SQL

Programming Courses

  • First Course in Java
  • Introduction to C Language Programming
  • Programming Python

Operations, Networking and Security Courses

  • Introduction to DevOps
  • Introduction to Cybersecurity
  • Fundamentals of Data Communications and Networking

Web Development Courses

  • JavaScript and jQuery: An Introduction
  • Fundamentals of Website Development

Current Topics Courses

  • Introduction to Quantum Computing With Applications
  • Blockchain Fundamentals

Learn More About this Program

Notes

Departmental contact: extension-techeng@berkeley.edu | (510) 642-4151

Instructional Types

Live Online
Live Online courses provide an interactive learning experience with scheduled synchronous online sessions held via Zoom video conferencing (Pacific Time). Learn more about the Live Online format.
Online, Start Anytime
Continuous enrollment course begins when you enroll. You have a minimum of 90 days and a maximum of 180 days to complete the course.
Online, Fixed Date
Enroll in this course by its start date and complete it by its specified end date. There are no live sessions, but plenty of opportunities to collaborate with your classmates and instructor.
Classroom
Take classes in-person at one of our buildings or partner locations.

English Language Proficiency Requirements

All of our courses are taught in English. If English is not your first language, please use the following test scores as guides in order to be successful:

  • TOEFL: 90
  • IELTS Academic Format: 7
  • DAAD: C1
  • TEM-4 or TEM-8: Level 70

Note: You do not need to submit test scores.

Extension

1995 University Ave., Suite 200

Berkeley, CA 94704-7000

extension@berkeley.edu

Facebook Facebook Icon Twitter Twitter Icon LinkedIn LinkedIn Icon YouTube YouTube Icon Instagram Instagram Icon Medium Small Icon for Medium
WeChat QR code

Locations

  • Berkeley
  • San Francisco
  • Online
  • Other

Resources

  • About Us
  • Career Services
  • Administration
  • Accessibility
  • Nondiscrimination
  • Privacy
  • Transcripts
  • Gifts
  • Jobs
  • Contact Us
Western Association of Schools and Colleges

The University of California, Berkeley, is accredited by the Western Association of Schools and Colleges (WASC). UC Berkeley Extension—like all other UC Berkeley schools, colleges and departments—is accredited by WASC through the University.

Copyright © UC Regents

Powered by Destiny One

We use cookies to give you the best experience on our website. By clicking Accept, you consent to our cookie policy and privacy policy.

Session Time-Out

For security reasons and the protection of your personal information, your session will time out due to a period of inactivity in minute(s) and second(s). Click Extend My Session to continue. For security reasons and the protection of your personal information, your session timed out after a period of inactivity. You will be redirected to the home page.

Confirm

Alert

Course Fee

Stephan Sorger

Stephan Sorger, MBA, M.S., PE, Extension Honored Instructor, is a serial marketing executive, instructor and author. He is the vice president of strategic marketing at the consulting firm On Demand Advisors. Previously, he held leadership roles in marketing and product development at companies such as Oracle, 3Com and NASA. Since 2003, he has taught marketing courses at UC Berkeley Extension. He also has developed two textbooks, Marketing Analytics: Strategic Models and Metrics and Marketing Planning: Where Strategy Meets Action. Find sample course materials here.

Online

Processing...

Privacy Policy

Cookie Policy

This statement explains how we use cookies on our website. For information about what types of personal information will be gathered when you visit the website, and how this information will be used, please see our privacy policy.

How we use cookies

All of our web pages use "cookies". A cookie is a small file of letters and numbers that we place on your computer or mobile device if you agree. These cookies allow us to distinguish you from other users of our website, which helps us to provide you with a good experience when you browse our website and enables us to improve our website.

Types of cookies we use

We use the following types of cookies:

  • Strictly necessary cookies- these are essential in to enable you to move around the websites and use their features. Without these cookies the services you have asked for, such as signing in to your account, cannot be provided.
  • Performance cookies- these cookies collect information about how visitors use a website, for instance which pages visitors go to most often. We use this information to improve our websites and to aid us in investigating problems raised by visitors. These cookies do not collect information that identifies a visitor.
  • Functionality cookies- these cookies allow the website to remember choices you make and provide more personal features. For instance, a functional cookie can be used to remember the items that you have placed in your shopping cart. The information these cookies collect may be anonymized and they cannot track your browsing activity on other websites.

Most web browsers allow some control of most cookies through the browser settings. To find out more about cookies, including how to see what cookies have been set and how to manage and delete them please visit https://www.allaboutcookies.org/.

Specific cookies we use

The list below identify the cookies we use and explain the purposes for which they are used. We may update the information contained in this section from time to time.

  • JSESSIONID: This cookie is used by the application server to identify a unique user's session.
  • registrarToken: This cookie is used to remember items that you have added to your shopping cart
  • locale: This cookie is used to remember your locale and language settings.
  • cookieconsent_status: This cookie is used to remember if you've already dismissed the cookie consent notice.
  • _ga_UA-########: These cookies are used to collect information about how visitors use our site. We use the information to compile reports and to help us improve the website. The cookies collect information in an anonymous form, including the number of visitors to the website, where visitors have come to the site from and the pages they visited. This anonymized visitor and browsing information is stored in Google Analytics.

Changes to our Cookie Statement

Any changes we may make to our Cookie Policy in the future will be posted on this page.