MS Excel Project on Netflix Movies & TV Shows | Data Analysis using Excel | Mamta Mukherjee

Описание: In this video, Mamta Mukherjee Ivy Pro students will be doing data analysis using excel on Netflix movies and Tv shows. Using various functions in excel she will analyze and get the insights on following objectives,

1. Analyse Movies and TV Shows on Netflix.
2. Distribution by type.
3. Number of movies and tv shows released per year by Netflix.
4. Analyse ratings of Netflix movies and shows.
5. Pick the top 5 actors in Netflix movies and shows.
6. Top 5 countries by viewership.
7. Top 10 viewed genres.
8. Top 10 directors on Netflix.

Dataset: https://drive.google.com/file/d/1I4Z6...

Chapters:
0:00 Intro
0:13 Student Intro and About the Project
1:01 Contents
1:08 Understanding the data set using Excel
3:15 Objective
3:50 lookup function and conditional formatting in excel
6:25 Answering business questions using pivot table
11:08 Creating Excel dashboard
13:53 findings from the pivot table and dashboard.

#netflix #msexcel #exceltricksandtips #exceltricks #exceltips #dataanalyst

❓Interested in a Data Science or Data Engineering career? Check out the Ivy Pro School’s top ranked Nascomm, Govt. of India and IBM accredited Data Science and Data Engineering courses: https://ivyproschool.com/

❓Why should you learn Data Science today?    • Future Of Analytics & Data Science | Learn...  

❓Are you a Fresher? Watch this video to know the Data Science Journey for Freshers:    • Data Science Journey for Freshers | Data S...  

✅Don’t forget to Subscribe to Ivy Pro School’s YouTube Channel:    / @ivyproschool  

✅Learn from Ivy Pro School’s Data Science and Data Engineering Students’ Success Stories :    • Student Success Story  

Liked the video? Check out below more playlists on Data Science and Data Engineering learning tutorial, alumni interview experiences, live data science case studies,etc:

⏩Students Share Interview Experiences-    • Data Science Interview Experience and Plac...  
⏩Data Cleaning using excel-    • Data Cleaning using Excel  
⏩SQL Interview questions solved in Hindi -    • Sql Interview Questions solved in Hindi  
⏩PowerBI Tutorials -    • Power BI Tutorial  
⏩Industry case studies and projects by students -    • Industry Case Studies & Projects by Students  
⏩Data Science for Beginners -    • Data Science for Beginners  
⏩Excel VBA tutorial -    • Excel VBA Tutorial  
⏩Excel Tutorials by Eeshani Agrawal -    • Excel for Beginners  
⏩Tableau Tutorials by Eeshani Agrawal -    • Tableau Tutorial by Eeshani Agrawal  

For more updates on courses and tips don’t forget to follow us on:
Instagram:   / ivyproschool  
LinkedIn:   / ivy-professional-school  
Facebook:   / ivyproschool  
Twitter:   / ivyproschool  
Telegram: https://t.me/learndswithexperts

Want to take a Data Science Course with Ivy Professional School - visit us at https://ivyproschool.com You can call us at +91-7676882222 or mail to [email protected].

#ivyproschool #datawithivypro #dataanalytics #analytics