business intelligence

Part A

In this assignment, you will submit a business intelligence solution framework for a university with one online and two physical campuses. The solution will be used by university executives to improve overall student retention and overhead costs.

Instructions:

  1. The BI solution must:
  • Provide real-time data access
  • Access historical institutional data from student databases from the past 15 years
  • Analytic capabilities to combine data sources (i.e., students’ data, course registrations, online/on-campus data, dates of course offerings, etc.)
  • Ability to predict students likely to drop out
  • Easy and secure access to data from multiple divisions within the university departments
  • BI dashboards to present and view the results
  • Model(s) (such as: artificial neural networks [ANN], Support Vector Machine [SVM}, and Linear Regression [LR} models) you recommend using and their rationale
  • You will use SAS code for the model(s) that you will use for this BI framework solution.
    • FOR EXAMPLE: if you’re using ANN model, write/locate ANN SAS code to include in your submission.
  1. Explain in detail how your BI framework solution will work with the above-mentioned characteristics to help executives improve decision making. The executives are the CEO and president level as well as the vice presidents of different departments. Each department will focus on its own data while top executives will focus on the overall university total retention and costs.

Submission Requirements:

Your framework should meet the following requirements:

  • Three to five pages (750-1,250 words) in length
  • Include the screenshot diagram(s) of the BI solution framework
  • Formatted according to APA guidelines as explained in the CSU-Global Guide to Writing & APA (Links to an external site.) (subheadings, one-inch margins, and double spacing)
  • Supported by three credible, academic outside sources in addition to course materials
  • Write clearly and logically, as you will be graded on content, analysis, and your adherence to the tenets of good academic writing, which should be succinct where possible while also exploring the topics appropriately. Integrate and cite scholarly sources to support your work, and supplement your ideas.

Part B: SAS Code – Conditional Situations

For the Part B of this assignment, read certain records to create a new SAS data set called: MYDATA. Subjects less than or equal to 10 years are included in the data set named MYDATA.

  1. Use the EXAMPLE.DATfile as the Input data file.
  2. Save this file in your directory that SAS can see on your hard drive.
  3. Using the SAS code below, view the file created in your Library and see that it works.

Here is the SAS code:

*******************************************************
* This SAS code is an example from the text *
* SAS ESSENTIALS 2nd Ed, Wiley *
* (C) 2016 Elliott, Alan C. and Woodward, Wayne A. *
*******************************************************;

* This example illustrates finding the FIRST and LAST values in a group;

DATA MYDATA;
* Your INFILE statement will vary based on your directory
INFILE ‘/folders/myfolders/sasuser.v94/EXAMPLE.DAT’;
INPUT ID $ 1-3 GP $ 5 AGE 6-9 TIME1 10-14 TIME2 15-19;
IF AGE LE 10;
PROC PRINT DATA=MYDATA;
RUN;

TITLE;FOOTNOTE;

5. Run this program.

6. State your understanding of the result and take a screenshot of the result for this assignment submission.

Submission Requirements:

  • In a Word document, include your statements of understanding and a screenshot of the result.
find the cost of your paper

Case study Analysis( paper)- Prime Bank of Massachusetts

APA format is required. References should be listed immediately after the question that is being answered. Each question lists a minimum number of unique scholarly references; the textbook is considered one unique….

“Letter from Birmingham Jail” was written by Martin Luther King Jr.

Overview “Letter from Birmingham Jail” was written by Martin Luther King Jr., as the title indicates, while he was confined in the Birmingham city jail in April, 1963. King is….

I need to write a medical report to academic advisor

Dear Sir or Madam, I need to write to my academic advisor a medical report ( Turki Alanazi came to our hospital after 14 days of his return from the….