In This Chapter
Using Excel to examine your data
Formatting and summarizing data in Excel
Automating tasks in Excel
Improving your business with KNIME
In this day and age, when it seems like everything is going to the cloud, standard installable desktop applications are fewer and farther between. Nonetheless, there are still a few programs out there that you can install on your computer and use for data science tasks. In this chapter, I explain how you can use Microsoft Excel to perform some basic tasks to help simplify your project work in data science. I also introduce a free, open-source analytics platform called KNIME and discuss how you can use that to perform advanced data science tasks without having to learn how to code.
Microsoft Excel holds its own special place among data science tools. It was originally designed to act as a simple spreadsheet. Over time, however, it’s become most people’s first choice in data analysis software. In response to user demands, Microsoft has been adding more ...