POWER BI
MODULE - 1 INTRODUCTION
- Getting Started
- PBI Introduction
- Data sources
- Data transformation tools
- Data types
- Power query
- Transformation
- Power query by transformation tools
MODULE - 2 PIVOT s UNPIVOT
- About pivot and unpivot
- Pivot columns
- Unpivot columns
- Unpivot columns in power query
MODULE - 3 TRANSPOSE
- About transpose
- Difference between transpose and pivot, unpivot
- Do some examples
MODULE - 4 Text transformations
- Split column
- Add prefix and suffix
- Merge text column
- Extract text
- Power query M formula language
MODULE - 5 Number transformations
- Rounding (Roundup, round down, Round)
- Check for Even/ Odd values
- Check for sign
- Arithmetic Operations
- Percentage
MODULE - 6 DATA TRANSFORMANTION
- Date transformation
- Handling dates
MODULE - 7 LIST AND TABLES
- Create list and table
- Sorting the table
- Do all exercise
MODULE - 8 TABULAR AND MATRIX VISUALIZATIONS
- Creating tabular visualizations
- Formatting tables
- Matrix visualizations
- Two- dimensional/ hierarchical tables
- Create a matrix visualization
- Formatting a matrix visualization
MODULE - 9 AGGREGATING COLUMNS IN TABLES/ MATRIX
- Aggregations
- Add conditional formatting
- Colors to the values
MODULE - 10 CARDS
- Create cards
- Create multi-Row cards
- Formatting the cards
MODULE - 11 FILTERS
- Filtering options
- Slicers
- Slicer for a data field
- Slicer for a numeric field
- Visual filters
- Page filters
- Drill through filters
MODULE - 12 CHARTS
- Clustered column graphs
- Analytics in clustered chart
MODULE - 13 CHARTS
- Line and stacked column
- Line chart and area chart
- Line and clustered column
- Ribbon chart
MODULE – 14 MAPS
- Pie, donut and tree map
- Geographical maps
- Scatter and bubble plots
- Decomposition tree
MODULE – 15 KPI VISUALS
- KPI visuals in PBI
- Custom visualization
- PBI services
- Publishing to phi services
- Qna
MODULE – 16 DATA MODELING
- PBI data modeling
- Start schema and snowflake schema
- OLTP/OLAP
- Add relationships
- Create hierarchies
MODULE – 17 DAX FUNCTIONS
- Calculated columns
- Calculated measures
- Sum/sumX
- Max/min/avg
MODULE – 18 DAX FUNCTIONS
- Concatenate / combine
- Exat
- Trim
- Replace/substitute
MODULE – 19 DATE AND TIME FUNCTIONS
- Minute, hours, days, months
- Quarter, year, week day, week no.
- Date, today, now
- Dated if, time intelligence function
- Dates between, dates in period
- Total MTD, total QTD, total YTD
MODULE – 20 VISUALS
- Additional visuals
- Importing visuals
- Animated charts
POWER BI Training center in West Delhi, Uttam nagar. Best certified computer course curriculum for professional learning institute near Dwarka, Uttam Nagar, Jankapuri, Tilak Nagar, Subhash Nagar, Tagore Garden, Rajouri Garden, Ramesh Nagar, Moti Nagar, Kirti Nagar, Shadipur, Patel Nagar, Rajendra Place, Karol Bagh, Jhandewalan, Ramakrishna Ashram, Connaught Place, vikaspuri, najafgarh, Delhi Cantt, Dhaula Kuan, Palam Colony, Palam Villag, Dabri, Hari Nagar, Fateh Nagar, Raja Garden, Punjabi Bagh, Shivaji Park, Paschim Vihar, Peeragarhi, Inderlok, Netaji Subhash Place, Pitampura, Rohini, Chandni Chowk, New Delhi, East Delhi, North Delhi, West Delhi.
