Learn how to quickly create a new connection to a database and access, query and subset data using the ‘Query Builder’:- Accessing- Querying- Sub setting- Saving- Updating
Situation: As the production manager, you need to access product, customer and address information to release product from the warehouse.
Task: The problem is that the critical parameter information along with address details for the driver are in multiple tables within a database.
Action: You use the Query Builder to access the database, query the data that you need subset it and save the information to a data table for analysis.
Result: You create multiple reports that demonstrate your product is stable and capable of meeting specifications for the critical parameter.
Next Steps: Your query and analysis is saved along with an Add-in that you and your team can quickly run the next time you need the information.
There are no labels assigned to this post.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.