Skip to main content
The following fields are required:
Error has occurred. Please reload this page and try the operation again.
  • Agents
  • Partners
  • Student Login
  • Instructor Login
UC Berkeley Extension Home Page
      • 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
      • Events
        • Information Sessions
        • Free and Low Cost Events
      • Academic Services
        • Enrollment
        • Transcripts
        • General Information
        • Community Guides
      • Course and Program Information
        • Latest COVID-19 Information
        • Online Course Policies
        • Certificates, Programs and CEUs
        • Concurrent Enrollment
        • Career Services
      • Student Aid
        • Disabled Students
        • Financial Assistance
        • Community Impact Scholarship
      • Voices
        • Voices Home
        • Educator Insights
        • Student Stories
        • Professional Pathways
        • Industry Trends
      • Events
        • Information Sessions
        • Free and Low Cost Events

  • Berkeley Global

Data Analytics and Visualization

COMPSCI X465

38377986
Learn techniques to effectively produce actionable reports and visualizations from data and data sets. You research data sets from a variety of business disciplines using Microsoft Excel, Microsoft Power BI and Google Analytics. Through hands-on exercises, you leverage statistical, data-querying and dashboard tools to create products that accurately convey crucial business trends and themes.

Course Outline

Expand or collapse section

Course Objectives

  • Explore a range of analytics and visual processes to effectively determine the best tools for the job.
  • Learn to analyze and process data from spreadsheets and relational databases.
  • Research the varieties of Internet data, and learn how to effectively represent them for business purposes.
  • Learn to produce responsive dashboards and reports that successfully display on laptops, mobile devices, or digital signs.

What You Learn

  • Data analytics and visualization (DAV)
  • Statistics for DAV
  • Data from spreadsheets and relational databases
  • Data from the Internet and IoT
  • Microsoft Excel for DAV
  • Popular tools for DAV
  • Microsoft Power BI
  • Dashboard design
  • Selecting visualizations
  • Designing for mobile
  • Validating your design
  • Google Analytics
  • Advanced topic: Statistical forecasting

How You Learn

  • In-class presentations by the instructor and DAV industry professionals
  • Individual analysis and design papers
  • In-class exercises and quizzes
  • Team-programming assignment using a team-chosen DAV platform such as Tableau

Is This Course Right for You?

This course is intended professionals, students and job-seekers interested in learning data analytics and visualization for business intelligence careers.

Loading...

Sections

Thank you for your interest in this course. Unfortunately, the course you have selected is currently not open for enrollment. Please contact the academic department at the email or phone number listed in the Notes section for more information.

This course applies to the following programs:

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

Prerequisites

  • Successful completion of a math or statistics undergraduate course.
  • Proficiency with Microsoft Excel features for managing data in spreadsheets.
  • Basic understanding of the goals, processes and operations of business enterprises.
  • A laptop running Windows and Excel. You can use Mac laptops but will be responsible for installing Windows on your Mac using one of the many utilities available.
UC Berkeley Extension UC Berkeley Extension Footer Logo

1995 University Ave., Suite 200

Berkeley, CA 94704-7000

extension@berkeley.edu

  • About Us
  • Administration
  • Contact Us
  • Gifts
  • Jobs

Copyright © UC Regents

Powered by Destiny One
Facebook Facebook Icon Twitter Twitter Icon LinkedIn LinkedIn Icon YouTube YouTube Icon Instagram Instagram Icon

Join us on WeChat!

Image of UC Berkeley Extension's WeChat QR code

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

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 http://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.