The graduate project is to write a paper that leveraging the information gained from class. The goals of the paper are to define a business intelligence need and describe the details to complete an SQL Server analysis Services solution. The paper should have sufficient detail that demonstrates your understanding of the topics covered in class. The scenario presented in the paper can be one from personal experience or completely fictional. If the description is from personal experience you should generalize the description. The paper is worth 20 points.
The paper should address the following main topics.
• Define the business problem
• Define the source data
• Define the data model
• Define either a SQL Server Analysis Services Multidimensional Model or Tabular model
• Define some business calculations for your SQL Server Analysis Services model
• Describe your reasoning for choosing one or the other model
• Describe opportunities to apply data mining to your business problem
The section on defining the business problem is where you define the particular business needs that require a business intelligence solution. Examples of business needs might be:
• Understanding of customer purchase history and trends
• Understanding and controlling expenses
• Understanding inventory and the supply chain
You should describe some of the business questions the scenario would support. Examples of these types of questions include:
• What is my customer purchase history by geography, by customer demographic, by time? What is customer sales compared to the previous period?
• What are my inventory levels at a point in time, what is the average inventory levels for the last year, what is my inventory compared to the same period last year?
The section on defining the source data should describe the types of business systems that would contain the information required to address the scenario and business questions described in the business requirements section. This can be a general description of the systems involved. For example customer information may come from a customer relationship management (CRM) system. You do not need to describe the data model for these systems.
You should describe the types of information that you would use to populate your dimensional model.
The section on define the data model should describe the dimensional data model that will provide the foundation of the SQL Server Analysis Services model. Text description on the type of facts and dimensions would be appropriate. In addition, the attributes that you would include in the dimensions to support your business requirements. If a diagram helps support your descriptions, you may include it in your paper.
Based on the information discussed in class define either a SQL Server Analysis Services Multidimensional Model or Tabular model to support your business requirements. You do not need to define every aspect of the model, but provide sufficient detail to cover the main points of the model.
Define the business calculations for your SQL Server Analysis Services model. You do not need to write specific MDX or DAX calculations, but describe the calculations that you would put in the SQL Server Analysis Services model. The purpose is to think about the various calculations that are best suited for Analysis Services versus writing out the exact syntax of MDX or DAX.
Examples include:
• Simple calculated measures such as profit.
• Time based calculations such as parallel period calculations or moving averages.
• Semi-additive calculations such as inventory counts.
• What key performance indicators (KPI) would you include if any?

In the previous section you selected one either a Multi-dimensional model or Tabular. In the next section describe your reasoning for choosing one or the other model. What are the main points or capabilities in the selected approach that fit your business needs?
In class we discussed data mining and various ways that data mining might be applied to a business intelligence project. In this section describe opportunities to apply data mining to your business problem. Examples include:
• Predicting future customer spend based on historical sales.
• Understanding customer characteristics that purchase similar products.

Solution Preview

This material may consist of step-by-step explanations on how to solve a problem or examples of proper writing, including the use of citations, references, bibliographies, and formatting. This material is made available for the sole purpose of studying and learning - misuse is strictly forbidden.

Business Problem Selection – the identification of the IT security threats in an organization had become a complex matter nowadays because of the sophistication level (e.g. number of rounds, heuristic signatures) reached by malware and cyber-attacks. Although the preventive and proactive measures play a significant role in the mitigation strategies, in many situations it would bring benefits (with respect to costs and involved resources) to have advanced ways for analyzing security data. Another challenge faced by most of the organizations is to first gather security data originating from multiple sources before performing any analysis on it...

This is only a preview of the solution. Please use the purchase button to see the entire solution


or free if you
register a new account!

Assisting Tutor

Related Homework Solutions

Questions about Oracle 11g
Homework Solution
Computer Science
Oracle 11g
System Privilege
Block Size
Database System Concepts
Homework Solution
Data Normalization
Homework Solution
Get help from a qualified tutor
Live Chats