Professionals who can consider Data Analyst as next logical move to enhance their careers.

• Must have knowledge of SQL and Python programming language
• Understanding of statistics will be beneficial.

Course Outline: 

Introduction to Data Analytics

• Introduction to Data Analyst
• Application of Data Analyst
• Data Analyst Job Prospects
• Why Learn Data Analyst
• Future of Data Analyst
• Data Science Vs Data Analytics
• Data Analyst Vs Business Analyst
• Data Analyst Application
• Data Analyst Jobs
• Prerequisite for Data Analyst
• Data Analyst Components
• Data Analyst Lifecycle
• Data Analytics workflow
• Data Analyst Tools

Excel Fundamentals: 

1. Getting started with Excel

• Structure of the Excel working area
• How to navigate in Excel
• Ribbons and tabs
• Quick Access Toolbar (QAT)
• Dialog Box & Task Panes
• Data entry, Data Editing and Formatting Number
• Data Formatting
• Working with cells and ranges in excel
• Managing Worksheets 

2. Excel Essentials

• Introduction to Excel Tables
• Auto-fill, Custom Lists, and Flash Fill
• Number Formatting in Excel 

3. Excel Formulas

• Excel Formula Basics
• Logical Formulas in Excel
• Math Formulas in Excel
• Lookup and Reference Formulas in Excel
• Stats Formulas in Excel
• Text Formulas in Excel
• Date and Time Formulas in Excel 

4. Data Analysis

• Named Ranges in Excel
• Data Validation in Excel
• Data Sorting and Filtering in Excel
• Using Conditional Formatting in Excel 

5. Introduction to Excel Chart

• Introduction to Excel Charting
• Advanced Excel Charting Examples
• Dynamic Charts in Excel

6. Pivot Table

• Overview of Excel Pivot Table

Dashboard Design Concepts

• The Building Blocks
• Visual Analytics Components
• Types of Dashboards
• Dashboard Success and Integration

MySQL and Statistics:

• RDBMS Intro
• Data Definition Language
• Data Manipulation Language
• Data Control Language
• Data Query Language
• Mean, Median & Mode
• Normal & Position Distribution
• Descriptive Statistics
• Inferential Statistics
• Probability

Note: One visualization tool would be covered from Power BI/Tableau or QlikView

Power BI:

Get Started with Microsoft Data Analytics

• Overview of Data Analysts
• Roles in Data
• Tasks of Data Analysts
• Building blocks of Power BI

Prepare Data in Power BI

• Get Data

Cleaning, Transforming, and Loading Data

• Shape the Data
• Profile the Data
• Combine multiple tables into single table

Designing a Data Model in Power BI

Create Model Calculations using DAX in Power BI

• DAX Formulas
• DAX Functions

Create Reports

• Design the analytical report
• Design visually appealing reports

Create Dashboards

Create and Manage Workspaces

Manage Datasets in Power BI

Row-level Security

Tableau:

• Introduction to Advanced Tableau
• Tableau Introduction for beginners
• Data Connections
• Creating Data Extracts
• Tableau Calculations
• Aggregation in Tableau
• Creating Quick Table Calculations
• Box and Whisker Plots in Tableau
• Chart Types in Tableau
• Formatting and Annotations
• Filtering Data
• Organizing & Simplifying Data
• Mapping in Tableau
• Data Blending in Tableau
• Sorting Data in Tableau
• Special Field Types
• Pivoting Date Parts On Shelves
• Parameters in Tableau
• Tableau LOD Expressions
• Tableau Dashboard

QlikView: 

1. Getting Started

• Define Qlik
• Define QlikView
• A quick tour of QlikView
• Build your first QlikView document (Create a simple document)

1. Loading Data

• Understand how to load basic data sets into QlikView.

1. Visualization Foundations

• Understand how visualizations are created and configured.
• QlikView design interface
• Understanding dimensions and measures

1. Configuring Charts

• Understand how to configure various chart objects.

1. Interacting with Documents

• Identify various ways to search within QlikView.
• Understand various ways to select data within QlikView.

1. Sharing

• Understand object sharing possibilities.

Introduction to Data Analytics on Cloud

1. Introduction
2. Understand Data Analytics Lifecycle on Google Cloud

• Introducing a Google Cloud data analytics workflow
• Google Cloud data sources and storage methods

3. Explore data and Extracts Insight by Using BigQuery

• Introduction to BigQuery for data analysts
• Derive insight from data with BigQuery
• Getting Started with Google Cloud Platform and Qwiklabs
• BigQuery organizes data to make analytics easier

4. Make Data Driven Decisions by Using Looker

• Use Looker to analyze and chart data
• Visualize data using Looker studio
• Share reports and visualizations

Training Material Provided

• Digital format
• Lab access and assignment access will be provided