Categories

Choose a category, or scroll down for all posts.

Data Analytics | Excel | Git | News | Python | SQL | Statistics | Uncategorized | Webinars

AI Governance Frameworks for Responsible Enterprise Adoption

April 10th, 2026 by Boxplot

Artificial intelligence is rapidly moving from an experimental technology to a core driver of enterprise strategy. From optimizing supply chains to personalizing customer experiences, AI promises significant competitive advantages. Yet, with this promise comes a complex web of risks – ethical dilemmas, regulatory compliance challenges, data privacy concerns, and the potential for biased outcomes. For […]

Read More


Designing an Optimal Data Architecture for Enterprise AI Success

April 9th, 2026 by Boxplot

For enterprises aiming to harness the full potential of Artificial Intelligence, a robust and well-designed data architecture is not merely a technical detail – it’s the fundamental enabler. An optimal AI data architecture provides the high-quality, accessible, and governed data foundation necessary for training, deploying, and maintaining effective machine learning models at scale, directly impacting […]

Read More


Optimizing Your Data Labeling Strategy for Enterprise AI Success

April 8th, 2026 by Boxplot

Optimizing Your Data Labeling Strategy for Enterprise AI Success Data labeling is the process of tagging or identifying raw data (images, text, audio, video) to provide context for AI models to learn from. For enterprises, a robust data labeling strategy is critical for building accurate, unbiased, and high-performing AI systems, directly impacting model efficacy, development […]

Read More


Real-Time Analytics for Enterprise: Unlock Business Agility

April 7th, 2026 by Boxplot

In today’s hyper-competitive business landscape, the pace of decision-making can be the difference between leading and falling behind. While traditional Business Intelligence (BI) has served enterprises well for decades, its batch-oriented nature often means insights are stale before they can drive truly agile action. Real-time analytics, however, provides immediate, up-to-the-second insights, empowering executives to react […]

Read More


Building an Enterprise AI Strategy: From Vision to Value

April 6th, 2026 by Boxplot

In today’s rapidly evolving business landscape, Artificial Intelligence (AI) has moved from an experimental concept to a strategic imperative. Yet, for many C-level executives and senior leaders, the path from abstract AI potential to concrete business value remains unclear. An effective enterprise AI strategy is not merely about adopting new technologies; it’s about architecting a […]

Read More


Driving Impact: Building an AI Value Measurement Framework for Enterprises

April 3rd, 2026 by Boxplot

An AI value measurement framework is a structured approach for quantifying the tangible business impact and return on investment (ROI) of artificial intelligence initiatives within an enterprise. It encompasses defining clear metrics, establishing baselines, attributing financial and operational gains, and continuously monitoring performance against strategic objectives. This framework is essential for justifying AI investments, optimizing […]

Read More


Navigating the AI Talent Gap: Strategies for Building an Enterprise AI Team

April 2nd, 2026 by Boxplot

The AI talent gap is a critical challenge for enterprises aiming to leverage artificial intelligence. Effectively addressing this involves a multi-pronged strategy focused on attraction, development, and retention. Leaders must proactively assess skill needs, foster an AI-ready culture, and implement structured programs to build and sustain high-performing AI teams. The Business Problem: Why the AI […]

Read More


Establishing Robust AI Governance in the Enterprise

April 1st, 2026 by Boxplot

The Imperative for AI Governance in Today’s Enterprise In today’s fast-evolving digital landscape, Artificial Intelligence (AI) offers unparalleled opportunities for enterprise innovation, efficiency, and competitive advantage. However, without a strong foundation of AI governance, organizations face significant risks, including regulatory non-compliance, reputational damage, ethical dilemmas, and operational inefficiencies. An effective AI governance framework provides the […]

Read More


Building an Enterprise AI Strategy: From Vision to Value

March 31st, 2026 by Boxplot

In today’s rapidly evolving business landscape, Artificial Intelligence (AI) is no longer a futuristic concept but a strategic imperative. For C-level executives and senior leaders, the challenge isn’t whether to adopt AI, but how to do so effectively, translating significant investment into tangible, sustainable business value. A well-defined enterprise AI strategy is the blueprint for […]

Read More


Crafting Your Enterprise AI Strategy: A Practical Guide for Executives

March 30th, 2026 by Boxplot

Why a Coherent Enterprise AI Strategy is Non-Negotiable In today’s competitive landscape, Artificial Intelligence (AI) is no longer an optional add-on but a critical driver of efficiency, innovation, and competitive advantage. C-level executives and senior leaders are keenly aware of AI’s potential, yet many organizations struggle to move beyond pilot projects to systemic, value-generating adoption. […]

Read More


Unlocking Value from Legacy Systems: An Enterprise Data Integration Strategy

March 27th, 2026 by Boxplot

In today's data-driven economy, the ability to rapidly derive insights and fuel intelligent systems is paramount for competitive advantage. Yet, many organizations remain hobbled by a common challenge: a fragmented data landscape, often rooted in disparate, legacy systems. This isn't merely a technical nuisance; it's a significant business impediment, leading to delayed decision-making, operational inefficiencies, […]

Read More


Designing an Effective AI Strategy: A Blueprint for Business Leaders

March 26th, 2026 by Boxplot

The Imperative of a Coherent AI Strategy In today’s rapidly evolving business landscape, Artificial Intelligence (AI) is no longer a futuristic concept but a present-day imperative. Yet, for many C-suite executives and senior leaders, the journey into enterprise AI feels less like a strategic voyage and more like navigating a dense fog. Ad-hoc AI initiatives, […]

Read More


Modernizing Business Intelligence: A Strategic Framework for Enterprise Leaders

March 25th, 2026 by Boxplot

In today’s fast-paced business landscape, the ability to derive timely, accurate, and actionable insights from data is no longer a luxury—it’s a strategic imperative. Yet, many organizations find their Business Intelligence (BI) capabilities struggling to keep pace, leading to slow decision-making, unreliable reports, and missed opportunities. Modern BI strategy goes beyond dashboard creation; it’s a […]

Read More


Building a Scalable Feature Store: Fueling Consistent ML Models and Data Science Productivity

March 24th, 2026 by Boxplot

An Enterprise Feature Store is a centralized data management system designed to serve consistent, curated features for machine learning models across an organization. It boosts data science productivity by reducing data preparation time, ensures model consistency by standardizing feature definitions, and accelerates AI development cycles by enabling feature reuse and real-time serving. The Core Challenge: […]

Read More


Establishing an AI Center of Excellence: A Blueprint for Enterprise Scalability and ROI

March 23rd, 2026 by Boxplot

An AI Center of Excellence (CoE) is a cross-functional organizational unit dedicated to standardizing, governing, and accelerating AI adoption across an enterprise. It centralizes expertise, defines best practices, manages risk, and fosters innovation, ensuring that AI initiatives are strategically aligned, efficiently executed, and deliver measurable business value at scale. The Business Imperative: Why Your Enterprise […]

Read More


Building an Enterprise AI Strategy: A Roadmap for C-Suite Leaders

March 20th, 2026 by Boxplot

Artificial Intelligence is no longer a futuristic concept; it’s a present-day strategic imperative. Yet, for many C-suite leaders, the path to leveraging AI across the enterprise remains fragmented. Organizations often find themselves grappling with isolated proof-of-concept projects, ambiguous returns on investment, and a growing concern over data ethics and governance. Without a cohesive enterprise AI […]

Read More


Crafting an Enterprise AI Strategy: A Roadmap for Sustainable Impact

March 19th, 2026 by Boxplot

In today’s competitive landscape, Artificial Intelligence (AI) is no longer a futuristic concept but a present-day imperative for businesses aiming for sustainable growth and operational excellence. Yet, for many C-suite executives and senior leaders, the path to successful AI adoption is fraught with uncertainty. Fragmented pilot projects, unmeasurable ROI, and a lack of clear strategic […]

Read More


Data Governance for AI: Ensuring Trust and Quality for Enterprise AI Systems

March 18th, 2026 by Boxplot

The Imperative: Why Data Governance is Non-Negotiable for Enterprise AI As enterprises increasingly invest in artificial intelligence, a critical truth often gets overlooked: the success of any AI initiative hinges entirely on the quality and integrity of its underlying data. Without robust data governance, AI models can produce biased, inaccurate, or non-compliant results, undermining trust, […]

Read More


Strategic AI Adoption for Enterprises: Beyond Hype to Tangible ROI

March 17th, 2026 by Boxplot

Strategic AI Adoption for Enterprises: Beyond Hype to Tangible ROI As C-level leaders, you’re constantly evaluating how emerging technologies can deliver competitive advantage and drive shareholder value. Artificial Intelligence (AI) has moved beyond buzzwords to become a critical component of enterprise strategy. However, merely investing in AI tools isn’t enough; successful enterprise AI adoption requires […]

Read More


Driving Value with Data Products: An Executive Guide to Data-as-a-Product

March 16th, 2026 by Boxplot

A data product strategy in an enterprise treats curated datasets, analytics, and ML models as consumable products, each with a clear business purpose, defined owners, and measurable value. This approach streamlines data access, enhances quality, and empowers self-service, transforming raw data into actionable assets that drive strategic decision-making and innovation. The Shifting Paradigm: From Data […]

Read More


Building an Enterprise Metrics Store: Driving Consistent Business Intelligence

March 13th, 2026 by Boxplot

The Persistent Problem: Inconsistent Metrics and Fragmented Truths As a senior leader, you’ve likely experienced it: a critical meeting where two different departments present conflicting numbers for the same key performance indicator (KPI). our customer acquisition cost? you ask, only to get answers that vary by 15% or more, each defended by different methodologies or […]

Read More


Building an AI-Ready Data Culture: A Strategic Imperative for Enterprise Leaders

March 12th, 2026 by Boxplot

The Imperative: Why an AI-Ready Data Culture Matters Artificial Intelligence (AI) is no longer a futuristic concept; it’s a present-day strategic imperative transforming enterprises across every sector. Yet, even with substantial investments in technology, many organizations struggle to move beyond pilot projects to unlock AI’s full potential. The missing link often isn’t the technology itself, […]

Read More


Unlocking Value: The Executive’s Guide to Enterprise AI Adoption

March 11th, 2026 by Boxplot

The Imperative for Strategic AI Adoption Artificial Intelligence (AI) has moved beyond experimental labs to become a critical component of modern enterprise strategy. However, merely investing in AI tools isn’t enough; true value comes from a thoughtful, strategic enterprise AI adoption strategy that aligns with business objectives. For C-level executives, the challenge lies in translating […]

Read More


Crafting an Enterprise AI Strategy: A Blueprint for Sustainable Business Growth

March 10th, 2026 by Boxplot

In today’s rapidly evolving business landscape, Artificial Intelligence (AI) is no longer a futuristic concept but a present-day imperative for competitive advantage. Yet, for many C-level executives and senior leaders, the path to enterprise-wide AI adoption remains fragmented. Without a cohesive enterprise AI strategy, organizations risk isolated pilot projects, inefficient resource allocation, and ultimately, a […]

Read More


Operationalizing Generative AI: From Proof-of-Concept to Production Value in the Enterprise

March 5th, 2026 by Boxplot

The Generative AI Production Challenge: Beyond the Hype Generative AI (GenAI) has rapidly moved from a futuristic concept to a compelling strategic imperative for enterprises. Leaders recognize its transformative potential—from automating content creation and summarizing vast datasets to accelerating research and enhancing internal knowledge management. Yet, many organizations find themselves caught in the "pilot trap," […]

Read More


Implementing Explainable AI (XAI) for Trust and Transparency in Enterprise AI Systems

March 2nd, 2026 by Boxplot

Explainable AI (XAI) refers to methods and techniques that allow human users to understand, interpret, and trust the results and outputs generated by machine learning algorithms. For enterprises, implementing XAI is crucial for demystifying complex AI models, ensuring regulatory compliance, managing risks, and fostering greater adoption and confidence in AI-driven decision-making processes across the organization. […]

Read More


Scaling Machine Learning: From Pilot to Production for Enterprise Impact

February 25th, 2026 by Boxplot

MLOps, or Machine Learning Operations, is a set of practices that operationalize machine learning models, enabling enterprises to move AI projects from experimental pilots to reliable, scalable production systems. It streamlines the entire ML lifecycle, ensuring continuous delivery, monitoring, and governance, ultimately maximizing the return on investment from AI initiatives and driving tangible business impact. […]

Read More


Building a Data Strategy for Sustainable Growth

February 18th, 2026 by Boxplot

In today’s fast-paced business environment, a well-crafted data strategy is crucial for sustainable growth. It serves as the backbone for informed decision-making and operational efficiency. This article delves into the key components of building a robust data strategy that aligns with your business objectives and ensures a competitive edge. The Importance of a Data Strategy […]

Read More


Building a Data Strategy That Drives Business Growth

February 17th, 2026 by Boxplot

Creating a robust data strategy is crucial for any business aiming to align its data assets with overarching business goals, enhance decision-making, and drive growth. In this article, we explore practical frameworks and actionable steps to help executives harness the power of a well-designed data strategy. Understanding the Importance of a Data Strategy A data […]

Read More


Unlocking Business Insights: A Guide to Forecasting and Experimentation

February 16th, 2026 by Boxplot

In today’s rapidly evolving business landscape, forecasting and experimentation are crucial tools for executives seeking to make informed strategic decisions. This guide explores how to leverage these techniques effectively to generate actionable insights and drive business growth. The Importance of Forecasting and Experimentation Forecasting and experimentation allow businesses to navigate uncertainty and test hypotheses before […]

Read More


Mastering Data Quality: A Strategic Framework for Executives

February 13th, 2026 by Boxplot

Data quality is not just an IT concern; it is a strategic asset that directly impacts business outcomes. Poor data quality can lead to misguided decisions, regulatory issues, and a loss of trust. Executives need a comprehensive framework to ensure data quality aligns with enterprise goals. Understanding Data Quality in the Executive Context Executives must […]

Read More


Driving Business Growth with Predictive Analytics: A Guide for Executives

February 12th, 2026 by Boxplot

Predictive analytics offers a powerful tool for executives seeking to drive business growth through data-driven insights and strategic decision-making. Leveraging predictive modeling, businesses can anticipate future trends, optimize operations, and achieve significant ROI. Understanding Predictive Analytics Predictive analytics involves using historical data, statistical algorithms, and machine learning techniques to identify the likelihood of future outcomes. […]

Read More


Leveraging Predictive Analytics for Strategic Decision-Making in Midmarket Enterprises

February 11th, 2026 by Boxplot

Predictive analytics is transforming the way midmarket enterprises make strategic decisions, offering a competitive edge through data-driven insights. The Business Imperative for Predictive Analytics In today’s fast-paced business environment, midmarket enterprises face pressure to make informed decisions quickly. Predictive analytics helps by offering insights derived from historical data, enabling companies to forecast trends and optimize […]

Read More


Harnessing Responsible AI: A Guide for Executives

February 5th, 2026 by Boxplot

In today’s rapidly evolving technological landscape, the implementation of Artificial Intelligence (AI) in enterprises is no longer a question of ‘if’ but ‘when.’ However, with this adoption comes significant responsibility. This guide explores how executives can harness AI responsibly, ensuring that their organizations leverage AI’s full potential while managing associated risks. Understanding Responsible AI Responsible […]

Read More


Building a Robust Analytics Engineering Team: A Guide for Executives

February 4th, 2026 by Boxplot

In today’s data-driven landscape, building a robust analytics engineering team is crucial for organizations aiming to leverage data effectively. This guide provides a strategic framework for executives to develop a successful team that aligns with business goals. The Importance of Analytics Engineering in Modern Business Analytics engineering bridges the gap between raw data and actionable […]

Read More


Maximizing Business Value with Data Governance: A Practical Guide for Executives

February 3rd, 2026 by Boxplot

In today’s data-driven business landscape, effective data governance is not just a regulatory necessity but a strategic asset. Executives who prioritize data governance can enhance data quality, build trust, and improve decision-making processes, ultimately maximizing business value. Understanding Data Governance and Its Business Impact Data governance encompasses the policies and procedures that ensure data accuracy, […]

Read More


n8n Security

October 31st, 2025 by Sofia Laval

n8n is a powerful and flexible automation platform that stands out for its ability to be self hosted and to support custom connectors, giving users freedom to tailor their workflows to their exact needs. Before getting started, it’s important to understand how n8n handles security and data protection. This post breaks down how n8n secures […]

Read More


Tableau Pulse

September 15th, 2025 by Sofia Laval

Quick, AI-Powered Metric Insights In a world where executives and teams need answers at a glance, Tableau Pulse delivers. Built for leaders or anyone who wants quick, easy-to-digest updates on a handful of key metrics. Pulse removes the noise into focused insights. What Tableau Pulse Does Think of Pulse as an AI-powered metric hub. Instead […]

Read More


Tableau + AI: A New Era of Business Intelligence

September 3rd, 2025 by Sofia Laval

The AI Shift in Analytics Artificial Intelligence is changing how businesses operate and companies are racing to implement and adapt quickly and strategically. Tableau, long known as a leader in data visualization, is now embedding AI directly into its ecosystem to meet the demands of today’s fast-changing business environment. Tableau Next: One Platform, Powered by […]

Read More


AI Agents: The Good, the Bad, and the Unknown – Insights from Arthur’s Webinar

January 7th, 2025 by Boxplot

Artificial Intelligence is one of the fast-developing areas, and it is now all about the agents that are acting and redefining the interaction of humans with technology. From transforming industries to raising ethical questions, these agents are both promising and complex. Boxplot attended Arthur’s recent webinar, “A Quick Primer on Agents: The Good, the Bad, […]

Read More


IBM and AI: watsonx

November 21st, 2024 by Boxplot

As AI continues to reshape industries globally, IBM has positioned itself at the front of this revolution through its groundbreaking AI platform, watsonx. Designed to make AI more accessible and effective for businesses, IBM’s innovations are set to redefine the future of enterprise operations. What is watsonx?  IBM watsonx is an open, scalable platform that […]

Read More


Prompt Sanitization: Safeguarding AI from Manipulative Inputs

November 19th, 2024 by Boxplot

In the rapidly advancing field of AI, especially with the growing prominence of Large Languages Models (LLMs), protecting these systems from vulnerabilities is crucial. While LLMs offer powerful capabilities, they are also susceptible to security leaks, leading to unintended outcomes. This is where prompt sanitization plays a vital role.  What is Prompt sanitization?  Prompt sanitization […]

Read More


Oracle and AI Innovation

November 17th, 2024 by Boxplot

As artificial intelligence continues transforming industries, the convergence of AI and advanced cloud platforms has become a game-changer for businesses worldwide. Oracle, a leader in enterprise cloud infrastructure, is at the forefront of this shift, seamlessly integrating AI capabilities into its robust cloud solutions.    Oracle and AI: A New Era of Enterprise Intelligence  Long recognized […]

Read More


Guide to AI Notetakers

November 9th, 2024 by Boxplot

Introduction With the rise of virtual meetings, AI notetakers have become valuable tools for organizations seeking efficiency through automated transcription and meeting summaries. However, privacy concerns have also emerged, prompting some companies to consider apps that block AI notetakers during sensitive discussions. This post compares the AI notetakers used in online meetings and the apps […]

Read More


Understanding and Combating Prompt Injections in Large Language Models (LLMs)

July 28th, 2024 by Boxplot

Large Language Models (LLMs), such as GPT-4, have revolutionized various industries with their ability to understand and generate human-like text. However, as with any technology, they come with their own set of vulnerabilities. One of the most pressing concerns in the realm of LLMs is prompt injection, a form of attack where malicious input is […]

Read More


Subito Motus + Boxplot Partnership

May 6th, 2024 by Boxplot

For Immediate Release Subito Motus and Boxplot Announce Partnership Philadelphia, PA – Quarter 2, 2024 – Subito Motus, a technology consulting firm focused on digital transformation, and Boxplot, a data and technology consulting firm focused on data-driven problem-solving, proudly announce a strategic partnership aimed at offering unparalleled technology solutions to businesses worldwide. This strategic alliance […]

Read More


Unconventional Visualizations – Network Diagram

April 24th, 2024 by Boxplot

Sometimes, we need to think outside the box for data visualizations! This is a visualization we did using a little-known tool called Kumu. It was for a nonprofit gardening project – they needed a way to visualize information about companion planting from a book. The book laid out the information linearly – for example, “x […]

Read More


Pulling Data Via An API In Python

February 17th, 2024 by Boxplot

What Is an API? An API, or Application Programming Interface, is a powerful tool that enables organizations to access and interact with data stored in various locations in real time. In other words, APIs allow different computer programs to communicate with each other seamlessly. For example, your business may have accounting software, a CRM, a […]

Read More


How B2B organizations can use their data

November 25th, 2023 by Boxplot

B2B organizations possess a unique advantage when it comes to leveraging data. Data on their institutional clients is often readily available. Some of the most valuable data-driven outcomes for B2B organizations include sector analytics, both retrospective and predictive, prospect analytics, and automated data cleaning. In this blog post, we’ll explore how B2B organizations can gain […]

Read More


A/B Testing Example (Two Mean Hypothesis Test)

November 4th, 2023 by Boxplot

A/B testing (sometimes called split testing) is comparing two versions of a web page, email newsletter, or some other digital content to see which one performs better. A company will compare two web pages by showing the two variants (let’s call them A and B) to similar visitors at the same time. Sometimes, the company […]

Read More


What Is Python, And Why Is It Awesome?

November 3rd, 2023 by Boxplot

What is Python? Python is a relatively intuitive, general-purpose programming language that allows users to do anything from analyzing data to building websites. In the context of data, it allows for complete flexibility and customizability when performing analyses. Here are some good resources that dive deeper into what Python is if you are interested: https://www.coursera.org/articles/what-is-python-used-for-a-beginners-guide-to-using-python […]

Read More


Github Tutorial

October 16th, 2023 by Boxplot

What Is GitHub And Why Is It Useful? GitHub is the world’s most widely used code hosting platform, enabling developers to store, write, view, and collaborate on code for free. It is built on Git, the underlying version-control system (Git is the tool; GitHub is the web platform). By centralizing code in a shared, access-controlled […]

Read More


Excel Templates for Data Analysis

July 17th, 2023 by Boxplot

When working in Excel, no one likes to start their analyses from scratch every time. Instead, data analysts can sometimes enhance the efficiency of their work by using templates for Excel tasks that they would otherwise complete manually. These templates give analysts all the intuitiveness that Excel offers while enhancing the ease and speed with […]

Read More


Small Business Social Media Metrics

April 23rd, 2023 by Boxplot

A superior social media analytics practice is one of the best ways for small businesses to gain an edge over larger competitors. And the growing accessibility of advanced analytical tools makes social media analytics a worthwhile pursuit even if on a tight budget. This blog post covers some of the most useful social media-specific metrics […]

Read More


Line Graphs

April 1st, 2023 by Boxplot

What Is A Line Graph? A line graph is a series of data points on an x–y axis, connected by a line. There are two kinds of line graphs: colored-in (also known as area charts) and standard. While the area under the line of a colored-in line graph is shaded in, the area under a standard line […]

Read More


Tips For Building Likert Surveys

April 1st, 2023 by Boxplot

Likert Surveys ―pronounced LICK-ert― are one of the most popular ways of collecting survey data. Their simple design of providing a series of prompts with a discrete scale of responses for each prompt (such as “Strongly Disagree”, “Disagree”, “Neutral”, “Agree”, and “Strongly Agree”; “Poor”, “Fair”, “Average”, “Good”, and “Excellent”, etc.) makes Likert Surveys an extremely popular […]

Read More


Interpreting Linear Regression Results

April 1st, 2023 by Boxplot

A Brief Introduction To Linear Regression Linear regressions discover relationships between multiple variables by estimating a line or other function of best fit to a set of data. For example, the orange line is what a linear regression’s result would look like for the data shown in blue: This function of best fit (shown here […]

Read More


How B2C Businesses Can Use Their Data

March 20th, 2023 by Boxplot

In order to understand your customers fully and correctly, the data and analytics you maintain about those customers are extremely important. For B2C organizations especially ―which sell directly to customers― customer data and analytics are a necessary component of sales, marketing, and managerial strategies for both pre- and post-market decision making. There is a long […]

Read More


Conditional Formatting with Excel

March 18th, 2023 by Boxplot

Conditional formatting is an Excel feature that allows users to customize the formatting of a single cell or group of cells based on whether a certain rule is satisfied. This feature is extremely useful in terms of automation, because the formatting of the selected cells changes automatically if the chosen condition is no longer satisfied […]

Read More


Histograms

March 12th, 2023 by Boxplot

A histogram is a type of bar chart that shows the distribution ―i.e., the probability of a variable being within a certain range of values, out of all possible values― of a certain variable. For example, we can use a histogram to show customer wait times at a restaurant: This histogram indicates that approximately 4 […]

Read More


Boxplot Makes List of 64 Best Pennsylvania Database Startups

April 29th, 2022 by Boxplot

This month, April 2022, Boxplot was listed as one of Pennsylvania’s best database startups. Startup Pill is an online international resource for startup founders, investors, and consultants.  The companies on this list were selected based on innovation, growth, management, and social impact. Take a scroll through their article to see our feature! About Boxplot Boxplot […]

Read More


WBENC Social Media Presentation

September 19th, 2021 by Boxplot

Watch the Webinar View the text for the video In June 2021, Barb was a guest speaker for the WBENC webinar series: From Pandemic to Progress. This webinar is geared towards small business owners who want to analyze their company’s social media data to use it for their advantage. The webinar goes into detail from […]

Read More


Setting up PostgreSQL & pgAdmin

July 4th, 2021 by Boxplot

What’s the difference between PostgreSQL and pgAdmin? PostgreSQL is a free-to-use relational database management system (DBMS); pgAdmin is a graphical user interface (GUI) tool that lets users interact with their PostgreSQL database(s). In other words, PostgreSQL is the actual database system, and pgAdmin is a tool that lets users use that system. How do I […]

Read More


Data Hour (September)

June 10th, 2021 by Boxplot

Watch the Webinar Barb returns to PowerToFly as a guest speaker in the “Data Hour” webinar. The first half of this “Data Hour” webinar consists of answers that Barb has for some general and more specific data analysis-related questions that the audience has. Some of the audience questions in this webinar include: “What is the […]

Read More


PivotTables in Excel

February 1st, 2021 by Boxplot

What is a PivotTable? A Pivot Table is an analytics tool that can quickly answer key business questions. They are excellent at extracting insights from a vast dataset quickly. PivotTables are one of the most efficient and effective ways to evaluate large quantities of data in Excel. By “pivoting” or aggregating a large data table […]

Read More


Are Decision-Makers Disempowered by the Modern Data Stack?

September 23rd, 2020 by Boxplot

Future Data 2020 Many winter moons ago, I (virtually) attended Future Data 2020, a conference about the next generation of data systems. During the conference, I watched an interesting talk given by Tristan Handy, founder and CEO of Fishtown Analytics, called The Modern Data Stack: Past, Present, and Future. During the talk, Tristan discussed a so-called […]

Read More


Pie Charts

September 4th, 2020 by Boxplot

Show/Hide Code   Introduction It seems as if people are split on pie charts: either you passionately hate them, or you are indifferent. In this article, we are going to explain why pie charts are problematic and, if you fall into the latter category, what you can do when creating pie charts to avoid upsetting those […]

Read More


Protected: Wording Surveys Well Makes Them More Effective: Part 4

June 18th, 2020 by Boxplot

There is no excerpt because this is a protected post.

Read More


Protected: Wording Surveys Well Makes Them More Effective (Part 3)

May 13th, 2020 by Boxplot

There is no excerpt because this is a protected post.

Read More


Protected: Wording Surveys Well Makes Them More Effective (Part 2)

April 24th, 2020 by Boxplot

There is no excerpt because this is a protected post.

Read More


Protected: Wording Surveys Well Makes Them More Effective

April 15th, 2020 by Boxplot

There is no excerpt because this is a protected post.

Read More


Intro To SQL

November 22nd, 2019 by Boxplot

Watch the Webinar PowerToFly has Barb on as a guest speaker in the “Intro to SQL” webinar. In this webinar, Barb answers various questions regarding SQL including: “What is SQL?”, “What kind of jobs use SQL?” and “What is a SQL query and what do I need to make one?”, followed by more specific questions […]

Read More


Useful Python Snippets

October 26th, 2019 by Boxplot

The goal of this blog post is a compilation of little tidbits and code snippets that address common issues when programming for data analysis in Python. General Snippets Difference between JSON and XML This page gives a great example of the difference between data in JSON format and XML format. It shows the exact same […]

Read More


A/B Testing Example (Two Proportion Hypothesis Test)

September 25th, 2019 by Boxplot

A/B testing (sometimes called split testing) is comparing two versions of a web page, email newsletter, or some other digital content to see which one performs better. A company will compare two web pages by showing the two variants (let’s call them A and B) to similar visitors at the same time. Typically, the company […]

Read More


Population Mean Hypothesis Test Example

September 25th, 2019 by Boxplot

The Situation: Kakes+, a Pennsylvania company that makes terribly unhealthy small pies/cakes, believes that their machines are overfilling their blueberry pies. Kakes+ wants to test this statistically, and has recruited you to come up with a data-backed answer. The pies should weigh 8 ounces each. Step 1: Collect Data You need to weigh the pies […]

Read More


Common Python Errors

September 1st, 2019 by Boxplot

This post is updated as appropriate, so keep checking back! Table of Contents Errors when installing python with homebrew Error: Permission denied Error: Could not symlik bin Errors when writing/running python code TypeError NameError IndentationError SyntaxError IndexError KeyError ValueError Installing Python Error: Permission denied @ dir_s_mkdir – /usr/local/Frameworks Check out this article for help: https://github.com/Homebrew/homebrew-core/issues/19286   […]

Read More


Tables & Linking Data Structures in Excel

September 1st, 2019 by Boxplot

Tables are one of the most important features of Excel, but are often overlooked. Tables and keeping analyses in Excel connected, will drastically increase your efficiency in Excel. Let’s start by understanding how they work with PivotTables. We’re going to use an R Dataset called DoctorContacts. Download the .csv file using this link (and save […]

Read More


Using DB Browser for SQLite

September 1st, 2019 by Boxplot

DB Browser for SQLite (it’s also called SQLite Browser for short) is an excellent tool for practicing SQL without having to get connected to a real live server. This post will walk through how to install, open, and use SQLite Browser. Install SQLite Browser Go to the SQLite Browser website and choose the download for […]

Read More


Git Resources

September 1st, 2019 by Boxplot

Resources for Learning Git Atlassian’s GitFlow Page This is a short tutorial article focused on a typical Git sequences.   try.github.io A list of Git Resources, broken down by type.

Read More


Grouping in PivotTables

September 1st, 2019 by Boxplot

Grouping in PivotTables is a way of combining data to perform analyses without having to use functions. You can group numeric columns to turn them into categories, you can group date columns by date ranges to get even intervals, and you can group text columns to put together similar values. We’ll go through all three […]

Read More


Installing & Running Jupyter Notebook

September 1st, 2019 by Boxplot

Step 1: Install Anaconda Go to this download webpage on Anaconda’s site. Choose the correct link for your operating system, and then go through the installation process. Step 2: Prepare a folder for notebooks Choose or create a folder on your computer where you will store all Jupyter notebook files. Make sure you choose a place […]

Read More


Make a Bubble Plot in Excel

September 1st, 2019 by Boxplot

Most people don’t know that bubble plots even exist in Excel. In this blog post, we’ll walk through how to take advantage of these very effective charts! They are great for comparing three quantitative variables at once. For a nice intro to bubble plots, check out Hans Rosling’s very famous Ted Talk. If you don’t […]

Read More


Python Resources

September 1st, 2019 by Boxplot

Python Resources Driven Data This is a great way to tackle Machine Learning and Python at the same time!  I also like Driven Data because it’s a project with a specific goal. I think that’s the best way to learn!   Automate the Boring Stuff with Python This is another project-based site that also is […]

Read More


Understanding JOINs in SQL

September 1st, 2019 by Boxplot

Joins in SQL Joins are one of the most important (if not THE most important) concepts in SQL. If you take the time to solidly understand how joins work, you’ll be in an excellent place for writing queries. We also have an in-depth article about performing multiple joins. So, let’s dive in! Join Definitions Joining […]

Read More


Understanding Multiple JOINs in SQL

September 1st, 2019 by Boxplot

Multiple joins are one of the toughest SQL concepts – in this post we’ll decode them and review some common pitfalls. One of the best ways to learn is with an example. If you’d like to follow along, you can download this zip file that contains the three tables as .csv files here, and import […]

Read More


Free Datasets

September 1st, 2019 by Boxplot

A list of freely available data on the web. The first list is sites we think are the best for accessing quality datasets. Below that are additional sources by category. Best Sources Kaggle By far our personal favorite! There are dozens if not hundreds of quality datasets available here. ICPSR You have to create an account, […]

Read More


Formatting Charts in Excel

September 1st, 2019 by Boxplot

Formatting charts in Excel is no easy task. It’s time-consuming, and Excel is pretty fussy which doesn’t make things easier. In this post I’ll give general tips for formatting charts, and also go over a few common scenarios. Understand the Parts of a Chart First thing’s first: it’s important to get the syntax down pat […]

Read More


Excel File Setup for Analysis

September 1st, 2019 by Boxplot

Excel gives you a lot of flexibility when creating files and starting projects, and we’re often asked what the “best” solution is for keeping things organized. This post will review what we recommend. As with everything in life, there may be a few exceptions where you’ll want to set up your file differently. However, this […]

Read More


What is SQL?

August 31st, 2019 by Boxplot

What is SQL? Currently, if you Google this question, you’ll get a whole slew of technical articles that aren’t very helpful for understanding just what SQL is and when people use it. We’ll break that down in this blog post. This is a high level overview – if you want to understand how to actually […]

Read More


Data Hour (July)

July 25th, 2019 by Boxplot

Barb returns to PowerToFly as a guest speaker for another “Data Hour” webinar. This “Data Hour” webinar consists of answers that Barb has for some general and more specific data analysis-related questions that the audience has. In this webinar, Barb answers many questions about data visualisation such as some of her favorite tools for compiling […]

Read More


Data Chat

April 4th, 2019 by Boxplot

Barb returns to PowerToFly as a guest speaker, this time, for a “Data Hour” webinar. This webinar consists of answers that Barb has for some general and more specific data analysis-related questions that the audience has. What’s unique about these Data Hour webinars is that audience members are able to get specific answers to questions […]

Read More


Data Visualization in Python Lunch + Learn

February 20th, 2019 by Boxplot

Data analytics expert, Barbara Donnini, joins PowerToFly as a guest speaker for a Python Visualization Seminar. This interactive seminar combines Python, Jupyter, and Pandas and focuses on visualizing and plotting. Some tasks that audience members learn throughout the course of this webinar include: importing and loading data and coding line plots, bar plots, histograms, scatter […]

Read More


100th Anniversary of Variance

December 28th, 2018 by Boxplot

This year (2018) is the 100th anniversary of a paper by R. A. Fisher, which introduced the statistical term “variance”. Variance is one of the toughest concepts in statistics, but it’s crucially important. Variance tells you how spread out your data are (yep, “are”; the word “data” is plural!). First, let’s get some terminology out […]

Read More


Need help applying these concepts to your organization's data?

Chat with us about options.

Contact Us  

Continue to make data-driven decisions.

Sign up for our email guides that contains relevant tips, software tricks, and news from the data world.

*We never spam you or sell your information.