Basics of Data Analytics and Data Visualisation

• Develop proficiency in creating and enhancing various types of dashboards, including sales performance, expense tracking, and supermarket sales.
• Utilize advanced Excel features such as slicers, date range filters, and dynamic data integration to create interactive and insightful dashboards.
• Gain expertise in creating and customizing 2D and 3D charts in Excel for better data presentation and visualization.
• Learn to optimize sales data visualization using advanced chart types like 100% stacked bar charts and dynamic scatter charts.
• Understand and create multidimensional charts such as Pareto charts, histograms, and geographical visualizations.
• Perform trend analysis using charts and integrate dynamic target lines, milestone charts, and year-over-year comparisons.
• Learn to automate repetitive tasks in Excel using VBA macros to enhance efficiency in dashboard creation and data analysis.
• Create automated sales performance and delivery performance dashboards.
• Understand the fundamentals of Business Intelligence and its application in optimizing sales, inventory management, and customer experience.
• Gain hands-on experience with Power BI to create engaging reports and perform advanced data analysis.
• Develop skills in using Power Query for data transformation, including text manipulation, date calculations, and conditional columns.
• Merge datasets, clean data, and perform efficient column management in Power BI.
• Master the creation of advanced visualizations in Power BI, including map visuals, Sankey charts, and sunburst charts.
• Customize and enhance Power BI reports with themes, dynamic titles, filters, and slicers.

• Create comprehensive and interactive Excel dashboards for sales performance, expense tracking, and supermarket analytics.
• Utilize advanced Excel features such as slicers, filters, and dynamic data integration to enhance dashboard functionality.
• Create and customize 2D and 3D charts to effectively visualize data trends and comparisons.
• Use advanced chart types like Pareto charts, histograms, and scatter charts to provide deeper insights into data.
• Leverage Power BI to create dynamic and visually appealing reports.
• Utilize Power Query for efficient data transformation and management, including merging datasets, cleaning data, and applying conditional logic.
• Write and implement VBA macros to automate repetitive tasks and streamline data analysis processes in Excel.
• Develop automated dashboards for sales and delivery performance monitoring.
• Apply advanced visualization techniques to present data clearly and effectively.
• Use BI tools to analyze and interpret complex data sets, providing actionable insights for business decisions.
• Customize Power BI reports with themes, dynamic titles, and interactive filters to enhance user experience.
• Create advanced visualizations such as Sankey charts, map visuals, and sunburst charts to convey information more effectively.

The academic approach of the course focuses on ‘work-centric’ education. With this hands-on approach, derive knowledge from and while working to make it more wholesome, delightful and useful. The ultimate objective is to empower learners to also engage in socially useful and productive work. It aims at bringing learners closer to their rewarding careers as well as to the development of the community.

• 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!