close
About the Author

Errin O'Connor

With over 25 years of experience in Information Technology and Management Consulting, Errin O’Connor has led hundreds of large-scale enterprise implementations from Business Intelligence, Power BI, Office 365, SharePoint, Exchange, IT Security, Azure and Hybrid Cloud efforts for over 165 Fortune 500 companies.

Power BI Concatenate Functions: A Practical Guide 

Posted by Errin O'Connor on Nov, 21, 2023 09:11

Power BI Concatenate Function is a powerful yet simple tool that allows users to combine values from different columns or tables into a single cell. This article will show you how to use the Concatenate function with syntax and examples in Microsoft Excel. What Is Power BI? Power BI is a tool that allows users […]

Continue Reading →

Power BI Concatenate Functions: A Practical Guide  - thumb image

Topics: Power BI

How to Use Power BI Switch DAX Function

Posted by Errin O'Connor on Nov, 21, 2023 09:11

Introduction Power BI is packed with useful features, and one of them is the Switch function. Think of the Switch function as your personal data assistant. It’s there to help you sort through all those numbers and categories in your reports. Once you start using it, you’ll see how it makes dealing with complex data […]

Continue Reading →

How to Use Power BI Switch DAX Function - thumb image

Topics: Power BIPower BI

How to Use the Power BI ALLEXCEPT Function for Advanced Data Analysis?

Posted by Errin O'Connor on Nov, 06, 2023 07:11

The ALLEXCEPT function is a beacon for those navigating the complex seas of data models, offering the unique ability to retain specific filters while removing all others from the context of a calculation. Imagine effortlessly comparing sales performance across different regions while maintaining a consistent product category filter, or evaluating marketing campaign effectiveness by keeping […]

Continue Reading →

How to Use the Power BI ALLEXCEPT Function for Advanced Data Analysis? - thumb image

Topics: Power BIPower BIPower BI

LOOKUPVALUE DAX Function in Power BI – A Complete Guide

Posted by Errin O'Connor on Nov, 02, 2023 06:11

If you want to extract specific values from a table in Power BI, the LOOKUPVALUE DAX function is the way to go. But what’s the secret behind its syntax and parameters, and how can you use it properly? We’re about to find out in this guide.  For instance, we’ll dive deep into the LOOKUPVALUE function, […]

Continue Reading →

LOOKUPVALUE DAX Function in Power BI – A Complete Guide - thumb image

Topics: Power BIPower BIPower BIPower BI

RANKX DAX Function In Power BI: A Complete Guide

Posted by Errin O'Connor on Nov, 02, 2023 06:11

Power BI, a popular business intelligence tool, has revolutionized how organizations analyze and interpret data. Interestingly, a recent survey has revealed that companies that invest in data analytics have a much higher chance of gaining new customers, 23 times to be precise. Not only that, these companies are also 19 times more likely to make […]

Continue Reading →

RANKX DAX Function In Power BI: A Complete Guide - thumb image

Topics: Power BIPower BIPower BIPower BIPower BI

How to Use the GroupBy Function in Power BI to Analyze Data?

Posted by Errin O'Connor on Oct, 31, 2023 08:10

Power BI, Microsoft’s interactive data visualization tool, offers a plethora of features to transform, analyze, and visualize data in meaningful ways. One such powerful feature is the “GroupBy” function, which allows users to group data based on one or more columns, enabling the aggregation of information for more insightful analysis.  In this article, we will […]

Continue Reading →

How to Use the GroupBy Function in Power BI to Analyze Data? - thumb image

Topics: Power BIPower BIPower BIPower BIPower BIPower BI

Spotfire Vs. Power BI: Choosing the Best BI Tool

Posted by Errin O'Connor on Oct, 20, 2023 07:10

In the world of intelligence business, data is like the new currency, and within this domain, Spotfire and Power BI are leading the way. Both are business intelligence and data analytical tools. But which of these powerful tools truly reigns supreme? To help you make an informed decision, we’ll explain the key features, advantages, disadvantages, […]

Continue Reading →

Spotfire Vs. Power BI: Choosing the Best BI Tool - thumb image

Topics: Power BIPower BIPower BIPower BIPower BIPower BIPower BI

Alteryx vs Power BI: Which One is the Ideal Analytics Champion?

Posted by Errin O'Connor on Oct, 20, 2023 07:10

Are you a decision maker in the field of data and business intelligence who’s unable to decide between Alteryx and Power BI for data analysis? Power BI is known for its versatile feature set, whereas Alteryx has an edge in data preparation and blending.  But out of these two, which one is better? We’re about […]

Continue Reading →

Alteryx vs Power BI: Which One is the Ideal Analytics Champion? - thumb image

Topics: Power BIPower BIPower BIPower BIPower BIPower BIPower BIPower BI

Looker vs Power BI: Which Tool Offers Better Data Visualization?

Posted by Errin O'Connor on Oct, 03, 2023 05:10

Two of the frontrunners in this space are Looker and Power BI. While both offer robust features for data analysis, Power BI consistently stands out as the superior choice regarding data visualization capabilities.  From its intuitive interface to its wide array of visualization templates, Power BI has been designed with the user in mind, ensuring […]

Continue Reading →

Looker vs Power BI: Which Tool Offers Better Data Visualization? - thumb image

Topics: Power BIPower BIPower BIPower BIPower BIPower BIPower BIPower BIPower BI

Power BI vs MicroStrategy: Which BI Tool Offers Better Integration Capabilities?

Posted by Errin O'Connor on Sep, 26, 2023 10:09

In the dynamic Business Intelligence (BI) world, choosing the right tool is pivotal for an organization’s success. Two leading contenders in this domain, Power BI and MicroStrategy, have long competed for the top spot.  While both platforms offer a wide range of advanced features, their integration capabilities are pivotal points of differentiation. Seamless integration is […]

Continue Reading →

Power BI vs MicroStrategy: Which BI Tool Offers Better Integration Capabilities? - thumb image

Topics: Power BIPower BIPower BIPower BIPower BIPower BIPower BIPower BIPower BIPower BI