Please enable JavaScript.
Coggle requires JavaScript to display documents.
Power BI (PowerBI Desktop (Split Column (P BI - File - OPtiosn &…
Power BI
PowerBI Desktop
-
-
-
- Get Data
- Choose Excel FIle
- Chosen Transactions FIle (Mark)
- Click Edit - Query Editor opens
- Excel Table - go to Design and Choose any Table
- Table name - row and column expands.
10:30
- Power Query import from Table name - to clean 1st
- POwer Query - no UNDO, use Applied Steps instead
- Source, Navigation, Changed Type - can create Changed Type
- Add Column - choose Columns From Examples - Add Column - update and can delete other column name 1 and name 2.
5.Visualization - Axis - pull column, click sales.
- Visualization - pull and display
- Power BI can undo but Power Query CANNOT
- Data formatting - change RM value to numbers in 'DATA' left pane
- For background setting - go to blank area and do Format - change color and transparency - import image.
PBI -
- Explicit and Implicit column
- Goto Edit Queries -
- Click Home - New Measures - KEY IN Formula Bar
- Currency - Goto Modelling and Apply Currency
- Create Measures (12.31) - in Home ribbon - New Measures - choose formula for Total Sales etc.
- Format align - chart - by select chart and goto Format
- New file from Get Data - Excel - Choose First Row from Icon Left Top corner Or TRANSFORMATION
Relationship - Left Top icon-1 of 3
- To do Upper case and Trim we can - Edit Queries - Trasnform- Format
-
-
Important Note
-
- Data source must be in table
-
-
- data coupling - fr Access db
Features
-
-
different format excel, sql, text, csv
-
Basics - Get data, clean data, display data
Help - Blog - for products release
- Community
- DAX is Data Analysis Expressions