Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

8 . We've mentioned future proofing many times. After all, if your query breaks next week, what was the point of automating everything? Future proofing

8. We've mentioned future proofing many times. After all, if your query breaks next week, what was the point of automating everything? Future proofing and testing are essential. Which of the following should you consider when building queries in Power Query? Select ALL correct answers.
a. Do I need to add comments to help the next user to navigate my queries?
b. Think about how the data might change in the future. How can you make your queries more robust against predictable changes in layout, such as the number of columns?
c. What data types will be needed for our analysis, and what data types should we set in our query?
d. Does my data really need to be loaded to an excel table, or will a connection suffice?
e. Will any of power query's automatically inserted steps mess up our queries if things change in the future?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Microsoft SQL Server 2012 Unleashed

Authors: Ray Rankins, Paul Bertucci

1st Edition

0133408507, 9780133408508

More Books

Students also viewed these Databases questions

Question

How does national culture relate to organizational culture?

Answered: 1 week ago

Question

2. Identify issues/causes for the apparent conflict.

Answered: 1 week ago