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
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.