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 [login to view URL] file and upload it to this link:
Hello Sir,
We are an Indian development company here.
we have checked your posted details here and want more clarification in it, so message us to discuss on it more then we will able to move on it.
Thanks
Hi,
I am a software developer with 5 years experience. I have experience with ssis and dtsx. Feel free to contact me for a discussion so that I can fulfill your need.
Thanks and have a nice day.
Regards,
Henry
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!
Hi I am looking forward to work with your proposal. I am having around 6 years of experience in the Software Development.
I have excellent experience in SSIS, SSRS and SSAS.
Currently I am working with world class leading MNC. I would like to discuss in detail if you find my proposal is suitable for your project.