Basics of Data Analytics Certificate

   
The American Society of Health-System Pharmacists is accredited by the Accreditation Council for Pharmacy Education as a provider of continuing pharmacy education with Commendation.

These activities are designed for pharmacists and pharmacy technicians who are interested in expanding their knowledge and skills in data analytics.

Introduction to Data Analytics
ACPE: 0204-0000-26-798-H04-P&T
Application-based
1.5 contact hours 

Learning Objectives:

• Define the data literacy dimensions from the Maturity Model for Data Literacy.
• Describe various tools for data analytics.
• List resources for additional learning, troubleshooting approaches, and technical tips.
• Summarize the lifecycle of data in the medication use process.
• Explain uses of data that pose ethical concerns. 

Step 1: Requirement Gathering
ACPE: 0204-0000-26-799-H04-P&T
Application-based
2.25 contact hours 

Learning Objectives:

• Differentiate the perspectives of business users and analysts for analytics asset development.
• Prioritize core questions for implementing the development of new analytics tools.
• Create an analytics request that meets business user and analyst needs. 

Step 2: Get the Data
ACPE: 0204-0000-26-800-H04-P&T
Application-based
0.5 contact hour 

Learning Objectives:

• Describe the purpose of databases.
• Explain the types of Structured Querying Language (SQL) database relationships.
• Describe how to use SQL to retrieve data.
• Summarize how SQL can be used for data aggregation. 

Step 3: From Chaos to Confidence—Unveiling Effective Strategies in Pharmacy Data Validation
ACPE: 0204-0000-26-801-H04-P&T
Application-based
1 contact hour 

Learning Objectives:

• Differentiate common Structured Query Language (SQL) issues and their impact on data accuracy.
• Apply strategic validation techniques (e.g., sampling, critical field validation) to validate row-level data.
• Apply cross-source validation techniques to confirm the absence of false positives and false negatives in population-level data. 

Step 4: Clean, Manipulate, and Analyze Data
ACPE: 0204-0000-26-802-H04-P&T
Application-based
4.25 contact hours 

Learning Objectives:

• Evaluate data to determine whether manipulation is required.
• Choose the appropriate data manipulation tool for a project.
• Identify the scope and strengths of numerical data types.
• Identify the scope and strengths of text data types.
• Summarize various techniques to interrogate and clean data in Microsoft Excel.
• Differentiate solutions to common data errors in Microsoft Excel.
• Apply appropriate data manipulation techniques to various dataset scenarios.
• Select the correct method to load data into python, given a specific source format.
• Use a Lambda function to manipulate date based on two columns.
• Compare different ways to select subsets of a DataFrame.
• Select appropriate packages and functions to clean data using R.
• Modify datasets through filtering, joining, and transformation using R.
• Analyze data using descriptive methods and inferential statistics in R. 

Artificial Intelligence
ACPE: 0204-0000-26-803-H04-P&T
Application-based
1 contact hour

Learning Objectives:

• Describe potential uses for artificial intelligence in pharmacy practice.
• Compare approaches for training machine learning models.
• Assess challenges and limitations of artificial intelligence in clinical practice. 

Step 5: Visualize & Communicate Concepts
ACPE: 0204-0000-26-804-H04-P&T
Application-based
3 contact hours 

Learning Objectives:

• Explain why visualization strategies matter in data communication.
• Describe the guiding principles for creating effective data visualizations.
• Assess various data visualization techniques for clarity of messaging.
• Compare approaches to the communication of data to best meet the customer’s needs.
• Identify best practices in data visualization for different analyses using Microsoft Excel.
• Contrast benefits and weaknesses of different data visualization types using Microsoft Excel.
• Explain capabilities within Tableau to load and connect data sources.
• Apply data manipulation techniques within Tableau to facilitate visualization of pharmacy data.
• Create an informative Tableau visual with pharmacy data.
• Assess methods to improve user interaction with a Tableau dashboard featuring pharmacy data.
• Choose a library for visualizing data with a Python-based communication approach.
• Use the R function ggplot2 to organize and visualize data.  

Project: Putting It All Together
ACPE: 0204-0000-26-805-H04-P&T
Application-based
2.5 contact hours 

Learning Objectives:

• Apply skills and concepts from the Maturity Model for Data Literacy to a project.
• Apply data analytics techniques in Microsoft Excel to effectively answer a case-based analytics scenario.

In accordance with our accreditor’s Standards of Integrity and Independence in Accredited Continuing Education, ASHP requires that all individuals in control of content disclose all financial relationships with ineligible companies. An individual has a relevant financial relationship if they have had a financial relationship with an ineligible company in any dollar amount in the past 24 months and the educational content that the individual controls is related to the business lines or products of the ineligible company. 

An ineligible company is any entity producing, marketing, re-selling, or distributing health care goods or services consumed by, or used on, patients. The presence or absence of relevant financial relationships will be disclosed to the activity audience. 

The following persons in control of this activity’s content have relevant financial relationships:

• Scott Nelson: Merative Micromedex, advisory counsel 

All other persons in control of content do not have any relevant financial relationships with an ineligible company. 

As defined by the Standards of Integrity and Independence in Accredited Continuing Education definition of ineligible company. All relevant financial relationships have been mitigated prior to the CE activity.

Each activity consists of audio, video, and/or PDFs and evaluations. Learners must review all content and complete the evaluations to receive continuing pharmacy education credit for each activity.

Follow the prompts to claim, view, or print the statement of credit within 60 days after completing the activity. 

Important Note – ACPE 60 Day Deadline:

Per ACPE requirements, CPE credit must be claimed within 60 days of being earned. To verify that you have completed the required steps and to ensure your credits have been reported to CPE Monitor, check your NABP profile account to validate that your credits were transferred successfully before the ACPE 60-day deadline. After the 60-day deadline, ASHP will no longer be able to award credit for this activity. 

ASHP PROFESSIONAL CERTIFICATES℠ contain learning activities that are ACPE-accredited knowledge and application-based continuing education. This is not an ACPE Certificate Program. Upon successful completion of the activities, the learner will be able to download an ASHP Professional Certificate.