Power BI Complete Introduction
Power BI Introduction
Data Visualization
Reporting
Business Intelligence (BI)
Flow of Work in Power BI Desktop
Flow of Work in Report server Power BI Desktop
Power BI Report Server
Power BI Service
Power BI Mobile
Flow of Work in Power BI / Power BI Architecture
Power BI Visualizations
- Stacked bar chart
- Stacked column chart
- Clustered bar chart
- Clustered column chart
- 100% stacked bar chart
- 100% stacked column chart
- Line chart
- Area chart
- Stacked area chart
- Line and stacked column chart
- Line and clustered column chart
- Ribbon chart
- Waterfall chart
- Scatter chart
- Pie chart
- Donut chart
- Tree map
- Filled map
- map
- Funnel
- Card
- Multi row card
- Table
- Matrix table
Tool Tips
- Felid level tool tips
- Default tool tips
- Page level tool tips
- Text level tool tips
- Visual header tool tips
Conditional Formatting
- Text conditional formatting
- Border conditional formatting
- Background conditional formatting
- Font conditional formatting
- Data bars conditional formatting
- Conditional formatting icons
Power BI Themes
- Browse for themes
- Theme gallery
- Customize current theme
- Save current theme
- Download themes from marketplace
- Import themes in Power BI Desktop
Power BI Templates
- Import Templates in Power BI Desktop
- Create Template Power BI Desktop
- Save Templates In Power BI Desktop
Power BI (AI Visualizations)
- Q&A
- Decomposition Tree
Other Options
- Buttons
- Shapes
- Images
- New parameter
- Gridlines
- Lock objects
- Bookmarks
- Advanced bookmarks
- Selection
- Sync slicers
- edit interactions
- Enter data
- recent source
- refresh
- Data grouping
Introduction to office 365
- What is office 365
- Why use office 365
- Download custom visuals
Custom Visuals
- Bar chart
- Chartaccentbarchart
- Hierarchy slicer
- Linedotchart
- Multi slicer
- Pivotslicer table heatmap
- Tornado chart
Filters in Power BI
- Visual Level Filters
- Page Level Filters
- Report Level Filters
- Drill Through Filters
- Filter Sub Types
- Basic Filtering, Advanced Filtering
- Top N
- Relative Date Filtering
- Numeric field filters
- Text field filters
- Date and Time field Filters
Hierarchies and Drill-Down Reports
- Hierarchy Introduction
- Default Date Hierarchy
- Creating Hierarchy
- Creating Custom Date Hierarchy
- Change Hierarchy Levels
- Drill-Up and Drill-Down Reports
- Data Actions
- Drill Down
- Drill Up
- Show Next
- Level, Expand Next Level
- Drilling filters other visuals option
Visualizing KPI Data
- Create and Format Gauge Visual
- KPI Visual
- Create and Format Card Visualization
- Multi Row Card
- Create and Format Table Visual
- Matrix Visualization
- Create and Format Map Visual
- Filled Map Visual
Power Query
Introduction to Power Query – Extract, Transform & Load
- Data Transformation
- Benefits of Data Transformation
- Shape or Transform Data using Power Query
- Overview of Power Query / Query Editor
- Query Editor User Interface
- The Ribbon (Home, Transform, Add Column, View Tabs)
- The Queries Pane, The Data View / Results Pane
- The Query Settings Pane
- Formula Bar
- Advanced Editor – Complete ETL Code
- Saving Your Work – Appling ETL Changes – Loading into Power Pivot Model
- Power Query Conceptually
Datatypes and Filters in Power Query
- Datatypes, Changing the Datatype of a Column
- Filters in Power Query
- Filter a Column using Text Filters
- Filter a Column using Number Filters
- Filter a Column using Date Filters
- Filter Multiple Columns
Inbuilt Column Transformations
- Remove Columns / Remove Other Columns
- Name / Rename a Column
- Reorder Columns or Sort Columns
- Add Column / Custom Column
- Split Columns
- Merge Column
- PIVOT, UNPIVOT Columns
- Transpose Columns
- Header Row or Use First Row as Headers
- Keep Top Rows, Keep Bottom Rows
- Keep Range of Rows
- Keep Duplicates, Keep Errors
- Remove Top Rows, Remove Bottom Rows, Remove Alternative Rows
- Remove Duplicates, Remove Blank Rows, Remove Errors
- Group By
Combine Queries (Append Queries & Merge Queries)
- Append Queries / Merge Queries
- Query Options
- Copy Query, Paste Query
- Delete Query, Rename Query
- Enable Load, Include in report Refresh
- Duplicate Query, Reference Query
- Move to Group, Move Up, Move Down
Power Pivot
- Power BI Data Modeling – Relationship View
- Data Modeling Introduction
- Relationship, Need of Relationship
- Relationship Types / Cardinality in General
- One-to-One
- One-to-Many (or Many-to-One)
- Many-to-Many
- AutoDetect the relationship,
- create a new relationship
- Edit existing relationships
- Make Relationship Active or Inactive
- Delete a relationship
Power BI Services
- Power BI Service Introduction
- Power BI Cloud Architecture
- Creating Power BI Service Account
- SIGN IN to Power BI Service Account
- Publishing Reports to the Power BI service
- Import / Getting the Report to PBI Service
- My Workspace
- App Workspaces Tabs
- DATASETS
- REPORTS
- DASHBOARDS
- Working with Datasets
- Creating Reports in Cloud using Published Datasets
- Power BI Datasets Live Connection using Desktop
- Working with Workbooks
- working with Reports
- Sharing Reports
- Creating new reports in services
- Embedding to web
- share report link
Dashboards Development
- Creating Dashboards Pin Visuals and Pin LIVE Report Pages to Dashboard
- Advantages of Dashboards
- Interacting with Dashboards
- Formatting Dashboard
- Sharing Dashboard
Data Gateways
- Introduction to Data Gateways
- How Data Gateways work
- Connect to an on-premise Data Source by using a Data Gateway
- Download Data Gateway
- Installing a Data Gateway
- Types of Gateways
- On-premises Data Gateway
- On-premises Data Gateway (personal mode)
- Manage Data Gateway
- Add and Remove Administrators
- Add Data Source
- Add or Remove Users to a Data Source
- Refresh on Premise Data
Configuring Automatic Refresh using Schedules
- Collaboration in Power BI using App Workspace
- Introduction to App Workspaces
- Create an App Workspace
- Add Members to App Workspace to Collaborate
- App Workspace Access
- Admin
- Member
- Contributor
Sharing Power BI Content using Apps
Introduction to App
- Publish an App
- Update a Published App
- Manage Content in App
- Include in App
- Exclude in App
- Include in App
- Exclude in App
- Entire Organization
- Specific individuals or group
- Un publishing an App
Power BI Row level Security
- Introduction of Row Level Security in Power BI
- Types of row level security in Power BI
- Dynamic row level security in power bi
- Static row level security in power bi
Power BI DAX
Introduction to DAX
- Introduction
- How to import data into power bi
- Data types in power bi
- Calculated columns
- Dax measures
- Logical function & operators
Date and Time Functions
- Calendar
- Calendarauto
- Date
- Datediff
- Datevalue
- Day
- Edate
- Eomonth
- Hour
- Minute
- Month
- Now
- Second
- Time
- Timevalue
- Today
- Utcnow
- Weekday
- Weeknum
- Year
Filter Functions
- All
- Allexcept
- Allselected
- Calculate
- Earlier
- Filter
- Keepfilters
- Lookup value
- Selectedvalue
Information Functions
- Contains
- Iblank
- Iserror
- Iseven
- Innontext
- Isodd
- Istext
- Username
Logical Functions
- And
- If
- True
- Falese
- Iferror
- Not
- Or
- Switch
- True
Math and Trig Functions
- Abs
- Ceiling
- Convert
- Currency
- Divide
- Even
- Fact
- Power
- Rand
- Randbetween
- Round
- Raoundown
- Roundup
- Sign
- SQRT
Other Functions
- Blank
- Error
Parent and Child Functions
- Path
- Pathcontains
- Pathitem
- Pathitemreverse
- Pathlength
Relationship Functions
- Related
- Userrelationship
Statistical Functions
- Median
- Medianx
- Rankx
Table Manipulation Functions
- Addcolumns
- Crossjoin
- Datatable
- Flters
- Generateseries
- Row
- Selectcolumns
- Summarize
- Topn
- Union
- Values
Text Functions
- Combinevalues
- Concatenate
- Exact
- Find
- Fixed
- Format
- Left
- Len
- Lower
- Mid
- Replace
- Rept
- Right
- Search
- Substitute
- Trim
- Unichar
- Unicode
- Upper
Time Intelligence Functions
- Closingbalsmonthe
- Dateadd
- Datesbetween
- Datesmtd
- Datesytd
- Endofmonth
- Firstdate
- Lastdate
- Openingbalancemonth
- Parallelperiod
- Totalmtd
- totalqtd
- totalytd
DAX Statements
var
Errors Handling and Variables
- Error handling
- Aggregation functions
- Variables in DAX
Secrets of Context in DAX
- Filter context
- Row context
Secrets of Calculate Function
- Calculate function to change the filter context
- Power bi calculate with all to ignore the filter context
- Power bi calculate with allselected
- Power bi calculate with alleselected
- Power bi keepfilters function in DAX
- Power bi nested calculate
Count Functions
- Power bi count vs counta functions
- Power bi countrowns distinctcount and countblank
Time Intelligence
- Calendarauto function in DAX
- Datesbetween function in DAX
- Datesytd function in DAX
- Sameperiodlastyear in Power BI