Data Management Blog

The best content to boost your business. Insights, advice, and trends in data management that will help you make informed decisions and discover your true potential.

Microsoft Fabric – A comprehensive review

Sep 1, 2023

The launch of Microsoft Fabric has caused a stir in the Data Management comunity. At Stratify we ran extensive tests. Have a look at our conclusions!

Top 5 Ways Data Roles Will Change in 2023

Mar 6, 2023

Professionals in data roles can no longer just limit themselves to being engineers. They also need to gain expertise in consumer requirements and core business operations.

Six data and analytics trends in 2023

Feb 15, 2023

Data analysis is at the core of many recent inventions. Data collection and analysis are often the cornerstone of organizations, whether in healthcare, decentralized work, online shopping, customer service, or internet banking.
According to a survey, the volume of data and associated analytics will expand at a CAGR of 13.5%. Consequently, the industry could increase its expected value from USD198.08 billion in 2020 to USD684.12 billion in 2030.
Learn about the top data and analytics trends in this article that are changing the way we approach everything from the economy to education to the environment.

The power of IoT solutions for manufacturing in navigating uncertain times

Jun 30, 2022

IoT solutions have been helping manufacturers for years to streamline operations, cut costs and gain otherwise unfounded insights, and their importance is emphasized now more than ever as factories, plants and warehouses adjust to operating under new guidelines coming out of the pandemic and are looking to play catch up.

IoT vs IIoT – The Fundamentals

Mar 8, 2022

Due to the ongoing fourth industrial revolution, a set of common questions are frequently asked regarding the basics of Industrial Internet of Things (IIoT). Its main goal is to provide smart, sensor-based solutions to manufacturing industries. IIoT offers a range of benefits for manufacturers that include innovation, maintenance cost reduction, improved efficiency, and lower unproductive periods. In short, IIoT devices help companies significantly improve their operations.

Marco conceptual de aplicaciones industriales de IoT

Jan 24, 2022

Terminos como Internet Industrial de las Cosas (IIoT), o Industria 4.0 son omnipresentes. El mercado global de 2022 se estima en USD 230 Billones, y se proyecta a USD 1.100 Billones en 2028. Sobre todo en las industrias de manufactura, retail y minería se pueden observar iniciativas de innovación y transformación a nivel operativo.

Introducción a las Arquitecturas de Gestión de Datos

Dec 19, 2021

Requerimientos de casos de uso de datos han ido evolucionando en línea con el crecimiento del volumen de datos y las herramientas avanzadas de manejarlos. Es inevitable que organizaciones que han logrado acceder y automatizar el consumo de datos basado en lógicas nocturnas empiezan a demandar datos en tiempo real. Casos típicos son soluciones de IoT, con sensores emitiendo datos sobre líneas de producción o transacciones financieros.

Acelerar la transformación digital requiere acelerar la transformación de datos

Nov 21, 2021

Las transformaciones digitales exitosas no son posibles sin una transformación de datos exitosa. Después de todo, son los datos y la capacidad de analizarlos – sobre los clientes, empleados, infraestructura, dinámica del mercado, cadena de suministro, sistemas de tecnología empresarial y más de una organización – los que hacen posible la transformación digital.

Gartner: Los desarrolladores ciudadanos pronto superarán en número a los programadores profesionales 4 a 1

Oct 25, 2021

Para hacer frente a la próxima ola de hiper-automatización, las organizaciones de TI deben hacer un mejor trabajo al asociarse con profesionales fuera de TI para automatizar los procesos comerciales y la integración de datos, según la firma de investigación Gartner.

Gobierno de Datos: Mejores prácticas, definiciones y ejemplos del marco de gobernanza de datos

Sep 12, 2021

Estamos en 2021, ¿sabes dónde están tus datos? Si respondió afirmativamente a esa pregunta retórica, tiene una comprensión decente de la gobernanza de datos. Si no es así, es hora de empezar a averiguarlo. Siga leyendo para obtener más información sobre la gobernanza de datos y cómo Stratify puede ayudarlo.

« Entradas más antiguas

Catogories

"Second Lung" Service

Flexible 100% Service Model, tailored to current data needs.

Activation and maintenance of an advanced toolbox.
Activation and maintenance of robust data governance.
Resource enablement as needed.

Services used by clients who…

...face transformational changes exceeding internal bandwidth in data management.
...need to avoid growing technological debt in data
...require responsiveness and operational continuity in data management, regardless of fluctuations in demand or internal capacity.

Example situations:

\Success bottleneck: Analysts spend more time maintaining existing reports, reducing their ability to respond to new requirements.
\ERP system change: A change in the ERP system necessitates greater effort in adapting reporting and analytics.
\Restructuring: organizational restructuring poses operational risks to critical reporting.
\High Turnover: frequent analyst changes disrupt critical reporting and analysis.

Exit

Retail Price Tracker

Application to capture and analyze product list prices.

Merchandisers or sales representatives can manually record prices at points of sale via mobile or tablet.
Automatic price capture in online stores.
Automated validation and analysis of captured prices.

Services used by clients who…

...have limited visibility into price movements across different points of sale.
...seek supplementary or alternative data to Nielsen data.
...are challenged by pricing and need to enhance their reactive capacity.
...manually process price data.

Example situations:

\Intermittent reporting sales representatives sporadically report point-of-sale data.
\Pricing Team lacks up-to-date and detailed price data while defining prices.

Exit

Retail Campaign Follower

Application to assess and track campaigns at retail points.

Merchandisers or sales representatives take photos and record campaign details at retail points.

Services used by clients who…

…have a sales force and/or merchandisers in retail chains.
…frequently work in retail stores during campaigns.

Example situations:

\The sales team lacks a solution to visualize retail points.
\Campaigns often fail, and there are no data or photos to support the analysis of the causes.

Exit

Retail Portal Solutions

Automate data extraction from B2B portals with tailored transformations and visualizations.

Automated download of sales and stock data from retail portals.
Automated download of data from SII portal, banking portals, and other sources.
Data formatting in various required formats.
Flexible data storage allowing combining portal data with other sources (e.g., ERP).
Customized transformation automation.

Services used by clients who…

...seek more flexible and cost-effective alternatives to Teamcore or Instoreview.
...want to automate "Sellin-Sellout" sales reports fed from different sources.
...aim to automate manual steps in data analysis extracted from retail portals.
...desire to visualize sales data in advanced visualization tools (e.g., PowerBi, Tableau).

Example situations:

\Manual Download: An analyst connects to retail portals daily to download sales and stock data.
\Manual Processing: Preparing sales reports requires Excel usage and manual processing.
\Limited Transformation: Combining Sellout with Sellin data becomes difficult to impossible due to complexity, table size, and time constraints.
\Limited Visualization: Report visualization is restricted to Excel views with little flexibility in result analysis.

Discover how we do it

Exit

IoT Production Plants

Flexible and scalable remote measurement and control solutions for production plants.

Custom-designed solutions for controlling critical variables in production lines.
Real-time dashboards with operational indicators on-site and remote.
Sensor data accessibility for advanced data analysis.
Remote, scheduled, and/or automated control of critical plant components.

Services used by clients who…

...require remote and automated measurement of critical production variables.
...have multiple installations from different providers and want to unify monitoring.
...face difficulties measuring critical variables with standard measurement solutions.
...struggle with accessing, processing, storing, and visualizing relevant production data.

Example situations:

\Efficiency: Production line efficiency measurement relies on manually fed Excel spreadsheets.
\Waste: Waste in production lines lacks a measurement solution.
\Electric Consumption: Total electricity consumption in a production plant is high, without clear understanding of the cause.
\Water Consumption: Water consumption at different points in the production process is high, without clear understanding of the cause.

Exit

Iot Residential Buildings

Sensor and actuator solutions that support and facilitate building management.

Remote sensors to measure critical variables in the cost and operation aspects of a building.
Remote actuators enabling key building functions.
Real-time dashboards and alerts for analytical purposes.

Services used by clients who…

...experience frequent interruptions in basic services like hot water or electricity.
...face high operating costs of the building and need to detect and manage causes.
...require remote operation of building functions.

Example situations:

\Hot Water: Fluctuations and failures in the hot water circuit are only detected by residents.
\Irrigation System: The irrigation system frequently fails, resulting in water loss and high costs.
\Access Control: The building's pump room is often accessed without restrictions or alerts.
\Electric Consumption: The pump room experiences power cuts and high electricity consumption.

Discover how we do it

Exit

IoT Agriculture

Tailored solutions for remote measurement and control in agricultural activities.

Development, implementation, and operation of sensors and actuators.
Enablement of remote dashboards, alerts, and control panels.

Services used by clients who…

...need to remotely measure environmental variables.
...require real-time alerts about changes in environmental variables.
...need to control and/or operate multiple facilities in distributed locations.

Example situations:

\Irrigation system control: the feeding and irrigation system of a field requires measuring water levels in central tanks and humidity at multiple points in the field.
\Remote pump control: remote and hard-to-access pumps need remote monitoring and operation.
\Harvest transportation control: ontainers designated for transporting harvests require measurement of multiple environmental variables (temperature, CO2, pressure).

Exit

Self-Service Data Management

Developing internal capacity to be self-sufficient in data analytics and reporting.

Selection, activation, and maintenance of an optimal toolset.
Creation of data models, data pipelines, analysis, and visualizations.
Application of best data governance practices.

Services used by clients who…

...need to build internal capability and necessary tools.
...have multiple analysts spending too much time processing data rather than analyzing.

Example situations:

\Challenged team: Well-designed push is needed to elevate data management to the required level.

Exit

Full Service Business Intelligence

Crafting Custom Reports and Tailored Analytical Services

Delivery of ready-to-use reports or analyses.
Ongoing maintenance and enhancement of reports.

Services used by clients who…

...require only one or two reports or analyses.
...want to outsource part or all of data reporting and analysis.
...don't have or want dedicated analysts for data work.
...want to test or preview a solution before mass usage.

Example situations:

\Complex reports or analyses: Advanced skills (e.g. data science) needed to solve.
\Urgent reports or analyses: Tangible results needed in a few days or weeks.
\Simple reports or analyses: Crafting and upkeep doesn't need internal resources.
\Operational disruption: Departure of a key person led to critical report breakdown.

Exit

Data Transformation

Challenge:

Inbound electronic invoices provided in a semi-structured file format. Transformation into a useable format for finance operations requiring one full-time analyst to manually cleanse and prepare data on a daily basis.

Approach:

Identified transformation requirements and options. Selected adequate toolset to meet requirements. Designed and implemented a fully automated data transformation logic. Established support and maintenance structure for the solution.

Result:

Analyst freed up from manual data transformation. The new solution requires one hour of maintenance per week. Cloud-based licensing costs under USD 100 per month. Manual processing errors eliminated.

Exit

Data Warehousing

Challenge:

Functional areas with local, and mostly file-based data storage. Data sharing through shared folders or emails create redundancies, inconsistencies, and multiple sources of truth. Analysts invest a significant amount of time in data reconciliation. Executive decision making is rarely backed by conclusive data.

Approach:

Implementation of cloud-based Enterprise Data Warehouse. Role-based security model established, including administrative procedures and policies. In-house support model added to address skill requirements and ensure useability and sustainability.

Result:

Established a single source of truth. Increased the quality and timely availability of data increased. Cross-functional collaboration and data-driven decision making enhanced.

Exit

Dashboarding

Challenge:

Management with fragmented, incomplete, and untimely views on key performance indicators. Multiple reports with inconsistent data and without drill-down options used.

Approach:

Created a customized dashboard based on a single, trusted data source. Optimized data extraction and data blending. Enabled self-service reporting functionality. Re-designed reporting processes and structure. Trained stakeholders in required skills and capabilities.

Result:

Vastly enhanced KPI visibility for the Management. Decreased data extraction and preparation efforts by over 80%. Decreased response time of KPI drill-downs from days to minutes.

Exit