-
-
One of the complexities in this project is due to file size. The data set is 7,000 rows but over 500 columns are necessary to provide data for all the reports, calculations, including multiple historical periods. The client has a strong understanding of his customers and doesn’t want to sacrifice on content. Our Excel macro file we use to create the 800 files is about 1 gb in size. Using a powerful system, we can generate the reports in a few hours.
-
We developed a custom process we call “zip/unzip”. As you may be aware, XLSX files are compressed files, so they don’t zip down much. But to compress an .xlsx file, you can rename the extension from .xlsx to .zip, extract all the elements of the file (the .xml files, etc), then zip them back to a .zip file, then finally rename the extension again from .zip to .xlsx. The largest files that come out of this production are about 80 mb, and we use our “zip/unzip” process to get them down below 50 mb.
-
We work with large companies, but we have special love for small companies. We develop long last partnerships and love to celebrate their success as they utilize our technology projects to improve their competitive position.
“I have used Infodatix with great satisfaction for many years and continue to use their services. Their ability to efficiently and effectively devise elegant solutions to complex problems is unsurpassed in this space. I could not recommend Infodatix more highly.”
Justin Barr, Managing Principal, Loan Workout Advisers, LLC.
-
-
We partnered with Bankdataworks in the early stages of their vision to create a powerful dashboard and data analysis tool for companies interested in banking financials. In a proprietary process, we automated a process that takes government data, manipulates and converts the data using a vast set of logic, including complex calculations to produce certain banking industry financial statistics and ratios.
We produce over 800 separate reports, which are then automatically uploaded to the website. Bankdataworks offers subscriptions to these reports to commercial real estate brokers, banking executives, and other professionals interested in bank financials.
Technologies used: C#,ASP, .NET, SQL Server, web services, MS Excel, VBA