“By visualizing information, we turn it into a landscape that you can explore with your eyes. A sort of information map. And when you’re lost in information, an information map is kind of useful.” – David McCandless Microsoft Power BI is a collection of apps, software services and connectors that come together to turn unrelated data into visually impressive and interactive insights. Power BI can work with simple data sources like Microsoft Excel and complicated ones like cloud-based or on-premises hybrid Data warehouses. Power BI has the capabilities to easily connect to your data sources, and visualise and share and publish your findings with anyone and everyone. Power BI is simple and fast enough to connect to an Excel workbook or a local database. It can also be robust and enterprise-grade, ready for extensive modelling and real-time analytics. This means it can be used in a variety of environments from a personal report and visualisation tool to the analytics and decision engine behind group projects, divisions, or entire corporations. As Power BI is a Microsoft product and has built-in connections to Excel, many functions will be familiar to an Excel user.
Therefore to make students aware of data visualisation and analysation; IETE-SF Conducted a Workshop on “Power BI”. The Session took place on 19th May 2022 and was a roaring success with over 120 participants attending the event. The Session started with good enthusiasm among the attendees to gain a good hold on Data Analytics under the guidance of the Speaker.
Firstly the speaker for the day, Prof. Ameya Kadam, introduced himself sharing his experience in the field of Data Analytics and Visualization. The speaker had instructed the participants to download POWER BI beforehand by sharing a video for the same. He yet quickly showed everyone how to download the POWER BI tool and connect it to Microsoft Excel.
With everyone having POWER BI Tool-ready on their laptops, the speaker started the session by discussing various tools for Data Visualization and modelling and why POWER BI is the most used application.
The speaker then shared with the students, the sample data to analyse. Data on the Superstore was shared with the students. The students were expected to work on the same throughout the workshop. After going through the data, the speaker then taught the attendees to load the data on the Power BI applications. Students followed the instructions and were on par with the Professor.
The next step was to analyze the sample given. The speaker guided the students to analyze the data given concerning different parameters and charts. The students were then engaged in transforming the data to create visuals and reports. The session also focused on making the students learn the different features of data visualisations by introducing the different types of charts viz, Column Chart, Stacked Column Chart, Pie Chart, Ribbon chart, Sankey Chart, ScrollerBox plot, Map Filled Map Gauge, Meter Drill down Line Chart, Funnel Chart, Donut Chart, etc.
Once the students were familiar with the charts and visualisation parameters, the speaker explained to them the formatting of the charts for better visualisation and modelling. Finally, Professor also taught them how to share the created visuals or reports using different Power BI services.
The students were now enhanced with the skill of Data Visualization and Modelling by using Power BI. The speaker concluded the session by briefing them on the summary of the workshop and finally taking up the questions and answers round. The session came to an end with the IETE team presenting Prof. Ameya Kadam with a Certificate Of Appreciation.
At the end of the workshop participants will be able to
- extract data from various data sources,
- transform data
- create visuals or reports
- share them using Power BI services.