Database Mining Learn Data Tables, Data Form and Analyze Data Using Pivot Tables etc
Advanced Database Mining Using Microsoft Excel
About Database Mining Course:
We are surrounded by databases. All accounting programs, sales programs, inventory programs and other business programs include a database. There is the main database in your corporation; there are databases on the web and all kinds of other departmental databases.
Working with larger database systems
With Excel you can develop analyses and reports that would be impossible or unaffordable to develop even with very sophisticated enterprise level database programs. Corporations that can afford these million dollar systems rely often on Excel to analyze the data and design reports to support very important decision making processes. Some of the most powerful analysis tools in Excel actually have database functionalities like sorting, filtering, subtotals, and pivot tables.
Why would you need to develop your own database?
Usually, very valuable data at the departmental level are not stored in the centralized mega database because they have no “corporate” significance but a departmental level database can be created and the data used for very critical decisions. Example databases are: sales by salesmen by region or product; customer demographics; simplified inventory system; tracking prices and indices; etc.
Database Mining Course Objectives:
This program caters to anyone wanting to have an edge over their peers in terms of analyzing data using various advanced functions and features of Microsoft Excel. Participants will learn not just to use these functions and features, but how best they can exploit it for the purpose of decision making with any given raw set of data.
Target Audience: Anyone who uses Excel on regular basis for data analysis, forecasting, and decision making. Advisable for participants to attend the “Advanced Microsoft Excel Tips and Techniques for Management” program first.
Training / Course Outline:
1. Understanding concept of a database
2. Applications of Logical Functions (IF, NOT, AND, OR)
3. One-way and two-way data tables
4. Creating a Data Form, and moving around on the Form
5. Introducing array formulas
6. Dimensions of an array (one and two dimensional arrays)
7. Working with array formulas (learning the application of array formulas with other built-in Excel functions)
8. Performing operations on an array (some use of mathematical operators within arrays)
9. Understanding some Database functions
10. Working with Lists (understanding what you can do with lists)
11. Filtering a List (application of filters and advanced filters for summarizing data)
12. Applying Database functions with Lists
13. Using external database file (understand how Excel extracts data from an external file)
14. Performing a query
15. Analyzing data with Pivot Tables (another method of summarizing, analyzing and presenting data)
16. Application of a scenario for maximizing, minimizing or best case events
17. Using the Solver (Excel add-in) for optimization problems (i.e. maximizing profit; minimizing cost; etc)
18. Putting it all together (case study given)