Yes. You can upload flat files to create Analytic Models. Kyubit transforms these files into a multidimensional structure, allowing you to slice, dice, and drill down just like you would with an OLAP cube.
Yes. When analyzing SSAS cubes or SQL data, users can perform drill-through actions to see the raw row-level data associated with a specific cell or chart element, provided they have the necessary permissions.