Course Outline

MODULE 1: DATA ANALYTICS FUNDAMENTALS

• Why Data Analytics?
• Data Driven Decision Making
• Data Literacy
• Different types of Data Analytics

Laboratory using Microsoft Excel

• Using Fill Series
• Name Manager to Simplify data structure
• Apply Simple Excel Number Functions with Name Manager
• Apply Criteria based Excel formulas (IF, COUNTIF, SUMIF, AVERAGEIF)

MODULE 2: DATA ANALYTICS PROCESS AND LIFE CYCLE

• Data Collection Method
• Data Formatting and Structure

Laboratory using Microsoft Excel

• Creating Indicators using Conditional Formatting
• Using Text Functions (Concatenate, Format Case, Flash Fill)
• Using Date Functions (Datedif, Networkdays, Workday)
• Using Lookup Functions (VLOOKUP, HLOOKUP, XLOOKUP)

MODULE 3: DATA ANALYSIS AND VISUALIZATION USING EXCEL PIVOT TABLE AND CHART

Laboratory using Microsoft Excel

• Introduction to Pivot Tables
• Importing Data to Pivot Area and apply best practices
• Creating Formulas in the Pivot Area
• Creating Dynamic Dashboard using Excel Pivot Chart

MODULE 4: DATA PREPARATION METHODS

• Quality Assurance
• Data Profiling
• Extract Transform and Load

Laboratory using Microsoft Power BI

• Power BI Desktop Configuration
• Import data to Power BI Desktop
• Introduction to Power Query
• Clean and Transform Data using Power Query

o  Date Related Functions

o  Text Related Functions

o  Number Related Functions

o  Merge and Append Query

MODULE 5: DATABASE NORMALIZATION

• Database Normalization
• Data Tables and Lookup Tables
• Primary Key and Foreign Key
• Relationship Cardinality

Laboratory using Microsoft Power BI

• Refreshing Queries in Power Query
• Data categories for Geographical Data
• Setting up Data Types
• Creating Table Relationships
• Creating Basic Dashboard with Power BI

MODULE 6: DATA ANALYSIS EXPRESSIONS WITH POWER BI

Laboratory using Microsoft Power BI

• Creating Calculated Columns

o  Logical Functions

o  Related Function

o  Text Functions

Creating Measures

• Aggregate Functions

SUM, DIVIDE, AVERAGE

COUNT, COUNTA, DISTINCTCOUNT

• Iterator X Functions

SUMX

RANKX

AVERAGEX

• Calculate Functions with Modifiers

ALL

FILTER

REMOVE FILTERS

MODULE 7: ADVANCED DATA ANALYSIS EXPRESSIONS WITH POWER BI

Laboratory using Microsoft Power BI

• Using Variables and Data Types
• Date Functions
• Time Intelligence Functions

o  DATESYTD

o  DATEADD

o  DATESINPERIOD

MODULE 8: VISUALIZE AND INTERPRET DATA USING POWER BI

Data Visualization Principles

• Essential Visuals
• Story Telling with Data
• Common Errors
• Dashboard Design Principles

Laboratory using Microsoft Power BI

• Create Dynamic Dashboard using Power BI

o  Power BI Report View

o  Using the ff. Visuals to Create Dashboard

• Matrix
• Bar and Column Chart
• Line Chart
• Area Chart
• Card. KPI’s and Guage Charts
• Filled Map Chart
• Tree Map Chart
• AI Visuals

o  Using Filters and Slicers

o  Edit Interactions

o  Creating Page Tooltips

o  Publishing the Dashboard in Power BI Service

Course Objectives:

At the end of the course, learners will be able to:

1.     Define and identify the role and importance of data analytics in the organization.

2.     Identify and discuss the key steps in the Data Analytics process.

3.     Apply appropriate data analytics tools to analyze, interpret data, and prepare reports that will be used by the organization and management in decision-making and business operations.

System Requirements HARDWARE REQUIREMENT

• at least 500 GB HDD
• at least 8GB RAM
• at least Core i3 Processor

NOTE: No Macintosh Laptop SOFTWARE REQUIREMENT

• Windows 10 Operating System
• Microsoft Excel 2019 / Office 365
• Microsoft Power BI Desktop
• Microsoft PowerPoint, PDF Reader software (Adobe Reader)
• NOTE: No Microsoft Office/ Excel Home Edition and Web App Edition

Target Participants

This course is intended for employees who are interested in learning the basics of data analytics to enhance their decision-making abilities. Participants might include analysts, managers, or any staff member looking to understand data analytics principles and apply them in their daily work.