WHY DATA ANALYTICS? 

Data analysis is the compass steering operations, optimizing voyages, and curbing emissions, a critical tool enhancing safety, logistics, and decision making. By harnessing data, professionals navigate challenges, steering the industry toward a more sustainable and resilient future. 

WHO SHOULD ATTEND THIS COURSE?

• Junior Officers / Engineers
• Operational level officers and Engineers
• Senior Officers / Engineers
• Management level officers and Engineers
• Mariner and Technical superintendent and Manager

PROGRAM SYLLABUS (MS EXCEL)

SESSION 1:  (23rd March - 3 Hrs)

Working with Functions

Basic functions:(Sum + Average + Max +Min +Count)

Working with referencing 

Cell addressing/referencing methods (Absolute + relative + mixed + range ..and more) 

Logical functions

 If + IFError + And + Or +Not + Nested IFs +

Utilize Formatting features

Conditional formatting 

Assignment / Exercise 

SESSION 2: (24th March - 3 Hrs)

Database management in excel

Static/Range and Dynamic Database Concepts +Tables+ Sort + Filter

Statistical functions

(SumIf + SumIfs +AverageIf + AverageIfs + CountIf +CountIfs) 

Name manager 

Naming the range + Using the name range in formulas

Data validation

Creating and working with lists, dependent lists

Creating custom validation, handling input, and error alerts 

Cell & workbook protections

Assignment / Exercise

SESSION 3 : (30th March - 3 Hrs)

Text to Column Concepts

Text and Date/Time Calculations in Excel. 

Look Up Reference functions

 VLookup + Reverse Vlookup + Vlookup with IF + Vlookup with Indirect +Vlookup with IFError + HLookup +Index + Match + Wildcards in Vlookup 

Assignment / Exercise

SESSION 4 : (31st March - 3 Hrs)

Remove Duplicates + Import/Export Data + Flash Fill  + Concatenate +Transpose

Working with charts

Different Types, Creating Excel Charts, Pivot Charts

Formatting, Design, and Layout of the Chart

Creating, Applying, and Removing Chart Templates, Sparkline, and

Dynamic Charts

Working with Pivot Tables

Introduction & creation of pivot tables

Overview & review of the assignments given

Debriefing & how you could continue using Excel after the course.

PROGRAM SYLLABUS (Power BI)
 

SESSION 1 : (6th April - 2 Hrs)
 

1. Introduction To Power BI

• Why Power BI
• Power BI Vs Excel
• Installing Power BI Desktop
• About the Project.

2. Getting Started

• Settings
• Power BI interface
• Canvas settings

3. Connecting & Shaping Data

• Type of data connectors
• Query editor tools
• Data categories
• Defining hierarchies
• Creating a rolling calender

4. Say Hi! to DAX

• Calculated columns
• Measures Quick
• measures Basic
• Math calculations

5. Creating Relationship in model view.

• Many to Many
• One to many
• Cross filter direction

SESSION 2: ( 7th April - 2Hrs)
 

6. Building Reports

• The Power BI report view
• Inserting objects & basic charts
• Formatting options.
• Filtering options
• Managing interactions
• Adding and Linking bookmarks & buttons
• “What if” parameters
• Importing custom visuals
• Preparing reports using Canva / Power Point.

7. Managing Power BI

• Data refreshing
• Sharing reports
• Some best practices

Final Assignment

• Doubt clearing Sessions
• Report presentation

Bonus Add-On

Integrating Chat-GPT with Excel and Power BI

• The AI World
• Prompt engineering (Tips & best practices)
• Chat GPT for Excel
• Chat GPT for Power BI

PLEASE NOTE: 

Please Note :
 

8th and 10th April - Doubt clearing session (1 Hrs each)
13th April - Assignment presentation by all candidates

If interested, please email education@seaandbeyond.com or connect at +91 89288 96420.

Regards,

Sea and Beyond Team.