SELF SERVICE BUSINESS INTELLIGENCE, KPR Institute Engineering and Technology, Autonomous Engineering Institution, Coimbatore, India

All
UG Courses

Offline (With in the campus)
SELF SERVICE BUSINESS INTELLIGENCE
Workshop State
DATE
Dec 10, 2022
TIME
09:00 AM to 04:15 PM
LOCATION
HI-PERFORMANCE COMPUTING LAB
DEPARTMENT
Continuing Education Programme
TOTAL PARTICIPATES
70
Outcome
The workshop on Self Service Business Intelligence was given a new insight for many students, faculty, staffs and industry persons on power query in Microsoft excel.
Summary
Faculties, staffs, students and Industry persons from various parts of Tamilnadu has participated and had a hands-on experience of using the pivot table and power query for business and analysis and report generation.
 They have explored the new possibilities on large data handling and data cleaning techniques. The expertise and experience of the resource person made all the participants to practice and upgraded their skill in using this tool.
The resource person has covered the topics in four sessions and the topics covered are given as follows:
>Session I – Introduction to Pivot Table
+ Spencer’s Sales Promotional Strategy
> Session II - Creating a Basic Pivot Table
+ Analyzing Activity by Market
+ Preparing the Source Data: Using an Excel Table with Monthly
Columns
+ Cleaning Up Data for Pivot Table Analysis
> Session III - Grouping
+ Grouping Text Fields
+ Grouping Data - Week wise, Month wise, Quarter wise and Year
wise
+ Grouping Numeric Fields
> Session IV - Sorting and Filtering
+ Sorting a Pivot Field: Sorting Value Items
+ Sorting a Pivot Field: Sorting Text Items
+ Sorting a Pivot Field: Sorting Items in a Custom Order
+ Filtering a Pivot Field: Manual Filter
+ Filtering a Pivot Field: Label Filter
> Session V - Data Crunching using Pivot Table
+ Using Formulae: Creating a Calculated Field without “IF”
Condition
+ Using Formulae: Creating a Calculated Field with “IF” Condition
+ Using Custom Calculations: % of Column
+ Using Custom Calculations: % Difference From
> Session VI - Graphical Presentation
+ Planning and Creating a Pivot Chart
+ Converting a Pivot Chart to a Static Chart
Everyone have appreciated the workshop and its usefulness. The participants are issued with certificate.

***END***


Still wondering where to begin?
Apply Now

21st Century Engineering College in Coimbatore

World is transforming everyday. In the rapidly evolving engineering landscape, we have an Increased responsibility to transform the engineering education from traditional curriculum to meet the 21st century skills like Creativity, Critical Thinking, Collaboration and Communication. Through our unique and strategic approach we enable our students to learn beyond and prepare them for life long success.

21st Century Engineering College