Webel IT Australia promotes the amazing Mathematica tool and the powerful Wolfram Language and offers professional Mathematica services for computational computing and data analysis. Our Mathematica
tips, issue tracking, and wishlist is offered here most constructively to help improve the tool and language and support the Mathematica user community.
DISCLAIMER: Wolfram Research does not officially endorse analysis by Webel IT Australia.
It's almost impossible to describe just how incredibly useful and wonderful the Mathematica
Dataset functionality is, and how cleverly it can react to complex data structures. The best way to learn about it is to simply try it out and then click just about anywhere:
anything //Dataset
Note that an Entity database query is also returned as a Dataset!
You can also use Import to suck in the sheets of a spreadsheet and then use Mathematica's nested Lists and super powerful String parsing to turn chaotic spreadsheet data into easily navigable structured data. It's almost too good to be true. And yet it is true. Seeing is believing.