In this article, let us briefly cover when the GROUP BY clause is limited and see how window functions can help. Let us also explore the power of some SQL window functions using a sample database, explained codes, and visual guidance. Better if you follow along with me I will use the SQL editor from Mode.com, which…

In this article, I will briefly cover what you can expect from the Google Business Intelligence Professional Certificate and some thoughts on building my capstone project on the Google Fiber Customer Service FCR Dashboard. Quick Review of the Google BI Professional Certificate The BI Professional Certificate is composed of 3 courses. The first course — Foundations of Business…

Want to upgrade your data science skills? Learn why hypothesis testing is a crucial part of data-driven business decisions. In this article, let’s understand the fundamental concepts behind it and apply its procedure to a business problem. What is hypothesis testing? Let’s start with the word hypothesis, which you might recall from high school…

In this article, I will briefly explore the nature of data science and how it relates to the scientific method and academic sciences. For an overview, the contents are summarized as follows. A very brief introduction to the historical development of science Modern science and the scientific method History and…

Unlike other scraping libraries (such as Beautiful Soup), Selenium can scrape information and interact with a website (such as clicking a button). In this blog, we will automate the clicking of every article’s link found on a site’s homepage to scrape its title, publication date, and text. What is Selenium? Selenium is an…

I think you forgot the "as pd" in the line for importing pandas. Nevertheless, nice article! Clear from start to finish.

In my previous article, I talked about how to code a function that determines the profitability of a breakout strategy for a given stock. The output of the said function is a distribution of profits (within 10 holding days) of all breakout candles in the stock’s entire history. Coding a Backtester for Stock Breakouts in Python Is a stock really profitable via a breakout strategy? Let’s develop a Python function that answers this.python.plainenglish.io

In this article, let’s understand how to do data modeling in Power BI if you are faced with multiple tables that are logically related to one another. Power BI’s Model view offers a convenient way to establish relationships between tables to ensure that our data analysis and visualizations are accurate. What is Data Modeling? …

In my previous article, I talked about how to code a Python function to easily identify the breakout candles in a stock chart. I will extend its codes here. For this article, our goal is to calculate the profits for those breakout entries and determine important trading probabilities. In this…