Data at the service of your decisions

Data Solutions Lemieux inc.

The quality of decisions depends on the quality of the data that feeds them. We help organizations put solid data foundations in place (quality, integration, modeling, and governance) to turn their data into a reliable base for analysis and decision making.

Areas of Service

Four areas cover most of our consulting mandates.

Data Integration

Connecting siloed system data to create a coherent, integrated picture, making it possible to cross-reference data and gain a more complete view of the organization.

Data Transformation

Transforming data according to business rules, from simple data extracts all the way to the establishment of a data warehouse.

Business Intelligence

Democratizing data, from the executive dashboard to raw datasets for advanced users, through day-to-day operational reports.

SQL Server Consulting

Assessing the health of SQL Server, optimizing performance and analyzing queries to improve the reliability and efficiency of data environments.

Our Approach

Our approach rests on a few simple principles that guide how we work with data.

Breaking data silos

A single version of the truth, even when several systems coexist. Connecting data sources makes it possible to reduce inconsistencies and to multiply the possibilities for analysis.

Data democratization

Non-sensitive data can create value well beyond their initial use. Making them accessible and comprehensible favors the sharing of knowledge and brings forth new possibilities.

Data security

Sensitive data must be protected at every step. Rigorous management of access and permissions is essential throughout the chain of data.

Data quality

Useful data must be accurate, consistent and reliable. Trust in the analyses and decisions begins with the quality of the data that feeds them.

Data governance

To trust data, one must know where it comes from, how it is transformed and how it should be used. Clear governance makes it possible to maintain this trust over time.

Areas of Experience

Hands-on experience in industrial environments where data plays a central role.

Close-up view of electrical relays in an industrial panel box showcasing circuit components

Industrial Computing

We have led several data integration projects involving data from PLCs, OPC systems, and historian systems such as AVEVA PI.

We are also comfortable with the security issues specific to industrial environments and to the separation of OT and IT networks.

Aerial view of an open pit mine

Mining

Several years of experience in the mining sector, with data projects covering geology, mine engineering, exploration, metallurgy, finance and other corporate functions.

PDF
Water bottles being processed on an automated conveyor in a modern factory setting

Manufacturing

Several years of experience in the manufacturing sector, particularly in data acquisition and in the calculation of key indicators such as OEE, MTTR and MTBF, as well as in the modeling of accumulation concepts for conveyor systems.