UC Berkeley Extension, Golden Bear Center, 1995 University Avenue, Room 210, Berkeley, California
Learn the fundamental principles guiding data warehouse design, dimensional data modeling, and online analytical processing (OLAP) and data including a review of SQL relational database fundamentals. Design data warehouses and data marts to further explore these principles. Build dimensional data models using SQL Server 2012 Enterprise Analytical Services, which supports online analytical processing and data. Course project work uses both workstation-based and Cloud tools for both data warehouse and dimensional modeling exercises. Free Student Access to Cloud SQL Server 2012 Enterprise and Virtual Windows Desktop with Visual Studio Business Intelligence Tools
X426.1 (3 semester units in EECS) Data Warehouse Design and Dimensional Modeling
July 6 - August 10, 2015
UC Berkeley Extension, Golden Bear Center, 1995 University Avenue, Berkeley, California
Learn the fundamental principles guiding data warehouse design, dimensional data modeling, and online analytical processing (OLAP) and data including a review of SQL relational database fundamentals. Design data warehouses and data marts to further explore these principles. Build dimensional data models using SQL Server Enterprise Analytical Services, which supports online analytical processing and data. Course project work uses both workstation-based and Cloud tools for both data warehouse and dimensional modeling exercises.
X411.4 Fall 2013 - Predictive Data Analysis, Warehousing and Mining
Meeting Dates TBD, 6 meetings, Saturdays, 9 am-4:45pm
UC Berkeley Extension, Golden Bear Center, 1995 University Avenue, Berkeley, California
Discover professional strategies and techniques for extracting, cleaning, aggregating and analyzing data through data mining tools so that it can be used to support strategic enterprise decision making such as cluster analysis, trend analysis and decision trees. After a brief review of SQL relational databases, learn the fundamental principles guiding data warehousing, Cloud-based online analytical processing (OLAP) and business intelligence. Develop your practical skills by turning raw data into useful information. Learn professional strategies and techniques for extracting, cleaning, aggregating and analyzing data through so that it can be used to support strategic enterprise decision making such as cluster analysis, trend analysis and decision trees. Course project work uses both workstation-based and Cloud tools for data warehouse, OLAP, data mining and predictive analytics exercises.
EDP 154625 X411.4 (3 semester units in EECS) Summer 2012 - Predictive Data Analysis, Warehousing and Mining
July 7 to August 11, 2012, 6 meetings, Saturdays, 9 am-4:45pm
1995 University Avenue, Berkeley, Room 210, 2nd Floor
Learn professional strategies and techniques for extracting, cleaning, aggregating and analyzing data through data mining tools so that it can be used to support strategic enterprise decision making such as cluster analysis, trend analysis and decision trees. After a brief review of SQL relational databases, learn the fundamental principles guiding data warehousing, Cloud-based online analytical processing (OLAP) and business intelligence. Develop your practical skills by turning raw data into useful information. Learn professional strategies and techniques for extracting, cleaning, aggregating and analyzing data through so that it can be used to support strategic enterprise decision making such as cluster analysis, trend analysis and decision trees. Course project work uses both workstation-based and Cloud tools for data warehouse, OLAP, data mining and predictive analytics exercises. You must install or have access to Microsoft SQL Server Enterprise Database Engine or similar software to succeed in this course.