Downloaded 166 times
Data Mining with MS Access
- 1. DATAMINING withMS ACCESSBy Dhatri ChandraMouli Yashoda
- 2.
- 3.
- 4.
- 5. Snapshots of theentire processPurpose ToolsTo integrate an Excel sheet into a Database format.Involves capturing of data from different sources, reformatting it and storing it in a data warehouse. Loading the result data in the destination database.Microsoft Excel 2007Microsoft Access 2007Access to MySql conversion toolPhp MyAdmin tool (for representing it on a database server)
- 6. Technique : ETLExtractionof data content from Excel sheet using MS Access.
- 7. Transformation (filtering, cleaning,converting, changing) of the extracted data with the help of MS Access tools.
- 8. Loading the transformeddata onto a web server using Php MyAdmin tool.Data ExtractionData TransformationData Loading
- 9.
- 10. Source data inExcel and filter removal
- 11. Source Data withoutFilter
- 12. Create a blankDatabase on MS Access
- 13. Choose External datato Import Excel sheet on MS Access launch
- 14. Choose the Excelfile to be imported
- 15.
- 16. Select Line asColumn title
- 17.
- 18. Set Date asIndex
- 19. Set Time asIndex
- 20. Set Room asIndex
- 21. Set Event asIndex
- 22. Set Dozent asIndex
- 23.
- 24.
- 25.
- 26. Imported data fromExcel to Access
- 27. Sort data accordingto Date, Time and Room – Step 1
- 28. Sort data accordingto Date, Time and Room – Step 2
- 29. Sort data accordingto Date, Time and Room – Step 3
- 30. Sort data accordingto Date, Time and Room – Step 4
- 31. Sort data accordingto Date, Time and Room – Step 5
- 32.
- 33.
- 34.
- 35.
- 36. Finding Duplicate Entries– Step 1
- 37. Finding Duplicate Entries– Step 2
- 38. Finding Duplicate Entries– Step 3
- 39. Finding Duplicate Entries– Step 4
- 40. Result for duplicateentries
- 41. MS Access toMySql
- 42.
- 43. Select the databaseand continue
- 44. Create a dumpfile
- 45. Select the requiredtable and click on next to continue
- 46. When clicked onRun, conversion as shown below will take place
- 47. Conversion complete –Exit on Finish
- 48.
- 49. Launch phpMyAdmin serverand select an existing database
- 50. Below shown Sqllines can be deleted from the dump.sql file
- 51. Import dump.sql filefrom the Import Tab
- 52.
- 53. Data is nowon the server
- 54.