It seems like Data Cleaning a little bit Hectic but an easy task. Even applying Data Mining algorithm on database is easy. But the problem arrives when you want to create an Interactive dashboard and Visualize for analysis. Can anyone guide me on the same?
P.S.: I am using Spreadsheet (EXCEL) as my database file.
I can only guide to go away from Excel. It is not designed for this task. Maybe you could look around on available software, e.g. R and shiny,
https://www.youtube.com/watch?v=VLKKO9Wbsks
R & Shiny is a very impressive software.
I worked in "Microstrategy" as well.
but something was not right.
Check out LabVIEW. Most people think it is strictly for instrumentation control, however, it has developed into a full programming language. It was originally designed for use in laboratories, but, I use it everyday for data analysis, control of instrumentation, data acquisition or modeling of simple problems. I have written many LabVIEW programs that never touch instrumentation or hardware. LabVIEW can interface to Simulink, Matlab, C, C++, C sharp and many other existing programs.
I agree, get away from excel (other than for the comma seperated variable data format), especially for large data sets. When it comes to GUI development, which I think is what you are asking about, my golden rule is "Write software that any idiot can use, because, you will have to use it later". Restated, keep it simple, and intutive, because you'll forget how to use it after a few months.
- Badges
- Science topic
- Similar topics
- Computer Science
- Data Mining