Please enable JavaScript.
Coggle requires JavaScript to display documents.
Microsoft POWER BI Day One - Coggle Diagram
Microsoft POWER BI Day One
Free version is on the Microsoft store
Payed version is only for sharing on like a webpage
Get data , "dont get data from desktop"
Drag column names from fields from the right side
"Transform Data" to highlight the data column, like jan 14 2021, right click to merge , then seperate , name it and it will combine the data
"Add custom column" like contry code then CHN
Use the same name like product key and maybe another column is called product no, then append it to the same name or change it to anoher name
Data Modelling:
Structure the data you need : Key is like date, Names and measures are like values and prices
Dim / add the column together like country, sub region and region to one key name like Dim Region Country
Create a retailer dimension....
Create table to catagorize small, Medium or large if you have numbers from 1 to 100
Buildings Visuals
Click Card from Visualization, then Fields drag one of the sub directories to the frame card. you can drag key fields in to a Measure.
Adding maps by adding country region from the fields
You can add a Slicer to the filter by draging like year and weeks below each other in the selection control
4 Data Model Tuning
Data view can be changed to report view
Model view is a overview of all tables
By Clicking the connection string you can edit the. please be in mind that if you need to delete a table, if you delete a table it is gone, it is okay to delete a relation ship
You can drag and drop a relationship to each box. Make sure that it is edit correctly
You can hide/Unhide some of the data from the edit function
You can click in the visual 3 dots and click show as table to have the tables and KPI in the same view.
5 Data Model Enrichment: Unpivot data
6 Calculations
DAX : Data Analysis Expressions
you can add new measures in the fields
add column to an excisting excel sheet in POWER BI
you can make a calculation of different between 2 numbers in each column