Category Archives for "Blog"
We hope to bring you the best in thought, news and reviews in regards data insight and digital data analysis
VLOOKUP vs INDEX Match
VLOOKUP is probably one of the top 5 functions that asked for Excel professionals to demonstrate for analysis or while interviewing. I can personally attest that early in my career I was asked whether I could do VLOOKUP hundreds of times. I often wonder why VLOOKUP became the go-to function for looking up data when […]
Python for Data Science –Free Learning Path
It took me a long time to learn Python. The reasons are aplenty on why it was such a long journey. However, hands down, I can tell you the main reasons are due to the vast amount of flexibility with Python. I tried to learn too much at one time instead of focusing on key […]
Google Store Most Installed Apps
The Google Apps store has a plethora of different apps ranging across a ton of different categories. Here is a visualization created in Tableau that give you an idea of what are the most popular apps on the platform. The dataset was sourced a Kaggle.com in the form a CSV. I did some light […]
70 Excel Keyboard Shortcuts to Save Time
One thing that I love to do more than anything is save time. So, here is a collection of some of the most useful Excel Keyboard shortcuts. These should help you become much more efficient and leave more time to analyze and visualize your data. These 70 tips range from general to data operation. If […]
NRA Political Donations from 1990 to 2018
NRA Donations by Party and Politician Where does the NRA concentrate their donations? You can view the data according to the New York Times, OpenSecrets.org and Fortune Magazine. The top politicians that receive money from the NRA are overwhelmingly Republican with Donald Trump who is the the top politician of the Republican party with over […]
Tableau vs Power BI – Which is the best tool for you?
Tableau vs Power BI The two top business intelligence and data visualization tools are Power BI and Tableau. The products are similar and the decision between the two is dependent on the specific needs of the company including budget, organization, and intended use. Tableau for Data Science A-Z for $10 Bundle. Become a Tableau Expert. […]
Intercontinental Ballistic Missiles (ICBM) Calculator
Use the Intercontinental Ballistic Missiles (ICBM) Calculator to calculate the max distance of missiles, types, and impact duration from country of origin. Nowadays, one of the biggest international threats is a nuclear weapons attack by North Korea. Their delivery method would be an intercontinental ballistic missile launch. North Korea has been increasing their capabilities in […]
Why You Shouldn’t Pay For Google Analytics Training
Google Analytics is a superb piece of software that allows you to track the acquisition, behavior and outcomes on your website. However, like any tool, its function is going to be different depending on the users intent. Although I do not have hard statistics, I am sure the vast majority of Google Analytics users are […]
Simpsons: Quality and Viewership Decline Trend
Like a very large segment of the world in the late 80s and early 90s. I was completely obsessed with the Simpsons. Every week, I would wait eagerly for each episodes to be release on FOX. I even bought the video games and other merchandise. But over time, the episodes became repetitive and less edgy. […]
Starbucks Data Story – Stores, Food and Drinks Stats
Starbucks is a dominate coffee chain that has multiple stores on every continent on the planet. I created a simple data story made up of three dashboards that highlight data on international store locations, food stats and drink stats. The data was sourced from multiple sources in the form of CSV files. Each dashboard was […]