Learn With The Nerds - Planning a Power BI Project

In this module, Nick Lee from Pragmatic Works guides students through planning and executing a successful Power BI project by balancing self-service and enterprise practices. The course covers essential topics such as budgeting for licenses and governance, selecting appropriate features like Direct Lake and paginated reports, and implementing security measures including row-level security and data loss prevention. Students will also learn about capacity management and automation through CI/CD pipelines, enabling them to create a clear, scalable roadmap for delivering value efficiently.

In this module, Nick explores the balance between self-service and enterprise approaches in Power BI, emphasizing the importance of a blended hub-and-spoke model to combine speed with governance. He explains how self-service enables rapid, flexible analysis close to the business, while enterprise practices ensure consistency, security, and trust through certified data sets and shared definitions. Students will learn practical guardrails and strategies to manage ownership, resolve conflicts, and scale analytics effectively without sacrificing agility.

In this module, Nick introduces the Power BI service, explaining the different licensing options such as free, Pro, Premium, and Fabric, and how they impact workspace capabilities. He demonstrates navigating workspaces, highlighting the distinctions between personal and shared environments, and the advanced features available in Fabric-enabled workspaces like data pipelines and lake houses. Additionally, Nick outlines Pragmatic Works’ Quick Start service, which helps organizations rapidly set up and configure Fabric workspaces with proper governance, data engineering, and reporting to accelerate their Power BI adoption.

In this module, Nick guides students through the essentials of budget planning for Power BI deployments, emphasizing the balance between self-service and enterprise licensing models. They explain how to align budget with organizational roles and outcomes, covering key cost drivers such as licensing types, capacity, external tools, training, and governance. Additionally, the module details the differences between Power BI licensing tiers—from free and Pro licenses to premium per user and fabric capacity—highlighting their features and appropriate use cases for effective resource planning.

In this module, Nick explains how to select the most cost-effective licensing option based on your organization's needs. They highlight that for a small number of users requiring premium features, a per-user license is ideal, while larger groups of viewers benefit from a capacity-based license to reduce costs. Additionally, the speaker emphasizes the importance of piloting and monitoring capacity metrics before scaling to ensure optimal budgeting and feature use.

In this module, Nick explores the hidden costs and budgeting strategies involved in managing Power BI environments effectively. They emphasize the importance of balancing investments across platform licensing, enablement through training and governance, and contingency planning to address real-world challenges like slow refreshes and security risks. Additionally, the module highlights best practices such as using certified data sets, monitoring system performance, and fostering collaboration to ensure reliable, scalable, and trusted data solutions.

In this module, Nick guides students through making strategic decisions about Power BI data connectivity options—Import, DirectQuery, and DirectLake—highlighting their impact on performance, data freshness, and scalability. He explains the purpose and use cases of paginated reports for creating print-ready, multi-page documents suited for operational and financial needs, along with licensing considerations. Finally, Nick introduces co-pilot as an AI assistant that enhances productivity by helping draft DAX, summarize visuals, and provide natural language insights without replacing core analytical skills.

In this module, Nick explains how lake houses, warehouses, and notebooks integrate within the fabric to support data transformation, governance, and consumption across different user roles. They emphasize designing clean, certified data models that serve engineers, analysts, and executives effectively, while advocating for a phased rollout approach to feature adoption that prioritizes real user needs. The module also highlights the importance of balancing data freshness, scalability, and usability through thoughtful connectivity choices and ongoing refinement based on user feedback.

In this module, the speaker explains how Power BI tenant settings act as essential guardrails that balance enabling user productivity with maintaining organizational security and compliance. They emphasize the importance of configuring these settings—such as data export, external sharing, workspace creation, and publishing controls—using targeted access scopes and pairing them with sensitivity labels, audit logs, and periodic reviews. By adopting a tiered governance model and clearly defining security groups and policies, administrators can effectively manage risk while supporting efficient and secure analytics operations.

In this module, Nick guides students through the Power BI admin portal settings, emphasizing the importance of managing permissions and features at the organizational level. Key topics include controlling the "Publish to web" option, configuring data export capabilities, and enabling certified datasets to ensure data trustworthiness. Students will learn how to tailor these settings by security groups to balance accessibility with governance effectively.

In this module, Nick explores the comprehensive security framework within Power BI, focusing on four key layers: Row Level Security (RLS), Object Level Security (OLS), One Lake Security, and Sensitivity Labels with Data Loss Prevention (DLP). Students will learn how each layer functions to protect data by controlling access to rows, objects, data assets, and enforcing compliance across Microsoft 365 applications. Emphasizing best practices and planning, the course highlights the importance of early security design to prevent risks as projects scale and ensures consistent, auditable protection throughout the data lifecycle.

In this module, Nick explores capacity management by explaining the differences between premium and fabric capacities and how they impact performance in Power BI and Microsoft Fabric environments. He guides students on monitoring key signals like refresh health, concurrency, and model footprint to identify bottlenecks, and emphasizes optimizing models and scheduling workloads before scaling capacity. The module concludes with best practices for maintaining balance through regular reviews, ensuring cost-effective scaling and consistent performance as usage grows.

In this module, Nick introduces the principles of CI/CD (continuous integration and continuous deployment) tailored specifically for Business Intelligence (BI) projects. He explains how applying professional software engineering practices—such as version control, automated testing, and environment-specific deployment pipelines—can streamline the development and release of Power BI and Fabric assets. Students will learn key techniques including Git integration, deployment pipelines, and automated validation to ensure reliable, repeatable BI releases that reduce manual errors and support team collaboration.

In this module, Nick Lee guides you through creating a clear and practical roadmap for your Power BI project by integrating strategy, budgeting, feature selection, governance, and optimization. You’ll learn how to balance immediate deliverables with phased implementation while ensuring security and performance through effective modeling and automation. This approach helps you set realistic expectations, make informed trade-offs, and maintain momentum throughout your project lifecycle.