Building Queries and Using Data Warehouse Tools

In this tutorial, learn how to efficiently query and manipulate data using a data warehouse mining tool. The step-by-step examples cover accessing, exploring, and optimizing queries to enhance data analysis. Gain insights on combining tables, filtering time ranges, and sorting data for better decision-making. Access the tool efficiently and follow along with practical demonstrations to maximize its capabilities.

• Data Warehouse
• Query Building
• Data Analysis
• Tool Tutorial
• Data Manipulation

cturn Follow

Uploaded on Mar 08, 2025 | 0 Views

Download Presentation

Please find below an Image/Link to download the presentation.

The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.

You are allowed to download the files provided on this website for personal or commercial use, subject to the condition that they are used lawfully. All files are the property of their respective owners.

The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.

Presentation Transcript

1. A Data Warehouse Mining Tool Stephen Turner 575-6281 Chris Frala 575-6286 1

2. WARNING: There are A LOT of slides.but they are step-by-step examples Learn how to gain access Take a look around Build some queries and then learn how to manipulate them to serve us better! 2

3. Building some queries Summary of Cost Centers for a BU Manipulating existing queries Summary of Cost Centers for a PI Details of Payroll for a BU Adding filter for a Time Range Details of Payroll for an Individual Adding a Sort feature Outstanding Invoices for a BU 3

4. Icon looks like this If you don t have the icon or you do or it is not active, then here is how to gain access. 4

5. Via Information Technology Services website http://its.uark.edu/ 5

6. 6

7. http://its.uark.edu/Data_Warehouse_Account_Request_Form.pdf 7

8. 8

9. 9

10. 10

11. 11

12. 12

13. 13

14. 14

15. 15

16. Now that we have two tables, we need to combine them Right click on one them and select Query Builder Then in the command bar, select Join Tables And then Add Tables 16

17. This is the default of joining two tables and what is used 99% of the time 17

18. This is the default of joining two tables and what is used 99% of the time 18

19. 19

20. 20

21. 21

22. 22

23. 23

24. 24

25. This is great, but what if I wanted to pull in the Category? 25

26. 26

27. 27

28. 28

29. 29

30. Lets save what we have done first 30

31. What if, we need to know it by PI instead? 31

32. 32

33. 33

34. 34

35. 35

36. 36

37. 37

38. 38

39. 39

40. 40

41. If I have not been to a Table in a while, I usually just Double Click the table. 41

42. Now I look for things I can use. For this example we will use BU, CCN, Pay Amount, Benefits 42

43. Now right click on LABOR_CURRENT and select Query Builder 43

44. Add a Filter 44

45. Selecting multiple BUs 45

46. 46

47. 47

48. But I wanted to know WHO was paid on a given time period. Right click on the Query Builder 48

49. Adding a new field 49

50. Adding a new Filter 50

Load More ...