Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started