Justin Vogel

Justin Vogel

Power BI Trainer

Meet Justin Vogel

About

Justin Vogel taught high school Advanced Placement® psychology and academic research for 15 years. He holds an MS in Psychology and spent several summers teaching psychology to educators new to the subject. He has also scored AP exams, reviewed textbooks for the Florida Department of Education, and written exam questions for test banks. He has presented at professional learning conferences at the local and national level and now puts his teaching and presentation skills to use on the Power BI team at Pragmatic Works.

Certifications

Courses

Course

Dashboard in a Day

Power BI is a business analytics service that gives you a single view of your business data, with the ability to monitor the health of your business using live dashboards, create rich interactive reports and access your data on the go, from your mobile devices. Microsoft in partnership with Pragmatic Works are pleased to offer this course covering the capabilities of Power BI. The goal of this informational session is to help you understand how to analyze your data in a rich and compelling way. Whether you are evaluating its ability to meet organizational requirements around data visualization and analysis or are looking to learn how Power BI can help you be more efficient and make a greater impact on the work you do every day, this is the training for you.

Course

Introduction to Microsoft Teams

Whether you're new to Microsoft Teams or just looking to get more comfortable, Introduction to Microsoft Teams with Justin Vogel will help you master the basics. This course walks you through how to use Teams for messaging, meetings, file sharing, and collaboration—all in one place. It’s designed for beginners who want to confidently connect with their team and stay productive. Justin breaks down key features step by step, showing you how to join and host meetings, organize conversations, and work with files directly inside Teams. By the end of the course, you’ll know how to use Teams effectively for both day-to-day tasks and long-term collaboration—no IT background required.

Course

Meetings in Microsoft Teams

Hosting or joining virtual meetings shouldn’t be complicated. In Meetings in Microsoft Teams, instructor Justin Vogel guides you through the entire meeting experience—from scheduling and joining to sharing content and using advanced features. Whether you're leading a team, running a webinar, or just want smoother video calls, this course will help you feel confident using Teams to communicate effectively. You’ll learn how to set up meetings, manage participants, use breakout rooms, record sessions, and collaborate in real time. Justin walks you through best practices for both organizers and attendees, so you can make the most out of every meeting. If you want to save time, reduce confusion, and run more productive meetings in Microsoft Teams, this course is for you.

Course

Microsoft 365 in Microsoft Teams

Microsoft Teams is more than just chat—it’s a powerful hub for all your Microsoft 365 tools. In Microsoft 365 in Microsoft Teams, Justin Vogel shows you how to access, share, and collaborate on Word documents, Excel spreadsheets, PowerPoint presentations, and more—without ever leaving Teams. This course is perfect for users who want to streamline their workflow and bring their productivity tools into one unified space. Through hands-on examples, you’ll learn how to co-edit documents in real time, manage file permissions, and integrate Microsoft 365 apps directly into your Teams environment. Justin also covers helpful tips for organizing files, tracking updates, and boosting team collaboration. Whether you’re new to Teams or looking to use it more effectively, this course will help you work smarter with Microsoft 365.

Course

Pragmatic Guides - DAX Text Functions

Unlock the full potential of your data with DAX Text Functions in this focused installment of the Pragmatic Guides series. Taught by Justin Vogel, this course breaks down essential DAX text functions one at a time, giving you clear, practical examples of how to clean, transform, and analyze text data inside Power BI. Whether you're formatting labels, extracting key information, or creating dynamic titles for your visuals, each module walks you through a specific function with hands-on demonstrations and real-world use cases. This course is perfect for learners who want to sharpen their DAX skills without the fluff—just straightforward guidance, one function at a time.

Course

Pragmatic Guides - DAX Date and Time Functions

The Pragmatic Guides – Date and Time Functions course provides a focused, hands-on exploration of essential DAX functions for working with dates and times in Power BI. Each module is dedicated to a single function, allowing you to quickly understand its purpose, syntax, and common use cases. Whether you’re calculating date differences, formatting time values, or building rolling period measures, this course equips you with the practical knowledge needed to manage and analyze time-based data effectively. Justin Vogel breaks down each function in an approachable way, making this a go-to resource for analysts, developers, and Power BI users who want to sharpen their DAX skills and confidently handle date and time calculations.

Course

Configurating Power BI Data Gateways

Bridge your on-premises data to the cloud with confidence. In Configurating Power BI Data Gateways, Justin Vogel shows you how gateways enable the Power BI Service to securely access data that lives behind your firewall or in private networks. You’ll learn when to use Standard vs. Personal mode, what prerequisites and permissions are required, and how to plan a clean installation—covering service accounts, regions, and basic network considerations like proxies and ports. Step by step, you’ll install a gateway, register it to your tenant, and connect common sources so reports refresh reliably. Once you’re up and running, the course turns to day-to-day management and best practices. Justin walks through configuring data sources in the Power BI Service, mapping credentials, and choosing between scheduled refresh and DirectQuery/Live scenarios. You’ll explore high availability with gateway clusters, tips for performance, and practical troubleshooting using logs and diagnostics. The course wraps with governance and security guidance—least-privilege access, ownership models, and change management—so you can keep your organization’s gateways stable, secure, and easy to maintain.

Course

Mastering the Star Schema

In Mastering the Star Schema, Justin Vogel walks you through how to design clean, intuitive data models that make reporting easier instead of harder. You’ll learn the core concepts of star schema ,design facts vs. dimensions, grain, surrogate keys, and relationships and why this structure is so widely used in analytics and Power BI. Justin shows how a good star schema simplifies DAX, improves performance, and helps report consumers slice and drill without confusion. From there, you’ll see how to apply these ideas in practical scenarios. You’ll walk through modeling common business processes, handling slowly changing dimensions, dealing with role-playing dates, and avoiding common traps like snowflaking and over-normalization. Along the way, Justin shares naming, documentation, and validation tips so your models stay understandable and maintainable as they grow. By the end, you’ll know how to design star schemas that are robust, performant, and ready for self-service BI.

Course

The Standalone Copilot Experience in Fabric

In The Standalone Copilot Experience in Fabric, Justin Vogel introduces a practical way to use Copilot as your “front door” to Microsoft Fabric, even when you’re not working inside a specific report, notebook, or dataset. You’ll learn what the standalone Copilot experience is, what it’s designed to help with, and how to use it to move faster when you’re exploring features, planning a workflow, or trying to understand what to do next. This course keeps the focus on real productivity, turning vague questions into clear next steps. You’ll also learn how to get consistently useful results by giving Copilot the right context and asking better questions. Justin covers easy prompting patterns, how to iterate when the first answer isn’t perfect, and simple guardrails to keep your work accurate and appropriate for your environment. By the end, you’ll be able to use Copilot in Fabric as a reliable guide, speeding up learning, reducing trial and error, and helping you feel more confident navigating the platform.

Show more

Bootcamps

Boot Camps

Mar 09 Virtual Advanced Power BI Bootcamp

Welcome to our Advanced Power BI 5-Day Intensive, designed for professionals who are ready to move beyond the basics and elevate their Power BI expertise. This immersive bootcamp is ideal for those with a solid foundation in Power BI who want to deepen their understanding and expand their capabilities. Throughout the course, you'll explore advanced techniques in data transformation, modeling, and visualization, learning how to apply complex business logic and build sophisticated data models that support real-world scenarios. You'll also gain practical experience with deploying solutions in the Power BI Service, ensuring your reports and dashboards are optimized for performance and accessibility across devices. With a focus on hands-on learning, this bootcamp provides the guidance and support needed to confidently transition from intermediate user to advanced practitioner. Whether you're looking to refine your skills or tackle more complex challenges in your organization, this course offers the tools and strategies to help you master Power BI. Individual days of the bootcamp are also available for purchase—details can be found on our bootcamps page.

Boot Camps

Mar 09 Advanced Data Modeling

Welcome to our Advanced Power BI Data Modeling Bootcamp, an intensive day class designed to elevate your data modeling skills to new heights. In this immersive full-day learning experience, you'll delve deeper than ever before into the world of Power BI and Data Modeling. Our expert instructors will guide you through advanced data modeling techniques, transforming raw data into a meaningful scheme. You'll master the intricacies of relationships, DAX (Data Analysis Expressions) functions for modeling which will enable you to create dynamic and interactive dashboards. Through hands-on exercises and a real-world case studies, you'll gain advanced knowledge in optimizing data models for performance and efficiency. Collaborative learning environments and peer interactions will enhance your problem-solving skills, ensuring you leave equipped with the expertise to tackle complex business challenges confidently. Join us on this transformative journey and unlock the full potential of your data modeling capabilities. Pragmatic Works bootcamps include interactive, hands-on labs that let you apply what you’re learning in real time. With expert instructors available for guidance and support, you’ll build skills by doing—not just watching.

Boot Camps

Mar 10 Virtual Advanced Data Shaping

Welcome to our Advanced Power BI Data Shaping Bootcamp, a comprehensive day class tailored for data enthusiasts seeking to refine their skills in data transformation and shaping. Throughout this immersive class, you will embark on a deep dive into the powerful world of the Power Query Editor, Power BI’s cutting-edge data shaping tool. Led by seasoned instructors, this course will empower you to manipulate and mold raw data into insightful, actionable information. You'll explore advanced techniques in data cleansing, merging, and transformation, as well as mastering the art of data preparation for analysis and visualization. Through hands-on exercises and real-world case studies, you'll learn to handle diverse data sources and complex data structures, ensuring you can confidently navigate and reshape any dataset. Collaborative learning environments and interactive discussions will enhance your problem-solving abilities, enabling you to transform messy data into clear, meaningful insights. Join us for this transformative journey and equip yourself with the expertise to shape data with finesse, making a significant impact on your organization's decision-making processes." Pragmatic Works bootcamps include interactive, hands-on labs that let you apply what you’re learning in real time. With expert instructors available for guidance and support, you’ll build skills by doing—not just watching.

Boot Camps

Mar 11 Virtual Advanced DAX Measures

Welcome to our Advanced DAX Measures Bootcamp, an immersive day class meticulously crafted for data professionals and analysts keen on mastering the intricacies of Data Analysis Expressions Measures. In this intensive day-program, you'll embark on a deep exploration of DAX Measures, the powerful formula language at the heart of Power BI that allows for insightful calculations. Led by seasoned instructors, this course will empower you to harness the full potential of DAX Measures, enabling you to create sophisticated calculations, advanced business metrics, and insightful analyses. Through hands-on exercises and real-world applications, you will learn to design complex measures, understand filter context, leverage advanced Time Intelligence functions to solve intricate analytical challenges and understand Calculate. From time intelligence and rolling totals to CALCULATE and ALL, this bootcamp covers a comprehensive range of DAX measures concepts. Collaborative learning environments and interactive discussions will enhance your problem-solving skills, ensuring you leave with a deep understanding of DAX measures. Join us on this transformative journey and elevate your data analysis capabilities with the mastery of DAX measures, making you a proficient and sought-after data expert. Pragmatic Works bootcamps include interactive, hands-on labs that let you apply what you’re learning in real time. With expert instructors available for guidance and support, you’ll build skills by doing—not just watching.

Boot Camps

Mar 12 Virtual Advanced Data Visualizations

Welcome to our Advanced Power BI Data Visualizations Bootcamp, an exhilarating day class tailored for individuals passionate about crafting impactful and compelling data stories. In this immersive day session, you'll embark on a creative journey into the art and science of data visualization using Power BI. Led by expert instructors, this course will deepen your understanding of advanced visualization techniques, enabling you to transform complex data sets into visually stunning, interactive dashboards. Through hands-on projects and interactive workshops, you'll explore intricate concepts such as custom visuals, storytelling with data, and real-time analytics, honing your skills to present data in ways that captivate and inform. You'll also delve into the world of data-driven design principles, mastering the art of choosing the right charts, colors, and interactive elements to enhance user engagement and comprehension for different types of data. With a focus on practical applications and real-world scenarios, you'll gain the confidence to create visually compelling reports that resonate with your audience. Join us on this transformative journey and unlock the full potential of your data visualization capabilities, turning raw data into compelling narratives that drive informed decision-making. Pragmatic Works bootcamps include interactive, hands-on labs that let you apply what you’re learning in real time. With expert instructors available for guidance and support, you’ll build skills by doing—not just watching.

Boot Camps

Mar 13 Virtual Power BI Administration

Welcome to our Advanced Power BI Administration Bootcamp, an intensive day class designed for IT professionals and Power BI administrators looking to optimize their organization's Power BI environment. In this comprehensive program, you will dive deep into the intricacies of Power BI administration, mastering the skills necessary to manage, secure, and optimize your Power BI deployment effectively. Led by experienced instructors, this course covers advanced topics such as data governance, security policies, data refresh scheduling, and performance optimization. Through hands-on labs and interactive sessions, you will gain practical expertise in managing user access, configuring data gateways, and monitoring usage analytics. You'll also explore best practices for version control, backup, and disaster recovery, ensuring the reliability and availability of your Power BI services. Collaborative learning environments and real-world case studies will enhance your problem-solving abilities, preparing you to tackle complex administrative challenges with confidence. Join us on this transformative journey and empower yourself with the knowledge and skills to efficiently administer Power BI, enabling your organization to harness the full potential of its data-driven initiatives. Pragmatic Works bootcamps include interactive, hands-on labs that let you apply what you’re learning in real time. With expert instructors available for guidance and support, you’ll build skills by doing—not just watching.

Boot Camps

Mar 30 Virtual SharePoint For Users Bootcamp

Welcome to the SharePoint bootcamp, an immersive two-day training program designed to equip SharePoint users with a comprehensive knowledge base of SharePoint sites, lists, and libraries. This bootcamp is meticulously crafted by industry experts to provide a hands-on learning experience, ensuring that participants gain practical insights and real-world applications of SharePoint. Whether you are a beginner or have some prior experience, this bootcamp will help you master the tools and techniques needed to use, design, or otherwise interact with SharePoint.

Boot Camps

Mar 30 Virtual SharePoint Bootcamp

Welcome to the SharePoint bootcamp, a comprehensive and immersive three-day training program designed to equip SharePoint users with a comprehensive knowledge base of SharePoint sites, lists, and libraries. This bootcamp is also available to purchase by sessions grouped in day 1 and 2 as one session and day 3 as the other. You can find those listed on our bootcamps page on our website. This bootcamp is meticulously crafted by industry experts to provide a hands-on learning experience, ensuring that participants gain practical insights and real-world applications of SharePoint. Whether you are a beginner or have some prior experience, this bootcamp will help you master the tools and techniques needed to use, design, or otherwise interact with SharePoint.

Boot Camps

Apr 01 Virtual SharePoint For Administrators Bootcamp

Welcome to the SharePoint for Administrators bootcamp, an informative one-day training program designed to equip SharePoint administrators with a comprehensive knowledge base of SharePoint’s administrative features. This bootcamp is meticulously crafted by industry experts to provide a hands-on learning experience, ensuring that participants gain practical insights and real-world applications of SharePoint. Whether you are a beginner or have some prior experience, this bootcamp will help you master the tools and techniques needed to use, design, or otherwise interact with SharePoint as an administrator.

Boot Camps

Apr 20 Virtual DAX Bootcamp

So you’ve been working with DAX in Power BI but either can’t quite complete the calculations needed or maybe you just want to expand your knowledge and utilize more capabilities of DAX to bring your reports to the next level – this is the course for you! In this in-depth DAX Bootcamp, all of your DAX knowledge will be enhanced to a point where you will have the tools to create any kind of calculation that is possible within the DAX language. You will also be learning about best practices, performance tuning, and much more! Pragmatic Works bootcamps include interactive, hands-on labs that let you apply what you’re learning in real time. With expert instructors available for guidance and support, you’ll build skills by doing—not just watching.

Boot Camps

May 11 Advanced Data Modeling

Welcome to our Advanced Power BI Data Modeling Bootcamp, an intensive day class designed to elevate your data modeling skills to new heights. In this immersive full-day learning experience, you'll delve deeper than ever before into the world of Power BI and Data Modeling. Our expert instructors will guide you through advanced data modeling techniques, transforming raw data into a meaningful scheme. You'll master the intricacies of relationships, DAX (Data Analysis Expressions) functions for modeling which will enable you to create dynamic and interactive dashboards. Through hands-on exercises and a real-world case studies, you'll gain advanced knowledge in optimizing data models for performance and efficiency. Collaborative learning environments and peer interactions will enhance your problem-solving skills, ensuring you leave equipped with the expertise to tackle complex business challenges confidently. Join us on this transformative journey and unlock the full potential of your data modeling capabilities. Pragmatic Works bootcamps include interactive, hands-on labs that let you apply what you’re learning in real time. With expert instructors available for guidance and support, you’ll build skills by doing—not just watching.

Boot Camps

May 11 Virtual Advanced Power BI Bootcamp

Welcome to our Advanced Power BI 5-Day Intensive, designed for professionals who are ready to move beyond the basics and elevate their Power BI expertise. This immersive bootcamp is ideal for those with a solid foundation in Power BI who want to deepen their understanding and expand their capabilities. Throughout the course, you'll explore advanced techniques in data transformation, modeling, and visualization, learning how to apply complex business logic and build sophisticated data models that support real-world scenarios. You'll also gain practical experience with deploying solutions in the Power BI Service, ensuring your reports and dashboards are optimized for performance and accessibility across devices. With a focus on hands-on learning, this bootcamp provides the guidance and support needed to confidently transition from intermediate user to advanced practitioner. Whether you're looking to refine your skills or tackle more complex challenges in your organization, this course offers the tools and strategies to help you master Power BI. Individual days of the bootcamp are also available for purchase—details can be found on our bootcamps page.

Boot Camps

May 12 Virtual Advanced Data Shaping

Welcome to our Advanced Power BI Data Shaping Bootcamp, a comprehensive day class tailored for data enthusiasts seeking to refine their skills in data transformation and shaping. Throughout this immersive class, you will embark on a deep dive into the powerful world of the Power Query Editor, Power BI’s cutting-edge data shaping tool. Led by seasoned instructors, this course will empower you to manipulate and mold raw data into insightful, actionable information. You'll explore advanced techniques in data cleansing, merging, and transformation, as well as mastering the art of data preparation for analysis and visualization. Through hands-on exercises and real-world case studies, you'll learn to handle diverse data sources and complex data structures, ensuring you can confidently navigate and reshape any dataset. Collaborative learning environments and interactive discussions will enhance your problem-solving abilities, enabling you to transform messy data into clear, meaningful insights. Join us for this transformative journey and equip yourself with the expertise to shape data with finesse, making a significant impact on your organization's decision-making processes." Pragmatic Works bootcamps include interactive, hands-on labs that let you apply what you’re learning in real time. With expert instructors available for guidance and support, you’ll build skills by doing—not just watching.

Boot Camps

May 13 Virtual Advanced DAX Measures

Welcome to our Advanced DAX Measures Bootcamp, an immersive day class meticulously crafted for data professionals and analysts keen on mastering the intricacies of Data Analysis Expressions Measures. In this intensive day-program, you'll embark on a deep exploration of DAX Measures, the powerful formula language at the heart of Power BI that allows for insightful calculations. Led by seasoned instructors, this course will empower you to harness the full potential of DAX Measures, enabling you to create sophisticated calculations, advanced business metrics, and insightful analyses. Through hands-on exercises and real-world applications, you will learn to design complex measures, understand filter context, leverage advanced Time Intelligence functions to solve intricate analytical challenges and understand Calculate. From time intelligence and rolling totals to CALCULATE and ALL, this bootcamp covers a comprehensive range of DAX measures concepts. Collaborative learning environments and interactive discussions will enhance your problem-solving skills, ensuring you leave with a deep understanding of DAX measures. Join us on this transformative journey and elevate your data analysis capabilities with the mastery of DAX measures, making you a proficient and sought-after data expert. Pragmatic Works bootcamps include interactive, hands-on labs that let you apply what you’re learning in real time. With expert instructors available for guidance and support, you’ll build skills by doing—not just watching.

Boot Camps

May 14 Virtual Advanced Data Visualizations

Welcome to our Advanced Power BI Data Visualizations Bootcamp, an exhilarating day class tailored for individuals passionate about crafting impactful and compelling data stories. In this immersive day session, you'll embark on a creative journey into the art and science of data visualization using Power BI. Led by expert instructors, this course will deepen your understanding of advanced visualization techniques, enabling you to transform complex data sets into visually stunning, interactive dashboards. Through hands-on projects and interactive workshops, you'll explore intricate concepts such as custom visuals, storytelling with data, and real-time analytics, honing your skills to present data in ways that captivate and inform. You'll also delve into the world of data-driven design principles, mastering the art of choosing the right charts, colors, and interactive elements to enhance user engagement and comprehension for different types of data. With a focus on practical applications and real-world scenarios, you'll gain the confidence to create visually compelling reports that resonate with your audience. Join us on this transformative journey and unlock the full potential of your data visualization capabilities, turning raw data into compelling narratives that drive informed decision-making. Pragmatic Works bootcamps include interactive, hands-on labs that let you apply what you’re learning in real time. With expert instructors available for guidance and support, you’ll build skills by doing—not just watching.

Boot Camps

May 15 Virtual Power BI Administration

Welcome to our Advanced Power BI Administration Bootcamp, an intensive day class designed for IT professionals and Power BI administrators looking to optimize their organization's Power BI environment. In this comprehensive program, you will dive deep into the intricacies of Power BI administration, mastering the skills necessary to manage, secure, and optimize your Power BI deployment effectively. Led by experienced instructors, this course covers advanced topics such as data governance, security policies, data refresh scheduling, and performance optimization. Through hands-on labs and interactive sessions, you will gain practical expertise in managing user access, configuring data gateways, and monitoring usage analytics. You'll also explore best practices for version control, backup, and disaster recovery, ensuring the reliability and availability of your Power BI services. Collaborative learning environments and real-world case studies will enhance your problem-solving abilities, preparing you to tackle complex administrative challenges with confidence. Join us on this transformative journey and empower yourself with the knowledge and skills to efficiently administer Power BI, enabling your organization to harness the full potential of its data-driven initiatives. Pragmatic Works bootcamps include interactive, hands-on labs that let you apply what you’re learning in real time. With expert instructors available for guidance and support, you’ll build skills by doing—not just watching.

Show more

Popular articles by Justin Vogel

What our clients say