Founded by
Maharishi Mahesh Yogi

APPLY NOW 2025

Events

Report on

    Five Days Hands-on Practice on Data Analytics

Date of Event: 24/3/2025 to 28/3/2025

Organised by: Maharishi School of Engineering and Technology

(MUIT Lucknow Campus) in association with IQAC

Objective: The Maharishi School of Engineering & Technology organized five-day training on Data Analytics to provide participants with a deep understanding of statistical analysis, data visualization, SQL, and Power BI. The training aimed to bridge the gap between theoretical knowledge and real-world application by engaging students in hands-on exercises and interactive sessions.

Participating Students: B. Tech, BCA and MCA students.

Event Details: The training started with an insightful lecture by Mr. Ashutosh Hiskiel (Data Scientist & Corporate Trainer), which focused on building a strong theoretical foundation in statistical analysis and data visualization techniques. Topics covered included basic statistical measures such as mean, median, mode, variance, and standard deviation, as well as probability distributions like normal and binomial distributions. Participants also learned about hypothesis testing, significance levels, and an introduction to data visualization principles, including different types of charts such as bar charts, pie charts, histograms, scatter plots, and box plots. The session emphasized the importance of statistical analysis in extracting meaningful insights from data and how graphical representation aids in interpreting results effectively.

Building upon the theoretical knowledge from Day 1, the second day focused on practical implementation using Python. The session covered an introduction to Python for Data Science, using Pandas for data manipulation and analysis, exploring NumPy for numerical operations, and visualizing data with Matplotlib and Seaborn. Hands-on exercises were conducted using real datasets to perform statistical analysis and create insightful visualizations. By the end of the session, students were able to write Python scripts to analyze data, generate graphs, and interpret results.

The third day introduced students to database management using PostgreSQL, with a focus on installation and setup of PostgreSQL and PGAdmin, understanding relational database concepts, and learning SQL for creating, modifying, and querying databases. Topics included performing CRUD (Create, Read, Update, Delete) operations, joining multiple tables, understanding relationships in databases, and writing optimized queries for data retrieval. Participants practiced executing SQL queries on sample datasets, gaining hands-on experience with database management.

On the fourth day, the focus shifted to business intelligence and data visualization using Power BI. The session included an introduction to Power BI and its interface, connecting Power BI with various data sources, data transformation and cleaning using Power Query Editor, and creating visual dashboards with charts, tables, and KPIs. Additionally, participants learned to implement DAX (Data Analysis Expressions) for advanced calculations and explored real-world case studies demonstrating the power of interactive dashboards. The session highlighted Power BI’s robust visualization capabilities, teaching participants how to create reports that effectively communicate insights.

The final day was dedicated to finalizing reports and clearing any doubts. The session included a step-by-step guide to generating and formatting reports in Power BI, exploring advanced Power BI features such as filters, slicers, and drill-down reports, and revisiting key SQL concepts to address any gaps. An open Q&A session allowed participants to clarify doubts from previous sessions. The day concluded with a hands-on project where students created a complete Power BI dashboard from scratch, ensuring that they left with a strong understanding of how to create professional reports and analyze data effectively.

Students’ feedback: Students found the training informative and well-structured, appreciating the blend of theory and hands-on practice in statistical analysis, Python, SQL, and Power BI. They valued the clear explanations and real-world applications but suggested more time for hands-on practice and advanced topics. The final Q&A was helpful, though dedicated doubt sessions after each class would improve clarity. Overall, the training enhanced their confidence in data analysis and visualization.

The event was coordinated by Dr. Shweta Singh, Mr. Anmol Yadav, Mr. Suraj Singh, Mrs. Pooja Shukla.

Acknowledgements: Gratitude to Mr. Ashutosh Hiskiel (Data Scientist & Corporate Trainer), Hon’ble Vice Chancellor (Prof. Bhanu Pratap Singh), Registrar (Dr. Girish Chhimwal), Dean Academics (Dr. Neeraj Jain, Lucknow Campus), Dean Engineering (Dr. Kalyan Acharjya) and Sr. AO (Dr. Rajesh Singh) for their active support and encouragement.

MUIT