Meet Emily Taylor
About
Emily graduated from Indiana University with a bachelor's degree in elementary education and the University of North Florida with a master's degree in educational leadership. After 11 years of teaching varying grades (K-5) in Indiana and Florida, she joined the Pragmatic Works team as a Power BI Trainer. Emily's primary goal is to provide engaging trainings that help customers gain confidence using Power BI. When not in the office, Emily enjoys camping, the beach, cheerleading, and visiting family in Indiana.
Certifications
PL-300: Power BI Data Analyst Associate
Microsoft
DP-900: Azure Data Fundamentals
Microsoft
PL-900: Power Platform Fundamentals
Microsoft
Course
Top Functions in Excel
In this course, Emily will guide you through the essential functions of Excel, empowering you to enhance data analysis efficiency and reduce errors across a wide range of tasks. You'll begin by mastering fundamental concepts such as formulas, functions, and cell referencing to build a strong foundation. From there, Emily introduces key text string functions like CONCAT and TRIM for manipulating and formatting data, followed by logical functions such as IF and AND to help with decision-making in formulas. You'll then explore common math functions, including SUM and AVERAGE, as well as statistical functions like COUNT and COUNTIF for analyzing data sets. Lookup and reference functions, including VLOOKUP and XLOOKUP, are covered to enable efficient data searches. You'll also dive into financial functions for calculating loans and investments, along with date and time functions to manage schedules and timelines. This comprehensive course will leave you well-equipped to manage and analyze data proficiently in Excel, whether for business or personal use.
Course
Learn With The Nerds - Excel to Power BI
Join us for our Learn With The Nerds – Power BI to Excel, a course designed to help you understand the basics of using Power BI and Excel together. In this course, you’ll learn how to bring data into Power BI, create simple visualizations, and then use Excel’s tools to further organize, analyze, and present that information. We’ll cover essential topics such as connecting to data sources, building easy-to-read dashboards, and enhancing your reports with interactive features in Excel. By the end of this course, you’ll feel more confident in your ability to handle data and share insights using both Power BI and Excel—no advanced technical skills required!
Course
Intergalactic Learn With The Nerds Day - Data Analytics With Excel
Emily Taylor will show you how to create pivot tables for dynamic data insights in Excel. The session will include writing essential functions to streamline data processing and cleaning data using Power Query Editor, while also covering quick data modeling and how to utilize Power Pivot.
Course
Data Connectors in Power BI
In Data Connectors in Power BI, instructor Emily Taylor walks you through how to connect Power BI to a wide range of data sources. From spreadsheets and databases to online services and cloud platforms, this course is a hands-on guide to bringing your data into Power BI quickly and correctly. Whether you're a beginner or just want a refresher, this course helps you get your connections right the first time.
Each module focuses on a specific type of connector, showing you the step-by-step process to connect, load, and start working with your data. Emily also highlights tips for navigating authentication, transforming incoming data, and ensuring your setup is reliable. By the end, you’ll be ready to work confidently with data from just about anywhere.
Course
Using a Live Connection in Power BI
In Using a Live Connection in Power BI, Emily Taylor shows you how to build reports on top of a shared, governed data model—so everyone works from the same, trusted source of truth. You’ll learn what a live connection is, how it differs from Import and DirectQuery, and when it’s the right choice for your project. Through simple, practical examples, you’ll connect to a published semantic model, explore fields, and create visuals that always reflect the latest approved data.
The course also highlights the real-world considerations: permissions and workspaces, row-level security behavior, and what you can—and can’t—change in the report layer when using a live connection. You’ll pick up tips for performance, collaboration, and handoffs between model authors and report builders. By the end, you’ll feel confident choosing a live connection and designing reports that are fast, consistent, and easy to maintain.
Boot Camps
Apr 06 Virtual Power BI Bootcamp
Creating Business Intelligence solutions no longer has to be a long, arduous process reserved exclusively for IT professionals. Power BI empowers you to build beautifully designed reports and dashboards independently, providing instant satisfaction for your data needs. This course introduces you to the Power BI ecosystem, guiding you from data discovery to developing solutions and solving complex business problems. You’ll start by importing data and applying business rules, then organize the results into a data model with relationships and calculations. Finally, you’ll learn the best practices for visualizing your data through various charts, graphs, maps, and gauges. Additionally, you’ll explore how to deploy solutions to the Power BI Service and create dashboards accessible from any device.
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
Apr 13 Virtual Python for Data Analyst Bootcamp
Welcome to the "Python for Data Analyst" bootcamp, a comprehensive and immersive four-day training program designed to equip aspiring data analysts with the essential skills and knowledge to excel in the field of data analysis using Python.
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 Python in data analysis.
Whether you are a beginner or have some prior experience, this bootcamp will help you master the tools and techniques needed to analyze, visualize, and interpret complex data sets effectively.
Boot Camps
May 18 Virtual Microsoft 365 Bootcamp
Welcome to the Ultimate Collaboration with M365 Workshop! This comprehensive 5-day workshop is designed to enhance your skills using Microsoft 365 applications to improve team collaboration, communication, and productivity.
Whether you want to attend the entire week, or just a day or two of the courses specific to your M365 learning needs, this course is for you! Throughout the workshop, you will gain hands-on experience with various M365 tools, including Teams, OneDrive, PowerPoint, Word, Excel, and Outlook.
By the end of this workshop, attendees will have learned how to effectively use Microsoft Teams for team collaboration and communication, understand the functionalities of OneDrive for cloud storage and file sharing, and master techniques for creating dynamic presentations in PowerPoint and professional documents in Word.
Additionally, you will gain proficiency in using Excel for data management and analysis, efficiently manage emails and calendars with Outlook, and integrate additional M365 apps for enhanced productivity. Join us to unlock the full potential of Microsoft 365 and take your collaboration skills to the next level!
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 18 Virtual Microsoft 365 Teams Bootcamp
Get acquainted with Microsoft 365 and its core applications. Learn how to use Microsoft Teams to improve team collaboration and communication. Practice setting up teams, scheduling meetings, and sharing files.
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 19 Virtual Microsoft 365 OneDrive Bootcamp
Discover the functionalities of OneDrive for cloud storage and file sharing. Explore OneNote as a tool for note-taking and organizing information. Practice real-world scenarios of document management and collaboration.
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 20 Virtual Microsoft 365 PowerPoint & Word Bootcamp
Learn to create dynamic and professional presentations using PowerPoint. Explore advanced features for enhancing presentations. Understand the capabilities of Word for document creation and collaboration.
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 21 Virtual Microsoft 365 Excel Bootcamp
Gain proficiency in using Excel for data management and analysis. Learn to create and interpret visual data representations. Discover the utility of Microsoft Forms for collecting and analyzing data.
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 22 Virtual Microsoft 365 Outlook Bootcamp
Learn to effectively manage emails and calendars using Outlook. Explore additional Microsoft 365 apps that complement Outlook. Practice integrating various tools for improved communication and productivity.
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 26 Virtual Microsoft Excel Bootcamp
The Introduction to Excel Bootcamp is an intensive course that is designed to get you to use Excel comfortably. You will first learn about the structure of Excel, then you will dive right into learning
different types of formulas and functions. Next, you will discover how to create models, tables, and charts to analyze your data better. You will also learn all about PivotTables, PivotCharts, and Power Pivot. This class will take you from Excel novice to PRO in four days!
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
Jul 07 Virtual Python for Data Analyst Bootcamp
Welcome to the "Python for Data Analyst" bootcamp, a comprehensive and immersive four-day training program designed to equip aspiring data analysts with the essential skills and knowledge to excel in the field of data analysis using Python.
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 Python in data analysis.
Whether you are a beginner or have some prior experience, this bootcamp will help you master the tools and techniques needed to analyze, visualize, and interpret complex data sets effectively.
Boot Camps
Jul 20 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
Jul 20 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
Jul 21 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
Jul 22 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
Jul 23 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
Jul 24 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.
Popular articles by Emily Taylor
What our clients say
Popular on-demand courses
Pragmatic Works On-Demand Learning courses offer beginner to advanced classes taught by Microsoft MVPs and authors.
.svg)
Get our special offers directly to your email
.png?width=564&height=618&name=Vector%20(2).png)
-2.png?width=380&height=384&name=Vector%20(14)-2.png)