M.S. in Business Intelligence and Database Systems

Study Synchronously Online or On Campus: It's Your Choice STEM-Certified Program

The Business Intelligence and Database Systems program at Touro University is designed to provide students with the necessary skills and knowledge to excel in the dynamic field of visualizing complex data. Through a comprehensive curriculum that combines theoretical foundations with hands-on training, students gain expertise in a variety of data visualization techniques, tools, and technologies, enabling them to effectively communicate insights and narratives through compelling visual representations.

Emphasizing the development of critical thinking and analytical skills essential for navigating the ever-expanding realm of data visualization, the program prepares students for diverse career opportunities. Graduates of the program are well-equipped to pursue roles such as data visualization specialists, information designers, data analysts, and business intelligence professionals. Coursework encompasses a wide range of topics, including interactive visualization, visual analytics, and data storytelling, providing students with a solid foundation in both the technical and artistic aspects of data visualization.

By mastering the art of transforming complex data into meaningful visual representations, graduates of the Business Intelligence and Database Systems program at Touro University play a crucial role in aiding decision-making processes across various industries. Whether you aspire to make an impact in data-driven organizations, research institutions, or creative agencies, our program equips you with the expertise and tools needed to succeed. Contact us today to discover how our program can help you realize your career aspirations in this exciting and rapidly growing field.

Career options include:

• Data Analyst

• Business Intelligence Analyst

• Data Scientist

• Data Engineer

• Database Administrator

Program Requirements

Business Intelligence and Database Systems
Required Courses
12 credits

Business Intelligence and Database Systems
Elective Courses
9 credits

Program
Core Courses
12 credits

Program
Total Courses
33 credits

Business Intelligence and Database Systems Required Courses

MDAN 631 Fundamentals of Visual Data Analytics: Data visualization is an essential storytelling tool for exploratory and explanatory analysis. This course navigates real-world business problems across different industries, focusing on iteratively deriving solutions through static and interactive dashboards. Students will gain hands-on experience with the latest cloud BI software, ingesting data and structuring relations between disparate sources. Working in agile-like weekly sprints, students will learn to identify patterns and anomalies, conduct prescriptive analyses, and effectively communicate insights to influence decision making of technical and non-technical stakeholders.
3 Credits
MDAN 632 Interactive Data Visualization: Building upon the foundational skills acquired in the prerequisite course, Interactive Data Visualization delves deeper into the intricacies of data analysis and visualization techniques. Through a combination of theoretical concepts and practical applications, students will explore advanced topics in data visualization, leveraging more robust features and functionalities. This course emphasizes the development of advanced dashboard designs tailored to specific business needs and objectives. Students will learn advanced techniques for data aggregation, filtering, and calculations to create dynamic and interactive visualizations that facilitate deeper insights and understanding of complex datasets. By the end of the course, students will have the skills and knowledge to tackle sophisticated data visualization challenges, extract actionable insights from diverse datasets, and effectively communicate findings to stakeholders at all levels of an organization.
Prerequisite: MDAN 631
3 Credits
MSIN 627 Multi-Dimensional Analytics and Visualization: The course introduces the practice of managing data as corporate assets by organizations to gain competitive advantage and meet regulatory demand. The course will also describe the data management emerging profession, and skills required to perform the various data management functions for each role.
Prerequisite: MSIN 615
3 Credits
MSIN 637 Principles of Data Analysis: This course is a hands-on introduction to the field of Data Analytics where students will learn the concepts and tools needed throughout the analysis process from formulating the research question to obtaining, cleaning, and collating data to making inferences and publishing results. Students will also learn how to formulate research questions in “data terms” so that it can be analyzed and identify the limitations imposed by the available data. Students will become versed in sorting data, filtering data and creating data totals. They will learn how to use Pivot Tables. They will also master Statistical Functions, Text Functions, Database Functions, Lookup Functions, and Date and Time Functions among others. Students will be introduced to data types, control structures, functions, and debugging tools. They will learn how to acquire data, what it means to clean data by removing inconsistencies and reformat data so that it can be analyzed by statistical tools.
Corequisite: MSIN 616
3 Credits

Business Intelligence and Database Systems Elective Courses

MDAN 621 R for Data Analytics: Students will learn about the basics and fundamentals of R programming/syntax to eventually being able to write R scripts. R will be used to solve problems related to data. Students will learn to assign variables and perform simple operations with vectors. Students will also learn about lists, matrix, arrays and data frames. To complete the basics, the course will cover conditional statements, functions, classes and debugging. Students will advance to reading and writing data in R, in either table format (CSV, Excel) or in a text file (.txt). Finally, students will cover important functions for character strings and dates in R.
3 Credits
MDAN 622 Python for Data Analytics: This course introduces the basics of the python programming environment, including fundamental python programming techniques such as lambdas, reading and manipulating csv files, and the NumPy library. The course will introduce data manipulation and cleaning techniques using the popular python pandas data science library and introduce the abstraction of the Series and DataFrame as the central data structures for data analysis, along with tutorials on how to use functions such as group by, merge, and pivot tables effectively. By the end of this course, students will be able to take tabular data, clean it, manipulate it, and run basic inferential statistical analyses.
Pre-or Corequisite: MDAN 608 & WMMN 607 or MDAN 610
3 Credits
MDAN 623 Statistics for Data Analytics: This course introduces univariate data analysis methods using statistics. Data visualization methods and practices, and an overview of sampling techniques for data collection. Specifically, this course teaches introductory statistical methods for the analysis and visualization of data and basic concepts of probability theory. Course topics include descriptive statistics, data visualization techniques, an introduction to statistical inference (confidence intervals and hypothesis testing) for decision making, linear regression models, data sampling techniques. The students will learn the statistical package SPSS to analyze data sets from real-world applications.
3 Credits
MSIN 614 Data Transformation, Migration and Integration: This course combines lectures with hands-on labs to teach students necessary skills to install, upgrade, manage & administer SQL Server instances and databases for performance, high availability &Disaster Recover. Topics covered in the class will include System Databases, Data Files, Log Files & Check Points, Memory CPU and Disk Redundancy Discussions, indexing and query optimization, Database backup and restoration, Log Shipping, Database Mirroring, Database Replication, Database Snapshots, Security, Policy Based Management, SQL Agent, Task Scheduling& Automation, Database Mail, Database Maintenance Plans, Monitoring, Alerting & Tuning, Blocking Transitions & Dedicated Administrator Connection.
Prerequisite: MSIN 615
3 Credits
MSIN 616 Advanced Database Management and Data Analytics: Building on Database Management and Administration, the course explores additional data modeling techniques, concepts of database integrity and transaction management, stored procedures, user-defined functions, database programming, query optimization, performance and tuning, and other advanced SQL topics.
Prerequisite: MSIN 615
3 Credits
MSIN 633 Data Modeling, Analysis, and Visualization: This course combines lectures with hands-on labs to help students understand transaction systems, data warehouses, fact and dimension tables, design custom columns, custom tables and create multi-dimensional data models based on a wide variety of data sources. Dashboards and widgets of varying complexities will be created using hierarchies, expressions, and functions for data analysis, visualization and decision support.
Pre- or Corequisite: MSIN 616
3 Credits
MSIN 675 Professional Internship Experience: The student will work in a professional environment, for a minimum of 480 hours over a period of at least two semesters. Students may secure an internship independently or may work with the GST Department of Career Services. Weekly logs and examples of work are required for the successful completion of the internship, and are reviewed by the Faculty Internship Coordinator, upon completion of the internship. The purpose of the internship is to provide students with practical, hands-on experience in their chosen field of expertise to complement their coursework. The Internship must be approved in advance by the program chair.
Pre- or Corequisite: Permission of the Program Chair
3 Credits
MSIN 677 Advanced Data Visualization: In this course, students will explore data analytics and visualization. The course will begin by reviewing analytical methods with an emphasis on the art of crafting compelling data stories. Through lectures, demonstrations, and hands-on tutorials, students will learn how to transform datasets into visualizations and dashboards that communicate key findings and that utilize visual design principles. By the course's end, students will be equipped to present insightful, data-driven narratives that enable decision-makers to discern trends and make informed choices.
Prerequisite: MSIN 627
3 Credits
MSIN 678 Business Intelligence Through Data Visualization and Power BI: This course combines lectures with hands-on labs to teach students necessary skills to connect to Various Data sources, Transform Data, Design Data Models, create, manage, and format Charts/Visuals/DashBoards using various data sources e.g. excel files, SQL Server Databases, and MS Access databases etc. of various complexities & Work with Filtering Students will start with connecting to Datasources, transform data, design models and create simple charts and move onto designing more complex Models and charts of various types including analyzing data over time, trends analysis etc. Advanced formatting, DAX expressions and Filtering will be utilized to make charts stand out.
Prerequisite: MSIN 627
3 Credits
MDAN 675, 676, 677, 678 CPT: MDAN 675: Full Time CPT
The student will work in a professional environment, for a minimum of 480 hours over a period of one semester. The student may secure an internship independently or may work with the GST Department of Career Services. The purpose of practical training is to provide valuable experiences that enhance the skills and competencies the student learns during the Touro degree program, providing the student with practical, hands-on experience in his/her chosen field of expertise to complement the coursework.. These experiences must be directly related to the student’s major area of study and be an integral part of an established curriculum. As such, the student needs approval before pursuing CPT. This is a 3-credit course and will serve as the first semester of CPT. Weekly logs and examples of work are required for the successful completion of the internship, and are reviewed by the Faculty Internship Coordinator, upon completion of the internship. The Internship must be approved in advance by the program chair.
Pre- or Corequisite: Permission of the Program Chair
3 Credits

MDAN 676: Part Time CPT
The student will work in a professional environment, for a minimum of 240 hours over a period of one semester. Students may secure an internship independently or may work with the GST Department of Career Services. The purpose of practical training is to provide valuable experiences that enhance the skills and competencies you are learning through your Touro degree program. These experiences must be directly related to the student’s major area of study and an integral part of an established curriculum. As such, you will need approval before pursuing CPT. This is a 3-credit course and will serve as the first semester of CPT. Weekly logs and examples of work are required for the successful completion of the internship, and are reviewed by the Faculty Internship Coordinator, upon completion of the internship. The purpose of the internship is to provide students with practical, hands-on experience in their chosen field of expertise to complement their coursework. The Internship must be approved in advance by the program chair.
Pre- or Corequisite: Permission of the Program Chair
3 Credits

MDAN 677: Full Time CPT
The student will work in a professional environment, for a minimum of 480 hours over a period of one semester. This working experience must build upon the one experienced in either MDAN 675 or MDAN 676. The student may secure an internship independently or may work with the GST Department of Career Services. The purpose of practical training is to provide valuable experiences that enhance the skills and competencies the student learns during the Touro degree program, providing the student with practical, hands-on experience in his/her chosen field of expertise to complement the coursework.. These experiences must be directly related to the student’s major area of study and be an integral part of an established curriculum. As such, the student needs approval before pursuing CPT. This is a 1-credit course and will serve as the second semester of CPT. Weekly logs and examples of work are required for the successful completion of the internship, and are reviewed by the Faculty Internship Coordinator, upon completion of the internship. The Internship must be approved in advance by the program chair.
Pre-requisite: MDAN 675 OR 676
1 Credit

MDAN 678: Part Time CPT
The student will work in a professional environment, for a minimum of 240 hours over a period of one semester. This working experience must build upon the one experienced in either MDAN 675 or MDAN 676. The student may secure an internship independently or may work with the GST Department of Career Services. The purpose of practical training is to provide valuable experiences that enhance the skills and competencies the student learns during the Touro degree program, providing the student with practical, hands-on experience in his/her chosen field of expertise to complement the coursework.. These experiences must be directly related to the student’s major area of study and be an integral part of an established curriculum. As such, the student needs approval before pursuing CPT. This is a 1-credit course and will serve as the second semester of CPT. Weekly logs and examples of work are required for the successful completion of the internship, and are reviewed by the Faculty Internship Coordinator, upon completion of the internship. The Internship must be approved in advance by the program chair.
Pre-requisite: MDAN 675 OR 676
1 Credit

Any Other Elective Approved by the Dean