Track
Data Science
Duration
30 hours
Skill Level
Advanced
Language
English
About this Course
Gain hands-on experience with cutting-edge digital tools. Focus on enhancing productivity, automation, and data capabilities.
Learning Mode: Learn at ALC or at Home
Detailed Course Curriculum
Hands-on module breakdown aligned with MKCL production standards and industry requirements.
- Discover Google Sheets Features
- Navigate Google Sheets with Ease
- Create and Save Your First Spreadsheet
- Spreadsheet Formatting
- Advanced Spreadsheet Formatting
- Collaborate and Share Spreadsheets Efficiently
- Basic Formula and Functions
- Introduction to Absolute and Mixed References
- Common Math Functions and Operations
- COUNTIF, SUMIF, and SUMIFS Functions
- Text Manipulation Functions
- LEFT, RIGHT, MID, and FIND Functions
- Date and Time Functions in Google Sheets
- NETWORKDAYS and TEXT Functions
- IF Statements, and Nested IFs
- VLOOKUP and HLOOKUP Functions
- Sort and Filter Data for Enhanced Insights
- Data Validation and Data Integrity
- Date and Text Validation
- Analyze Data Efficiently with PivotTables
- Date Data Grouping, Extracting and Filtering
- Visualize Data with Charts and Graphs
- Creating Stacked Columns, Combo Charts, and Line Graphs
- Conduct Advanced Data Analysis Techniques
- Enhance Teamwork with Comments and Tools
- Track Changes with Revision History
- Automate with Google Apps Script Basics
- Create Custom Functions and Macros
- Create Macros to Automate Task
- Automate Routine Tasks in Google Sheets
- Setting Triggers for Spreadsheet Opening
- Apply Advanced Cell Formatting Techniques
- Implement Conditional Formatting for Insights
- Create Custom Conditional Formats for Data
- Use Templates for Consistent Data Reports
- Master Advanced Formatting for Professional Reports
- Import Data Seamlessly from Various Sources
- Export Data in Multiple Formats for Use
- Query Data within Google Sheets for Insights
- Connect Sheets with Apps for Streamlined Workflow
- Clean and Transform Data for Analysis
- Create Interactive Charts for Dynamic Insights
- Utilize Sparklines for Compact Data Visualization
- Implement GeoMapping for Geographic Data Analysis
- Customize Column Charts
- Chart Customization for Enhanced Data Storytelling
- Analyze Trends with Advanced Visualization
- Automate Reports for Up-to-Date Dashboards
- Integrate Sheets with Data Pipelines for Efficiency
- Optimizing Google Sheets to Overcome Limitations
- Function Optimization and Execution Control
- Apply Advanced Tips for Efficient Data Analysis
- Recap: Transform Data Entry into Actionable Insights
- Why Choose Looker Studio?
- Setting Up Looker Studio
- Exploring the Interface
- Creating Your First Visualization
- Saving the Look in Looker
- Introduction to Filtering
- Filtering in Looker Using Measures
- Overview of Visualization in Looker
- Creating Bar and Column Charts
- Adding Dimensions, Pivoting, and Grouping
- Grid Layout, Pivoting, and Spacing
- Designing Line Charts
- Pie Charts for Data Distribution
- Introduction to Scatterplots
- Advanced Scatterplot - Trend Lines, Reference Lines, and Saving
- Utilizing GeoMaps
- GeoMap Scale, Position, Zoom, and Saving
- Single-Value Visualization
- Introduction to Customs in Looker
- Creation and Interpretation of Table Calculations
- Permissions, Limitations, and Key Distinctions
- Custom Dimension Creation
- Binning as a Custom Dimension
- Grouping Data with Custom Dimensions
- Developing Custom Measures
- Look View Mode in Looker
- Data and Filters in View Mode
- Different Options in Look View Mode
- Customizing Dashboard Layout and Design
- Filter Adding to the Dashboard
- Optimizing Dashboards with Filters, Linked Filters, and Tile Management
- Setting Up Tiles and Filters Dashboard
- Creating and Managing Folders
- Downloading the Data from Looker
- Sharing Looks and Sending Mails from Looker
- Sharing Dashboards and Sending Mails from Looker
- Creating Boards in Looker
- Overview of R
- Introduction to Data Types in R
- Understanding Data Type Casting
- Introduction to Variables in R
- Variable Methods and Naming Conflicts
- Operators in R
- Reading Data Files in R
- The Reader Package, CSV Files, and read_lines Function
- Data Import with read_table and read_CSV
- Writing Data inside R
- Introduction to Decision Making
- Nested If-Else-If Statement, Switch Statement
- Introduction to Loops
- Nested For Loops, Break Statement & Next Statement
- Repeat Loops & While Loops
- Introduction to String Functions
- Standardizing Text Case in R
- Creating Date Objects in R
- Formatting Dates & Handling Time Data
- Calculating Date and Time Differences
- Math Functions in R
- Introduction to Arrays & Multidimensional Structures
- Accessing Elements, Rows & Columns
- Introduction to Lists in R
- Manipulating Lists
- Introduction to Data Frames in R
- Multiple Activities using Data Frames in R
- Introduction to Vectors in R
- Manipulation of Vectors and Factors
- Introduction to Matrices in R
- Accessing Matrix Elements & Modifying Matrices
- Combining Matrices & Creating Special Matrices
- Introduction to Charts and Graphs, Bar Plots, Histograms
- Box Plots, Multiple Box Plots, Scatter Plots, Heat Maps & 3D Graphs
- Scatter Plots
- 3D Scatter Plots, Box Plots, Colored Box Plots & Multiple Box Plots in One Plot
- Bar Plots & Labeled Bar Plots
- Grouped Bar Plots, Stacked Bar Plots & Histograms
- Conducting T-tests
- Working with Excel Files in R
- Managing CSV Files in R
- Introduction to Advanced Data Import Techniques
- Reading XML Files & Reading Data from Websites
- Understand ChatGPT-4’s Capabilities
- Understand ChatGPT-4’s Limitations
- Set Up ChatGPT-4 for Efficient Data Analytics
- Create Datasets Using Diverse Sources and Techniques
- Clean Data by Identifying and Resolving Irregularities
- Classify Data Types and Structures for Analytics
- Learn Basic Data Transformation Techniques
- Execute Simple Data Queries Using ChatGPT-4
- Data Analysis and Exploration with ChatGPT
- Cleaning, Analysis, and Visualization with ChatGPT
- Analyze Market Trends with ChatGPT-4
- Perform Real-time Data Processing and Analysis
- Apply Predictive Analytics in Business Decision-Making
- Utilize ChatGPT-4 for Understanding Financial Reports
- Missing Values and Outliers
- Normalize and Standardize Data for Consistency
- Engineer Features to Enhance Data Analysis
- Preprocess Text Data for Effective Analysis
- Understanding Date and Time Data with ChatGPT
- Extracting, Analyzing, and Enhancing Date of Birth Data
- Prepare Data for In-Depth Analysis
- Apply Effective Data Visualization Principles
- Create Basic Charts and Graphs Using ChatGPT-4
- Form Histograms & Bar Charts
- Generate Advanced Visualizations: Heatmaps and Boxplots
- Build Interactive Dashboards and Compelling Data Stories
- Real-Time Dashboards with ChatGPT
- Apply Best Practices in Data Presentation
- Perform Exploratory Data Analysis with ChatGPT-4
- Analyze Data Statistically and Summarize Metrics
- Introduction, Anomalies, Patterns, and ChatGPT Exploration
- Spotlight on Anomaly Detection and Box Plot Analysis
- Analyze Correlation and Causation in Data Sets
- Insights on Correlation and Causation
- Extract Inferences from Exploratory Data Analysis
- Understanding Employee Attrition and Strategies for Retention
- Perform Regression Analysis with ChatGPT-4
- Apply Classification Techniques in Data Analytics
- Conduct Time Series Analysis and Forecasting
- Implement Clustering
- Conduct Sentiment Analysis and Study Consumer Behavior
- Generate Custom Code for Data Analytics with ChatGPT-4
- Seamlessly Integrate ChatGPT-4 with Analytical Tools
- Master Advanced Data Querying and Retrieval with ChatGPT-4
Eligibility Criteria
• Basic knowledge of computers and keen desire to build skills in this field.
• Open to students, job seekers, and working professionals.
• Open to students, job seekers, and working professionals.
Official Certification
• Official MKCL KLiC Certificate upon successful completion of the course and evaluations.
Work-Centric Learning Approach
• Step 1: Learners are given an overview of the course and its connection to life and work
• Step 2: Learners are exposed to the specific tool(s) used in the course through the various real-life applications of the tool(s).
• Step 3: Learners are acquainted with the careers and the hierarchy of roles they can perform at workplaces after attaining increasing levels of mastery over the tool(s).
• Step 4: Learners are acquainted with the architecture of the tool or tool map so as to appreciate various parts of the tool, their functions, utility and inter-relations.
• Step 5: Learners are exposed to simple application development methodology by using the tool at the beginner’s level.
• Step 6: Learners perform the differential skills related to the use of the tool to improve the given ready-made industry-standard outputs.
• Step 7: Learners are engaged in appreciation of real-life case studies developed by the experts.
• Step 8: Learners are encouraged to proceed from appreciation to imitation of the experts.
• Step 9: After the imitation experience, they are required to improve the expert’s outputs so that they proceed from mere imitation to emulation.
• Step 10: Emulation is taken a level further from working with differential skills towards the visualization and creation of a complete output according to the requirements provided. (Long Assignments)
• Step 11: Understanding the requirements, communicating one’s own thoughts and presenting are important skills required in facing an interview for securing a work order/job. For instilling these skills, learners are presented with various subject-specific technical as well as HR-oriented questions and encouraged to answer them.
• Step 12: Finally, they develop the integral skills involving optimal methods and best practices to produce useful outputs right from scratch, publish them in their ePortfolio and thereby proceed from emulation to self-expression, from self-expression to self-confidence and from self-confidence to self-reliance and self-esteem!
• Step 2: Learners are exposed to the specific tool(s) used in the course through the various real-life applications of the tool(s).
• Step 3: Learners are acquainted with the careers and the hierarchy of roles they can perform at workplaces after attaining increasing levels of mastery over the tool(s).
• Step 4: Learners are acquainted with the architecture of the tool or tool map so as to appreciate various parts of the tool, their functions, utility and inter-relations.
• Step 5: Learners are exposed to simple application development methodology by using the tool at the beginner’s level.
• Step 6: Learners perform the differential skills related to the use of the tool to improve the given ready-made industry-standard outputs.
• Step 7: Learners are engaged in appreciation of real-life case studies developed by the experts.
• Step 8: Learners are encouraged to proceed from appreciation to imitation of the experts.
• Step 9: After the imitation experience, they are required to improve the expert’s outputs so that they proceed from mere imitation to emulation.
• Step 10: Emulation is taken a level further from working with differential skills towards the visualization and creation of a complete output according to the requirements provided. (Long Assignments)
• Step 11: Understanding the requirements, communicating one’s own thoughts and presenting are important skills required in facing an interview for securing a work order/job. For instilling these skills, learners are presented with various subject-specific technical as well as HR-oriented questions and encouraged to answer them.
• Step 12: Finally, they develop the integral skills involving optimal methods and best practices to produce useful outputs right from scratch, publish them in their ePortfolio and thereby proceed from emulation to self-expression, from self-expression to self-confidence and from self-confidence to self-reliance and self-esteem!
Ready to start Exploring Advanced Tools and Techniques?
Join our upcoming batch at ZICA Kalyani center with certified instructors.
