.. _sphx_tag_topic-data-analytics: My tags: topic: data analytics ############################## .. toctree:: :maxdepth: 1 :caption: With this tag ../learn/data_analytics/1_foundations/001-why-data-analytics-matters-today.rst ../learn/data_analytics/1_foundations/002-how-data-analytics-improves-the-workplace.rst ../learn/data_analytics/1_foundations/003-data-driven-decision-making.rst ../learn/data_analytics/1_foundations/004-detectives-and-data-analysts.rst ../learn/data_analytics/1_foundations/005-the-six-phases-of-the-data-analysis-process.rst ../learn/data_analytics/1_foundations/006-the-origins-of-data-analysis-and-the-many-ways-to-structure-it.rst ../learn/data_analytics/1_foundations/007-understanding-the-data-ecosystem.rst ../learn/data_analytics/1_foundations/008-understanding-the-data-analysis-process-and-the-data-life-cycle.rst ../learn/data_analytics/1_foundations/009-understanding-the-data-life-cycle.rst ../learn/data_analytics/1_foundations/010-a-review-of-the-six-stages-of-the-data-life-cycle.rst ../learn/data_analytics/1_foundations/011-the-stages-of-the-data-analysis-process-and-their-roles.rst ../learn/data_analytics/1_foundations/012-practical-application-of-the-data-analysis-process.rst ../learn/data_analytics/1_foundations/013-analytical-skills-and-their-core-components.rst ../learn/data_analytics/1_foundations/014-applying-analytical-skills-in-a-business-context.rst ../learn/data_analytics/1_foundations/015-analytical-thinking-and-its-core-components.rst ../learn/data_analytics/1_foundations/016-analytical-thinking-and-questions-for-problem-solving.rst ../learn/data_analytics/1_foundations/017-root-cause-analysis-and-business-applications-of-the-five-whys.rst ../learn/data_analytics/1_foundations/018-data-driven-decision-making-and-the-role-of-analytical-skills.rst ../learn/data_analytics/1_foundations/019-case-studies-in-data-analysis-and-the-practical-impact-of-data-driven-decision-making.rst ../learn/data_analytics/1_foundations/020-overview-of-core-tools-used-by-data-analysts.rst ../learn/data_analytics/1_foundations/021-the-role-of-spreadsheets-in-data-analysis-and-basic-concepts.rst ../learn/data_analytics/1_foundations/022-the-concept-and-basic-use-of-sql-query-language.rst ../learn/data_analytics/1_foundations/023-the-role-and-importance-of-data-visualization.rst ../learn/data_analytics/1_foundations/024-industries-where-data-analysts-work-and-how-data-is-used.rst ../learn/data_analytics/1_foundations/025-the-role-of-business-tasks-in-data-analysis.rst ../learn/data_analytics/1_foundations/026-fairness-in-data-analysis.rst ../learn/data_analytics/1_foundations/027-key-factors-to-consider-when-choosing-a-data-analytics-role.rst ../learn/data_analytics/1_foundations/index.rst ../learn/data_analytics/2_data_driven_decisions/001-using-data-analysis-to-choose-the-right-advertising-strategy.rst ../learn/data_analytics/2_data_driven_decisions/002-understanding-common-problem-types-in-data-analytics.rst ../learn/data_analytics/2_data_driven_decisions/003-applying-data-analytics-problem-types-in-real-business-scenarios.rst ../learn/data_analytics/2_data_driven_decisions/004-why-asking-the-right-questions-matters-in-data-analytics.rst ../learn/data_analytics/2_data_driven_decisions/005-the-relationship-between-data-and-decision-making.rst ../learn/data_analytics/2_data_driven_decisions/006-quantitative-and-qualitative-data-in-decision-making.rst ../learn/data_analytics/2_data_driven_decisions/007-data-creates-value-only-when-it-is-communicated.rst ../learn/data_analytics/2_data_driven_decisions/008-the-difference-between-data-and-metrics-and-the-role-of-metrics.rst ../learn/data_analytics/2_data_driven_decisions/009-dashboards.rst ../learn/data_analytics/2_data_driven_decisions/010-mathematical-thinking.rst ../learn/data_analytics/2_data_driven_decisions/011-spreadsheets-in-data-analysis.rst ../learn/data_analytics/2_data_driven_decisions/012-building-and-organizing-a-spreadsheet.rst ../learn/data_analytics/2_data_driven_decisions/013-how-data-analysts-use-spreadsheets.rst ../learn/data_analytics/2_data_driven_decisions/014-spreadsheet-calculations-with-formulas.rst ../learn/data_analytics/2_data_driven_decisions/015-common-spreadsheet-errors-and-how-to-fix-them.rst ../learn/data_analytics/2_data_driven_decisions/016-spreadsheet-functions.rst ../learn/data_analytics/2_data_driven_decisions/017-defining-the-problem-domain.rst ../learn/data_analytics/2_data_driven_decisions/018-context-and-bias-in-data-analysis.rst ../learn/data_analytics/2_data_driven_decisions/019-stakeholder-expectations-in-data-analysis.rst ../learn/data_analytics/2_data_driven_decisions/020-staying-focused-on-the-project-objective.rst ../learn/data_analytics/2_data_driven_decisions/021-clear-communication-with-stakeholders-and-teams.rst ../learn/data_analytics/2_data_driven_decisions/022-adapting-to-communication-expectations-at-work.rst ../learn/data_analytics/2_data_driven_decisions/023-managing-stakeholder-expectations-and-project-constraints.rst ../learn/data_analytics/2_data_driven_decisions/024-balancing-speed-and-accuracy-in-data-analysis.rst ../learn/data_analytics/2_data_driven_decisions/025-sharing-data-to-drive-impact.rst ../learn/data_analytics/2_data_driven_decisions/026-effective-meetings.rst ../learn/data_analytics/2_data_driven_decisions/027-conflict-resolution-in-the-workplace.rst ../learn/data_analytics/2_data_driven_decisions/index.rst ../learn/data_analytics/3_data_preparation/001-how-data-is-generated-and-collected.rst ../learn/data_analytics/3_data_preparation/002-choosing-the-right-data-to-collect.rst ../learn/data_analytics/3_data_preparation/003-understanding-data-types-and-data-formats.rst ../learn/data_analytics/3_data_preparation/004-structured-data-and-data-models.rst ../learn/data_analytics/3_data_preparation/005-data-types-in-spreadsheets.rst ../learn/data_analytics/3_data_preparation/006-data-tables-tabular-data.rst ../learn/data_analytics/3_data_preparation/007-wide-data-vs-long-data.rst ../learn/data_analytics/3_data_preparation/008-understanding-bias-in-data-analysis.rst ../learn/data_analytics/3_data_preparation/009-sampling-bias-and-unbiased-data.rst ../learn/data_analytics/3_data_preparation/010-common-types-of-data-bias.rst ../learn/data_analytics/3_data_preparation/011-identifying-good-data-sources-roccc-framework.rst ../learn/data_analytics/3_data_preparation/012-identifying-bad-data-sources-when-data-does-not-roccc.rst ../learn/data_analytics/3_data_preparation/013-data-ethics-in-data-analysis.rst ../learn/data_analytics/3_data_preparation/014-data-privacy-in-data-ethics.rst ../learn/data_analytics/3_data_preparation/015-open-data-and-openness-in-data-ethics.rst ../learn/data_analytics/3_data_preparation/016-databases-and-relational-database-concepts.rst ../learn/data_analytics/3_data_preparation/017-metadata-in-databases.rst ../learn/data_analytics/3_data_preparation/018-metadata-repositories-and-data-governance.rst ../learn/data_analytics/3_data_preparation/019-accessing-data-internal-and-external-sources.rst ../learn/data_analytics/3_data_preparation/020-importing-data-into-spreadsheets.rst ../learn/data_analytics/3_data_preparation/021-sorting-and-filtering-data-in-spreadsheets.rst ../learn/data_analytics/3_data_preparation/022-bigquery-account-types.rst ../learn/data_analytics/3_data_preparation/023-querying-data-with-sql.rst ../learn/data_analytics/3_data_preparation/024-organizing-data-for-personal-and-work-projects.rst ../learn/data_analytics/3_data_preparation/025-data-security-in-spreadsheets.rst ../learn/data_analytics/3_data_preparation/index.rst ../learn/data_analytics/4_data_cleaning_preparation/001-the-importance-of-clean-data.rst ../learn/data_analytics/4_data_cleaning_preparation/002-data-integrity-and-its-risks-in-data-analysis.rst ../learn/data_analytics/4_data_cleaning_preparation/003-aligning-data-with-business-objectives.rst ../learn/data_analytics/4_data_cleaning_preparation/004-handling-insufficient-data-in-data-analysis.rst ../learn/data_analytics/4_data_cleaning_preparation/005-population-sample-size-and-random-sampling.rst ../learn/data_analytics/4_data_cleaning_preparation/006-statistical-power-in-data-analysis.rst ../learn/data_analytics/4_data_cleaning_preparation/007-sample-size-and-data-integrity.rst ../learn/data_analytics/4_data_cleaning_preparation/008-margin-of-error.rst ../learn/data_analytics/4_data_cleaning_preparation/009-dirty-data-vs-clean-data.rst ../learn/data_analytics/4_data_cleaning_preparation/010-the-importance-of-clean-data-revisited.rst ../learn/data_analytics/4_data_cleaning_preparation/011-common-issues-in-dirty-data.rst ../learn/data_analytics/4_data_cleaning_preparation/012-data-cleaning-with-spreadsheets.rst ../learn/data_analytics/4_data_cleaning_preparation/013-cleaning-and-merging-multiple-datasets.rst ../learn/data_analytics/4_data_cleaning_preparation/014-spreadsheet-tools-for-data-cleaning.rst ../learn/data_analytics/4_data_cleaning_preparation/015-using-spreadsheet-functions-for-data-cleaning.rst ../learn/data_analytics/4_data_cleaning_preparation/016-viewing-data-differently-for-more-effective-data-cleaning.rst ../learn/data_analytics/4_data_cleaning_preparation/017-data-mapping-and-the-big-picture-of-clean-data.rst ../learn/data_analytics/4_data_cleaning_preparation/018-introduction-to-sql.rst ../learn/data_analytics/4_data_cleaning_preparation/019-spreadsheets-vs-sql.rst ../learn/data_analytics/4_data_cleaning_preparation/020-core-sql-queries-for-data-cleaning-and-analysis.rst ../learn/data_analytics/4_data_cleaning_preparation/021-cleaning-data-with-sql-removing-duplicates-and-cleaning-string-variables.rst ../learn/data_analytics/4_data_cleaning_preparation/022-using-cast-to-clean-and-format-data-in-sql.rst ../learn/data_analytics/4_data_cleaning_preparation/023-advanced-sql-functions-for-data-cleaning.rst ../learn/data_analytics/4_data_cleaning_preparation/024-coalesce.rst ../learn/data_analytics/4_data_cleaning_preparation/025-verifying-and-reporting-data-integrity.rst ../learn/data_analytics/4_data_cleaning_preparation/026-verifying-data-cleaning-efforts.rst ../learn/data_analytics/4_data_cleaning_preparation/027-verification-techniques-using-spreadsheets-and-sql-to-catch-repeated-errors.rst ../learn/data_analytics/4_data_cleaning_preparation/028-documenting-data-cleaning-changes.rst ../learn/data_analytics/4_data_cleaning_preparation/029-reporting-data-cleaning-results.rst ../learn/data_analytics/4_data_cleaning_preparation/030-using-feedback-from-data-cleaning-to-improve-data-quality.rst ../learn/data_analytics/4_data_cleaning_preparation/031-refining-a-resume-for-data-analytics-roles.rst ../learn/data_analytics/4_data_cleaning_preparation/032-exploring-data-analyst-job-opportunities.rst ../learn/data_analytics/4_data_cleaning_preparation/index.rst ../learn/data_analytics/5_analyze_data/001-understanding-data-analysis.rst ../learn/data_analytics/5_analyze_data/002-data-organization-in-analysis.rst ../learn/data_analytics/5_analyze_data/003-sorting-and-filtering-in-data-analysis.rst ../learn/data_analytics/5_analyze_data/004-sorting-data-in-spreadsheets.rst ../learn/data_analytics/5_analyze_data/005-sorting-and-filtering-data-in-sql-using-order-by-and-where.rst ../learn/data_analytics/5_analyze_data/006-data-formatting-and-unit-conversion-in-spreadsheets.rst ../learn/data_analytics/5_analyze_data/007-data-validation-in-spreadsheets.rst ../learn/data_analytics/5_analyze_data/008-combining-data-validation-and-conditional-formatting-in-spreadsheets.rst ../learn/data_analytics/5_analyze_data/009-using-concat-in-sql-to-combine-text-from-multiple-columns.rst ../learn/data_analytics/5_analyze_data/010-working-with-strings-in-spreadsheets-len-left-right-find.rst ../learn/data_analytics/5_analyze_data/011-problem-solving-and-seeking-help-in-data-analysis.rst ../learn/data_analytics/5_analyze_data/012-how-to-effectively-search-for-solutions-online-as-a-data-analyst.rst ../learn/data_analytics/5_analyze_data/013-choosing-the-right-tool-in-data-analysis.rst ../learn/data_analytics/5_analyze_data/014-preparing-data-for-vlookup-in-spreadsheets.rst ../learn/data_analytics/5_analyze_data/015-using-vlookup-to-combine-data-across-spreadsheets.rst ../learn/data_analytics/5_analyze_data/016-troubleshooting-vlookup-and-building-a-problem-solving-framework.rst ../learn/data_analytics/5_analyze_data/017-using-join-in-sql-to-combine-tables.rst ../learn/data_analytics/5_analyze_data/018-subqueries-in-sql.rst ../learn/data_analytics/5_analyze_data/019-aggregating-data-with-subqueries-having-and-case-in-sql.rst ../learn/data_analytics/5_analyze_data/020-using-spreadsheet-formulas-for-sales-trend-analysis.rst ../learn/data_analytics/5_analyze_data/021-using-countif-and-sumif-for-conditional-aggregation-in-spreadsheets.rst ../learn/data_analytics/5_analyze_data/022-using-sumproduct-for-advanced-spreadsheet-calculations.rst ../learn/data_analytics/5_analyze_data/023-using-pivot-tables-for-calculations-and-trend-analysis.rst ../learn/data_analytics/5_analyze_data/024-using-pivot-table-filters-and-calculated-fields-for-deeper-analysis.rst ../learn/data_analytics/5_analyze_data/025-comparing-calculations-in-spreadsheets-and-sql.rst ../learn/data_analytics/5_analyze_data/026-embedding-calculations-in-sql-queries.rst ../learn/data_analytics/5_analyze_data/027-using-group-by-and-order-by-for-aggregated-calculations-in-sql.rst ../learn/data_analytics/5_analyze_data/028-data-validation-as-an-ongoing-analytical-process.rst ../learn/data_analytics/5_analyze_data/029-temporary-tables-and-the-with-clause-in-sql.rst ../learn/data_analytics/5_analyze_data/030-creating-temporary-tables-in-sql-methods-trade-offs-and-best-practices.rst ../learn/data_analytics/5_analyze_data/index.rst ../learn/data_analytics/6_data_visualization/001-data-visualization.rst ../learn/data_analytics/6_data_visualization/002-connecting-data-and-images.rst ../learn/data_analytics/6_data_visualization/003-creating-powerful-data-visualizations-focus-structure-and-analytical-purpose.rst ../learn/data_analytics/6_data_visualization/004-static-vs-dynamic-data-visualizations-design-tradeoffs-control-and-interactivity.rst ../learn/data_analytics/6_data_visualization/005-elements-of-art-in-data-visualization-line-shape-color-space-and-movement.rst ../learn/data_analytics/6_data_visualization/006-choosing-the-right-visualization-audience-centered-design-and-chart-selection.rst ../learn/data_analytics/6_data_visualization/007-design-thinking-in-data-visualization-a-user-centered-framework.rst ../learn/data_analytics/6_data_visualization/008-accessibility-in-data-visualization-designing-for-everyone.rst ../learn/data_analytics/6_data_visualization/009-introduction-to-tableau.rst ../learn/data_analytics/6_data_visualization/010-getting-started-with-tableau-public.rst ../learn/data_analytics/6_data_visualization/011-creating-a-co-emissions-visualization-in-tableau-public.rst ../learn/data_analytics/6_data_visualization/012-effective-vs-ineffective-data-visualizations-in-tableau.rst ../learn/data_analytics/6_data_visualization/013-using-creativity-in-tableau.rst ../learn/data_analytics/6_data_visualization/014-linking-multiple-datasets-in-tableau-public.rst ../learn/data_analytics/6_data_visualization/015-data-storytelling-giving-numbers-a-clear-and-convincing-voice.rst ../learn/data_analytics/6_data_visualization/016-engaging-your-audience-in-data-storytelling-identifying-the-key-message.rst ../learn/data_analytics/6_data_visualization/017-data-dashboards-organizing-insight-for-real-time-decision-making.rst ../learn/data_analytics/6_data_visualization/018-using-filters-to-create-compelling-and-focused-visuals.rst ../learn/data_analytics/6_data_visualization/019-structuring-a-persuasive-data-presentation-turning-insights-into-story.rst ../learn/data_analytics/6_data_visualization/020-designing-effective-data-presentation-slides-structure-visuals-and-professional-impact.rst ../learn/data_analytics/6_data_visualization/021-using-a-strategic-framework-to-structure-data-presentations.rst ../learn/data_analytics/6_data_visualization/022-weaving-data-into-presentations-hypotheses-context-and-the-mccandless-method.rst ../learn/data_analytics/6_data_visualization/023-presentation-skills-for-data-analysts-delivering-insights-with-confidence.rst ../learn/data_analytics/6_data_visualization/024-presenting-like-a-pro-best-practices-for-data-analysts.rst ../learn/data_analytics/6_data_visualization/025-preparing-for-q-and-a-anticipating-and-responding-to-stakeholder-questions.rst ../learn/data_analytics/6_data_visualization/026-handling-objections-in-data-presentations-responding-with-confidence-and-clarity.rst ../learn/data_analytics/6_data_visualization/027-q-and-a-best-practices-answering-questions-with-clarity-and-confidence.rst ../learn/data_analytics/6_data_visualization/index.rst ../learn/data_analytics/7_data_analysis_python/001-introduction-to-python-and-programming-fundamentals.rst ../learn/data_analytics/7_data_analysis_python/002-python-fundamentals.rst ../learn/data_analytics/7_data_analysis_python/003-jupyter-notebook-and-coding-environments.rst ../learn/data_analytics/7_data_analysis_python/004-object-oriented-programming-oop-in-python.rst ../learn/data_analytics/7_data_analysis_python/005-variables-in-python.rst ../learn/data_analytics/7_data_analysis_python/006-naming-conventions-and-restrictions-in-python.rst ../learn/data_analytics/7_data_analysis_python/007-data-types-and-type-conversion-in-python.rst ../learn/data_analytics/7_data_analysis_python/008-functions-in-python.rst ../learn/data_analytics/7_data_analysis_python/009-code-reusability-modularity-and-clean-code-in-python.rst ../learn/data_analytics/7_data_analysis_python/010-comments-algorithms-and-docstrings-in-python.rst ../learn/data_analytics/7_data_analysis_python/011-boolean-data-comparators-and-logical-operators-in-python.rst ../learn/data_analytics/7_data_analysis_python/012-branching-and-conditional-statements-in-python.rst ../learn/data_analytics/7_data_analysis_python/013-while-loops-and-iteration-in-python.rst ../learn/data_analytics/7_data_analysis_python/014-for-loops-in-python.rst ../learn/data_analytics/7_data_analysis_python/015-range-function-and-loop-control-in-python.rst ../learn/data_analytics/7_data_analysis_python/016-strings-in-python.rst ../learn/data_analytics/7_data_analysis_python/017-string-indexing-and-slicing-in-python.rst ../learn/data_analytics/7_data_analysis_python/018-string-formatting-with-format-in-python.rst ../learn/data_analytics/7_data_analysis_python/019-data-types-vs-data-structures-and-introduction-to-lists.rst ../learn/data_analytics/7_data_analysis_python/020-modifying-lists-in-python.rst ../learn/data_analytics/7_data_analysis_python/021-tuples-in-python.rst ../learn/data_analytics/7_data_analysis_python/022-advanced-use-of-loops-lists-tuples-and-list-comprehension.rst ../learn/data_analytics/7_data_analysis_python/023-dictionaries-in-python.rst ../learn/data_analytics/7_data_analysis_python/024-advanced-dictionary-usage-in-python.rst ../learn/data_analytics/7_data_analysis_python/025-sets-in-python.rst ../learn/data_analytics/7_data_analysis_python/026-libraries-packages-and-modules-in-python.rst ../learn/data_analytics/7_data_analysis_python/027-introduction-to-numpy-and-vectorization.rst ../learn/data_analytics/7_data_analysis_python/028-numpy-arrays-ndarray-and-core-concepts.rst ../learn/data_analytics/7_data_analysis_python/029-introduction-to-pandas-data-analysis-library.rst ../learn/data_analytics/7_data_analysis_python/030-pandas-dataframe-and-series.rst ../learn/data_analytics/7_data_analysis_python/031-boolean-masking-in-pandas.rst ../learn/data_analytics/7_data_analysis_python/032-grouping-and-aggregation-in-pandas-groupby-agg.rst ../learn/data_analytics/7_data_analysis_python/033-combining-data-in-pandas-concat-and-merge.rst ../learn/data_analytics/7_data_analysis_python/index.rst ../learn/data_analytics/8_job_search/001-transferable-skills.rst ../learn/data_analytics/8_job_search/002-career-identity-statement.rst ../learn/data_analytics/8_job_search/003-career-dreamer-ai-tool-for-career-exploration.rst ../learn/data_analytics/8_job_search/004-job-search-plan-using-ai-tools.rst ../learn/data_analytics/8_job_search/005-tailoring-your-resume.rst ../learn/data_analytics/8_job_search/006-using-ai-to-improve-and-tailor-your-resume.rst ../learn/data_analytics/8_job_search/007-building-a-professional-online-presence-personal-brand.rst ../learn/data_analytics/8_job_search/008-choosing-the-right-job-platforms.rst ../learn/data_analytics/8_job_search/009-job-application-tracking-using-ai-spreadsheets.rst ../learn/data_analytics/8_job_search/010-networking-for-job-search.rst ../learn/data_analytics/8_job_search/011-interview-preparation.rst ../learn/data_analytics/8_job_search/012-star-method-behavioral-interview.rst ../learn/data_analytics/8_job_search/013-using-ai-notebooklm-for-interview-preparation.rst ../learn/data_analytics/8_job_search/014-practicing-interviews-with-ai-gemini-live.rst ../learn/data_analytics/8_job_search/015-post-interview-strategy.rst ../learn/data_analytics/8_job_search/index.rst ../learn/data_analytics/index.rst