I am currently using QlikView Personal Edition to do some analysis on the inventory of my wholesale business. The data comes directly from my ERP system, a huge Oracle database with a few thousand tables and overall several million rows. As I need a solution that can be used by a whole team, I found Metabase, but I am quite lost on how to start.
I connected the Oracle database and after some time, my tables show up. Do I have to edit all the tables manually now, set most of them to invisible to get a usable tool? Or is there a way to specify the tables to import manually? For the old approach I do have SQL statements that generate for example a table of items, their names and important values for analysis (coming from around 20 tables). Can I use them as starting point?
Or should I add these statements as views to the original database for analysis?
Any help is appreciated.