Data Management with Excel and Tableau

When:

August 12, 2017 Saturday 8:30AM - 5:00 PM

 

Where:

 Innoworld, 940 Stewart Dr, Sunnyvale, CA 94085

Last date for On-line Registration:  
Early Bird - 7/30/2017
Regular - 8/6/2017
 

Description:

Data Management with Excel and Tableau(Intermediate)

 

Let’s face it – Microsoft Excel is the choice of many a project manager, and its usage far overruns all others, including MS Project. It is the only tool that is acceptable to Finance and other peripheral functions.
Being a part of “Office”, we tend to be self-taught, and consequently, end up frustrated.

So why not learn about some useful tips and tricks through common scenarios?

The material for this class is derived from the common yet significant “use cases” and mistakes that instructors have observed in their careers.

Who Should Attend This Workshop:

Those who are self-taught; those who have been frustrated by MS Excel beyond colors and type-faces in “Formatting”
Those who wish to understand more about how MS Excel handles data
Those who are unfamiliar with reporting project status and risks using traffic lights and weighted score cards.
Those who wish to know more about using Excel as a formidable tool in Engineering Operations
Those who are unfamiliar with the details regarding the interface of Excel and MS Project
Those who wish to know about the next step - Tableau
 

Please refer to the self eval sheet before signing up. 

What You Will Learn

Importing and exporting data
Formatting data, and extracting “parts of the data”
Lookups
Conditional Arithmetic
Duplicates
Pivot Tables and Pivot Charts
Resources: Details and Types
Error Checking and Boundary Conditions
Data Visualization
Introduction to Tableau
And much more…
 

About the Instructor:

 

SutanuGhosh Sutanu Ghosh, PMP, Certified ScrumMaster is a regular speaker at the Tools and Techniques Forum. He has served as a PMO as well as a hands-on PM on both SW and HW projects at many distinguished institutions in the Valley, including Bay Networks, Symbol Tech, Savi (Lockheed Martin) and NetApp.  After graduating from Jadavpur University, Calcutta, 1986, he worked for Tata Motors, which ignited his passion for “Lean.”  He has a MS from Arizona State in Mechanical Engineering (CAD), and has published in ASME on CAX tools.

 

 

 

Project Management Education Hours: 

Earn 7 PDUs (Technical)

 

Meeting Leader: Sagar Amancherla

 

Program Agenda:

Please note the door will be locked at 8:25 AM, so plan to arrive early.

08:30 AM - Sign In and Networking

09:00 AM - Workshop Begins

12:00 PM - Lunch Break

12:45 PM - Workshop Resumes

5:00 PM – Adjourn

Food:

Continental Breakfast, Coffee, and Lunch will be provided.

Attendees should indicate whether they want a vegetarian meal during the registration.

 

Plan Ahead Registration:

Early Bird:  PMISV member: $140     Non-PMISV member: $190

Regular:  PMISV member: $190   Non-PMISV member:  $240

At-the-Door Registration:  No walk-ins allowed. Please register for the course online in advance 

  

Cancellation Policy:

This event is a professional society meeting, held for the benefit of its members.

 

  • Cancellation before Early Bird Registration Date: Full refund
  • Cancellation between Early Bird Registration Date and Regular Registration Date: $30 cancellation fee; remaining amount refunded
  • Cancellation after Regular Registration Date and Day before workshop (by 5:00 PM Pacific): 50% refund

Click here for Refund Request