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.

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

Skillshare.Excel.for.Data.Analytics.for.the.Absolute.Beginners.Taught.by.Data.Scientist.PM-ViGOROUS
Data Analysis on Ireland Loan Datasets :

1.Find out which customers are good or bad and who are likely to repay the loan.

2. Churn out the excel reports for the end business users with only relevant information and password protected. Printing should be in as less pages as possible.

3.Download the loan files and follow the lectures to practice along-with it.

Acquisition Analytics on the Telemarketing datasets

The datasets contains information of abount 45000 customers and their historical reponse to products offered by bank.The objective is the find those segments who are likely to purchase bank products in future.

This is the most common analytics across the industries . The usual purpose is the increase the sales of the products and reduce the cost of marketing . Instead of calling everyone and trying to sales , the tele-marketing channels will call only few customers and make as much sale.

1.Dowload the bank marketing files.

2. Remove the unwanted columns if needed.

3.Do the formatting.

4.Calculate the % response rate based on certain demography : Job , Education , Marital Status , Age band.

5. Use the Pivot tables to re-calculate as per the item 4 above.

6. Do the data analysis and visualizations to find the interesting trends and insights.
| | | |
| | Release date: 2020-07-30 | |
| | URL: www.skillshare.com | |
| | Language: English | |
| | Type: Bookware | |
| | Format: MP4 | |
| | Source: Skillshare | |
| | | |
| | | |
| | ex.FiLES: Yes | |
| | | |
| | | |
| | | |: +-----------------------------------------------------------------------+: Group News:

Looking for 10gbit

|Greets |
|====== |
| CONSORTiUM APoLLo |

| x art=caciq x |
Thanks by

Related Downloads :

{related-news}