20. Given a line graph showing profit by month of order date, what should you do to show a forecast for the next 3 years?
Correct Answer: Go on Analytics tab, Drag Forecast to the chart, Right click anywhere in the chart, Select Forecast options, change Forecast length to 3 years and click Ok.
Question: How to “Drag” Forecast from Analytics tab? I can’t do it.
Make sure that you have a line chart built like this – Order Date on the Columns shelf (right click it and select the continuous Month – where it says May 2015 as an example) and Profit in the Rows shelf. Now Forecast should be enabled and you should be able to drag it.
Thank you so much for this ! I followed your desktop specialist exam and passed with flying colours. Was looking for data analyst tests and came across your mock tests. The real test questions are very close to how you modelled. Just scored 93% for your first test, good to find my weakness. Thank your !!
Hey! Question 30. When you calculated the average amount you discover that the result is not including the missing data. You want to calculate the Average Amount. What formula should you use?
Answer Provided: ZN(AVG([Amount])) Correct Answer: AVG(ZN([Amount])).AVG(IFNULL([Amount],0)) AVG(ZN([Amount])) – won’t show you zero, when data is missing, I checked. The right answer is either one I gave (ZN(AVG([Amount]))) or AVG(IFNULL([Amount],0))
The correct options are 1 and 4. You’ve chosen ZN(AVG([Amount])) – it’s not correct since the first calculation made will be the AVG([Amount]) – which will not include the missing data. After that calculation is made the ZN function appears. AVG(ZN([Amount])) however is correct since the first function that runs is ZN – it will check all the values and replace null with 0, after that the AVG function will calculate on the results of ZN – it won’t show any 0 because we will only see the final average result (made on all values, including nulls that were transformed in 0).
AVG(IFNULL([Amount],0)) – is doing the same thing as AVG(ZN([Amount])).
Hi! I took the test and there were no answer options for MAC for example “Right click (control-click on a Mac) the map and change to Density map.” above.
Why do you have them in your test prep? It is confusing
The real exam is taken on a virtual machine with Windows, but preparing for the exam can be done on Mac as well. So, the controls for Mac are included for the users that use Macbook computers at home and want to prepare on them for the exam without creating a virtual machine with Windows.
Thank you Tracye! I added answers to question 59 and changed the second graph on question 9.
Hi,
I am afraid I don’t fully understand. Can you please elaborate? Are you referring to the solution guide?
Thanks,
Narcis
20. Given a line graph showing profit by month of order date, what should you do to show a forecast for the next 3 years?
Correct Answer: Go on Analytics tab, Drag Forecast to the chart, Right click anywhere in the chart, Select Forecast options, change Forecast length to 3 years and click Ok.
Question: How to “Drag” Forecast from Analytics tab? I can’t do it.
Hi Rich,
Make sure that you have a line chart built like this – Order Date on the Columns shelf (right click it and select the continuous Month – where it says May 2015 as an example) and Profit in the Rows shelf.
Now Forecast should be enabled and you should be able to drag it.
Hope this helps,
Narcis
Thank you so much for this ! I followed your desktop specialist exam and passed with flying colours. Was looking for data analyst tests and came across your mock tests. The real test questions are very close to how you modelled. Just scored 93% for your first test, good to find my weakness. Thank your !!
Hi Vaskar,
Congratulations on passing the exam! We’re happy you’ve found the practice tests useful.
Thank you,
Narcis
Hey!
Question 30.
When you calculated the average amount you discover that the result is not including the missing data. You want to calculate the Average Amount. What formula should you use?
Answer Provided: ZN(AVG([Amount]))
Correct Answer: AVG(ZN([Amount])).AVG(IFNULL([Amount],0))
AVG(ZN([Amount])) – won’t show you zero, when data is missing, I checked. The right answer is either one I gave (ZN(AVG([Amount]))) or AVG(IFNULL([Amount],0))
Hi Anastasiia,
The correct options are 1 and 4. You’ve chosen ZN(AVG([Amount])) – it’s not correct since the first calculation made will be the AVG([Amount]) – which will not include the missing data. After that calculation is made the ZN function appears.
AVG(ZN([Amount])) however is correct since the first function that runs is ZN – it will check all the values and replace null with 0, after that the AVG function will calculate on the results of ZN – it won’t show any 0 because we will only see the final average result (made on all values, including nulls that were transformed in 0).
AVG(IFNULL([Amount],0)) – is doing the same thing as AVG(ZN([Amount])).
Hope this helps,
Narcis
Hi!
I took the test and there were no answer options for MAC for example
“Right click (control-click on a Mac) the map and change to Density map.” above.
Why do you have them in your test prep?
It is confusing
Hello,
The real exam is taken on a virtual machine with Windows, but preparing for the exam can be done on Mac as well. So, the controls for Mac are included for the users that use Macbook computers at home and want to prepare on them for the exam without creating a virtual machine with Windows.
Hope this makes it clearer.
Narcis
Thank you! with your help I approved my exam! cheers!