Skip to main content Skip to navigation
Mauricio Featherman Mauricio Featherman Ph.D

MIS 557 Designing Business Intelligence Systems

All course content at

Course Overview:

The course reviews current BI architecture formats, and the designing of BI systems from both a managerial and technical perspective. The metaphor for the course is the creation of a data pipeline that provides processed data to reporting and interactive analysis systems. Therefore the course covers the role and technologies related to data-based transaction processing systems, and the data warehouses that provide a stable and accessible platform for corporate reporting and analysis.

The course begins with a review of T-SQL, and the creation of views, and stored procedures. These objects are used to build a strong foundation This database-oriented introduction invigorates the student to accept an easier reporting and data management paradigm. Students learn about the logical design of data warehouses, the ETL process and the creation of data cubes. After the process of data warehouse design and population are covered, students learn hierarchical multi-dimensional analysis using MDX programming (similar to T-SQL) and the creation of management dashboards. From a managerial perspective the role of enterprise data governance, BI architecture and use-cases of Data Warehouse implementation are covered. The technologies covered include SQL Server a) Management Services, b) Integration Services, c) Analysis Services and d) Reporting services. Dashboards are built on top of the extracted data cubes, using different technologies.

The ETL process of extract, transforming and loading transaction data into the data warehouse is covered along with the data cleansing, harmonizing, and data management processes. This process gives the course participant strong T-SQL, SSIS and SQL Server skills which remain vital to career success as a management analyst.

The course then investigates the information workers evolving enquiry process, the persistent need for new datasets and the mapping of the organization’s information needs to the data cube and management dashboard creation process. Coupled with the prior focus on using data, this course focuses on how to get data and format as needed (create cubes to use in subsequent BI/BA applications).

The course also covers managerial aspects and cases to investigate the planning and implementation of BI systems. Students will be asked to teach a module of the class on data governance.

While the course may be the most technical of your academic career, the focus will remain in the context of the management analyst harnessing the power of technology to monitor business processes, perform analyses of business performance with the goal of providing a report of recommended action.