For most of the companies, the transactional queries take a
lot of time. M&N BI’s offerings help crash the execution times of the transaction
queries. This should help the end client with the following:
·
Meeting the SLAs of the Chief Technology
Officers.
·
Saving of the time in nightly processing. For
example the nightly load could take 5 hours instead of 8 hours. With the
additional 3(three) hours, the end client could develop additional dashboards
and reports or restart the process in case of failure.
·
Readymade datawarehouse for developing analytics
and dashboards.
·
Real time ETL for enabling the data extract
·
Lower load on the transaction system.
·
Lower configuration of servers.
·
Lower manpower support costs.
How does the ETL team do the same and what is required?
·
Bottleneck sql queries from the end client: time
of execution and the criticality of the process.
For whom is this offering useful?
·
End clients that require the queries to be
executed quickly.
·
ETL and data analytics companies looking for end
clients.
How will the ETL team solve the problem?
·
Get access to the bottleneck sql
·
Design the optimized sql flow: M&N BI end.
·
Implement the same using an ETL tool: ETL tool company/BI tool company
·
Generate reports using the BI tool/SQL: BI tool company
Why consider our firm?
·
Strong ETL
expertise: please see our cloud offerings
·
Ability to work with
multiple ETL tools
·
Expertise at reverse
engineering cursor sql code to set based sql code. Sample cases can be shown to
the end client.
·
Developed readymade
ETL products in C#/.Net. one of the products is already deployed with a GSP
partner on cloud.
·
Expertise at
developing datawarehouses in sql with quickness and ease.
·
High value for the
ETL company/BI tool company
·
Readymade
datawarehouses with ETL connectors for sale available with the ETL team.
Next steps:
·
Send the bottleneck sql to the ETL team at apoorv@mnnbi.com,prashant@mnnbi.com.
Attached blogs:
Our latest project has been ETL integration on the cloud for a GSP
partner in India:
•
Automation of GST filings(in collaboration with Hazel GSP).
Attached is a blog for the same:
•
Blog link: http://mnnbi.net/gst/gst.aspx
•
Preliminary video: https://www.youtube.com/watch?v=-Vp7JzHCYp0&feature=youtu.be
•
Detailed demo link: https://youtu.be/d-KD3mp1jic
Other blogs:
Other blogs:
Spreadsheet consolidation: http://mnnbi.net/spreadsheet/spreadsheet.aspx
GST(cloud services): http://mnnbi.net/gst/gst.aspx
Hospital analytics: http://mnnbi.net/hospital/hospital.aspx
Construction analytics: http://mnnbi.net/construction/construction.aspx
Inventory analytics: http://mnnbi.net/
