Course Outcome and Key Takeaways
- This course offers 100% practical learning to ensure hands-on experience with real-time Data Science applications.
- Includes Master Classes with 1:1 mentorship through the Learning Management System (LMS).
- Upon completion, students receive a certificate from internationally and nationally recognized organizations.
- Ideal for profile building, preparing for higher studies, and enhancing job prospects.
- Learn from industry professionals, get career guidance, explore job opportunities, and consider international education options.
- Exceptional students can apply for higher studies and job opportunities in the Data Science field.
Course Topics
Explore a wide range of practical topics to enhance your Data Science skills
Topic 1: : Introduction to Data Analysis: Excel Basics
- Excel Layout and Navigation
- Data Entry and Formatting
- Basic Formulas and Functions
- Data Cleaning and Preparation
- Sorting and Filtering
- Pivot Tables
- What-if analysis & Analysis Tool Pak
Topic 2: Data Visualization and Dashboard with excel and Cognos
- Basic Charts and Graphs in Excel
- Advanced Visualizations
- Combining Charts and Creating Visualizations
- Cognos Analytics (Data Preparation from various sources)
- Building Dashboards
- Sharing and Collaboration
Topic 3: Making Macros & Recording Macros
- Accessing Developer Tab
- Hands on VBA
- Creating Macros
- Performing Operations
- Recording Macros using Relative Reference
- Making Macros using VBA and Processing
Topic 4: Macros Running and Deleting
- Creating Spreadsheets, Workbooks using Macros
- Fonts, Altering Text, MsgBoxes using Macros
- Handling Various Operations
- Accessing Trustcenter Settings
- Deleting Macros
- Deleting Spreadsheets
- Testing Macros
Topic 5: : Creating Pie charts and Histograms in Excel
- Creating Piecharts and Line Charts
- Creating histograms in Excel
- Creating Charts using VBA
What You Could Become
Data Scientist
Data Analyst
Data Engineer
Course Completion Certificate
The Automotive Skill Development Council of India (ASDC) awards the Course Completion Certificate upon successfully completing the Data Science Course.
