(2/2)Data Analysis and Presentation Skills：the PwC Approach 专项课程

02_introduction-to-python-programming-tools

03_introduction-to-python-ide

04_introduction-to-kaggle-and-why-it-is-required

05_introduction-to-github-and-why-it-is-required

06_introduction-to-python-programming-language

07_indentation-in-python

08_comments-in-python-and-why-it-is-useful

01_python-identifiers

02_keywords-in-python

03_variables-in-python

04_first-code-using-python-programming-language

05_type-casting

01_arithmetic-operators

02_assignment-operators

03_comparison-operators

04_membership-operators

05_bitwise-operators

01_input-formatting-in-python-input

02_if-statement

03_nested-if-else-statement

04_break-statement

01_while-loop

02_for-loop

03_what-are-strings

04_why-is-a-string-immutable

01_string-operations-concatenation-repetition

02_built-in-string-functions

03_split-and-join

04_test-cases-in-strings

05_formatting-of-strings

01_array-what-are-arrays

02_length-list-indexing-list-slicing

03_array-concat-repetition-membership

04_looping-an-array

05_built-in-array-functions

06_why-are-arrays-mutable

01_lists-what-are-lists

02_lists-concat-repetition-membership

03_why-are-lists-mutable

04_built-in-list-functions

01_tuples-what-are-tuples

02_length-tuple-indexing-tuple-slicing

03_why-are-tuples-immutable

04_built-in-tuple-functions

05_sets-what-are-sets

06_functions-in-sets-change

07_how-to-join-two-sets

01_dictionary-what-are-dictionaries

02_dictionary-indexing

03_built-in-dictionary-functions

04_dictionary-methods

01_what-are-functions

02_function-composition

03_formal-and-actual-arguments

04_what-is-a-lamda-function

01_oops-concept

02_concept-of-class-and-object

03_program-to-use-instances-as-return-values

04_concept-of-inheritance

05_polymorphism-concept-and-a-program-to-demonstrate-the-same

06_data-encapsulation-concept-and-a-program-to-demonstrate-the-same

07_data-abstraction-concept-and-a-program-to-demonstrate-the-same

01_what-are-files

02_program-to-read-an-entire-text-file

03_modes-of-opening-a-file

04_opening-and-closing-a-file

05_making-a-directory

01_working-with-directory

02_renaming-the-directory

03_changing-the-directory

04_removing-a-directory

01_introduction-to-exception-handling

02_types-of-errors

03_warning-vs-exception

04_try-statement

01_welcome-to-programming-for-data-science

03_learning-to-program

01_introduction-to-python

04_introduction-to-jupyter-notebook

01_python-as-a-calculator

01_overview-of-basic-data-types-in-python

01_introduction-to-structured-data-types-in-python

01_introduction-to-control-structures

01_introduction-to-functions

01_program-introduction

02_what-is-data-science

04_course-introduction

07_a-day-in-the-life-of-a-data-scientist

01_stages-of-a-data-science-project

02_roles-in-a-data-science-project

03_tools-of-the-trade

04_applications-of-data-science

01_introduction-to-structured-thinking

02_frameworks-of-structured-thinking

03_structured-thinking-and-problem-solving

04_structured-thinking-in-solving-business-problems

01_framing-the-problem-statement

02_the-common-pitfalls-the-loop-trap

03_the-common-pitfalls-the-complexity-trap

04_the-common-pitfalls-the-obvious-trap

01_defining-a-problem-statement-worksheet-psw

02_how-the-psw-helps-in-defining-a-problem-statement

01_mutually-exclusive-and-collectively-exhaustive-mece

02_what-is-an-issue-tree

03_creating-an-issue-tree

01_documenting-the-implementation-phase

02_the-adoption-plan

03_metrics-for-evaluation-1

04_metrics-for-evaluation-2

05_creating-user-research-for-insights

01_common-design-pitfalls

02_common-strategic-pitfalls

03_phases-of-testing-a-ds-project

01_human-centered-design-hcd-and-empathy

03_what-is-hcd

05_the-discovery-phase

07_the-solution-phase

08_fireside-chat-with-biju-dominic

09_empathy-in-design-three-strategies-to-build-empathy

01_program-introduction

02_gateway-to-the-course

01_database-and-why-relational-database

04_choosing-the-right-rdbms

06_introduction-to-the-ui-of-mysql

07_case-study-foodhunter-import-data

08_writing-your-first-code-to-explore-orders-table-part-1

09_writing-your-first-code-to-explore-orders-table-part-2

01_understanding-the-monthly-sales

02_analyzing-the-trend-in-sales-for-foodhunter

03_various-factors-affecting-revenue-hypothesis-generation

04_did-discounts-have-any-impact-on-sales

05_did-day-have-any-impact-on-sales

01_understand-percentage-change-in-sales-over-months

02_understanding-window-functions

04_compare-month-on-month-change-in-revenue

05_insights-based-on-delivery-time

01_a-sneak-peek-into-the-module

02_combine-information-from-different-tables-using-joins

04_analysing-the-food-preferences-of-customers

05_finding-restaurants-with-no-items-ordered

01_complete-recall-and-a-gist-of-the-module

02_converting-raw-data-into-a-structured-relational-dataset

03_importing-data-using-the-table-import-wizard

04_understanding-percentage-change-in-competitor-revenue-vs-foodhunter-revenue

01_introduction-to-the-global-problem-statement

02_basic-querying-of-data

03_product-based-analysis-of-sales

04_impact-of-campaign-on-sales-of-products

01_program-introduction

02_introduction-to-data-visualization

03_gateway-to-the-course

02_power-bi-interface-and-its-capabilities

03_charts-and-graphs-in-power-bi-part-1

04_charts-and-graphs-in-power-bi-part-2

05_charts-and-graphs-in-power-bi-part-3

07_building-your-first-dashboard-part-1

08_building-your-first-dashboard-part-2

01_why-do-we-need-to-clean-data

02_preliminary-investigations-of-data

03_understanding-relationships-between-tables

04_understanding-data-model

01_cleaning-and-transforming-the-data

02_transforming-the-data-using-pivot-table

03_updating-data-with-new-information

01_introduction-to-dax-function

02_introduction-to-calculated-columns-and-row-context

03_introduction-to-measures-and-filter-context

01_understanding-the-aggregation-function

02_understanding-the-logical-function

03_understanding-the-text-function

04_understanding-the-filter-functions-calculate-and-filter-part-1

05_understanding-the-filter-functions-calculate-and-filter-part-2

06_understanding-filter-functions-all-part-3

01_introduction-to-the-global-problem-statement

02_identifying-the-relationship-between-units-sold-revenue-and-online

03_understanding-the-web-traffic

04_understanding-click-through-rate

05_understanding-cost-per-click

06_comparing-marketing-spent-with-total-revenue

07_building-the-sales-and-marketing-dashboard-part-1

08_building-the-sales-and-marketing-dashboard-part-2

02_installation-introduction-to-ui-of-tableau

03_basics-of-data-visualization

04_why-data-visualization-is-important-for-any-career

05_exploratory-vs-explanatory-analysis

06_clients-and-products-in-tableau

01_introduction-to-the-tool

02_tableau-features

03_connecting-data-with-tableau

04_joining-data-sources

05_union-on-data-sources

01_live-data-connections-vs-data-extracts

02_usage-of-menus-and-toolbar

03_usage-of-data-pane

04_analytics-pane

05_sheet-tabs

01_shelves-and-cards

02_marks-card

03_legends

04_difference-between-green-and-blue-pill

05_splitting-data

01_pivoting-transforming-data

02_blue-green-pills-filters

03_blue-green-pills-affect-on-dates

04_cleaning-data-by-bulk-re-aliasing

05_create-hierarchies-to-drill-down-into-data

01_creating-groups-for-data

02_creating-and-using-sets

03_create-data-filters

04_create-calculated-fields

05_combine-data-sources-using-data-blending

06_bringing-in-more-data-with-joins

01_visualizing-data-using-bar-chart

02_line-charts

03_scatterplots

04_heat-maps

05_histograms

01_maps-in-tableau

02_dual-axis-charts

03_pie-charts

04_bump-charts

05_control-charts

01_pareto-charts

02_waterfall-charts

03_usage-and-filtration-of-data-with-charts

04_visualizing-categorical-data

05_visualizing-time-series-data

06_visualizing-multiple-variables

01_mapbox-integrations

02_aggregate-calculations

03_date-calculations

04_logic-calculations

05_number-calculations

06_string-calculations

07_summary-statistics-in-visualizations

01_add-reference-lines

02_add-trend-lines

03_visualizing-forecasting-data

04_what-is-dashboard

05_use-of-dashboard

06_creating-a-dashboard

01_course-introduction

02_languages-of-data-science

03_introduction-to-python

04_introduction-to-r-language

05_introduction-to-sql

06_other-languages

01_categories-of-data-science-tools

02_open-source-tools-for-data-science-part-1

03_open-source-tools-for-data-science-part-2

04_commercial-tools-for-data-science

05_cloud-based-tools-for-data-science

01_libraries-for-data-science

02_application-programming-interfaces-api

03_data-sets-powering-data-science

04_sharing-enterprise-data-data-asset-exchange

05_machine-learning-models

06_the-model-asset-exchange

01_overview-of-git-github

02_github-getting-started

03_github-working-with-branches

04_git-and-github-via-command-line-optional

05_branching-and-merging-via-command-line-optional

06_contributing-to-repositories-via-pull-request-optional

01_getting-started-with-jupyter-notebook

02_getting-started-with-jupyterlab

03_jupyter-architecture

01_what-is-rstudio-ide

02_installing-packages-and-loading-libraries-in-rstudio-ide

03_plotting-within-rstudio-ide

01_what-is-ibm-watson-studio

02_watson-studio-introduction

03_creating-an-account-on-ibm-watson-studio

04_jupyter-notebook-in-watson-studio-part-1

05_jupyter-notebook-in-watson-studio-part-2

06_linking-github-to-watson-studio

01_other-ibm-tools-for-data-science

02_ibm-watson-knowledge-catalog

03_data-refinery

04_spss-modeler-flows-in-watson-studio

05_ibm-spss-modeler

06_spss-statistics

07_model-deployment-with-watson-machine-learning

08_auto-ai-in-watson-studio

08_model-deployment-with-watson-machine-learning

09_auto-ai-in-watson-studio

09_ibm-watson-openscale

01_types

01_expressions-and-variables

01_string-operations

01_string-operations

01_list-and-tuples

01_dictionaries

01_sets

01_conditions-and-branching

01_loops

01_functions

01_objects-and-classes

01_reading-files-with-open

01_writing-files-with-open

01_loading-data-with-pandas

02_pandas-working-with-and-saving-data

01_one-dimensional-numpy

01_two-dimensional-numpy

01_simple-apis-part-1

02_simple-apis-part-2

02_html-for-webscraping

03_webscraping

01_welcome-from-your-instructors

03_python-packages-for-data-science

01_welcome-to-statistics

02_types-of-data

03_measure-of-central-tendency

04_measure-of-dispersion

01_visualization-fundamentals

02_statistics-by-groups

03_statistical-charts

04_introducing-the-teachers-rating-data

01_random-numbers-and-probability-distributions

02_state-your-hypothesis

04_normal-distribution

05_t-distribution

06_probability-of-getting-a-high-or-low-teaching-evaluation

01_z-test-or-t-test

02_dealing-with-tails-and-rejections

03_equal-vs-unequal-variances

04_anova

05_correlation-tests

01_regression-the-workhorse-of-statistical-analysis

02_regression-in-place-of-t-test

03_regression-in-place-of-anova

02_introduction-to-the-instructor

03_introduction-to-bigquery

04_setting-up-and-accessing-bigquery

05_navigating-the-bigquery-ui

06_exploring-bigquery-public-data-datasets

01_introduction-to-data-warehousing-and-bigquery

02_creating-datasets-for-data-organization

03_defining-tables-with-schema-and-settings

04_partitioning-and-clustering-strategies

05_creating-tables-using-sql

06_creating-partitioned-tables-using-sql

01_installing-anaconda-package-and-configuring-credentials

02_introduction-to-jupyter-notebook-ui

03_manipulating-data-with-pandas-replacing-and-appending-tables

04_adding-schema-information-dynamically

05_incorporating-partitioning-and-clustering-configurations

01_understanding-etl-extract-transform-load

02_performing-etl-with-csv-excel-and-json-files

01_introduction-to-data-query-language

02_exploring-sql-examples-for-data-retrieval

03_leveraging-aggregate-and-window-functions-for-advanced-queries

04_user-defined-functions-udfs-for-custom-transformations

05_data-security-and-governance-best-practice

01_conclusion

01_course-overview-video

01_module-1-introduction

03_introduction-to-time-value-of-money-and-cash-flow-diagrams

04_cash-flow-diagrams-in-excel

05_types-of-interest-simple-vs-compound

06_nominal-and-effective-interest-rates

07_terminology-interest-vs-discount-rates

08_the-power-of-compounding

09_basic-excel-financial-functions-i-fv-pv

10_basic-excel-financial-functions-ii-rate-nper

11_examples-using-apr-ear-fv-and-pv-functions

12_net-present-value-npv-xnpv-function

13_annuity-and-perpetuities

03_calculating-loan-payments-pmt

04_understanding-amortization-or-repayment-schedules

05_creating-an-amortization-in-excel-applying-ipmt-ppmt-functions

06_calculating-loan-balances-with-cumprinc-function

07_calculating-total-interest-and-principal-payments-with-cumipmt-and-cumprinc

08_impact-of-paying-extra-each-period-on-loan-repayment-horizon-nper

09_impact-of-adjustable-rate-mortgages-on-credit-card-loans

03_introduction-to-capital-budgeting

04_evaluating-one-time-projects-using-net-present-analysis

05_capital-budgeting-for-ongoing-projects-using-a-specified-time-horizon

06_capital-budgeting-for-ongoing-projects-equivalent-annual-worth

07_internal-rate-of-return-analysis-irr-xirr

08_incremental-cash-flow-analysis-and-marr

01_module-2-introduction

03_overview-of-pivot-tables

04_guidelines-for-inserting-pivot-tables-and-pivot-table-structure

05_understanding-variable-types-and-pivot-table-structure

06_filtering-organizing-and-sorting-pivot-tables

07_grouping-dates-and-more-filtering-of-pivot-tables

08_pivot-tables-contextual-tabs-the-design-and-analyze-tabs

09_the-show-value-as-display

10_creating-calculated-fields

11_the-power-of-show-value-as-displays-to-analyze-data

03_pivot-table-options-field-headers-and-buttons

04_using-slicers-and-timelines-in-pivot-tables

05_creating-pivot-charts

06_pivot-tables-with-different-levels-of-granularity

07_pivot-tables-in-google-sheets-functional

03_chart-interface-in-google-sheets

04_introduction-to-xlookup-powerful-replacement-to-vlookup-and-hlookup

05_xlookup-s-match-mode

06_xlookup-s-wildcard-mode

07_nested-xlookups-overview

08_dropdown-lists-plus-xlookups-vs-vlookup-and-match

09_unique-and-sort-functions-along-with-cell-referencing-in-google-sheets

10_the-filter-function-and-dependent-dropdowns

11_the-filter-functions-power

01_module-3-introduction

03_introduction-to-mastering-excel-dashboards

04_dashboard-design-checklist

05_dashboard-design-basics-getting-started

06_dashboard-workbook-structure

07_useful-shortcut-keys

08_dashboard-design-and-creation-tips

09_static-dashboard-calculations-i

10_static-dashboard-calculations-ii-getpivotdata-function

11_constructing-static-dashboard-using-textboxes-for-flexibility

12_design-elements-of-dashboards

13_static-dashboard-formatting-i-size-fonts-and-colors

14_static-dashboard-formatting-ii-containers-and-alignment

15_static-dashboard-formatting-iii-object-properties-final-touches

03_match-function-tutorial

04_using-slicers-and-timelines-in-pivot-tables

05_index-function-efficient-lookup-function

06_large-and-small-for-sorting-values

07_choose-an-alternative-to-if-statements

08_sumifs-a-review-with-twists

09_introduction-to-the-developer-tab-and-form-controls

10_combo-box-more-attractive-dropdown-list

11_check-box-check-uncheck-option

12_list-box-a-different-way-to-selection-from list

13_spin-button-increase-or-decrease-a-value-position

14_option-button-choose-between-options

15_scroll-bar-another-way-to-move-through-contents

OFFSET Function - Basic Usage

OFFSET with Arrays

03_calculations-form-controls-and-slicer-cell-links

04_calculations-overall-metric-calculations

05_calculations-monthly-charts-and-dynamic-titles

06_calculations-current-vs-previous-year-deltas

07_calculations-top-3-and-bottom-3-products-by-profitability

10_construction-and-design-shapes-and-formatting

13_construction-and-design-charts-edits-and-shape-properties

14_construction-and-design-linked-pictures

17_final-touches-for-dynamic-dashboard

01_welcome-to-the-business-intelligence-analyst-professional-certificate

03_the-business-intelligence-analyst-role

01_welcome-to-the-course

01_welcome-to-week-1

06_business-analytics-vs-business-analysis-vs-data-analytics

01_welcome-to-week-2

01_welcome-to-week-3

02_what-is-project-management

01_welcome-to-week-4

03_congratulations

01_welcome-to-the-course

03_the-business-intelligence-analyst-role

01_welcome-to-week-1

03_business-analysis-process-framework-overview

02_metrics-kpis-overview

02_power-interest-grid

01_welcome-to-week-2

01_welcome-to-week-3

02_what-are-visual-models

01_welcome-to-week-4

03_congratulations

01_welcome-to-the-course

03_the-business-intelligence-analyst-role

01_welcome-to-week-1

04_anatomy-of-a-spreadsheet

01_welcome-to-week-2

01_welcome-to-week-3

03_congratulations

01_welcome-to-the-course

03_the-business-intelligence-analyst-role

01_welcome-to-week-1

10_connecting-to-a-data-source

12_the-data-source-page

01_welcome-to-week-2

05_rename-fields

07_hide-fields

09_pivot-fields

05_edit-data-types

05_split-a-field

07_tour-de-france-part-1

08_tour-de-france-part-2

09_tour-de-france-part-3-optional-challenge

01_welcome-to-week-3

04_joins

06_unions

08_relationships

05_cross-database-joins

09_netflix

03_congratulations

01_course-introduction-scrum-master-profession

02_scrum-master-role-and-benefits

03_expert-viewpoints-what-does-the-scrum-master-do

04_scrum-master-skill-inventory

05_expert-viewpoints-scrum-master-skills

06_a-day-in-the-life-of-a-scrum-master

02_scrum-master-and-traditional-project-manager-comparison

03_expert-viewpoints-traditional-project-management-and-the-scrum-master

04_developing-scrum-master-skills

05_scrum-master-employment-opportunities

06_scrum-master-levels

07_expert-viewpoints-why-become-a-scrum-master

03_expert-viewpoints-scrum-master-employment

04_the-path-to-certification-pmi-acp-pmi-dasm-and-csm

05_expert-viewpoints-scrum-master-job-environment

01_expert-viewpoints-advice-for-aspiring-scrum-masters

02_course-introduction

02_scrum-process-and-artifacts

03_the-role-of-the-scrum-master

05_the-job-description-of-a-scrum-master

06_expert-viewpoints-what-does-a-scrum-master-do

07_comparing-scrum-values-to-project-management-methodologies

01_keys-to-success-skills-attributes-and-personality-traits-essential-to-scrum

02_scrum-master-defined

04_introduction-to-personas

02_managing-stakeholders

03_engaging-stakeholders

05_expert-viewpoints-scrum-master-as-a-leader

06_working-agreement

02_managing-the-daily-stand-up-meeting

03_focusing-the-team

05_expert-viewpoints-the-scrum-master

02_servant-leadership

03_define-qualities-of-a-self-organized-team

04_expert-viewpoints-scrum-master-as-a-coach

05_development-models-to-improve-team-effectiveness-and-continuous-improvement

01_scrum-master-and-the-product-owner-collaboration

02_expert-viewpoints-servant-leadership

03_develop-a-product-vision-and-determine-product-goals

04_collaborating-with-the-product-owner-to-refine-the-backlog

05_refining-the-backlog

03_dealing-with-difficult-stakeholders

04_expert-viewpoints-product-owner-collaboration

05_using-the-force-field-analysis-tool

01_conflict-and-the-team

02_expert-viewpoints-managing-complexity-and-change

03_recognizing-dependencies

05_navigating-change

03_the-path-to-certification-pmi-acp-pmi-dasm-and-csm

01_expert-viewpoints-advice-for-aspiring-scrum-masters

02_expert-viewpoints-scrum-master-job-environment

01_course-introduction

02_review-the-contents-and-purpose-of-a-project-charter

03_review-a-product-roadmap

04_case-study-project-charter-and-product-roadmap

05_stacey-diagramming-method

03_review-a-working-agreement

02_user-story-and-product-backlog-review

03_product-vision

01_risk-register-and-relative-estimation

02_velocity

02_sprint-backlog-and-kanban-boards

02_sprint-1-demo-review-demo-purpose-and-planning

02_sprint-1-retrospective-overview

02_sprints-1-and-2-analysis

02_personal-portfolio-development

03_resume-and-job-search-tips

01_course-introduction

02_csm-overview-and-domains

03_exam-testing-strategies

02_course-introduction

03_what-is-power-bi

04_applications-of-power-bi

05_installation-of-power-bi-desktop-and-service

06_working-with-power-bi

01_frameworks-for-data-model-i

02_frameworks-for-data-model-ii

03_power-bi-desktop-interface

04_power-bi-service-interface

05_data-sources-in-power-bi-desktop

01_transforming-data-i

02_transforming-data-ii

03_cleaning-data-i

04_cleaning-data-ii

05_shaping-data-relationships

02_analyzing-the-scenario

03_transformations-adjusting-the-data

04_transformations-adding-new-data

05_transformations-sorting-new-data

07_practice-project-problem-statement

08_practice-project-solution

01_summary-for-data-modeling-and-transformation

01_introduction-to-dax

02_dax-queries-i

03_dax-queries-ii

04_dax-queries-iii

01_dax-operations-i

03_dax-operations-problem-description

04_dax-operations-transformations

05_dax-operations-column-manipulations

06_dax-operations-date-manipulations

01_dax-functions-i

02_dax-functions-ii

03_dax-functions-iii

04_data-functions-iv

05_dax-functions-v

07_practice-project-i-railway-analysis

08_practice-project-ii-table-management

09_practice-project-iii-modifying-measures

10_practice-project-iv-insights

01_summary-for-dax

01_populating-charts-with-data

02_visualization-types-i

03_visualization-types-ii

04_visualization-types-iii

01_visualizing-data-i

02_visualizing-data-ii-problem-description

03_visualizing-data-iii-loading-data

04_visualizing-data-iv-creating-visuals

06_visualizing-data-vi-managing-visuals

01_practice-project-i-problem-description

02_practice-project-ii-transforming-data

03_practice-project-iii-creating-visuals

04_practice-project-iv-arranging-visuals

05_practice-project-v-syncing-visuals

01_summary-for-data-visualization

01_overview-of-power-bi-service

02_power-bi-service-i-loading-data

03_power-bi-service-ii-manipulating-visuals

04_power-bi-service-iii-creating-report

05_power-bi-service-iv-publishing-reports

06_power-bi-service-v-dashboarding

07_power-bi-service-vi-ai-insights

08_summary-for-power-bi-service

01_introduction-to-the-program

02_course-introduction-preparing-data-for-analysis-with-microsoft-excel

06_day-in-the-life

01_introduction-to-microsoft-excel

02_entering-and-formatting-data

01_reading-large-data-blocks

02_sorting-and-filtering-data-in-excel

08_module-summary-excel-fundamentals

01_what-is-a-formula

02_controlling-calculations

04_controlling-calculations-in-action

01_what-is-a-function-formula-and-how-to-write-it

02_using-the-insert-function

07_module-summary-formulas-and-functions

01_how-inconsistent-data-can-affect-data-analysis

01_why-understanding-date-calculations-is-important

02_dynamic-date-and-time-entries

01_using-the-if-function

02_using-nested-if-and-ifs-function

08_module-summary-preparing-data-for-analysis-using-functions

01_course-recap-preparing-data-for-analysis-with-microsoft-excel

01_congratulations

01_course-introduction

01_what-is-the-role-of-a-data-analyst

03_roles-working-with-data

04_essential-data-analyst-skills

01_gathering-the-right-data

02_processing-and-analyzing-the-data

07_how-data-insights-drive-business

01_introduction-to-power-bi

03_analyzing-data-with-power-bi

09_module-summary-data-analysis-in-business

01_identifying-and-evaluating-required-data

02_workflow-in-power-bi

01_the-etl-extract-transform-load-process

02_ingesting-and-gathering-data

03_storing-and-managing-data

01_transforming-and-cleaning-data

03_what-is-power-query

08_module-summary-the-right-tools-for-the-job

01_course-recap-harnessing-the-power-of-data

01_congratulations

01_course-introduction

01_how-combining-data-sources-gives-business-insights

03_setting-up-a-flat-data-source

07_storage-modes-in-power-bi

08_configuring-storage-modes-in-power-bi

01_structured-vs-unstructured-data

02_what-are-connectors

03_triggers-and-actions

07_module-summary-data-sources-in-power-bi

01_why-data-needs-to-be-transformed

02_introduction-to-power-query-and-its-interface

03_the-applied-steps-list

05_working-with-columns

08_dealing-with-errors-in-power-query

11_pivot-and-unpivot-columns

01_the-importance-of-data-combination

02_combining-tables-with-append

01_what-is-a-join

03_join-types

04_combining-tables-with-merge

07_identifying-a-new-potential-product

09_module-summary-transforming-data-in-power-bi

01_introduction-to-loading-data

02_the-staging-area-in-power-bi

01_introduction-to-data-profiling

02_profiling-data-in-power-bi

06_vignette-bad-data

01_best-practices-when-working-with-power-query

03_introduction-to-dataflows

04_introduction-to-reference-queries

05_reference-queries-and-dataflows

07_query-parameters

10_using-advanced-editor-to-modify-code

13_module-summary-advanced-etl-in-powerbi

01_course-recap-extract-transform-and-load-data-in-power-bi

01_congratulations

01_course-introduction

01_introduction-to-data-models

03_introduction-to-schemas

05_setting-up-a-flat-schema-in-power-bi

01_understanding-fact-and-dimension-tables

03_introduction-to-cardinality

06_introduction-to-cross-filter-direction

07_defining-data-granularity

01_setting-up-a-star-schema-in-power-bi

04_setting-up-a-snowflake-schema

06_why-it-is-important-to-use-snowflake-schema

07_resolving-challenges-in-data-models

09_module-summary-concepts-for-data-modeling

01_introduction-to-data-analysis-expressions-dax

02_row-context-and-filter-context

03_formulas-and-functions-in-dax

05_introduction-to-calculated-tables

07_creating-calculated-columns

01_introduction-to-measures

02_types-of-measures

03_basic-statistical-functions

05_context-and-dax-measures

01_creating-quick-measures

02_creating-custom-measures-with-dax

04_introduction-to-the-crossfilter-function

05_using-calculate-with-filters

01_introduction-to-role-playing-dimensions

02_introduction-to-the-userelationship-function

03_configuring-role-playing-dimensions

01_the-importance-of-time-intelligence

02_using-dax-for-summarization-over-time

03_using-dax-for-comparison-over-time

06_setting-up-a-common-date-table

07_setting-up-a-common-date-table-with-m-and-power-query

09_time-intelligence-in-business

10_module-summary-using-dax-in-power-bi

01_what-is-optimization-and-why-is-it-necessary

02_optimization-by-example

03_resolving-performance-issues-in-the-data-model

04_identifying-and-reducing-cardinality-levels

01_behavior-and-limitations-of-directquery-connections

02_optimizing-directquery-performance-with-query-reductions

03_optimizing-directquery-performance-with-table-storage

01_what-are-aggregations-and-why-use-them

02_creating-an-aggregation

05_module-summary-optimize-a-model-for-performance-in-power-bi

01_course-recap-modeling-data-in-power-bi

01_congratulations

02_what-is-quality-origins-of-six-sigma-david-cook

03_six-sigma-foundations-and-principles

04_purpose-of-six-sigma

05_six-sigma-methodology

06_evolution-of-six-sigma

07_value-of-six-sigma

02_individual-contributors

03_yellow-and-green-belt

04_roles-and-responsibilities-of-black-belts

05_role-of-master-black-belts

06_role-of-champions

02_introduction-to-quality-tools

03_pareto-charts

04_cause-and-effect-diagrams

06_flow-charts-and-process-mapping

07_checksheets

09_scatter-diagrams

10_histograms

02_six-sigma-measure-pt1

03_six-sigma-measure-pt2

05_cost-of-poor-quality

01_importance-of-teams

03_types-of-teams

05_stages-of-team-development

02_brainstorming

03_team-decision-making

02_agendas-minutes-and-status-reports

02_purpose-of-lean

05_value-stream-mapping

06_interview-real-world-value-stream-mapping

02_jit-kanban

04_poka-yoke

02_value-to-the-organization

02_voice-of-the-customer

03_critical-to-satisfaction

04_quality-function-deployment

05_project-selection

06_swot-analysis

07_identifying-stakeholders

08_process-identification

09_sipoc

02_defining-the-problem-statement

04_developing-a-project-plan

05_brainstorming-diagramming-tools

07_other-project-planning-tools

09_six-sigma-phase-reviews

02_basic-statistics-pt1

03_basic-statistics-pt2

02_data-collection

03_data-collection-techniques-part-1

04_data-collection-techniques-part-2

02_measurement-system-analysis-part-1

04_measurement-system-analysis-part-2

01_process-analysis-tools

03_eliminating-waste

04_5s

02_fmea-part-1

04_fmea-part-2

06_fmea-part-3

01_root-cause-analysis

03_5-whys

05_process-mapping

07_force-field-analysis

09_matrix-charts

02_characteristics-of-probability-distributions

04_calculating-probabilities-using-the-normal-distribution

05_calculating-probabilities-in-the-normal-distribution-example-problems

07_the-binomial-distribution

08_binomial-distribution-calculations

09_binomial-distribution-calculations-more-examples

02_common-versus-special-cause-variation

02_dependent-and-independent-variables

03_types-of-correlation

05_the-regression-equation

06_use-of-regression-for-prediction

08_regression-for-six-sigma

02_hypothesis-testing-basics

04_types-of-errors

05_types-of-error-examples

07_how-to-do-a-hypothesis-test

09_p-value-and-statistical-significance

01_introduction

02_suboptimization

04_kaizen-and-kaizen-blitz

06_pdca

08_cost-benefit-analysis

10_cost-of-quality

02_control-charts-part-1

03_control-charts-part-2

04_document-management

02_six-sigma-philosophy

04_luminaries-and-path-to-six-sigma

06_what-is-process

07_significance-of-six-sigma

09_green-belt-roles

10_dmaic

12_cost-benefit-analysis

13_key-concepts

01_explaining-yellow-belt-refresher-areas

02_purpose-of-lean

03_value-stream-mapping

04_jit-and-kan-ban

05_poka-yoke

06_value-to-the-organization

07_suboptimization

08_kaizen-and-kaizen-blitz

09_pdca

10_cost-benefit-analysis

11_cost-of-quality

02_introduction

03_history-of-lean

04_lean-principles

06_lean-concepts

08_the-toyota-way

10_theory-of-constraints

12_important-tools

13_measuring-and-monitoring

02_design-for-six-sigma-pt1

04_design-for-six-sigma-pt2

03_project-selection

04_process-elements

05_sipoc

06_identifying-stakeholders

03_voice-of-the-customer

04_critical-to-satisfaction

05_quality-function-deployment

03_defining-project-charter

04_developing-a-project-plan

01_yellow-belt-refresher-areas-explained

03_cause-and-effect-diagrams

04_checksheets

05_flow-charts-and-process-mapping

07_pdca

09_defects-per-unit-defects-per-million-opportnities

10_roll-throughput-yield

12_affinity-diagram

13_activity-network-diagram

15_multivoting

16_nominal-group-technique

18_force-field-analysis

20_prioritization-matrices

22_sipoc

23_tree-diagrams

24_control-charts-pt1

25_control-charts-pt2

01_introduction

02_kano-model

04_voice-of-the-customer-tools-for-measure

06_benchmarking-and-balanced-scorecard

08_more-team-tools

10_8d-problem-solving

02_process-capability

01_explaining-yellow-belt-refresher-areas

02_the-importance-of-teams-in-quality-improvement

03_types-of-teams

04_stages-of-team-development

05_brainstorming

06_team-decision-tools

07_agendas-minutes-and-status-reports

01_introduction

03_process-mapping-and-flow-charts

05_written-procedures

06_work-instructions

08_cedac

10_pareto-diagrams

12_relationship-matrix

02_basic-probability-concepts

04_mutually-exclusive-independent-events

06_addition-rules-for-probability

08_conditional-probability

10_multiplicative-rules

02_combinations-and-permutations

04_the-central-limit-theorem-clt

05_the-central-limit-theorem-clt-applications

07_descriptive-vs-inferential-statistics

01_characteristics-of-probability-distribution-yellow-belt-refresher-video

03_the-binomial-distribution-yellow-belt-refresher-video

04_binomial-calculations-yellow-belt-refresher-video

06_poisson-distribution

08_calculating-probabilities-using-the-normal-distribution-yellow-belt-refresher

10_chi-square

12_t-distribution-f-distribution

01_explaining-the-yellow-belt-refresher-areas

02_basic-statistics-pt-1

03_basic-statistics-pt-2

02_collecting-and-summarizing-data-pt-1

03_collecting-and-summarizing-data-pt-2

04_collecting-and-summarizing-data-pt-3

02_measuring-system-analysis-pt-1

03_measuring-system-analysis-pt-2

02_process-and-performance

03_designing-process-performance

04_analyzing-process-capability

05_control-chart-interpretation

02_multi-variable-study

03_types-of-correlation-yellow-belt-refresher-video

04_correlation

05_linear-regression

02_hypothesis-test-z-test

04_hypothesis-test-t-test

06_confidence-intervals

08_paired-comparison-tests

10_anova-chi-square

02_intro-to-design-of-experiments

03_factors-outcomes-levels-and-treatments

05_variables-effects-interaction-and-experimental-error

07_ways-to-mitigate-experimental-error

09_the-doe-process

02_interpreting-main-effects

04_interaction-effects

06_introduction-to-anova

08_full-vs-fractional-factorial-design

10_summary-of-doe

01_yellow-belt-refresher-area-explained

02_purpose-of-lean

03_cause-and-effect-diagrams

04_5-whys

05_fmea-pt1

06_fmea-pt2

07_fmea-pt3

02_introduction

04_7-step-model

05_more-tools-for-root-cause

07_counter-measures

09_single-minute-exchange-of-die-smed

01_yellow-belt-refresher-areas-explained

02_poka-yoke

03_removing-waste

04_kaizan

05_kan-ban

06_5s

07_process-mapping-vid1

08_process-mapping-vid2

09_value-stream-mapping

10_total-productive-maintenance-visual-management-smed

01_introduction

02_lean-philosophy

03_lean-goals

04_lean-tools-systems

05_case-study-1

06_case-study-2

07_case-study-3

02_statistical-process-control-part-1

03_statistical-process-control-part-2

04_statistical-process-control-part-3

05_statistical-process-control-part-4

02_control-plan

02_lean-tools-for-process-control-part-1

03_lean-tools-for-process-control-part-2

01_course-introduction-and-specialization

01_introduction-to-data-visualization

03_what-is-data-visualization-and-why-do-we-do-it

05_installing-tableau

01_exploring-and-navigating-tableau-overview

02_importing-visualizations

03_navigating-the-tableau-publics-software-part-1

01_making-data-connections-overview

02_preparing-your-data-for-import

03_primary-types-of-connections

04_preparing-your-data

05_connecting-and-merging-multiple-data-sources

01_context-of-data-visualization-overview

02_the-who-what-and-how-of-data-visualization

04_illustration-of-the-who-what-and-how

05_context-of-data-visualization

01_course-wrap-up

01_course-introduction

02_the-human-brain-and-data-visualization

03_cognitive-vs-perceptual-design-distinction

01_introduction-of-effective-and-ineffective-visuals

02_types-of-visualizations

03_examples-of-the-types-of-visualizations-in-tableau

04_practicing-good-ethics-in-data-visualization

05_ineffective-visuals-and-how-to-improve-them

01_visual-perception-and-cognitive-principles-introduction

02_cognitive-load-and-clutter

03_principles-of-visual-perception

04_strategic-use-of-contrast

05_pre-attentive-attributes-of-visualizations

06_color-as-a-pre-attentive-attribute

07_de-cluttering-exercise

01_design-best-practices-introduction

02_gestalt-principle-proximity

03_leveraging-pre-attentive-attributes

04_accessible-visualizations

06_aesthetics

01_design-and-exploratory-analysis-introduction

02_what-is-exploratory-and-explanatory-analysis

03_case-study-anscombes-quartet

05_constructing-a-control-chart

01_design-for-understanding-introduction

02_know-your-audience-s

03_design-for-purpose

04_data-relationships-and-design

05_static-versus-interactive-visualizations

06_multiple-connected-view

07_language-labeling-and-scales

08_visual-lies-and-cognitive-bias

01_final-thoughts

01_visual-analytics-with-tableau-introduction

01_introduction-to-charting

02_tableau-charts

03_colors-shapes-and-sizes

04_dual-line-charts

05_tableau-tooltip

06_charting-guidelines-bar-charts-line-graphs-pie-charts

07_charting-guidelines-maps-scatter-plots-gantt-charts-bubble-charts

08_charting-guidelines-histograms-bullet-charts-heat-maps-and-highlight-tables

09_charting-guidelines-treemaps-and-box-and-whisker-plots

01_introduction-to-dates

02_discrete-vs-continuous-dates

03_date-hierarchies

04_converting-discrete-and-continuous-dates

05_tableau-calculated-fields

01_introduction-to-table-calculations

02_calculated-fields

03_quick-table-calculations

04_custom-table-calculations

05_filters

06_parameters

01_introduction-to-mapping

02_working-with-geographic-data

03_shapes-colors-and-sizes

04_custom-mapping-techniques

05_custom-geocoding

06_dual-layer-mapping

01_course-summary

01_course-introduction

01_introduction-to-planning-and-preproduction-for-visualizations

02_a-design-checklist-of-the-who-what-why-and-how

03_start-with-your-stakeholders

04_addressing-your-audience-and-their-context

05_finding-the-story

06_prioritizing-optimizing-and-designing-the-data-story

08_case-study-the-tale-of-100-entrepreneurs-part-1

09_case-study-the-tale-of-100-entrepreneurs-part-2

10_case-study-the-tale-of-100-entrepreneurs-part-3

01_introduction-to-key-metrics-indicators-and-decision-triggers

02_key-performance-indicators-kpis

03_tableau-calculated-fields-and-kpis

04_creating-complex-kpis-using-tableau

05_thresholds-and-alerts

02_best-practices-for-dashboard-design

03_dashboard-design-principles-1-2-3

04_dashboard-design-principles-4-5-6

05_hierarchies-actions-filters-and-parameters-part-1

06_hierarchies-actions-filters-and-parameters-part-2

07_hierarchies-actions-filters-and-parameters-part-3

08_hierarchies-actions-filters-and-parameters-part-4

09_important-considerations-for-creating-dashboards

02_tell-the-story-of-your-data-introduction

03_the-art-of-storytelling-past-present-and-future

04_storytelling-and-the-human-brain

05_bringing-data-to-life-emotions-and-data-storytelling

07_emotion-modulators-color-language-and-other-design-elements

08_framing-and-format

09_framing-conventions-and-priming

10_false-narratives-and-data-storytelling

11_telling-the-stories-within-the-story-part-1

12_telling-the-stories-within-the-story-part-2

13_story-considerations

14_preparation-of-the-story-points

15_setting-up-the-story

16_creating-points-in-the-story

17_interactive-story

18_create-a-data-story-in-a-static-presentation

01_course-summary

01_project-welcome

01_milestone-1-assignment-overview

01_milestone-2-assignment-overview

01_milestone-3-assignment-overview

01_milestone-4-assignment-overview

01_milestone-5-assignment-overview

01_project-summary

01_course-introduction

02_modern-data-ecosystem

03_key-players-in-the-data-ecosystem

04_defining-data-analysis

05_viewpoints-what-is-data-analytics

01_responsibilities-of-a-data-analyst

02_viewpoints-qualities-and-skills-to-be-a-data-analyst

03_a-day-in-the-life-of-a-data-analyst

04_viewpoints-applications-of-data-analytics

01_overview-of-the-data-analyst-ecosystem

02_types-of-data

03_understanding-different-types-of-file-formats

04_sources-of-data

05_languages-for-data-professionals

01_overview-of-data-repositories

02_rdbms

03_nosql

04_data-marts-data-lakes-etl-and-data-pipelines

05_foundations-of-big-data

06_big-data-processing-tools

01_identifying-data-for-analysis

02_data-sources

03_how-to-gather-and-import-data

01_what-is-data-wrangling

02_tools-for-data-wrangling

03_data-cleaning

04_viewpoints-data-preparation-and-reliability

01_overview-of-statistical-analysis

02_what-is-data-mining

03_tools-for-data-mining

01_overview-of-communicating-and-sharing-data-analysis-findings

02_viewpoints-storytelling-in-data-analysis

03_introduction-to-data-visualization

04_introduction-to-visualization-and-dashboarding-software

05_viewpoints-visualization-tools

01_career-opportunities-in-data-analysis

02_viewpoints-get-into-data-profession

03_viewpoints-what-do-employers-look-for-in-a-data-analyst

04_the-many-paths-to-data-analysis

05_viewpoints-career-options-for-data-professionals

06_viewpoints-advice-for-aspiring-data-analysts

07_viewpoints-women-in-data-professions

01_course-introduction

02_introduction-to-spreadsheets

03_spreadsheet-basics-part-1

04_spreadsheet-basics-part-2

05_viewpoints-using-spreadsheets-as-a-data-analysis-tool

01_viewing-entering-and-editing-data

02_copying-filling-and-formatting-cells-and-data

03_the-basics-of-formulas

04_intro-to-functions

05_referencing-data-in-formulas

01_introduction-to-data-quality

02_importing-file-data

03_basics-of-data-privacy

04_viewpoints-data-quality-and-privacy

01_removing-duplicated-or-inaccurate-data-and-empty-rows

02_dealing-with-inconsistencies-in-data

03_more-excel-features-for-cleaning-data

04_viewpoints-issues-with-data-quality

01_intro-to-analyzing-data-using-spreadsheets

02_filtering-and-sorting-data-in-excel

03_viewpoints-filtering-and-sorting

04_useful-functions-for-data-analysis

05_using-vlookup-and-hlookup-functions

01_introduction-to-creating-pivot-tables-in-excel

02_viewpoints-pivot-tables

03_pivot-table-features

03_introduction-to-charts

04_interview-using-visualizations-to-tell-a-data-story

05_creating-basic-charts-in-excel-line-pie-and-bar-charts

06_using-the-excel-pivotchart-feature

01_creating-treemaps-scatter-charts-and-histograms

01_introduction-to-dashboarding

03_interview-using-dashboards-to-present-data-results

01_cognos-analytics-introduction-and-how-to-sign-up

02_navigating-in-cognos-analytics

03_creating-a-simple-dashboard-in-cognos

04_advanced-capabilities-in-cognos-analytics-dashboards

01_types

01_expressions-and-variables

01_string-operations

01_string-operations

01_list-and-tuples

01_dictionaries

01_sets

01_conditions-and-branching

01_loops

01_functions

01_objects-and-classes

01_reading-files-with-open

01_writing-files-with-open

01_loading-data-with-pandas

02_pandas-working-with-and-saving-data

03_pandas-working-with-and-saving-data

01_one-dimensional-numpy

01_two-dimensional-numpy

01_simple-apis-part-1

02_simple-apis-part-2

01_welcome-to-sql-for-data-science

01_welcome-to-sql-for-data-science~1

02_introduction-to-databases

03_how-to-create-a-database-instance-on-cloud

04_relational-database-concepts

01_create-table-statement

02_select-statement

03_count-distinct-limit

03_select-statement

04_insert-statement

05_count-distinct-limit

05_update-and-delete-statements

06_insert-statement

07_update-and-delete-statements

02_information-and-data-models

03_types-of-relationships

04_mapping-entities-to-tables

05_relational-model-concepts

01_using-string-patterns-ranges

01_using-string-patterns-ranges~1

02_sorting-result-sets

03_grouping-result-sets

01_built-in-database-functions

02_date-and-time-built-in-functions

03_sub-queries-and-nested-selects

04_sub-queries-and-nested-selects

04_working-with-multiple-tables

05_working-with-multiple-tables

02_relational-model-constraints

03_relational-model-constraints-advanced

01_how-to-access-databases-using-python

01_how-to-access-databases-using-python~1

02_writing-code-using-db-api

03_connecting-to-a-database-using-ibm-db-api

04_creating-tables-loading-data-and-querying-data

05_analyzing-data-with-python

05_creating-tables-loading-data-and-querying-data

06_analyzing-data-with-python

02_join-overview

03_inner-join

04_left-outer-join

05_right-outer-join

06_full-outer-join

01_working-with-real-world-datasets

01_working-with-real-world-datasets~1