-
₹15000
-
Duration: 10 Hours
-
Delivery mode: Flexible as per the student
-
Group size: Individual
-
Instruction language:
English,
Malayalam
-
Certificate provided:
No
1. Power Query Editor (Basic, Intermediate, Advanced) – 3 Hours
- Power Query Interface: Query pane, formula bar, applied steps, advanced editor
- Basic Transformations: Rename, change types, filter, split, merge, fill down, group by
- Combining Queries: Merge (joins), Append
- Applied Steps & Query Management: duplicate, reference, dependencies
- M Language Basics: let-expression, syntax, custom functions
- Conditional Columns & Error Handling: if-else, try-otherwise
- Parameterized Queries: file paths, dynamic filters
- Reusable query templates and automation
2. Data Modeling – 3 Hours
➤ Basic Data Modeling (1 Hour)
- Star vs. Snowflake schema
- Fact vs. Dimension tables
- Creating relationships: one-to-many, cross-filter direction
- Calculated columns vs. measures
- Building simple KPIs
➤ Intermediate Data Modeling (2 Hours)
- Many-to-many relationships using bridge tables
- Composite models & relationship behavior
- DAX for modeling: CALCULATE, FILTER, ALL, SUMX, RELATED
- Time intelligence modeling: date table, SAMEPERIODLASTYEAR, TOTALYTD, DATEADD
- Context transition, filter vs. row context
3. Advanced Data Modeling – 1 Hour
- Many-to-Many Relationship deep dive with bridge table
- Role-playing dimensions with USERELATIONSHIP
- Optimizing model: reduce cardinality, hide columns, performance tips
4. Power BI Visualization – Advanced Syllabus – 3 Hours
➤ Hour 1: Visuals & Interaction
- Core visuals: bar, line, card, KPI, matrix
- Drill down, drill up, and drill-through
- Tooltips: default and custom tooltip pages
- Slicers and sync slicers
➤ Hour 2: Dynamic & Formatting
- Dynamic titles using DAX
- Conditional formatting: color, font, data bars
- Parameters (What-If, slicer-driven)
- Dynamic filtering using field parameters
- Custom fonts & JSON themes
➤ Hour 3: UX, Wireframes & Optimization
- Figma for wireframe and layout design
- RLS: static and dynamic using USERNAME()
- Performance optimization: analyzer tool, minimizing visuals
- Using certified custom visuals from AppSource
5. Power BI Service – 1 Hour
- Publishing reports from Desktop to Service
- Workspaces, sharing, and collaboration
- Dataset permissions and access control
- Row-Level Security setup in Service
- Exporting to PDF/PPT and mobile layout basics