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

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