Tools Every Data Analyst Must Learn

Excel for Data Analysis

[{"selector":"#anim-7877bcba-d946-4463-8a27-1f1de71f78f8","keyframes":{"transform":["translate3d(-115.18988%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-36571c2a-6b98-40d5-8020-e3ab57791ffe","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-5aa2574b-d7fb-4995-b6ee-9034c3efc481","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] [{"selector":"#anim-82031474-ec09-45ca-89b0-baea536990ed","keyframes":{"transform":["translate3d(115.18987%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-074271d0-f4eb-4662-a029-0800660cc1b3","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-9a06c2f5-b843-4640-a55f-3ee8a9752149","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] [{"selector":"#anim-0cf96a43-de7d-456a-9d8c-230b3f19fc75","keyframes":{"transform":["scale(1)","scale(1.5)","scale(0.95)","scale(1)"],"offset":[0,0.33,0.66,1]},"delay":0,"duration":1450,"easing":"ease-in-out","fill":"both","iterations":1}]

SQL for Data Handling

[{"selector":"#anim-16684b06-455a-403e-a73b-a37011721c79","keyframes":{"transform":["translate3d(115.18987%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-caf531ca-6a53-4f08-a841-e0af94865092","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-655eca4c-188c-41a1-8204-9d9f3e4cb134","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] [{"selector":"#anim-6ecfd4d1-63c4-4638-8b13-55af63cbce96","keyframes":{"transform":["translate3d(-105.66038%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-c6e2cef6-67a7-4dfb-9b1d-2e25824ad1ed","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-8e02ce7c-1b52-48ad-b119-f9d4f5050c39","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] [{"selector":"#anim-1ed1d80f-bae2-45fb-bdf4-2c4e122849ef","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}]

Data Visualization Tools

[{"selector":"#anim-41e54536-6e20-4098-b425-83b445e73f20","keyframes":{"transform":["translate3d(-109.85508%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-68cf1726-ea14-4364-9cb0-157ef74f43c9","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-4abd3d47-69b7-48e8-996d-be392a65e51a","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] [{"selector":"#anim-39a7dac2-d9c1-4835-aefd-9f5707e736b4","keyframes":{"transform":["translate3d(115.18987%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-3f5992b7-8b4f-4125-9509-8a09a5dec819","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-b408deef-aa47-4bf4-a42c-3cde5c110d34","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] [{"selector":"#anim-0dda01f5-59ff-4443-b66d-d2ea7273e14a","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-9adb8a89-75e1-4529-a4b6-74e0716f0b63","keyframes":{"transform":["translate3d(0px, -932.32337%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}]

Python for Analysis

[{"selector":"#anim-e8d16f0c-3952-4a62-bfaa-1320a35d9c02","keyframes":{"transform":["translate3d(115.18987%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-7076095b-5058-4377-a432-1f52050340af","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-db2269e9-4adb-40e3-b5d1-4ef4d5704017","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] [{"selector":"#anim-698b7189-e013-4ea1-9c0e-3a7651898de1","keyframes":{"transform":["translate3d(-115.18988%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-cda6b2d7-f0d9-48f1-b381-3b03826bdc61","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-599f06c1-f6fd-4281-9d13-51ba08364ebf","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] [{"selector":"#anim-06dee63f-ac83-4afe-b187-8d2b40c5d56d","keyframes":{"opacity":[0,1]},"delay":0,"duration":1200,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-37a02d2e-0eb8-4f06-826c-84bf10c72116","keyframes":{"transform":["scale(0.3333333333333333)","scale(1)"]},"delay":0,"duration":1200,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}]

Data Cleaning Tools

[{"selector":"#anim-fd035a7e-52bf-4cf3-aaaf-4b00540d2448","keyframes":{"transform":["translate3d(-116.02564%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-071619e8-958a-43c8-ad44-f58c073321b5","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-8d97ae6e-0b93-48ce-8b74-99abe55da67a","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] [{"selector":"#anim-e84abf89-24f9-4c19-aaeb-b25b303f2cf4","keyframes":{"transform":["translate3d(111.71171%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-8cd8f78b-e1c5-41b9-92c6-c91d932207c9","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-29a6695f-18d4-4117-bd88-9be1b25957c7","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] [{"selector":"#anim-7f195c3e-65e7-4fb0-8fb7-98df68add46b","keyframes":{"opacity":[1,1]},"delay":0,"duration":1000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-5defcc7f-3996-4e68-aaf0-8e9bdf95869c","keyframes":{"transform":["scale(3)","scale(1)"]},"delay":0,"duration":1000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}]

Become Job-Ready Analyst

[{"selector":"#anim-c4a3563d-8347-4429-960c-b6bd0ede72ba","keyframes":{"transform":["translate3d(115.18987%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-7a3a3836-1903-431f-8d49-017d7e18311d","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-41165f09-4b29-4438-b691-33dbab54348d","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] [{"selector":"#anim-4e2ba44a-7a51-431a-b17c-51fd0f46aadb","keyframes":{"transform":["translate3d(-105.66038%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-50d7990e-a394-465d-8ae8-b3f8effeed35","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-083989ca-abee-4fa2-aabe-5afca338edf8","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}] [{"selector":"#anim-fd081ce3-dc44-4d08-9fd6-cb7ed1e00cbc","keyframes":[{"offset":0,"transform":"translate3d(0, -964.14153%, 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, -271.116598236%, 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, -92.171930268%, 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, -34.612680927%, 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, -15.040607867999999%, 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"}]

Tools Every Data Analyst Must Learn

#DataAnalyst

Excel for Data Analysis

Use Microsoft Excel for data cleaning, formulas, pivot tables, and basic analysis.

#ExcelSkills

SQL for Data Handling

Learn SQL to extract, manage, and analyze data stored in databases efficiently.

#SQL

Data Visualization Tools

Create dashboards using Power BI and Tableau.

#DataVisualization

Python for Analysis

Use Python for data processing, automation, and advanced analytics.

#Python

Data Cleaning Tools

Clean and prepare raw data for accurate insights using modern tools and techniques.

#DataCleaning

Become Job-Ready Analyst

Master these tools to land roles in data analytics, business intelligence, and reporting.

#DataCareer