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
Mar 02 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 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
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.
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)