November 5, 2024

Day – 02 Excel pivot table

Video by Pantech eLearning via YouTube
Source

Module 1: Microsoft Excel- Data analysis with pivot table
1.Excel pivot table
2.Formatting data with pivot tables
3. Sorting, Filtering and grouping the data with pivot tables
4. Enriching Data with pivot table calculated & fields
5. visualizing data with excel pivot
6. Excel pivot table case studies
1.analyzing salary data
2.analyzing stock market data
3.analyzing tracking Daily weather conditions

Module 2: Data Visualization Tools – Tableau
1.How to install tableau and create first Visualization
2.How to use Calculated Fields and Bins in Tableau
3.How to create visualization in Tableau
4.How to use joins in Tableau
5.Full project in Tableau

Module 3: Data Visualization Tools – PowerBi
1.how to install PowerBi and create first Visualization
2.how to use power query in powerBi , create and manage relationship in powerBi
3.how to use DAX in powerBi, how to use drill down
4.how to use conditional formatting, bins, lists
5. popular visualization in power bi
6. full project in powerBi

Module 4: Python – Data Analysis
1. python basics and installation
2. python data structures for data science
3. python fundamental programming
4. data analysis – pandas
5. data analysis – NumPy
6. data analysis – matplotlib & Seaborn
7. introduction of machine learning and actions
8. credit score classification
9. stress prediction
10.covid 19 prediction based on X ray image based on deep learnihg

#pantechelearning #pantech #elearning #project

Pantech is excited to announce the launch of our Summer Internship Program for 2023!
📍📍Check the Summer Internship Program here: ‘https://www.pantechelearning.com/internship/
📌Enroll Now: https://www.pantechelearning.com/summer-internship-fb/

Pantech Provides Academic Research Custom Requirements and Lab Requirements, Links are given below,

*Research Project Enquiry*: https://forms.gle/wVWXTvDdFoxQnsXz5
*Educational Lab Equipments (Trainer Kits)*: https://forms.gle/unj6UEzsQs6d9mY29 (Not for Students)

Assured 100% job placements for students from any field.
Golden opportunity for pass-out students of 2020, 2021 & 2022. Open to all backgrounds, this course with Placement offers new learning and skill growth.
Register Now: https://www.pantechelearning.com/course-with-placement/

Click here to know more about Upcoming events & Updates: ‘https://linktr.ee/Pantechevents

Connect with Pantech E-Learning on social media for the latest offers, promos, Free Events, and much more:
► Subscribe: https://bit.ly/3lWnpmh
► Youtube: https://www.youtube.com/pantechelearning
► Facebook: https://www.facebook.com/pantechelearning
► Instagram: https://www.instagram.com/pantechelearning
► Facebook community – https://www.facebook.com/groups/ainternships/
► LinkedIn: https://www.linkedin.com/company/pantechelearning
► linkedin community – https://www.linkedin.com/groups/14227052/
► Website: https://www.pantechelearning.com
► LMS Link: https://lms.pantechelearning.com/s/store
►Pantech App: https://play.google.com/store/apps/details?id=com.pantechlearning.courses

Contact Us for any further Queries:
Masterclass — 8925533488
Associative Programs — 8925533489
Support — 8925533484
Projects — 8925533485
Products / Lab Equipments — 9840974408
Events / Placement Program — 8925041666

If you have queries mail us:
training@pantechelearning.com

Happy Learning!😃

Go to Source