Data & Finance for Work & Life
Data analytics for professional development.
Data analysis and data science are popular terms today, but the direct advantages of using them in business are still unclear for many people. If you’re a business owner, you need to know what you stand to gain from incorporating analytics into your company. And if you’re a data analyst, you need to show exactly […]
9 Tangible Benefits of Data Analytics (& How to Get Them) Read More »
If you’ve ever tried to execute a complex analysis, you know the feeling of getting stuck. It’s a normal part of any analysis to need time to reflect, but what if you find yourself struggling longer than usual? In these cases, you may feel stumped. I’ve spoken with several analysts about this feeling, and there
Stuck in Your Data Analysis? Here’s Why, & How You Can Fix It Read More »
If you’re used to navigating Excel spreadsheets with the F2 key and arrow keys, the switch the LibreOffice Calc can be tough. While most standard functionalities are the same between the two spreadsheet applications, many of the nuanced shortcuts that Excel formula warriors are accustomed to don’t transfer. Unfortunately, the F2 toggle function is one
Last week, I was working on an accounting exercise in Tableau in which I needed to filter a trial balance for all accounts starting with “6” and “7.” Where I work, these are the accounts present on the profit and loss statement. The first thing I did was look at the wildcard filter settings, since
Filter On Two Substring Values With STARTSWITH() in Tableau Read More »
If you’re anything like me, you can’t use waterfall charts enough. They’re the ideal visualization of the addition and subtraction of values from a total over time. In Excel, there’s a really simple way to create waterfall charts. However, getting/setting total columns? Not so easy. Total columns are essential to waterfall charts. Yet for some
How to Set the Total Bar in an Excel Waterfall Chart Read More »
Clusters are everywhere. In school, students are placed in different grades and classes. In business, employees belong to different departments. How do we decide who goes where? Shared characteristics such as age, subject matter, or skill, tell us who belongs together. In the same way, data analysts cluster data based on similarities among data points.
Data Cluster: Definition, Example, & Cluster Analysis Read More »
Every profession needs some form of evaluation. Academics use written tests, athletes use speed and agility exercises, and businesspeople use a combination of key performance indicators, such as conversion rates and sales. The same assessment applies to organizations as a whole. For example, universities use drop-out rates, teams play in tournaments, and companies set financial
Assessment Measures: Definition & Examples in Business Read More »
In business, solutions are a way of life. Companies aim to solve customers’ problems, and to do so, they have to overcome many of their own problems. However, solutions are rarely easy. They have to be fast, affordable, and qualitative — but they’re rarely all three. In addition, they need to be well understood throughout
Solution Design: Template, Steps, & Definition Read More »
A career in data is a good idea these days. Workers with data and similar analytic skills are expected to grow by 31% from 2019 to 2029 according to the U.S. Bureau of Labor Statistics. But data analysts aren’t the only ones looking at data, and their skills are in high demand across a growing
Can a data analyst become a business analyst? Yes, Here’s How Read More »
As a concept, data classes are nearly as old as IT itself. They represent a group of data attributes, data items, and/or logical operators that the user wants to treat as one group, or class. The tricky part is that data classes carry slightly different definitions depending on the programming language or data analysis software.
What is a data class? Get, Set, & Allocate Data Attributes Read More »
