PM01-0411. Gráficos avanzados y sus usos

Visualización

Gráficos avanzados y su uso

Recuerda:

[{"selector":"#anim-da6413ae-ef59-4640-a74e-771262a6c8c3","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-c2e2b36a-4853-47d6-85fa-d77741abe6c1","keyframes":{"transform":["translate3d(-117.64707%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-f3bca96d-2cd7-4ce9-bcdf-2d424a7bc65f","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-70edc574-7d4a-4c0c-877c-dd4be72a7eea","keyframes":{"transform":["translate3d(117.32027%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-a784df29-74b2-4921-84d4-4a84c787fdd0","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-f2af104f-b05d-4c73-a773-e3ea0ec73ff0","keyframes":{"transform":["translate3d(0px, -111.5825%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}]

¿Para qué?

[{"selector":"#anim-818b5408-61b7-46e2-8c11-e709fda26957","keyframes":[{"offset":0,"transform":"translate3d(0, -629.81068%, 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, -177.10276321600003%, 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, -60.20990100800001%, 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, -22.610203412000004%, 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, -9.825046608000001%, 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":600,"fill":"both"}] [{"selector":"#anim-a20e27e3-a012-43ec-8cd6-af3aea453eea","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-92ea020e-086a-4c96-999d-6feba77b744e","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-9dabd2f7-71da-4139-aa61-368615974e95","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-35a028b7-3abf-4c64-a41a-c4dd1554e3f8","keyframes":{"transform":["translate3d(0px, 103.70369%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}]

En Excel puedes crear visualizaciones (gráficos) sencillas, tales como:

[{"selector":"#anim-09dca538-cb78-436c-aef0-3a3bfaa5c628","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-3400beda-78ec-4d98-b576-8458f440988a","keyframes":{"transform":["translate3d(0px, -271.1674%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-ef8744b5-7f19-40da-a0dd-615963899bf2","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-b9e2d867-d1b9-495d-a20a-419ea4a772c2","keyframes":{"transform":["translate3d(131.50684%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-baa8b95c-b477-4d47-939e-470b02401c8a","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-433ae2ff-2111-467d-b4d7-d2e21b1a0f2d","keyframes":{"transform":["translate3d(-554.99993%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-b37a40f7-c91a-48f2-bcb8-f38c732516bb","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-81ea46c9-29d4-4ce3-b112-35213b2f2cbc","keyframes":{"transform":["translate3d(-554.99993%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-f080c87e-1050-4719-8a1f-8f31031a775a","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-5c38a042-14fb-4197-aad1-fb8dd3433f3d","keyframes":{"transform":["translate3d(-554.99993%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-af5e67e6-a4a5-4623-8d38-c5810c83a786","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-d817bc18-3211-4716-bc7b-c5bd93d8b114","keyframes":{"transform":["translate3d(-554.99993%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-8b6f51ce-1612-458a-97ca-d53e9286912f","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-1319d023-8447-4777-b104-de8eb875afe4","keyframes":{"transform":["translate3d(0px, 104.91582%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] Dot Dot Dot Dot

O visualizaciones avanzadas, tales como:

[{"selector":"#anim-675a11ec-6cd8-4b72-a841-219f2a1723ae","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-93076886-a105-4d86-a950-a7206c6ed30c","keyframes":{"transform":["translate3d(-117.32027%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-995a25ad-48a2-4326-a17d-d30e2ced9c4b","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-ea5480f8-4a4c-48d9-8d58-c2ad02d4d863","keyframes":{"transform":["translate3d(122.45763%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-403f2724-9770-41b1-b376-404ea8d970f8","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-c7b43962-bc3e-40c2-9d1c-0fcd28a7888c","keyframes":{"transform":["translate3d(-554.99993%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-f1e50751-5f39-4398-8513-ff709e2c3806","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-769c1209-9250-4724-9f7d-f9dc4486a3a8","keyframes":{"transform":["translate3d(-554.99993%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-1e15eee4-3c90-4866-9539-261083b91749","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-cfa49bbc-0ef6-455e-a4f9-20fea7c32709","keyframes":{"transform":["translate3d(-554.99993%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-b7754f4f-d519-4b50-a3f8-07caf851a4d8","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-06f62365-8aec-461a-a93a-1256706fd695","keyframes":{"transform":["translate3d(-554.99993%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-acf3e0a9-ef84-4242-8494-fa4c87802f7d","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-ac884db0-31ef-4146-95d5-dad1bae303da","keyframes":{"transform":["translate3d(0px, -145.90643%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-df1d78ce-652d-4b24-a5c3-a5c86005dfc1","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-d5513f8f-d572-42eb-bf0f-3264d8d2d84b","keyframes":{"transform":["translate3d(-554.99993%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-2e0cc7bd-404c-4ae7-993c-3604593e6bf8","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-e4105133-d2d9-41cf-8db0-4cea7333712d","keyframes":{"transform":["translate3d(-554.99993%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-bbf15032-b878-41c4-9c26-833af6d69ab6","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-80a005f2-e469-4bc1-ad7c-7abc01fff84f","keyframes":{"transform":["translate3d(-554.99993%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-78b805ca-ed35-483f-8b4a-a6868e42a2bf","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-97d24189-3341-4678-820d-3288c5f38373","keyframes":{"transform":["translate3d(-554.99993%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] Dot Dot Dot Dot Dot Dot Dot Dot

De la misma manera, puedes personalizar tus gráficos para adaptarlos a tus necesidades específicas, desde etiquetas hasta estilos visuales.

[{"selector":"#anim-dcc32015-5ba6-4060-8ff3-a5251be58c10","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-05e710a5-09c0-496a-a89f-3a6c13b0bf85","keyframes":{"transform":["translate3d(0px, -202.65546%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-ea59cc21-551b-45d0-9d84-34f409a98f93","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-efd871c6-7f2c-490f-9e04-96440eb3a27c","keyframes":{"transform":["translate3d(0px, 117.64309%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}]

Aprende a hacer una visualización de termómetro para KPI’s

[{"selector":"#anim-2477bdb7-3814-488f-89bc-c3595c4046aa","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-40945db5-d4df-4af0-b7cb-7dd175cbe4d2","keyframes":{"transform":["translate3d(-114.51104%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-fef3f215-b938-419a-849b-47a902251f8d","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-2a64ccbe-02e4-46e4-9ecf-03bb8fd7f7bd","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-d4f8f05c-c043-48d6-859b-525c0e31a326","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-f0c1d2f9-76f6-4588-bf92-7b624631072c","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-08eb1cb6-9e11-4884-b081-9594824c5698","keyframes":{"transform":["translate3d(-100%, 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

¿Quieres aprender a construir otros tipos de gráficos avanzados?¡Pregúntame!

[{"selector":"#anim-77debb30-aac9-436f-b80f-fd223ce434a3","keyframes":[{"offset":0,"transform":"translate3d(0, -179.9458%, 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, -50.60075896%, 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, -17.20281848%, 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, -6.46005422%, 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.80715448%, 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"}] [{"selector":"#anim-78f3e4ae-7809-4a7b-8c51-2396ef97c5a4","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-89349539-e10a-4c0f-96b3-db99c786c4c4","keyframes":{"transform":["translate3d(0px, -190.77571%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}]

Visualización

Recuerda:

Es importante que presentes una visualización gráfica pertinente según la naturaleza de tus datos e insights que deseas comunicar.

¿Para qué?

1. Para mostrar tus datos de forma eficiente y facilitar la comprensión de tu análisis. 2. Para facilitar la toma de decisiones. 3. Para ahorrarte tiempo y esfuerzo.

En Excel puedes crear visualizaciones (gráficos) sencillas, tales como:

Tablas. Gráficos de pastel. Gráficos de barras. Lineales.

O visualizaciones avanzadas, tales como:

Gráfica de dispersión. Radar. Gráfico de burbuja. Map Tree. Diagramas de caja. Termómetros. Gráfico de cascada. Entre muchos más.

De la misma manera, puedes personalizar tus gráficos para adaptarlos a tus necesidades específicas, desde etiquetas hasta estilos visuales.

Aprende a hacer una visualización de termómetro para KPI’s

¿Quieres aprender a construir otros tipos de gráficos avanzados?¡Pregúntame!