This course provides concepts, principles, and tools for designing, implementing, and using Data Warehouses. More specifically, we introduce database constructs such as Operational Data Store (ODS), Data Warehouse, and Data Mart, as well as their components. We study the differences between Ralf Kimball's and Bill Inmon’s approaches, roles and responsibilities in the design and implementation of a Data Warehouse, project management guidelines and techniques, requirements gathering, dimensional modeling, Extract Transform and Load (ETL) architecture, specification and data loading, master and reference data management, integration approaches (ETL, EII, EAI), analytical reporting concepts, data governance and recent trends in the data warehouse domain. The course will leverage a portfolio of SQL Server tools that include SQL Server DBMS, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Service (SSAS) to provide hands-on experience in implementing a reporting solution through assignments, lab exercises and projects.
Internal Number: 80161
About Syracuse University
Syracuse University is a place where talent, desire, and opportunity thrive. In 12 different schools and colleges that span the liberal arts and professional disciplines, students, faculty, and staff from diverse backgrounds come together to learn, create, and break boundaries.
The University is also a vital part of the community, providing services as well as being a leader in employee benefits, work-life and organizational development, training, student employment, staff relations, and workforce diversity.
Syracuse itself is located at the crossroads of New York State, and offers a lush landscape of seasons. From fun-filled summers in the Finger Lakes to snowy winters that thrill outdoor sports enthusiasts, the area truly has something for everyone.