MIS 563 COURSE PROJECT

2806 words 12 pages
Table of Contents

Findings…………………………………………………………… 2
Issues………………………………………………………………. 2
Opportunities………………………………………………….. 3
Recommendations………………………………………….. 3
Next Steps………………………………………………………. 3
Project Schedule…………………………………………….. 4
Database Design…………………………………………….. 4
Data Modeling & Data Marts…………………………. 4
Database Selection…………………………………………. 5
ETL Selection………………………………………………….. 5
Data Mining…………………………………………………… 6
Conclusions………….………………………………………… 8
References…………………………………………………….. 10

Findings:

ABC University has several departmental databases that perform specific functions for each department. Within these databases are several items that can be considered cross functional data among
…show more content…
Microsoft Visio is the easiest of any of the tools for an end user or database design to read, interpret and modify.
Database Selection In my experience of BI, the mainstream database tool that is used in most companies is Microsoft SQL Server. Microsoft SQL Server BI Tools has the ability to build the database structure and have BI Tools on top of the database to directly analyze data through cubes using Microsoft SQL Server Analysis Services and can also serve up custom reports straight from SharePoint or another service using SQL Server Reporting Services. The users can connect to the cubes using Microsoft Excel Pivot tables, or one of the of the Microsoft tools like Microsoft Power Query or Microsoft Power Pivot.

ETL Selection
For the ETL process design and development at ABC University, we will be sticking with the Microsoft tools for the ease of integration and the use of one vendor for this project. We will be utilizing Microsoft SQL Server Integration Services (SSIS) to finish the ETL Process. Again as explained in earlier documentation, the Microsoft Business Intelligence tools are the most commonly used suite of tools among businesses and have the most people versed in using them. They are not as complex as some of the other tools on the market such as Oracle. I do not have personal experience with the other tools such as Informatica, Ab Initio, Business Objects, or IBM Infosphere,

Related

  • Acct 505 Course Project
    1440 words | 6 pages
  • Hrm 590 Course Project Part a
    1165 words | 5 pages
  • Netw583 Course Project
    3668 words | 15 pages
  • Course Project
    2311 words | 10 pages
  • Mgmt 591 Course Project
    2615 words | 11 pages
  • mgmt 597 course project
    1942 words | 8 pages
  • Course Project Acct 312
    4052 words | 17 pages
  • Linux Course Project
    2595 words | 11 pages
  • Is535 Course Project
    2768 words | 12 pages
  • Finance Course Project
    1835 words | 8 pages