All posts by James

Set of creative business infographic elements.

What Skills Do You Need for Data Analysis?

We know that data has permeated our lives. Every action you take these days seems to generate data. Whether that is good or bad is up for debate. But what is true is that data is being collected and more

Continue reading
Four Core Measures

The Four Core DAX Measures

When I first started working with Power BI, I often heard that you could get by with just four core DAX measures: Total Sales, Total Cost, Total Profit, and Profit Margin. At the time, that advice felt

Continue reading
Searching

Create Lookup Tables from Fact Tables Using Merge in Power BI

When analyzing data, analysts should adhere to best practices. Once such best practice is to use a star schema for the data. At its basic level, a star schema contains one or more fact tables, and several

Continue reading
Right Brain Left Brain

How to Get Familiar with Your Data

Let's face it. Looking at data sometimes can be a nightmare. It never seems to conform to the neatly laid out samples from training modules. Often, the data you obtain is a scattered mess. How do you

Continue reading
Data Transformation

Why Data Analysts Need a Data Transformation Process

Data is messy. It's a fact we all need to face as analysts. That's why analysts need a data transformation process. Business intelligence tools work best when data is not messy. A big part of an analyst's

Continue reading
It's All About Filters

What’s the Big Deal About Filter Context in Power BI?

Power BI is a robust business intelligence tool, hence the BI in its title, that allows analysts to create meaningful reports from an organization’s data. You can think of Power BI as a next generation

Continue reading
Mapping Tables

Tutorial: A Quick and Easy Mapping Table in Power BI

I often work with annual reports, including financial statements for listed companies. I do it both for investing and for my job where I want to know the financial solvency of my clients and potential

Continue reading
DataCamp.com Introduction to Python

Review of Data Camp’s Introduction to Python

If you take no other course to learn Python, take the free first chapter to the Introduction to Python course from DataCamp.com. Between an industry expert teaching the course and Data Camp's innovative

Continue reading
Keep Career Current

Keep Your Career Current Through Maintenance Learning

The data science field is constantly changing. Employers are demanding that data scientists know more and can do more. For that to happen, though, you'll need the right skillsets.Unless we use certain

Continue reading
Accessing the Dark Web

Accessing the Dark Web: Proceed with Caution

At the time of this writing, it was not illegal to access the dark web. It's what you do on it that can get you into trouble. Further, some people don't even know when they are doing something wrong.

Continue reading
1 2 3 4 10