Description
Task1:words:300
Excel is probably the most popular spreadsheet software for PCs. Why? What can we do with this package that makes it so attractive for modeling efforts?
Task2:words:300
What are the common business problems addressed by Big Data analytics? In the era of Big Data, are we about to witness the end of data warehousing? Why?
Explanation & Answer
View attached explanation and answer. Let me know if you have any questions.
1
The popularity of Excel and Big data Analytics
Student’s Name
Institutional Affiliation
Course
Instructor’s Name
Date Due
2
The popularity of Excel and Big data Analytics
Task 1: Reason for popularity of excel spreadsheet software
Excel is available for macOS and Windows and has many features compared to other
spreadsheet software. When dealing with bid data, excel can handle a more extensive
spreadsheet as it contains over 17 billion cell counts. Added functions like powerful filters and
INDEX MATCH allow data display as per the user's preferences. Features like pivot tables and
conditional formatting enhance workflow speed in just a click by recording macros. Excel has a
user-friendly interface with a customizable access toll bar for placing vital functions used for
faster access. It is possible to compute calculations using a local machine without involving the
server, an advantage in performance over Google sheets which needs web options only (Brookes,
2019). Excel shares f...