Skip to main content

Short Term Certificate Program on Business Analytics [GTU Approved]

 Event Report for the Short Term Certificate Program on Business Analytics [GTU Approved] organized in the Academic Year 2021-22


1.      Event Title- Short Term Certificate Program on Business Analytics [GTU Approved]

2.      Date of Event- 20/11/2021 to 13/12/2021

3.      Type of Event

a.        Curricular

b.      Co-curricular

4.      Venue- Online Mode via Google meet

a.       Organizer – Narmada College of Management, Bharuch

b.      Host- Narmada College of Management, Bharuch

5.      Event Coordinator – Dr. Trupti Almoula, Mr. Kanu Raval, Ms. Nisha Dubey

6.      Event Participant

a.       Total 38

b.      11 Students (NCM and Others)

c.       27 Industry Professionals (from 6 Industries)

7.      Expert Speaker / Facilitator (if applicable )

a.       Name- Dr. Sameer Rohadia

b.      Organization – Freelance

c.       Designation - Data Analyst and IT Trainer

8.      Proceedings of the event (day wise)

MS Excel

1.      Day 1 (20/11/2021)

·         Introduction to MS Excel, 

·         Pivot Tables,

2.      Day 2 (21/11/2021)

·         Pivot Tables,

·         Slicers,

·         Pivot Charts,

·         Macros,

3.      Day 3 (27-11-2021)

·         Lookup Functions,

·         Data Validation,

4.      Day 4 (28-11-2021) and Day 5 (04-12-21)

·         Logical Functions,

·         What-If Analysis,

·         Hyperlinks, 

·         Group & Ungroup data

Microsoft Power BI

5.      Day 6 (05-12-21)

·         Introduction to Data Visualization, 

·         What is MS Power BI?,   

·         Connecting Data, 

·         Data cleaning & data transformation

6.      Day 7 (12/12/2021)

·         Data visualization,

·         Hierarchy & Interactions,  

·         Formatting visuals,   

·         Slicers & Filters,

7.      Day 8 (13/12/2021)

·         Calculated Columns, 

·         Measures

9.      Take-home/learning for the students-

a.       Theoretical as well as practical knowledge about Advanced Excel and Microsoft Power BI.

The participants were truly satisfied with the session but suggested that they would like to explore more with their dataset. Response from the participants was quite encouraging.

 

11.   


Comments

Post a Comment

Popular posts from this blog

Two day visit of MBA-I students at Adani Port, Mundra

A REPORT on Two day visit of   MBA-I students at Adani Port, Mundra Date of Visit: 29 th -30 th September, 2019 68 students of MBA-I, along with 4 faculty members visited Adani Port at Mundra on 29 th and 30 th September, 2019, as part of Industrial visit organized by the College. Adani Ports and Special Economic Zone Limited (APSEZ) is promoted by Adani Group, one of India’s largest business conglomerates. The US$11 bn Group has interests across resources -coal mining and trading; logistics- ports and logistics, shipping and rail; energy - renewable, thermal power generation and transmission; agro commodities and ancillary industries. Their ten strategically located ports and terminals represent 24% of the country’s port capacity, handling cargo of vast hinterland, demonstrating that when it comes to servicing core national needs, Adani Ports is prepared with scale, scope and speed. Mundra Port is a deep draft, all-weather port that is t...
2 comments
Read more

Students Participation in "All India Essay Writing Event 2016"

Our students Ms. Fatema Ibrahim Surti and Ms. Sashista A. Chauhan participated in  "All India Essay Writing Event 2016" organised by Shri Ram Chandra Mission, United Nation Information Center for India and Bhutan, and The Heartfulness Institute.
1 comment
Read more

Group Discussion Report - Flair 2019

Date : 3rd October, 2019 Venue : NCM conference room Group Discussion activity   was organized by Narmada College of Management, Bharuch on 3rd October, 2019 at NCM Conference Room, Bharuch. The major objective of the Group Discussion among the students, to observe their personality and skills, ability to discuss on the given subject and to guide them on how to take part in Group Discussions. The facilitator of this activity was Prof. Iramada Khan and coordinate by Raisha Khan.     The topic for the group discussion were: 1. English is an official language in India. 2. Are space research project waste of money. list of participants who had taken part in the competition were: Sr. No Name of the participants 1. Chauhan Priyanshi 2. Dave Harvi 3. Dudkiya Priya 4. Chauhan Riya 5. Mistry Hemangini 6. ...
Post a Comment
Read more