Learn to analyze and visualize data to support data-driven decision-making in your organization.
As the amount of data companies collect continues to grow at a rapid rate, the ability to effectively transform that data into actionable information has become paramount for business growth and success. The expanding field of business intelligence (BI) is now fundamental to all facets of business across all industries.
Business intelligence analysts use data to determine industry trends and help develop a picture of where an organization stands within the industry. Businesses also use BI analysts to determine how to improve processes, to discover efficiencies, to support customers, and to reduce costs.
This hand-on certificate provides individuals with the skills necessary to become successful BI analysts who support data-driven organizational decision-making and maximize the utility of accumulated data. Students will gain a comprehensive, working knowledge of the complete analytics cycle, from determining requirements to extracting and disseminating information through various visualization techniques. Advanced topics such as Predictive Analytics, SAS Programming, R Programming, Python, or SQL can be taken as electives for further specialization.
For more information about this program, please contact the program manager at email@example.com or 858-534-9358.
There will be a $60 fee upon acceptance into the program
All four courses are required.
As the amount of data companies collect continues to grow at a rapid rate, the ability to effectively transform that data into actionable information has become paramount for business growth and success. Business intelligence (BI) and data analytics enables businesses to make better decisions, improve processes, discover efficiencies, support customers, and reduce costs.
In this course, students will learn the complete analytics cycle, from determining requirements to extracting and disseminating information. It will cover the process, technologies, applications, tools, and skills required to analyze data so that informed and timely decisions can be made.
Course typically offered: Online in Fall, Winter, Spring, and Summer (every quarter)
Next Steps: Upon completion of this course, consider taking Dashboards and Data Visualization for Data Analysis to continue learning.
More Information: For more information about this course, please contact firstname.lastname@example.org.
Learn how to use the Structured Query Language (SQL) to create, manipulate, and create reports from database tables. Important concepts associated with relational databases will be covered. You will run SQL commands to create database tables and define data element types.
Single and multiple table queries will be created with simple and compound conditions using SQL operators such as:
Basic and complex reports will be created based on data in a table or view. Database Administration features of SQL will be discussed.
For more information about this course, please contact the program manager at
Excel can be intimidating, complex and confusing with so many features and tools to use. After covering the basics to lay the foundation, this course will move to advanced features of Excel that can be applied in healthcare data analysis, statistics, and visualization, while building pragmatic solutions to common business problems. This course will follow a problem-solution format to explore data analysis options and cover best-practices for delivering solutions in Excel.
For more information about this course, please contact email@example.com or 858-534-9352
With the growing amount of data available to businesses, decision-makers must translate strategy into accountability, measure progress against goals, and leverage data for business decision making. Dashboards are used to present and analyzing enterprise performance data, both strategic and operational, and to perform business analysis easily and quickly.
This course will teach dashboards and data visualization technologies, using an approach that will include theory as well as a significant hands-on component. Students will learn how to design and build dashboards, as well as create content of different types that can be incorporated into dashboards.
Software: Students will learn to use Tableau to visualize data. Registration and download information will be provided by the instructor on the start date.
Next Steps: Upon completion of this course, consider taking Predictive Analytics to continue learning.
Three units required
Statistical computing is employed within a diverse range of industries. In recent years, an open source project, R, has emerged as the preeminent statistical computing platform. With its unsurpassed library of freely available packages, R is capable of addressing almost every statistical inference problem.
In this course, you will learn to write R programs that access data from multiple sources, generate output, manipulate different types of R objects that are based on programming objectives, perform character manipulation, generate statistical reports, create statistical graphics, and, most importantly, write flexible R functions by using different types of control structures
Software: R, a free software environment for statistical computing and graphics, is used for this course.
Prerequisites: Knowledge of basic programming or Introduction to Programming is recommended.
This course will be focused on using MS SQL Server and T-SQL, covering data aggregation using aggregate functions, writing sub-queries, recursive queries, and common table expressions. You will also cover creating views, stored procedures, functions, and triggers using different looping and database locking mechanisms. Specific areas in the SQL Server database using data file structures, database schemas, setting properties, snapshots, data space and type usage and identity columns will be covered. SQL tuning and use of execution plans will also be addressed.
For more information contact: firstname.lastname@example.org or 858 534-9352
Informatics is the study of structure, algorithms, behavior, and interactions of information systems. Its applications are powerful and broad, and include such fields as life sciences, data mining, business analytics, and social computing.
This hands-on course introduces the Python programming language, and is targeted toward students without prior programming experience who are interested in how informatics can be employed to provide solutions to complex, data intensive problems in a variety of scientific and business domains. After learning the core syntax and elements of the Python language, students will gain experience in the fundamentals of network programming, web services, databases and Structured Query Language (SQL), and data visualization.
Software: Students will use Python 2.7 and 3.X in this course. There is no additional cost to access this software.
Course typically offered: Online in Winter and Summer; In-class in Fall and Spring
Next Steps: Upon completion of this course, consider taking other courses in data science to continue learning.
The SAS system is a software suite for data analysis and management, widely used in business, government, and academia. Because the pharmaceutical, biotech, and clinical research industries use SAS to analyze clinical trial data, SAS programmers are in especially high demand in these industries.
In this course, students will learn the tools necessary to write SAS programs to perform elementary data management, analysis, and reporting. Students will also gain the skills necessary to create and document data sets, manage and reshape data, write simple reports, and compute basic statistics on dataset variables.
Software: Students must download and install SAS OnDemand for Academics: Enterprise Guide. There is no additional cost for this product. Registration and download information will be provided by the instructor on the start date.
Prerequisites: Completion of Introduction to Programming or basic programming skills required.
Next Steps: Upon completion of this course, consider taking SAS Programming II: Advanced DATA Step Programming to continue learning.
As an increasing volume of customer, product, and industry data is being collected by businesses, companies must apply intelligent methods to convert the large information repositories into effective sources of decision making.
This course covers the basics of predictive analytics and data mining methods for business applications, gives an overview of the basic tools and techniques, and includes case studies and exercises. Students will learn what data mining can do to enable business intelligence and how to build analytical capabilities. Explore examples of the applications of predictive analytics, including a variety of successful real-life projects that focus on the analysis, prediction, marketing, investments, and business practices that enable educated decision-making to drive revenues, reduce costs, and provide competitive advantage.
Software: WEKA may be used during the class.
Course typically offered: Online in Fall and Spring
Next Steps: Upon completion of this course, consider taking Fundamentals of Data Mining to continue learning.
Discrete mathematics is used to solve certain types of math problems, such as how to count or enumerate quantities, and to describe their properties and the relationships among them. Discrete math is applied math: it provides the basis for much of computer science, statistics, and programming, as well as being integral to engineering and many different scientific disciplines. Discrete math helps to find solutions to every day, real-world problems.
In this course, students are introduced to the fundamental concepts and cover some of the essential techniques of discrete mathematics. With emphasis on the problem solving and a very hands-on approach, students will master concepts and techniques such as number theory and graph theory.
Course typically offered: Online in Winter and Summer
Prerequisites: Strong understanding of college algebra required.
The success of today’s organizations depends on the ability of workers to make better and faster fact-based decisions to solve complicated business problems. Statistics-based predictive analytics has become the key enabler for this evidence-based management. Digital analytics uses sophisticated traffic information about a web service to deliver a comprehensive array of vital business intelligence and visitor behavior insights.
Using Microsoft Excel, R, and KNIME software tools as a work engine for data analysis, this course will teach the applications of predictive analytics using web analytics data. Popular methods and algorithms, including regression, naive Bayes, and decision trees, will be covered and assessed for their value and validity.
Software: Students will use the R statistical package, Google Analytics, Excel, and/or KNIME during this course.
Prerequisites: Familiarity with Google Analytics or another web analytics tool required. Basic math, including statistics, functions, and matrices, required. Basic programming skills or Introduction to Programming required.
The Predictive Model Markup Language (PMML) is the de facto standard to represent data mining and predictive analytic models. With PMML, one can easily share a predictive solution among PMML-compliant applications and systems.
This course will explore how the PMML language allows for models to be deployed in minutes. You will get to know its business value and the data mining tools and companies supporting PMML. You will also begin to understand the language elements and capabilities and learn how to effectively extract the most out of your PMML code.
Software: Students will use PMML 4.2 in this course.
Prerequisites: Fundamentals of Data Mining or equivalent knowledge required. Introduction to Programming or equivalent knowledge required.
Next Steps: Upon completion of this course, consider taking additional data science courses to continue learning.
You may enroll in the certificate program at any time. However, it is recommended that you enroll as soon as possible. The program curriculum may be updated at any time; if certificate requirements change, you must adhere to the curriculum at the time of your enrollment into the certificate.
From the 'Apply Now' button, login to your student account, complete the online application, and pay the application fee if applicable.
It is preferable that you create an account before proceeding if you have not already done so.
Candidates are encouraged to apply in the certificate program as early as possible to take advantage of program benefits.
See Certificate FAQs for more information.
Science & Technology. Call 858-534-9358 or Email: email@example.com
Although programs are open to all adult learners, UC San Diego Extension programs are designed to best serve college-prepared working professionals. Where program capacity is limited, applicants with this profile will receive preference for admission.
Experian Consumer Direct
San Diego Supercomputer Center
Modus Operandi Analytics
The Marlin Alliance
Big Data Intelligence
There are no prerequisite required to enroll in the certificate program, however basic programming knowledge is recommended but not required for some of the courses.
The program costs approximately $3,650 including the certificate fee, course fees, and required textbooks. This is an estimate of the full cost of the program. This estimate may vary based on a variety of factors. All estimated costs are subject to change. Program fees are paid on a per-course basis, when you enroll in a course, and current fees and textbooks are listed on the individual course pages.
Yes! This program is designed for you to take it online in the convenience of your own home or office. Some courses may also have in-class options, but all program requirements can be completed online. For online courses, all assignments, tests, and quizzes can be completed online and submitted through Blackboard, our online learning platform.
If you have taken a course from an accredited university covering the learning objectives of a program course, you may be able to transfer your previous coursework to Extension. If you have not taken a course elsewhere, but already have the skills covered in a course, you may be able to substitute an alternate Extension course in its place. Please contact the program representative at firstname.lastname@example.org or (858) 534-9358 for more information.
Yes, the program is open to non-California residents, including non-US residents. The tuition is the same for all students. If you have questions about how enrolling in courses may or may not affect your visa status, please contact our International Department at email@example.com or (858) 534-6784.
Most students complete the program in about a year and three months by taking one course per quarter for five consecutive quarters. If you would like to complete the program more quickly, you can take more than one course per quarter. You have up to five years to complete all requirements for the certificate.
You will find a downloadable program flyer and program FAQs under "Related Documents" on the right side of the top of this page. If you need further information, please contact the program representative at 858-534-9358 or firstname.lastname@example.org.
There will be a $60 fee upon
acceptance into the program
about Business Intelligence Analysis
Hear about upcoming events and courses