rb_services
TRANSCRIPT
contact: Rupam B mobile: +91 8861858800 email: [email protected]
IService Catalogue
T
CConsultant Business Analytics
TrainerIT & Soft Skills
SoftSkills
IT
BIImplementation
ProjectSupport Services
Rupam Babout
Note: Hyperlinked Presentation! Please click on appropriate picture, text or shape to proceed
New
contact: Rupam B mobile: +91 8861858800 email: [email protected]
know who… Rupam B
most recent:
Successfully conducted migration training project for 800 users including CFOs, Directors, and VPs, on Office 365, for Majid-Al-Futtaim (Dubai)
A technophile, Microsoft Certified Professional, having
10+ Yrs. Exp. with Training Facilitation & Data Analytics
contact: Rupam B mobile: +91 8861858800 email: [email protected]
Consultation : IT Automation Projects
Business Requirement Analysis
BI Implementation & Predictive Analytics
Analyzing data; designing Dashboards / Scorecards
Scope Analysis – Effective Change Management
Mentoring MIS and Reporting team members
Use Cases : Incident-Problem-Change Management
And More …
Services Offered
contact: Rupam B mobile: +91 8861858800 email: [email protected]
SoftSkills
IT
Advanced Microsoft Excel
Microsoft Excel – Self Service BI
Office 365 and Power BI
Excel – VBA Programming
Top 5
Data Analytics & Visualization
Top 5
Effective Presentations
Problem Solving and Decision Making
Corporate Survival Skills
Effective Business Communications
Critical Thinking Skills
contact: Rupam B mobile: +91 8861858800 email: [email protected]
EXCELMICROSOFTAdvancedimplementing smart techniques – program highlights … [2 Days ]
Excel Advancements – some amazing features incorporated in last few years
Advanced Excel Functions – SUMIFS, SUMPRODUCT, DSUM and related functions
Using Lookup & reverse Lookup techniques – easy demo of VLOOKUP, HLOOKUP, INDEX and MATCH
Advanced Data Sorting and Filtering techniques using data tables
Generating Pivot Tables and Charts from complex datasets, instantly
Implementing Slicers and Sparklines to build interactive dashboards
Exploring Data Validation techniques and creating dynamic lists
Using ‘What-If-Analysis’ and Data Consolidation techniques
Performing Age Analysis on ticket data using simple steps
Developing and formatting KPI Dashboards
And More …
contact: Rupam B mobile: +91 8861858800 email: [email protected]
EXCELMICROSOFT Self-Service BIimplementing smart techniques – program highlights … [2 Days ]
Appreciate the use of latest technology in Business Intelligence
Benefits of BI, understanding the architecture
Latest trends in BI – exploring Self Service capabilities
Using Microsoft Excel as Power BI – unleashing the various components
New Features of Microsoft Excel, inline with BI
Using Power Query as sophisticated and use-friendly ETL tool
Creating and managing Data Models using Power Pivot
Dynamic Data Visualization using Power View and Power Map
And More …
contact: Rupam B mobile: +91 8861858800 email: [email protected]
OFFICE 365 : program highlights … [2 Days ]
Understanding Office 365 and its components
Integration capabilities of Office 365
Exploring the online collaboration features of Lync
Working with mails, contacts and calendar in Outlook Web App (OWA)
OneDrive: Managing Data Libraries and Shared Profiles
OneNote: Personal & Business Notes, Real-time collaboration, Advanced Search Options
SharePoint: Creating Sites, Libraries and Items, Managing Tasks and Workflows
Advanced SharePoint: Publishing Excel Spreadsheets in Sites, working with Web Access Web Parts
Working with Power BI Q&A
And More …
contact: Rupam B mobile: +91 8861858800 email: [email protected]
highlights …
[2 Days ]
Understanding VBA architecture and security levels
Exploring Visual Basic Editor and Project Explorer
Comparing recorded and coded macros
Programming fundamentals: Objects, data types and variables
Functions, Operators and Conditional logic
Exploring Conditional statements and loops
Understanding Excel object model and working with various objects
Program debugging and error handling
Editing recorded macros
Developing Excel Add-Ins and macro-enabled templates
And More …
EXCEL VBA Programming
contact: Rupam B mobile: +91 8861858800 email: [email protected]
highlights …
[ 1 Day ]
Steps involved in Data Analytics
Understanding Analytics Terminology
Domains in Analytics
Data Visualization techniques
Descriptive & Predictive Analytics (Basic Concepts - HindSight, Insight, Foresight)
Guiding principles for conducting analysis
Data forecasting techniques - Using Time Series Analysis
Trend analysis with complex historical data
Understanding the Analytics Maturity Model
And More …
Data Analytics
contact: Rupam B mobile: +91 8861858800 email: [email protected]
Effective Presentations Program highlights …
Advanced Presentation Techniques
Types of Perception – how it impacts presentations
Data Visualization – Concepts
Usage of Charts (comparison, distribution, relationship, composition)
4Ps of effective presentation skills – quick tips
Building an effective impromptu presentation
Managing pre-presentation jitters and stage fright
Common Presentation mistakes
Quick tips for managing presentation anxiety
And More …
contact: Rupam B mobile: +91 8861858800 email: [email protected]
Problem Solving n Decision Making highlights …
Problem Analysis and Decision Making - Best Practices
Imposing Creativity on the Choice of Solutions
Important factors in Decision Making
Factors influencing natural decision-making
Problems with intuitive decision-making processes
Reverse Brainstorming – a different approach to problem solving
Tools and Options – Cause n Effect Analysis, RCA, SWOT, 5 Whys
Common Decision Making Tools – Flowcharts and Storyboarding
And More …
contact: Rupam B mobile: +91 8861858800 email: [email protected]
Corporate Survival Skills program highlights …
Critical Thinking and Problem Solving
Collaboration Across Networks and Leading by Influence
Agility and Adaptability
Initiative and Entrepreneurialism
Effective Oral and Written Communication
Accessing and Analyzing Information
Curiosity and Imagination
Activities : Survival scenarios – Desert, Island, Ice, Moon, etc.
And More …
contact: Rupam B mobile: +91 8861858800 email: [email protected]
Effective Business Communications highlights …
Communications planning – exploring learning styles
Communication Cycle – Steps to better communication
Speaking, Listening, Writing, and Reading Effectively
Understanding Non-Verbal Communication (body language)
7Cs of communication; barriers in communication
Effective business communication (in writing)
Managing Meetings; taking MoMs
Common Communication mistakes
Practice assertive communication techniques
And More …
contact: Rupam B mobile: +91 8861858800 email: [email protected]
Coming
Soon!
[email protected] send your feedback, suggestions, queries to:
Lateral T
hinking Sk
ills