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: (2nd Dec - 3 Hrs)
 

• Basic data management
  • Excel database creation + sorts + Filters
• Cell & workbook protections
• Working with formulas
  • Cell addressing/referencing methods (Absolute + relative + mixed + Naming + range ..and more)
• Assignment / Exercise related to formulas & filters.

SESSION 2 : (3rd Dec - 3 Hrs)
 

• Utilize Formatting features
  • Adjusting + Printing + Table and Conditional formatting
• Data validation
  • Creating and working with lists, dependent lists
  • Creating custom validation, handling input, and error alerts
• Assignment / Exercise

SESSION 3 : (9th Dec - 3 Hrs)
 

• Database management in excel
  • Basic and Dynamic Database Concepts
  • Subtotals and Text to Column Concepts Remove
  • Duplicates + Import/Export Data + Flash Fill + Concatenate +Transpose
• Working with Functions
  • Basic functions: (Sum + Average + Max +Min +Count)
  • Statistical functions:(SumIf + SumIfs +AverageIf + AverageIfs + CountIf +CountIfs)
  • Logical functions: If + IFError + And + Or +Not + Nested IFs + Look Up
  • Reference functions: VLookup + Reverse Vlookup + Vlookup with IF + Vlookup with Indirect +Vlookup with IFError + HLookup +Index + Match + Wildcards in Vlookup
  • Text and Date/Time Calculations in Excel.
• Assignment / Exercise

SESSION 4 : (10th Dec - 3 Hrs)
 

• 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 : (16th Dec - 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: (17th Dec - 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: 

18th and 20th Dec - Doubt clearing session (1 Hrs each) 

23rd Dec - Assignment presentation by all candidates 

If interested, please email on javeria@seaandbeyond.com or connect on +91 8097847091.

Regards,

Sea and Beyond Team.