$20 Bonus + 25% OFF
$20 Bonus + 25% OFF
Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
Add File

Error goes here

DAT701 SQL Query Assignment

tag 0 Download20 Pages / 4,811 Words tag Add in library Click this icon and make it bookmark in your library to refer it later. GOT IT


This company has a presence in 5 countries across 5 industries (Segments) within each country. Calculate the total sales per year and the total profit per year for each Country / Segment. Note that profit can be calculated: Write & then run this query and include a screenshot of the results.Produce one or more visualisations using PowerBI to display this information.Based on your visualisations, which region performed the best? Which region performed the worst?

Each sales person has a yearly sales KPI. This is their yearly sales target which they are expected to meet. I’d like you to use this information to calculate a yearly sales KPI for each Country and Segment:Include your t-sql below.

Once you have calculated this KPI, calculate the yearly performance against the KPI (i.e. if the KPI for Mexico, Midmarket is $100,000 and the total sales was $110,000, then the yearly performance would be 110%). Include your t-sql below. Not done Produce one or more visualisations in PowerBI to show this information.

3A: A lot of information about sales performance is lost when it is aggregated yearly. Change your query from (Query Two 2B) to calculate the month-by-month total sales performances and plot these data in PowerBI. include your t-sql and a screenshot of your visualisations below.

3B: What general conclusions can you draw from this visualisation? Justify your reasoning.Finally, the company wants to reward the best performing sales people. But they don’t really know what they mean by “best performing”.  Not done Explain how could you rank & compare each salesperson’s performance Create a query & one or more visualisations that allows the company to explore the performance of their salespeople. Include the t-sql and a screenshot of the visualisations below. Not done

Using your results, which salespeople do you believe are the “top 10 best performers”

Download Sample Now

Earn back the money you have spent on the downloaded sample by uploading a unique assignment/study material/research material you have. After we assess the authenticity of the uploaded content, you will get 100% money back in your wallet within 7 days.

Unique Document

Under Evaluation

Get Money
into Your Wallet

Total 20 pages, 1 USD Per Page

Cite This Work

To export a reference to this article please select a referencing stye below:

My Assignment Help. (2021). SQL Query Assignment. Retrieved from https://myassignmenthelp.com/free-samples/dat701-sql-query-assignment/reporting-queries.html.

My Assignment Help (2021) SQL Query Assignment [Online]. Available from: https://myassignmenthelp.com/free-samples/dat701-sql-query-assignment/reporting-queries.html
[Accessed 18 April 2021].

My Assignment Help. 'SQL Query Assignment' (My Assignment Help, 2021) <https://myassignmenthelp.com/free-samples/dat701-sql-query-assignment/reporting-queries.html> accessed 18 April 2021.

My Assignment Help. SQL Query Assignment [Internet]. My Assignment Help. 2021 [cited 18 April 2021]. Available from: https://myassignmenthelp.com/free-samples/dat701-sql-query-assignment/reporting-queries.html.

Do preparing flawless assignments seem too daunting for you? Opt for the outstanding services of MyAssignmenthelp.com, and witness a huge difference in your academic grades. Whether you are searching for college essay examples, thesis examples, dissertation topic or other essay examples, you will have our unwavering assistance. Apart from that, our experts can also help you out to gain remarkable ideas on how to complete different kinds of assignments successfully. From choosing a remarkable essay topic, conducting a valuable research, writing a strong introduction, to following all the citation norms, our experts can guide you with all. Visit MyAssignmenthelp for more details.

Latest Operations Samples

ELE5PRB Brick Escalator Controller

Download : 0 | Pages : 6

Answer: PID control algorithm is used in most advanced motion control application for increased accuracy and efficiency. There are three control loops that can be controlled using a PID controller which are torque, velocity and position respectively. In vehicles which do not have the electronic controls do not have the linear motion though same power is transferred independently to the wheels. The non-linear motion of the vehicle is caused mai...

Read More arrow

MGT603 Business Operations Management

Download : 0 | Pages : 4

Answer: Describe the overall goal of a supply chain. The main goal of supply chain management is to deliver the best values to the customers. This can be done by taking the products to the desired destination at the right time (Jacobs, Chase & Lummus, 2014). They have to ensure that the products are being delivered in a fresh and proper state. An effective supply chain is one that will help in minimizing the cost and maximizing the o...

Read More arrow Tags: United States saint george Management University of New York 

BRE810 Business Research

Download : 0 | Pages : 25

Answer: Introduction: The report is focused towards understanding the challenges that affect the operations of a Sydney based small and medium sized enterprise named SVSR PTY LTD. The company primarily deals in sewer venting facilities and mini crane hire services. The problem issues that the project will focus towards concerns the sewer venting operations of the company. The sewer venting facilities that are provided by the company focuses t...

Read More arrow

BUS 430 Operations Management

Download : 1 | Pages : 7

Answer: About Starbucks Starbucks is a coffee company based in the United States which operates a huge coffeehouse chain all over the world. The organization was established in the year 1971 in Seattle, Washington. The company has its current operations in more than 28,000 locations all over the world. Starbucks is also considered to be a major representative of the concept of “second wave coffee” which has been able to distinguis...

Read More arrow

MGT632 Operations Management

Download : 0 | Pages : 24

Answer Operation Management Introduction  The current report is been carried out with the intention to document and focus upon the organisation observed under field trip. It would include the information collected and facts learned about the two companies i.e. New Zealand courier and Pizza hut. Both the companies include effective supply chain operations which would be discussed in the report elaborately. The report would further ev...

Read More arrow

Save Time & improve Grade

Just share requirement and get customized Solution.

We will use e-mail only for:

arrow Communication regarding your orders

arrow To send you invoices, and other billing info

arrow To provide you with information of offers and other benefits

Add File

Error goes here




Overall Rating



Our Amazing Features


On Time Delivery

Our writers make sure that all orders are submitted, prior to the deadline.


Plagiarism Free Work

Using reliable plagiarism detection software, Turnitin.com.We only provide customized 100 percent original papers.


24 X 7 Live Help

Feel free to contact our assignment writing services any time via phone, email or live chat. If you are unable to calculate word count online, ask our customer executives.


Services For All Subjects

Our writers can provide you professional writing assistance on any subject at any level.


Best Price Guarantee

Our best price guarantee ensures that the features we offer cannot be matched by any of the competitors.

Our Experts

Assignment writing guide
student rating student rating student rating student rating student rating 5/5

134 Order Completed

95% Response Time

Thomas Nelson

MS in Information Systems Technology with Specialization in Database Administration

New Jersey, United States

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

755 Order Completed

95% Response Time

Douglas Cowley

Masters in Finance with Specialization in Audit

Wellington, New Zealand

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

2632 Order Completed

100% Response Time

Albert Ambrosio

MSc in Nursing

London, United Kingdom

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

2109 Order Completed

99% Response Time

Emma Zhong

Ph.D in Project Management with Specialization in Project Communications Management

Singapore, Singapore

Hire Me

FREE Tools


Plagiarism Checker

Get all your documents checked for plagiarism or duplicacy with us.


Essay Typer

Get different kinds of essays typed in minutes with clicks.


GPA Calculator

Calculate your semester grades and cumulative GPa with our GPA Calculator.


Chemical Equation Balancer

Balance any chemical equation in minutes just by entering the formula.


Word Counter & Page Calculator

Calculate the number of words and number of pages of all your academic documents.

Refer Just 5 Friends to Earn More than $2000

Check your estimated earning as per your ability




Your Approx Earning

Live Review

Our Mission Client Satisfaction

I got a very high mark and I am satisfied with the service provided this time. Thank you!


User Id: 546862 - 18 Apr 2021


student rating student rating student rating student rating student rating

It was great. The paper got the details and the information I needed. It was good effort.


User Id: 457776 - 18 Apr 2021


student rating student rating student rating student rating student rating

It was good. The assignment provided good details and I got the information I needed.


User Id: 457776 - 18 Apr 2021


student rating student rating student rating student rating student rating

GOOD! The tutor is professional, responsible and patient. The reply was timely...................


User Id: 604370 - 18 Apr 2021


student rating student rating student rating student rating student rating

Order on the go!

Say hello to our new app

callback request mobile
Have any Query?