What you'll learn

Art of Data Analysis on the Real world data sets
Data manipulation techniques and reporting to business users
Ways and techniques to find the business insights from the raw data
Data Visualisazations , Pivot , Vlookup etc
Complex formulae , sorting and filtering with short cut keys
Acquisition Analytics to find out which customer segment is the profitable
Report making techniques for business users.
Investment Case Study to identify the top3 countries and investment type to help the Asset Management Company to understand the global trends

Requirements

Students must be passionate about data

Description

1. Learn basic and advanced functionalities of Excel.

2. Learn how to do data manipulation and analysis to solve real world business problems using case studies.

3. Start using pivot tables and Vlookup like a pro.

4. Start using built-in formulae in excel for the data analysis.

5. Learn how to find interesting trends in the real world datasets.


Real World Case Studies include :

Acquisition Analytics on the Telemarketing datasets : Find out which customers are most likely to buy future bank products using tele channel.

Investment Case Studies: To identify the top3 countries and investment type to help the Asset Management Company to understand the global trends

Data Analysis on Ireland Loan Datasets : Find out which customers are good or bad and who are likely to repay the loan.


Who this course is for:

Beginners who are looking to enhance their data science skills
Those who want to switch the career in data science

Homepage: https://www.udemy.com/course/excel-for-analytics/

Download Part 01

Download Part 02

Download Part 03

Click Here for More Tutorial