What is R If you keep seeing R software mentioned and have never used it. I recommend downloading and installing it to see how it works and what you can do with the software. I used it for my Data Mining class from the University of Louisville. It is a great software package that makes … [Read more…]
Preventative Maintenance Data Mining Overview One of the benefits of storing vast amounts of data is the ability to use this data to search for patterns to make your business more efficient. For businesses that rely on equipment that needs regular maintenance data mining can provide an advantage over your competition. Historical data is used … [Read more…]
Enterprise Architecture – Parts of a Data Architecture The data architecture program within an Enterprise Architecture initiative will include many documents about the data processes within your organization. To begin this exercise you must determine what applications are in scope to explore and document. Beginning with the physical database schema for the applications included create … [Read more…]
Data Management – Beginnings Every reporting project begins with the need for data from the applications presented to the users in the best format possible to enable business decisions. This can be an easy process or very complex depending upon where the data is coming from. Simple reporting can be accomplished when the data is … [Read more…]
PowerPivot Excel 2013 offers the add-in of PowerPivot for self service Business Intelligence. To access these features you must activate the Power Pivot add-in. Filter data when importing. Rename tables and columns as you import data in PowerPivot. Manage the model and create relationships using drag and drop in the Diagram View. Apply formatting (to … [Read more…]