Capitalising data for decision making
Businesses today are sitting on piles of data but unfortunately are able to capitalise on only a small portion of it. It is clear that data is the new currency and whoever is able to leverage it, they are the gainers. Data contributes to decision-making at the highest level. All successful strategic and financial decisions depend on how well the managers are able to assess the health of the business and how intelligently they are able to plan for future.
To harness the power of data, it is important to recognise the pattern in the data. Data cleaning, checking internal consistency of data, visualisation and summarisation are some of the critical steps necessary to monitor the current status of business.
This program has been conceptualised as the first step in understanding how best to extract information out of complex set of observations. The tool of choice is MS Excel which is available everywhere. After completing the program participants will be able to leverage the higher level MS Excel functionalities, tools and techniques to provide data-driven strategic support to the top level.
Who should attend?
This program is ideally suited for all power users of data - middle and senior-level MIS users, sales professionals, finance executives, HR executives, operations team, business analysts, research executives and anyone who handles data at any level.
How will you benefit?
- Become a power user of spreadsheet (MS excel ) to work successfully on multiple spreadsheets and check internal consistency of data
- Perform visual and descriptive analytics with data for managerial presentation and business data decisions
- Provide data-driven support to internal and external clients
Each session will be interactive in nature with a focus on problem solving, experience sharing and real-world case analysis. On Day 3 a complex dataset will be presented to extract and present information.
Day 1 (10.00am-5.00pm)
- Basic excel functions
- Descriptive analytics
- Statistical functions
Day 2 (10.00am-5.00pm)
- Working with multiple spreadsheets
- Data consistency checking
- Pivot tables, pivot charts
- Complex excel functions and excel formulae
At the end of the Program, you will be able to:
- Work successfully on multiple spreadsheets
- Check internal consistency of data
- Understand what are the possible loopholes for errors
- Perform visual and descriptive analytics
- Prepare data for further analysis
- Prepare MIS reports
Dr. Srabashi Basu is Program Director-Analytics at Bridge School of Management. She is Ph.D., MA (Statistics - The Pennsylvania State University). M. Sc. (Statistics - The University of Calcutta). Srabashi has always been interested in application of statistics and analytics in business related matters. After Indian Statistical Institute she took up a managerial position in Skytech, a niche company in travel analytics.Dr. Srabashi Basu is a Ph.D from the Pennsylvania State University. She has been in academia, training and corporate for over two decades. She has headed analytics teams and has worked as consultant to various organisations.
Next Batch start date:
Please write to firstname.lastname@example.org
Enquire at 1800-102-4500
Customised timings as per Program needs
1st Floor, Tower B Infinity Towers, DLF Cyber City
Gurgaon – 122001
Contact - 1800-102-4500
E-mail - Career.Advisor@bridgesom.com