24 10, 2018

Modernizing Data Management

2018-10-24T13:22:33+00:00Comments Off on Modernizing Data Management

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. [...]

24 10, 2018

Network Server Assessment

2018-10-24T13:20:49+00:00Comments Off on Network Server Assessment

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 [...]

24 10, 2018

Report Migration

2018-10-24T13:18:35+00:00Comments Off on Report Migration

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 [...]

24 10, 2018

MDM, Data Quality, and Data Governance Implementation

2018-10-24T13:07:16+00:00Comments Off on MDM, Data Quality, and Data Governance Implementation

"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. " [...]

24 10, 2018

SQL Query and Performance Tuning

2018-10-25T12:58:57+00:00Comments Off on SQL Query and Performance Tuning

"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 [...]

24 10, 2018

Marketing Dashboards Powered By Y&L

2019-06-12T21:39:43+00:00Comments Off on Marketing Dashboards Powered By Y&L

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.

Go to Top