POWERBI Recorded Session Course

​ POWERBI CONTENT Report Visualiza5ons Choosing visuals based on context Na4ve & Custom Visuals Using Bullet, Sca<er, Ribbon & Waterfall charts Build a What-if Analysis Report (4me permiFng) Op5mizing the Design Adding Tool Tips Types of Condi4onal FormaFng Custom Page Sizing Logo & Icons Shapes and Borders FormaFng Tips & Tricks Power BI Bookmarking (4me permiFng) Best Prac4ce Guidelines and Development Tips Governance & Distribu5on Row Level Security – Crea4ng and Tes4ng Roles Publishing to the cloud Service Security – Add Users to Defined Roles Sharing Dashboards & Reports Adding Users & Edi4ng Workspaces Publishing Apps Report Building (cont.) Report Layout Guidelines Crea4ng Calculated Measures Understanding DAX syntax Implicit Vs Explicit Measures Base Measures & Metrics Commonly Used DAX Func4ons Sum, Average Time Intelligence (MTD, QTD, YTD, Prior Year) Calculate and filter context Filter, All IF, HasOneValue Switch -Divide UserRela4onship Selected Value Op4mizing Measures for Self-Service BI Using Quick Measures Build a Monthly Trend Report How to Slice by Measure Dynamic Headings & Dates Types of Slicers and filters Understanding KPI cards Using Field, Format, Analy4cs Pane Build a Tabular Report (Matrix) Types of Condi4onal FormaFng Report Func5onality Drill-Downs Drill-Through Slice by Rela4ve Dates Focus Mode - See Details SeFng Visual Interac4vity Expor4ng Data from Power BI Desktop Using Power BI Desktop Quick Insights Handling Mul4ple rela4onships with the fac

  • Module 1: Software Installation
  • Module 2: Bar Chart & Cross Tab Data
  • Module 3: Line Charts & Folder Handling
  • Module 4: Data Combining & Visualization
  • Module 5: Table & Matrix With Cards
  • Module 6: Merge Queries & Joins
  • Module 7: Eliminate Vlookup & Relationships
  • Module 8: DAX Formulas (SUMX, FILTER ETC)
  • Module 9: DAX QUERIES (TOPN, DATE FUNCTIONS)
  • Module 10: Calculate vs Calculate Table
  • Module 11: New Visual Calculations
  • Module 12: Conditional Formatting & Sparkles
  • Module 13 : Advance Date Function & Manage Roles
  • Module 14: Relationship Functions
  • Module 15: Dashboard Publishing