Client’s AS400 system didn’t regulate data consistency or provide a user-friendly experience. In working closely with the executive team an end-to-end data solution was agreed upon; Microsoft stack on the backend with Qlik Sense empowering users on the frontend. A SQL Server Database environment was implemented to ingest AS400 data. [...]
Our client wanted to determine active vs. dormant databases, their overall performance and utilization, and any consolidation/decommissioning opportunities. Our analysts reviewed the entire environment using network listeners for a high-level preliminary analysis before diving into details of each database instance. The following attributes were defined for output and visualization in [...]
Client had an immoveable deadline to retire their legacy data warehouse and migrate 15,000 existing Cognos reports to a new Oracle data warehouse. Combining usage reports and interviewing report users reduced reports to 2,000. Decomposing reports down to their root elements was conducted, and a matrix of all base elements [...]
"Due to rapid growth, our client’s product and customer data was not easily shared between systems, resulting in duplicate and inconsistent naming conventions. Y&L analyzed data sources across various systems and created a single data model. A source-to-target mapping document showed the migration from source systems to master tables. " [...]
"Y&L analysts were brought in to eliminate data integration failures. An in-depth analysis of system logs was conducted, the server and network infrastructure was reviewed and validated, the integration process and code was reviewed, and data tables were analyzed for improvement. " "The team incorporated various changes including table indexing [...]
Big Data, Analytics, Governance, AI, IoT/IIot, RPA and the like all fit into this bucket. While some are emerging technologies and others are software and scientific practices they all deal with data. Learn how we can help you turn data into insight.
You might have the brightest data scientist, the most powerful analytical tools on the market but if the data doesn’t present insight in a way meaningful to business people so they can take action, then it’s still just data. Watch how data can turn into insight with powerful marketing dashboards.
