Tally Business Intelligence

Fast, easy and quick way to access Tally Data:

We have made simple to use and simple to deploy extraction, load and transform products that help in faster, easier and more convenient report making

Our products help compress data and reduce the number of lines of sql required to make the reports. The above 2 features help in the following:

Faster report making: this is achieved through the following

·        Separation of the transaction and the reporting layer
·        Reduction in the size of the database to be queried through the star schemas
·        Reduction in the sql required to make the reports. This is achieved through pre coding of business logic, reduction in joins after normalization(through star schemas)
·        Incremental load

Easier report making: for easier report making we have enabled the following features.

·        Easy to deploy solution.
·        Easy to use solution
o   The solution should work across multiple companies simultaneously
o   The solution has business logic coding layer for pre coding of business logic.
Convenient:

·        There is little maintenance required for the solutions.
·        Large data loads shall be handled very easily over long periods of time.
·        The solutions are scalable over multiple clients

Low risk:
·        ETL/ELT process is a product, not a service.

Lower costs:
·        Expensive ETL tools and resources are not required.
·        The solutions are easily deployable.

Our team seeks to minimize the report refresh times(for maximum concurrency), minimize report reload times(to reload maximum number of reports in nightly ETL) and minimize the ETL times(to enable maximum number of reports to be reloaded).

Attached demos are for the extraction piece:

2 minute demo: https://www.youtube.com/watch?v=1ySNrgI4Na0&feature=youtu.be

6 minute video: https://www.youtube.com/watch?v=uY3edSdLDhc

15 minute detailed demo:

https://youtu.be/k9Oe9EDRfTM

Installation video: https://www.youtube.com/watch?v=qIjf6e_5KpA&t=3621s

For end clients that prefer using ETL tools, attached are the links:

Step by step guide using SSIS: https://www.youtube.com/watch?v=j9H0wMMx1oY

One can consider an exhaustive case study for inventory optimization for Tally

For case studies for optimizing inventory using various Business Intelligence tools, click here

Due to data compression and sql reduction, the ETL team is able to carry out high end predictive analytics that help the end client optimize its inventory and increase the sales of slow moving products.

Sample Tally connector set up file: https://www.dropbox.com/s/nw6g4v7zhb5auym/Database%20%2BTally_ConnectorSetupFile%2804-08-2014%29.rar?dl=0

Inventory valuation details: the inventory valuation methods along with Business Intelligence tools case studies are attached herewith.