Page Comparison

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