#02 Tally based Dashboards in Hex Data Notebook - Data Modelling (via SQL Query) скачать в хорошем качестве

#02 Tally based Dashboards in Hex Data Notebook - Data Modelling (via SQL Query)

Second part of end-to-end tutorial for implementation of Dashboards in Hex Data Notebook from Tally Prime ERP data. This part demonstrates process of creating / establishing database connectivity with PostgreSQL database (or any other database supported by Hex). It walks through some basics of drafting SQL query to analyze data, join multiple tables & then create accounting views with debit credit line items. 0:00 Intro 1:34 Establishing database connectivity 4:06 Drafting SQL query (SELECT / FROM / JOIN syntax) 18:22 Conclusion Link of Tally to Database sync utility project https://github.com/dhananjay1405/tall... SQL query of df_accounting_view: select v.date, v.voucher_type, v.party_name, p.parent as party_group, a.ledger, g.name as ledger_group, g.primary_group, t.parent as voucher_category, a.amount from trn_accounting as a join trn_voucher as v on v.guid = a.guid join mst_ledger as l on l.name = a.ledger join mst_group as g on g.name = l.parent join mst_vouchertype as t on t.name = v.voucher_type join mst_ledger as p on p.name = v.party_name where v.is_order_voucher = 0 and v.is_inventory_voucher = 0