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-23-836-H04-P & T
Activity Type: Knowledge-based

• 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.

Medication Use Process & Data Culture, Ethics, Security
ACPE: 0204-0000-23-837-H04-P & T
Activity Type: Application-based

• 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-23-838-H04-P & T
Activity Type: Application-based

• 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-23-839-H04-P & T
Activity Type: Application-based

• 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-23-840-H04-P & T
Activity Type: Application-based

• 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-23-841-H04-P & T
Activity Type: Application-based

• 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-23-842-H04-P & T
Activity Type: Application-based

• 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-23-843-H04-P & T
Activity Type: Application-based

• 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-23-844-H04-P & T
Activity Type: Application-based

• 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.
• Apply data analytics techniques in Python to effectively answer a case-based analytics scenario.
• Apply data analytics techniques in R 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 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. 

• Scott Nelson: Merative Micromedex, advisory counsel 

As defined by the Standards of Integrity and Independence definition of ineligible company. All relevant financial relationships have been mitigated prior to the CPE activity.

This online activity consists of a combined total of 9 learning modules. Pharmacists and Pharmacy Technicians are eligible to receive a total of 16.25 hours of continuing education credit by completing all 9 modules within this professional certificate. 

Participants must participate in the entire activity and complete the evaluation and all required components to claim continuing pharmacy education credit online at ASHP Learning Center. Follow the prompts to claim credit and view your statement of credit within 60 days of 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.