In this blog I share techniques on how to convert a dataset containing words into actual numbers (integer or float) save the output with numbers to an external CSV/XLSX data file. If you’re wondering why would one ever need this? Here’s a scenario: A list of movies and their corresponding revenues were read into a […]
Tag: datascience
Eiesenhower Matrix in Excel (Quadrant Matrix)
Former US President Eisenhower is known to have said: “What is important is seldom urgent and what is urgent is seldom important.” This is reflected in a popular quadrant design, often referred to as “The Eisenhower Matrix”, used to effectively prioritize tasks according to their urgency and importance. This can be expressed in a quadrant matrix (image) […]
HOW TO CREATE AN ORGANIZATIONAL CHART FROM EXCEL DATA
If you’ve worked with Visio or PowerPoint, you may have used their built-in organizational charts…and manually enter the information for each node. But what if you have the data already as a table, as in a CSV or Excel file? You can use that data and create an organizaitonal chart right within Excel. However, you’ll […]
Venn Diagrams Done Right (Excel)
Venn diagrams are best used to show overlapping or interconnected relationships, especially overlapping segments. While they are ubiquitous, very few diagrams actually update automatically when data changes…that’s because most of them are one-time illustrations with no ties to the underlying data…they’re just drawn up like Infographics. It doesn’t have to be that way! In this […]
Mass and Energy – Explained Simply
In this blog, I explain in simple terms, the relationships between mass, weight, and ultimately energy as it relates to anything, including your own body mass, and how all of this can be tied to Einstein’s equation: E=MC^2. By the end of this post, you’ll be able to tell how much energy is stored within […]
Complementary post to: Pop Quiz [And Solutions With Low Code!]
This post is a continuation of or complementary post to about using Excel and SQL for pop-quizes. Please read that first to get proper context…otherwise, this wouldn’t make much sense. As discussed in the post linked above, the SQL queries can be saved from Microsoft Query Editor to an external file. It’s really convenient because […]
Pop Quiz [and Solutions with Low Code!]
Every now and then I see some simple quizzes pop-up on Facebook such as: “Name a state without letter A in it.” The letter can be another, they just switch it around from time to time. This particular post is inspired by such posts. Sure we can go through all the states in our heads […]
Understanding Trends: Real-world example
Trend analysis is a pivotal part of business analytics, project planning, marketing, and virtually all aspects of strategic planning and understanding of patterns/behavior. In this post, I present a straight-forward but very practical use of some analytics and walk you through: 1) Data collection 2) Data cleanup and shaping 3) Creating trends and understanding the […]
Carbon footprint estimation made easy
Indeed, “Climate change” has been the hot topic for the last couple of weeks. It even surpassed the hubbub around the pandemic the world is experiencing for the past 2 years and counting! Thanks to COP26…the gathering of the “relevant” world leaders to discuss top, pressing issues of the world, the list of which contains […]
Ig Nobel Prize Winners: 2021
The winners of the 2021 Ig Nobel Prize are announced today. One of them caught my attention, which happens to be in the Economics category by Pavlo Blavatskyy for for discovering that the obesity of a country’s politicians may be a good indicator of that country’s corruption. Very interesting indeed and although it made me […]