Computer Technology and Information Management

A to Z Course Index

Information Sessions

Certificate Programs

Transcripts

Course Locations

Concurrent Enrollment

Order a Catalog

Courses begin every month. A new edition of our catalog is published three times a year in early April, July and December.

Quick Enroll	Search

Business Intelligence with SQL Server

X404.8 (1 semester unit in EECS)

Business Intelligence (BI) is exposed by combining operational information from various departments into a data mart, and then providing insightful queries and reports to decision makers. BI has become an essential tool for strategic management, finance, customer service, marketing and sales, and other business aspects. Learn to analyze and develop a BI system, including programming examples using Microsoft SQL Server. You gain an understanding of BI applications, SQL data mart features, trends in the BI industry, and learn to design insightful inquiries and reports.

Students will be exposed to BI operational systems such as Extract, Transform, and Load (ETL), relational databases with star schema, creating a data cube, aggregation, slowly changing dimensions, the BI features in SQL Server, data mining, decision trees, time series, sequence clustering, and how to design insightful queries and reports that provide mining, prediction, classification, and views to decision makers. The course assumes students have familiarity with business management, marketing, finance, spreadsheets, relational databases, and programming. Students will be asked to complete individual analysis and design papers, and in-class exercises and quizzes; and there will be team programming assignments using Microsoft SQL Server.

There are currently no sections open for enrollment.

---

Sections closed for enrollment

Thurs. Nov. 12, San Francisco

ERICK AHRENS, M.B.A., B.S., is senior business analyst at UCSF, leading development of business intelligence (BI) and data mart. He taught application service provider (ASP) design and development at UC Berkeley Extension, and business analysis and database at University of Phoenix. His research interest is Software as a Service (SaaS) for automated compliance with environmental regulations at Instiva.

• 5 meetings
• Nov. 12 to Dec. 17: Thurs., 6:30-9:30 pm (no meeting Nov. 26)
• San Francisco: Room 807, UC Berkeley Extension Downtown Center, 425 Market St., 8th Floor (enter on Fremont St.)
• $425 (EDP 311951)

Quick Enroll	Search