This session will include everything a beginner needs to start with Power BI. We will start the session by opening a fresh Power BI file and making ourselves aware of the basic elements:
• Report page, canvas, gridline & page settings - to familiarise 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 tell 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
BIO
Pragati has been recently awarded with Microsoft Most Valuable Professional award (MVP) under Data Platform category.
Currently, she is working as a Senior Data Analyst in UK and works towards generating and delivering data insights to various customers. She holds a Master’s degree in Data Science and Analytics from
Royal Holloway University of London.
