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, 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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.