Most of the business user use Excel to track day to day information and swear it’s a great database. Excel is a great spreadsheet application but, it’s not really a database at all. Excel however is an excellent complement to any database since its can turn row after row of data into attractive useful information.
Excel also lists as one of the many data sources of SmartAnalytics, in order to import the data from excel use it to create reports / analytics or integrated it with data obtained from other data sources.
Advantage of Excel as Data Source
- Easy to access and maintain the spreadsheet; and easily used with Smart Analytics
- All the records are stored at one location as it is so easy to create
- Easy to understand and implement
- Fast in data fetching