REPORT OF Power BI WORKSHOP FOR ACADEMIC YEAR – 2021
1. Event Title: Microsoft Power BI Workshop
2. Date of Event:
5th July – 9th
July 2021
3. Type of Event: Co-Curricular
4. Venue: Online (Google Meet)
5. Event Coordinator: Mr. Kanu Raval and
Prof. Nisha Dubey
6. Event Participant: MBA-I (SEM-2), alumni
& all faculties of NCM
7. Expert Speaker / Facilitator (If Applicable):
a. Name: Dr. Sameer Rohadia
b. Designation: Data Analyst and IT Trainer at
Hannover, Germany
8. Proceedings of the Event (Day Wise):
·
Day 1- 5th
JulyMonday2021: 16:30 to 18:30 Hours
·
Day 2- 6th
July Tuesday 2021: 16:30 to 18:30 Hours
·
Day 3- 7th
July Wednesday 2021: 16:30 to 18:30 Hours
·
Day 4- 8th
July Thursday 2021: 16:30 to 18:30 Hours
·
Day 5- 9th
July Friday 2021: 16:30 to 18:30 Hours
9. Take-Home/Learning for the Students:
Ø Day 1- Data Analytics and Microsoft Power Bi:
o Data Visualization-It Is the Graphical Representation of
Quantitative information Graphical Visuals are easier for human brains to
understand.
o "Michael Florent Van Langren "1644 an
astronomer introduced the term "Data visualization”.
o "William Playfair " in 1786, Scottish engineer
and political economist Considered as Father of Statistical Graphics, Bar,
Pie-Chart Etc.
o Benefits of data visualization are:
o Quick & Clear Understanding of Information
o Identify Emerging Trends & Act Quickly Based on What
We See.
o Identify Patterns and relationships.
o It Improved Customer Experience & Engagement.
o Features of BI
o It Provide Advanced Analytics with Familiarity of Excel.
o Create Interactive Reports Customize for Business.
o Helpful To Everyone to Operate Anywhere.
o Power BI Products: - Power BI Desktop, Power BI Pro,
Power BI Premium, Power BI Mobile.
o It Has Big Data Dashboard.
o Data Visualization Specialists Are 100% Committed to
Their Profession.
o Some Learning Platforms: - UDEMY, EDX, NPTEL, LINKEDIN
LEARNING
Ø Day 2- Data Cleaning and Transformation:
o Data cleaning and transformation (Individual File)
o How to remove column: - use first row as header.
o How to remove NA: - click header – in list go to NA –
remove tick -- click ok.
o How to filter the blank rows: - click header – in list go
to blank – remove tick – click OK.
o Data cleaning and transformation (Combine File)
o How to combine file: - click append queries – click A.Q.
As new – dialogue box – select table – click OK.
o How to rename query: - double click query – write name –
click enter.
o How to remove error: - correct error in original file –
open power query editor file – click refresh button.
o Applied steps: - it shows summary whatever we have do
till now.
o
How to save change:
-click close & apply – home page of power query editor file window will
open – click save the file.
Ø Day 3-Microsoft Power BI and Its Features:
o First of all, Dr. Sameer started with Use of
Visualizations panels.
o After He select the charts on blank page and make line
charts and Clustered Column charts.
o In Microsoft Power BI, X-Axis Called as Axis and Y-Axis
Called as Values.
o Data Visualization Steps
o Open Project-Population-Start
o On bottom - Click on + Name the page as Overview.
o Data Visualization
o How to Create Chart: - Visualization – Click on Line
chart.
o How to Add Information in Chart: - Click on Line chart –
Click Dim-Region – Region name – Drag this into – Field option – Legend.
o Click Fact Population – Population – Drag this into –
Field option – Values.
o Click Fact Population – Population Female – Drag this
into – Field option – Tooltips.
o Click on Fact Population – Population Male – Drag this
into – Field option – Tooltips.
o Add another chart into the same canvas.
o Click on the outside of the Line Chart.
o How to Create New Chart: - Visualization – Clustered
Column Chart.
o How to Add Information in Chart: - Click Clustered Column
Chart – Click Dim-Region – Region name – Drag this into – Axis.
o Click Dim-Region – Country – Drag this into – Axis.
o Click Fact-Population – Population – Drag this into –
Values.
o Tooltips are giving a detail information of the data
point on the charts/visuals.
o Interaction Function is selecting an item in a visual
will effect on the display of another charts.
o Interaction are two types like Right to left and left to
Right.
o In power BI clicking on the none button, we can stop the
interaction function.
o After we learning about hierarchy function.
o Hierarchy function include drill up,
o Dr. Sameer is giving idea about how power BI have easy
and quick operate the function.
o Helpful To Everyone to Operate Anywhere.
o Last function of the today workshop is Format Function.
o Format Function is useful for customize the data on the
chart like title, color, border, zoom slider and many more facilities.
o Zoom slider facility is available from the last 6 months
of power BI.
o After Dr. Sameer give answer of the students and faculty
member and end the today workshop.
Ø Day 4- Slicer:
o
Meaning of Slicer
o When to use slicer
o Types of Slices:
§ List
§ Drop Dow
§ Between
§ Less than or equal to
§ Greater than or equal
o Types of filters
§ Report level filter
§ Page level filter
§ Visual level filter
§ Filtering slicer
§ Formatting slicer
Ø Day 5-Calculated Columns
and Measures:
o
Difference between slicer and filter is that slicer is
convenient and dynamic whereas filters are static.
o
Calculated columns and measures are part of DAX (data analysis
expression)
o
Calculated columns is a column which is having a value which has
been calculated.
o
There are three views: Report view, Data view and Model view.
o
Data view show data set and in model view you can create
relation/connection among tables.
o By clicking table tools and then new
columns a new column can be created
o
In formula bar you can write formula that you want to calculate.
o
To transfer data of one table to another both the tables should
be connected that can be done in model view.
o
Identify common field in both tables and connect those fields.
o
Measures shows only one single value such as total population,
total salary, total sales.
o
Measures are very helpful in dashboards and reports.
o
Five measures are created – total population, average
population, female population, male population and percentage of female
population in total population.
o
Difference between calculated column and measures is calculated
column show one value of each record/row whereas measures show only one single
value.
Ø Feed back of the students (Link)-
The workshop was perceived to
be an excellent opportunity by most of the participants through which they
learnt practical aspects of theory and new tools taught in Business Analytics.
The day wise systemic distribution of content presentation including Data
Cleaning and transformation, Graphs
and Visualization, Slicing and Filtering followed by Calculated Column And Measure Columns were
taught at a very good pace and most of the participants were able to easily
comprehend the presented content. Even for the working professionals including alumni,
faculty and staff members they’ve learnt a new tool by which they can
effectively present their data for research or business presentations. Overall,
the event was a great platform for bridging the gap between the businesses
applications of the theoretical aspects covered in the curriculum.
Link:
https://forms.gle/fRX2bFigTka3Gbge8
Ø
Event Video Link/Photos:
|
5
July 2021 |
https://drive.google.com/file/d/1odprmDTpHDxqIBZQEN5zTnkY8S3jjX_b/view?usp=sharing |
Power BI workshop - Day1 - Data Cleaning and
transformation |
|
6
July 2021 |
https://drive.google.com/file/d/1OEPocBgv3B0eWiztcQJj6-QfHlK3_HWE/view?usp=sharing |
Power BI workshop - Day2 - Data Cleaning and
transformation |
|
7
July 2021 |
https://drive.google.com/file/d/1OudTrpuvaB6Nl4LjwdOYtVLc5l1YVbEW/view?usp=sharing |
Power BI workshop - Day3 - Graphs and Visualization |
|
8
July 2021 |
https://drive.google.com/file/d/1G_Dx9_R-7lOZYs4Sx7GX11p0MoCf5bYB/view?usp=sharing |
Power BI workshop - Day4 – Slicing & Filtering |
|
9
July 2021 |
https://drive.google.com/file/d/1qhU_tPw4n38rMpH0gl0AvB1ZYvLcTDn2/view?usp=sharing |
Power BI workshop - Day5 - Calculated Column And Measure
Column |
Comments
Post a Comment