Track
Data Science
Duration
60 hours
Skill Level
Beginner
Language
English
About this Course
Understand foundational analytics concepts and visualize data using basic tools.
Learning Mode: Learn at ALC or at Home
Detailed Course Curriculum
Hands-on module breakdown aligned with MKCL production standards and industry requirements.
- Monthly Sales Performance Dashboard
- Expense Tracker Update for Supermarket Dashboard
- Enhancing Sales Dashboard with Slicers
- Enhancing Sales Insights with Date Range Filters
- Dynamic Data Integration for Supermarket Dashboard
- Supermarket Sales Performance Dashboard
- Visualizing Product Performance
- Visualizing Supermarket Performance
- Enhancing Sales Data Visualization with 100% Stacked Bar Charts in a Supermarket
- Optimizing Sales Data Visualization
- Enhancing Clarity in Sales Data Visualization
- Visualizing Yearly Sales Trends for Three Products Using Excel Charts
- Comparing the Effectiveness of 2D vs. 3D Stacked Area Charts for Data Presentation
- Customizing Scatter Charts in Excel
- Visualizing Sales, Marketing, and Finance Trends with Scatter Charts
- Create and Customize Scatter Charts with Straight Lines
- Excel Data Visualization Assignment
- Creating a Combo Chart in Excel
- Sales and Performance Data for Ten Individuals
- Creating and Enhancing Dynamic Scatter Charts in Excel
- Creating and Enhancing Excel Charts
- Visualizing the 80-20 Rule with Excel’s Pareto Chart
- Create and Customize Histograms for Sales Data Analysis
- Create and Customize Geographical Data Visualizations
- 3D Geographical Mapping in Excel
- Interactive Data Point Identification in Excel Scatter Charts
- Integrating Dynamic Target Lines in Excel Charts
- Create and Customize Data Visualizations for Clarity and Insight
- Visualizing Year-Over-Year Changes with Trend Arrows in Excel Charts
- Create and Customize Milestone Charts for Project Tracking
- Create and Customize Dynamic Pareto Charts
- Creating and Understanding Dynamic Pareto Charts in Excel
- Creating and Understanding Dynamic Charts in Excel
- Create and Customize a Speedometer Chart for Performance Tracking
- Creating a Speedometer Chart
- Creating and Analysing Excel Charts
- Constructing and Customizing a Basic Bullet Chart in Excel
- Creating Advanced Charts for Better Visualization
- Dynamic Sales Dashboard
- Advanced Conditional Formatting in Excel Dashboards
- Advanced Dashboard Construction and Data Visualization in Excel
- Advanced Dashboard Customization and Visualization
- Creating an Interactive Expense Tracking Dashboard
- Advanced Dashboard Construction and Optimization in Excel
- Building and Customizing an Advanced Dashboard
- Explore and Learn Advanced Data Visualization and Dashboard Enhancements in Excel
- Creating and Customizing an Expense Tracking Dashboard
- Sales & Profit Management Dashboard in Excel
- Creating a Sales Dashboard with Advanced Visualizations in Excel
- Creating an Interactive Sales Dashboard in Excel with Slicers and Timelines
- TechMart Sales Analysis Dashboard
- Regional Sales Performance Dashboard
- Budget Monitoring Dashboard for Monthly Expenses
- Enhancing Sales Performance with Pivot Tables and Slicers
- Top Products and Employees Monthly Sales Analysis
- Interactive Financial Performance Dashboard for ABC Finance Ltd
- Interactive Sales Performance Dashboard for XYZ Retailers
- Quarterly Sales Performance Dashboard for an Indian Retail Store
- Automating Weekly Sales Report with Excel Macros
- Monthly Delivery Performance Dashboard for Logistics Management
- Monthly Sales Performance Dashboard for Top FMCG Products
- Optimizing SuperMart’s Inventory and Sales Strategies Using Power BI
- Quarterly Sales Performance Analysis of Product Categories
- Regional Sales Performance Analysis for Last Month using Power BI
- Analysing Textile Production Volumes Last Quarter Report
- Enhancing Sales and Customer Experience with BI at Retail India Pvt Ltd
- Introduction to Power BI Desktop & Power Query
- Creating Engaging Reports in Power BI
- Power Query - Streamline Data Import
- Text Manipulation in Excel Using Power Query
- Text Transformation in Power BI
- Advanced Text Splitting in Power BI
- Date Functions in Power Query
- Basic Date Calculations in Power Query
- Advanced Date Calculations in Power Query
- Date Functions, Prefixes and Suffixes, Basic Arithmetic Operations in Power Query
- Advanced Operations, Modulo, and Percentage Calculations in Power Query
- Math Functions, Rounding, and Number Types in Power Query
- Trigonometric Functions and Conditional Columns in Power Query
- Custom Column Creation and Conditional Logic in Power Query
- Conditional Formatting and Columns in Power Query
- Conditional Columns and Comparisons in Power Query and Excel
- Using Excel Flash Fill and Functions
- Formatting with Flash Fill
- Merging and Splitting Text Columns
- Merging and Splitting Text Columns in Power Query
- Merging Data with Power Query
- Using VLOOKUP in Excel and Merging Queries in Power BI
- VLOOKUP Challenges and Solutions
- VLOOKUP Advanced Techniques
- Merging Datasets in Power BI
- Efficient Column Management in Power Query
- Appending Multiple Excel Sources and Data Sets
- Merging and Refreshing Data in Power BI
- Data Cleaning and Appending in Power BI
- Streamline Tables
- Sales Trends Analysis
- ales Distribution Analysis by Region
- Advanced Visualizations and Clustered Column Charts in Power BI
- Advanced Chart Techniques in Power BI
- Advanced Visualization Techniques in Power BI
- Enhancing Chart Backgrounds and Formatting Lines and Markers
- Creating and Enhancing Combo Charts
- Working with Power BI Charts and Slicers
- Creating and Formatting Charts in Power BI
- Customizing Pie Chart Data Labels and Modifying Text in Visuals
- Advanced Map Visualizations in Power BI
- Working with Maps and Dynamic Chart Titles in Power BI
- Implementing Dynamic Titles and Single Selections in Power BI
- Advanced Visualization Techniques in Power BI
- Creating and Optimizing Map Visuals in Power BI
- Enhancing Power BI Reports with Visual Borders and Tooltips
- Customizing Canvas in Power BI
- Customizing Filters and Themes in Power BI
- Enhancing Power BI Reports with Custom Themes
- Applying and Customizing Themes in Power BI
- Creating Stacked Area Charts
- Creating Different Chart Types
- Creating Scatter and Waterfall Charts
- Creating Gauge Charts and Scrollers
- Creating and Understanding Sankey Charts in Power BI
- Creating and Customizing Infographic Visualizations and Word Clouds in Power BI
- Utilizing Matrices and Tables in Power BI
- Designing Tables and Generating Sunburst Charts in Power BI
- Utilizing Various Visuals in Power BI
- Applying Filters in Power BI
- Implementing and Utilizing Filters in Power BI
- Implementing and Customizing Text Filters in Power BI
- Using Advanced Text Filters and Top N Text Filters in Power BI
- Using Date Filters in Power BI
- Advanced and Top N Date Filters in Power BI
- Applying Number Filters, Value Filters, and Relative Date Filtering in Power BI
- Customizing Filters and Using Slicers in Power BI
- Managing and Customizing Slicer Selections in Power BI
- Designing Order Date Slicers, Utilizing Hierarchy in Slicers, and Customizing Date Formats in Power BI
- Utilizing Relative Date Slicers in Power BI
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 Basics of Data Analytics and Data Visualisation?
Join our upcoming batch at ZICA Kalyani center with certified instructors.
