Skip to content

Details

Title: Data Analysis Using Power BI for Beginners ~ Pragati Jain

Follow us on Twitter @CloudDataDriven & Facebook, LinkedIn at #clouddatadriven

Join Our LinkedIn Group: https://www.linkedin.com/groups/12485934/

This event is online. You may need to install MS-Teams: https://www.microsoft.com/en-us/microsoft-teams/download-app

Please feel free to share this invitation to any people you think may be interested.

Agenda:
Introductions (2 mins)
Presentation (50 mins)
Q&A (10-15 mins)

Abstract:
This is a beginner’s session that focuses on what Microsoft Power BI is and what this tool can do. The session is specially for developers who have started to work on building reports and dashboards using Power BI. The tool is not just for visualization, but it extends its capabilities to data cleaning and data transformations. We will start the session by opening a fresh Power BI file and making ourselves aware of the basic elements like:
• Report page, canvas, gridlines, page settings to familiarize ourselves with the tool interface.
• Available Data source connections – files, folders, azure, database, etc.
• Different types of filters – visual level, page level & report level.
• In-built data hierarchy in the data.
• Show and talk about Report, Data and Model View in Power BI.
• A walkthrough by loading a sample data csv/excel file in Power BI and start looking at few data transformations/cleaning in Query editor.
• Basic data cleaning and transformations using query editor – modifying datatypes, handling missing values, creating new custom column, adding an index column.
• Once the data is loaded, we will start by generating few basic charts.
• Basic visuals for reporting – line charts, bar charts, columns charts, pie-charts, card visual, tree-maps.
• Edit Interactions functionality to control the interactions among different visuals on the report.
• As Power BI is a very strong tool in identifying key insights in the data, we will cover few interesting data behaviours that we see on the data.

Summary:
This session will include everything a beginner needs to start with Power BI. They will learn what Power BI is and how they can use this tool to not only generate pretty visuals but also find patterns and key insights in the data we use in the session. At the end of the session, the attendee will have a quick report generated using a “travel insurance claims” dataset and the kind of data insights that we uncover while creating this report.

Bio:
Pragati has been recently awarded with Microsoft Most Valuable Professional award (MVP) under Data Platform category.
She currently works as a Data Analyst at D4T4 Solutions Plc, based in UK. Previously she has gained experience as a Programmer Analyst with Tata Consultancy Services. Working with TCS, developed her interest in data analytics field and then she decided to pursue masters in the same area. She holds a Master’s degree in Data Science and Analytics from Royal Holloway University of London.
She is skilled in various tools and technologies like Microsoft Power BI, Tableau, Microsoft Excel, Azure ML Studio, Azure databricks Pyspark and SQL. She has been using Power BI for last 5 years and started participating on Power BI Community from last few months where she is one of the communities Superusers.
Outside work she enjoys photography, loves hiking, she is a trained Indian classical singer and has a passion for painting. She even has her Instagram page dedicated to painting (https://www.instagram.com/creationsbyprags)

Her LinkedIn Profile: https://www.linkedin.com/in/pragatijain1187/

Her blog is: https://datavibe.co.uk/

Join Our Social Media User Group
LinkedIn 👉 https://bit.ly/3676SV3
Facebook 👉 https://bit.ly/2XUggXV
Eventbrite 👉 https://bit.ly/3sHxO7K
YouTube 👉 https://bit.ly/38SRFsA
Meetup 👉 https://bit.ly/3a0v5gT
Twitter 👉 https://bit.ly/3akl1iW

You may also like