Expert Data Visualization and Analytics with Power BI

Course Modules

Module 1: Getting Data

• Connecting to an Excel Workbook from SharePoint
• Connecting to Web Data
• Connecting to a SQL Database

Module 2: Working with Advanced Visualizations

• TOPIC A: Creating Data Visualizations
• Creating Combo Chart (Line & Column)
• Adding Data
• Format Visual
• Creating Waterfall Chart
  • Adding Data
  • Format Visual

• Creating Scatter Chart
  • Adding Data
  • Format Visual
  • Apply clustering techniques
  • Time series Analysis
• Get More Visual
  • Import Visual

Module 3: Adding interaction to visuals and reports

• TOPIC A: Adding Elements
• Sync slicer
• Adding Bookmark
• Adding Button
• Adding Navigator
• TOPIC B: Drill Through
• Adding Drill Through
• Setting up Report page for Drill Through
• Sync slicer

Module 4: Analytics in visuals

• TOPIC A: Adding Analytics
• Adding Average Line
• Adding Constant Line (Target)
• TOPIC B: Adding Analytics
• Create a Group
• Edit a Group
• Create bin groups

Module 5: Working with New Data Using DAX

• TOPIC A: Parameter
  • Numeric Range
  • Fields

• Adding Quik Measure
• Time Intelligence
• Filter
• Total

Module 6: Publish Report to Workspace

• TOPIC A: Publish Report
• Publish a Report a my Workspace
• Publish Report a dedicated Workspace
• Manage Workspace
• TOPIC B: Auto Refresh
• Use Gateway to set Schedule Refresh
• Use Cloud Connection

Module 7: Managing User Permission with RLS

• TOPIC A: Manage Security Roles
• Add a Role
• Manage Roles
• View As