Advanced Visualizations, Interactivity & Publishing to Power BI Report Server
(Expanded + Fabric Section)
Morning Session — Advanced Visualization & UX Design
Data Visualization Best Practices for Report Server
- Core design principles for business‑ready dashboards: clarity, minimalism, contrast, hierarchy
- Structuring report pages for storytelling and intuitive user flow
- Choosing the right visual types for comparisons, trends, KPIs, hierarchies, and spatial data
- Handling large datasets visually while maintaining performance
Creating Interactive, High‑Impact Reports
- Building reports with user‑friendly navigation: page layout, grouping, and visual organization
- Enhancing interactivity with:
- Slicers (list, dropdown, date, numeric range)
- Drill‑through pages for contextual detail
- Drill‑down hierarchies & multi‑level exploration
- Buttons, shapes, and navigation elements
- Designing “guided analytics experiences” using bookmarks:
- Bookmark‑driven navigation
- Showing/hiding visuals
- Multi‑state storytelling sequences
Usability Enhancements & Aesthetics
- Applying report themes for consistent branding
- Conditional formatting for heatmaps, threshold warnings, comparative indicators
- Customizing tooltips for contextual insights
- Using report page tooltips to show deeper detail without clutter
Afternoon Session — Publishing, Collaboration & Report Management
Publishing to Power BI Report Server
- Step‑by‑step publishing workflow for on‑premises environments
- Managing multiple versions of reports, updating PBIX files, and safe rollback
- Ensuring compatibility with Report Server–optimized PBIX versions
- Folder structure best practices for enterprise reporting environments
Collaboration, Security & Report Lifecycle Management
- Setting permissions and defining user roles in Report Server
- Strategies for secure sharing in on‑prem environments
- Version control strategies for large‑team reporting workflows
- Scheduling and managing refresh processes (Report Server perspectives)
- Managing linked reports, KPIs, and deployed assets
Final Lab & Capstone Project
Participants complete a full end‑to‑end project:
- Transform and model data
- Build measures using DAX
- Design a multi‑page interactive report
- Implement usability features (bookmarks, drill‑through, custom tooltips)
- Publish the final report to Power BI Report Server with proper permissions
A forward‑looking preview introducing students to the future of analytics with Microsoft Fabric.
What is Microsoft Fabric?
- Overview of Microsoft’s unified, end‑to‑end analytics platform
- How Fabric brings together data engineering, data science, real‑time analytics, BI, and governance into one SaaS experience
- How Power BI becomes the visualization layer within the broader Fabric ecosystem
Key Fabric Concepts
- OneLake: A single, organization‑wide data lake that centralizes storage for all Fabric workloads
- Direct Lake Mode: High‑performance Power BI models reading data directly from OneLake without import or DirectQuery bottlenecks
- Unified Governance & Security: Centralized data lineage, access control, and workspace management
Why Fabric Matters for Power BI Users
- How existing Power BI skills translate naturally into Fabric workspaces and pipelines
- Improved performance, automation, and scalability for enterprise reporting
- Real‑world examples of how organizations are modernizing BI with Fabric
What’s Next for Learners
- Suggested learning paths after this bootcamp
- How adopting Fabric over time enhances your Power BI investment
- Where to start if your organization is considering Fabric adoption
