Dashboard From Scratch | Microsoft Power BI in Tamil | Part 9A | Visualization Options |
HTML-код
- Опубликовано: 5 июн 2024
- Microsoft Power BI in Tamil
POWER QUERY
=====================================================
Data Visualization
POWER BI DESKTOP
-M query
-Power Query Editor
-Data Modeling
-DAX Functions
-POWER BI Visualization
-POWER BI Service
-Report View
-Data View
-Model View
Power Query Editor - ETL(Extract Transform Load)
-Transform (make changes in the real data column)
-Add Column (will add new column and make the changes)
Transform
Data Types
-Whole number
-Decimal number
-Text
-Date
-Date/Time
-Time
-True/False
-Use first row as Headers
-Transpose
-Reverse Rows
-Count Rows
-Detect Data Type
-Rename
-Replace values
-Fill
-Pivot Column
-Unpivot Columns
-Move
-Convert to list
-Split Column
-Format
-Merge Columns
-Extract
-Parse
Data Visualization
POWER BI DESKTOP
-M query
-Power Query Editor
-Data Modeling
-DAX Functions
-POWER BI Visualization
-POWER BI Service
-Report View
-Data View
-Model View
Power Query Editor - ETL(Extract Transform Load)
-Transform (make changes in the real data column)
-Add Column (will add new column and make the changes)
Transform
Data Types
-Whole number
-Decimal number
-Text
-Date
-Date/Time
-Time
-True/False
-Use first row as Headers
-Transpose
-Reverse Rows
-Count Rows
-Detect Data Type
-Rename
-Replace values
-Fill
-Pivot Column
-Unpivot Columns
-Move
-Convert to list
-Split Column
+By delimeter
+By number of char
+By positions
+By lower to upper case
+By upper to lower case
+By digit to Non-Digit
+By Non-Digit to Digit
-Format
-Merge Columns
-Extract
-Parse
Data Visualization
POWER BI DESKTOP
-M query
-Power Query Editor
-Data Modeling
-DAX Functions
-POWER BI Visualization
-POWER BI Service
-Report View
-Data View
-Model View
Power Query Editor - ETL(Extract Transform Load)
-Transform (make changes in the real data column)
-Add Column (will add new column and make the changes)
Transform
Data Types
-Whole number
-Decimal number
-Text
-Date
-Date/Time
-Time
-True/False
-Use first row as Headers
-Transpose
-Reverse Rows
-Count Rows
-Detect Data Type
-Rename
-Replace values
-Fill
-Pivot Column
-Unpivot Columns
-Move
-Convert to list
-Split Column
-Format
-Merge Columns
-Extract
-Parse
SATATISTICS
STANDARD
-add
-multiply
-subtract
-divide
-integer divide
-modulo
-Percentage
-Percent Of
SCIENTIFIC
-Absolute value
-power
-square root
-exponent
-logarith
-Factorial
ROUNDING
-round up
-round down
-round
INFORMATION
-iseven
-isodd
-sign
DATE
-age
-date only
-parse
-year
-month
-quarter
-week
-day
-combine date and time
-earliest
-latest
TIME
itime only
-local time
-parse
-hour
-minute
-second
-combine date and time
-earliest
-latest
STANDARD
SCIENTIFIC
ROUNDING
DATE
TIME
DURATION
ADD COULUMN
-Column from examples
-Custom column
-Invoke custom column
-Conditional Column
-Index Column
-Duplicate Column
New Source
Recent Sources
Enter Data
Data Source settings
Refresh Preview
Properties
Advanced Editor
Manage
Parameter
-value Changes value dynamically
Home
-Choose columns
-Remove columns
-Keep rows
-Remove rows
-Sorting
-Split Column
-Group By
Merge Queries
-Left Join (All records from LEFT side table,mached record from RIGHT side)
-Right Join (All records from RIGHT side table,mached record from LEFT side)
-Inner Join (Matched records from both the table)
-Full Outer Join (Matched and Unmatched records from both table)
-Left Anti (left table records, without matching records with right table)
-Right Anti (right table records, without matching records with left table)
Append Queries
appending two or more tables,for example adding Jan record + Feb record
DAX - Data Analytics Expressions
Calculated Column - will occupy memory space, gives value for each rows
Calculated Measure - wont occupy memory space, gives a aggregated single value
DATE FUNCTIONS
-DAY
-MONTH
-YEAR
-QUARTER
-Weekday
-Weeknum
-Today
-Now
-Datediff
-Dateadd
-Start of the month
-End of the month
-EOmonth
LOGICAL FUNCTIONS
-If
-Iferror
-And
-Or
Calculate
TEXT FUNCTIONS
-uppercase
-lowercase
-propercase
-left
-right
-mid
-length
-trim
-coconate
-& ampersand
-" " - space
-subtitute
-search
Date value
Network Days
switch
Not
Time Inlellinge Function
-previuos day
-previous month
-previous quarter
-previous year
-next day
-next month
-next quarter
-next year
-sameperiodlastyear
-Start of month
-Start of quarter
-Start of Year
-End of month
-End of quarter
-End of Year
-ytd
-qtd
-mtd
INFORMATION FUNCTION
-is blank
-is empty
-is odd
-is even
-is number
-is text
-is error
-is nontext
-is filtered
-is logic
-Filter
-All
-AllExcept
-AllSelected
-Var
-Concatenatex
Aggregate Functions
-Sum
-Average
-Min
-Max
-Count (10,20,20,30,40) = 5
-Distict Count (10,20,20,30,40) = 4
-sum vs sumx
Visualizations
Types of charts
Filters
Relationshps
-Cardinality
Power BI service
- Create account for Power BI service
10minutemail.com/
- Publishing the report
- Comment
- Share
- Export
- Download as .Pbix
- Refresh now (it will refreshes in the current time)
- Scheduled refresh
- Subscription
- Alerts
- Creatin Dashboard