Data Analysis

• Ask: Define business problems, define bottom lines, manage stakeholders, and manage stakeholder expectations.

• Asking smart and effective questions: agreed-upon expectations, timelines, milestones, and reports.

• Asking the right questions: 5 whys, interviewing, surveys, workshops, brainstorming.

• Spreadsheets, databases, query languages, visualization software

• Spreadsheet basics: functions and formulas, data types.

• Difference between spreadsheets and databases.

• Types of popular visualization software and their uses: Power BI/Tableau

Session 2B: Database and query basics

• Types of popular visualization software and their uses: Power BI/Tableau

• Data visualization basics.

Structured thinking—recognizing current problems/solutions, organizing available solutions, revealing gaps and opportunities, identifying options.

• Data formats: quantitative data, qualitative data

• Sources of data: primary, secondary, tertiaryQualities of data - 5 Vs

• Structured and unstructured data
  
  

  Data Collection

  • Types of sampling, statistical significance, hypothesis testing

  • Data Modelling - conceptual/logical/physical

Data Preparation 1

• Bias and Variance

• Boolean: OR, AND, NOT

• Data ethics: ownership, transaction transparency, consent, currency, privacy, and openness.

• Database Normalization: Primary/Foreign Keys, Excel Demo.

 Data Preparation 2

• Metadata types: Import data in CSV/importrange

• Data Protection and Security: Encryption, Tokenization, and Version Control

Session 4C: Data Preparation 3

• Sort/Filter in Excel

• Databases: DML, DCL, DDL

• File organization

• Formatting Splitting

• Remove duplicates, find and replace

 Cleaning

• COUNTIF, LEN, TRIM, CONCATENATE

 Cleaning

• Pivot Tables, Vlookup

• SQL Dialects

• CAST, COALESCE, CONCAT

• Sorting with Excel and SQL

• Data conversion and validation

 Analyze

• VLOOKUPs and Joins

• Subqueries

• Temporary Tables

• Decision tree for visualization

• Design Principles

 Visualize

• Utilizing Tableau

• Visuals and Charts in tableau

• ing datasets

• 1. Manage & deliver projects under little or no supervision. [Apply what is gained using practical training]
• 2. Solve business case studies & provide solutions to business problems.
  
  
• 3. Job preparation to prepare you for your market transition.

• Building a basic computer system

• Configuring a small network

• Troubleshooting common IT issues

• Simulating customer support scenarios