PM01-0211. Segmentación de datos

Manipulación de datos

Es una herramienta poderosa que facilita el análisis al dividir conjuntos de datos en segmentos específicos.

[{"selector":"#anim-869d11dd-09fb-4c18-a9b6-e500c36e5f14","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-a96dc28b-e96d-455a-8bc4-c186cf9b8ec7","keyframes":{"transform":["translate3d(118.95425%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-883d1bce-8cbc-43f9-9029-2eb6ea059068","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-179e5b34-98c9-4bf8-8569-7b98f4edea35","keyframes":{"transform":["translate3d(-115.45741%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}]

1. Crea una tabla a partir de los datos.

[{"selector":"#anim-3e3ebde6-80c4-4ed5-a660-b15005128613","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-5f76de34-e98d-4f16-b045-575f50e18e6f","keyframes":{"transform":["translate3d(118.95425%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-a30d842c-baa8-4c9c-9add-ce16f668c78e","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-cd800801-9962-4048-adf7-81dd5375603c","keyframes":{"transform":["translate3d(-115.77287%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-ba531ef4-4155-433a-890c-64e29bc498ce","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-7c63a700-08fb-4630-86ce-e858beefd0ba","keyframes":{"transform":["translate3d(118.95425%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] -Ve a la pestaña INSERTAR de la cintilla de opciones y después selecciona la opción TABLA.

3. Selecciona los campos por los cuales se quiere hacer el filtrado.

[{"selector":"#anim-ecee79a9-98f6-4c21-96f9-a5fb10ea5d7d","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-e8ad52d9-5a48-43c5-a998-5beacd2b89af","keyframes":{"transform":["translate3d(116.99347%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-a3799c5a-9177-4523-91fc-bad7470b6bf4","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-721893ca-654f-40f3-8a0d-46f43690679b","keyframes":{"transform":["translate3d(115.68628%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}]

Observa un ejemplo práctico:

[{"selector":"#anim-482d1438-e123-4f09-867a-507e5224d570","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-195fe4e8-43fa-401a-8af5-15717b871de6","keyframes":{"transform":["translate3d(-114.8265%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-511b2dd0-9668-4765-9e3b-227b05ca898c","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-5376140a-7c0c-4e91-94c5-c3d69b5b4c7d","keyframes":{"transform":["translate3d(-386.51686%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-8f50b377-b7ea-4c87-845d-84d98f50b62a","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-32c68cc6-d8ca-4f93-afe2-258afc1b811c","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-6762de0c-065e-4098-bd55-221e573a5435","keyframes":{"transform":["translate3d(100.00000%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] Aplica Burst with Arrow

[{"selector":"#anim-35341ea3-76df-41cc-a223-735028dcf28b","keyframes":[{"offset":0,"transform":"translate3d(0, -166.2263%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.29,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.45,"transform":"translate3d(0, -46.74283556%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.61,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.71,"transform":"translate3d(0, -15.89123428%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.8,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.85,"transform":"translate3d(0, -5.967524170000001%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.92,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.96,"transform":"translate3d(0, -2.59313028%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":1,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"}],"delay":0,"duration":1400,"fill":"both"}]

Manipulación de datos

Segmentación de datos

Es una herramienta poderosa que facilita el análisis al dividir conjuntos de datos en segmentos específicos.

La segmentación de datos

1. Crea una tabla a partir de los datos.

Pasos prácticos para llevarla a cabo:

2. Posteriormente, selecciónala y ve a la pestaña DISEÑO DE TABLA de la cintilla de opciones y selecciona la opción INSERTAR SEGMENTACIÓN DE DATOS.

3. Selecciona los campos por los cuales se quiere hacer el filtrado.

4. Da formato a las segmentaciones desde la pestaña SEGMENTACIÓN que se activa al manipular la tabla.

Observa un ejemplo práctico: