23 August 2023

Guest Blog – Power BI Fundamentals

😜 Wish the sunshine coming back. Today, I want to explain the Power BI Desktop fundamentals concisely.

πŸ€” Why do we need Power BI?
Because we need to tell stories to end users. Power BI can hold datasets and visualise them, showing massive information simultaneously on several pages.

πŸ€— So how does it work?
Power BI Desktop has two main parts, the main interface (including report, data and model three layers) is for data modelling and visualisation. For the data transformation purpose, Power Query Editor support this part.

πŸ’β€β™€οΈ Then the common steps are:
Step 1: Get Data from connectors, they can be Files (e.g., Excel, CSV), databases (e.g., SQL Server), and URLs (e.g., SharePoint).
Step 2 (Optional): Sometimes, we do not have permission to change the raw data or our requirements are personalised. We need to adjust the data before loading. View column quality and distribution, Pivot or Unpivot, Split and so on.
Step 3: The model layer can build relationships among tables for joining tables together, and may add new measures or columns (it won’t change source data).
Step 4: Choose visuals on the right area, then drag data from fields into values, and may legend.

πŸ™†β€β™€οΈ That’s it, I hope it is helpful for my friends who want to learn a data visualisation tool. #powerbi #learningandgrowing #datavisualizationtools

Guest Blog by Ivy Li who has been reskilling and is Actively looking for a πƒπšπ­πš π€π§πšπ₯𝐲𝐬𝐭 role – check out her website here.

If any of our members or women looking to get into or are already in the tech industry and wish to share their knowledge then please feel free to do a guest blog with us – we’re here to support the community.

Women in data

Data science

Interested in what's happening in Women's Tech Hub?

Sign up to our newsletter
Skip to content