basic project on ssis,ssas,mdx -- 3
$30-250 USD
Paid on delivery
i need a basic on ssis and ssas for a basic college database and that should be developed on the basis of my professor database table. This a very basic pro
this should be done in mdx
(1%)
Write an MDX query that displays the matrix of Departments (Rows) and Grades (Columns). Each cell represent the number of students who earned the respective grade in the respective department across all semesters.
(2%)
Write an MDX query that shows the top 10 cities in terms of sales for all time. This is the kind of question that marketing might ask in order to see where their marketing spend is having the biggest impact.
(3%)
Write an MDX that calculates the student GPA. It’s up to you to determine how best to display this information!
Academic Integrity:
Students must work on this assignment on their own! Any student submitting duplicate or similar work (to be determined at the discretion of the professor) will receive a zero grade for the assignment.
Do not download and submit code from the internet. If you cannot answer questions regarding your code then you will receive a zero grade for the assignment.
Submission:
Save your MDX statements (numbered 1, 2, 3 accordingly) in a [url removed, login to view] file and upload it to this link:
Project ID: #10844019
About the project
Awarded to:
2 freelancers are bidding on average $153 for this job
Dear You, I am really interested to work on this project, I can start the work now , and can provide the best services from my end. Please come on chat to discuss more about the project. Thanks!
