Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

  • Coursera: paid online courses

  • Enroll in a course and elect to audit the course for free

  • Guided projects are not available to audit

Databases and SQL for Data Science

  • Introduction to databases and basic SQL

  • Advanced SQL

  • Accessing databases using Python

Managing Big Data with MySQL

  • Understanding relational databases

  • Queries to extract data from single tables

  • Queries to summarize groups of data from multiple tables

  • Queries to address more details business operations

Communicating Business Analytics Results

  • Analytical techniques applied to business problems

  • Best practices in data visualization

  • Interpreting, telling and selling

  • Acting on data

Introduction to Data Analysis Using Excel

  • Introduction to spreadsheets

  • Spreadsheet functions to organize data

  • Introduction to filtering, pivot tables and charts

  • Advanced graphing and charting

Problem Solving with Excel

  • Overview of Excel

  • vLookups and data cleansing

  • Logical functions & pivot tables

  • More advanced formulas

Data Visualization with Advanced Excel

  • Preparing a professional Excel

  • Advanced scenario analysis

  • Data visualization

  • Dashboarding

  • No labels