Workshop on Advanced Excel and Power BI

Workshop on Advanced Excel and Power BI

Types: Workshop

Date:14 October – 2024 to 19 October – 2024

Venue: Lab D

Number of Participants:55(registered :63)

Name of the Speaker:Dr. Ruchi Nanda, Dr. Amita Sharma, Dr. Astha Pareek,

Dr. Anubha Jain, Mr. Neelansh Yadav (Metlife,Jaipur)

Name of the Coordinator: Dr. Amita Sharam

Objective of the Workshop

The objective of the 6-day Offline Workshop on Advanced Excel and Power BI was to provide participants with practical knowledge and advanced skills in data analysis, visualization, and business intelligence using Microsoft Excel and Power BI. Key objectives included:

  • Mastering Advanced Excel Features: Equip participants with a deep understanding of Excel’s advanced functionalities, including formulas, PivotTables, PivotCharts, and financial modeling, to perform efficient data analysis and reporting.

  • Data Visualization and Dashboard Creation in Power BI: Enable participants to create visually compelling and interactive reports and dashboards in Power BI, combining various data visualizations to present insights effectively.

  • Data Preparation and Transformation: Teach participants how to clean, transform, and prepare raw data using Power Query for accurate analysis in Power BI, with a focus on creating calculated fields and custom columns.

  • Developing Strong Data Models: Guide participants in building robust data models by establishing relationships between tables, applying proper data schema designs, and optimizing data connections for scalable analysis.

  • Introduction to DAX: Introduce the basics of Data Analysis Expressions (DAX) and empower participants to create advanced calculations, including time-based analysis, using DAX functions for dynamic reporting.

  • Power BI Automation and Integration: Equip participants with skills to automate workflows, set up data refresh cycles, and integrate Power BI with other systems for efficient data management and reporting processes.

By the end of the workshop, participants were expected to apply these skills to real-world business scenarios, enabling them to streamline data processes and generate actionable insights through Excel and Power BI.

  • Printer-friendly version