Mar 22How to install Python with Anaconda: easy guidelineSince Python is an interpreted language, you must install the software to perform data analysis or run scripts on your computer. If you have more than one person in your BI team, install it on each person’s computer. Ways to install Python There are two possible ways to install Python: the standard installation the…Python3 min readPython3 min read
Mar 153 ways to calculate the difference between two months in TableauSuppose you must compare two dates to show how sales changed (i.e., quarterly, semi-annual, or year-to-year). In that case, you might be interested how to calculate this delta. You can analyze any business metrics, such as market share, turnover, conversion rate, and the number of subscriptions. …Tableau7 min readTableau7 min read
Jan 9How to remove a special character from the name in Tableau?If your data includes the symbols such as arrows, commas, dashes, or the hash, you might need to detach those characters from the text. It is necessary if you need to connect two or more databases with the same fields. …Tableau Desktop3 min readTableau Desktop3 min read
Nov 2, 2022SQL queries you must know (with examples) — PART 2I published an article about SQL queries Part 1 on Medium a couple weeks ago. This tutorial will provide three more solutions to basic queries across a construction sector database. We will use the open-source code ‘Construction Database Schema’ from Github. In the database, you can see three tables —…Sql4 min readSql4 min read
Oct 24, 2022Design a Bike shop Database — Example ER diagram + SQL codeSuppose your business is still using multiple Excel tables. In that case, it’s time to create a database system with a logical structure that will help you to automate, secure, and optimize the process. In this article, we will tackle the problem of creating a database for a bike store…Sql3 min readSql3 min read
Oct 24, 2022Measure marketing performance for a startup—with an Excel templateIf you are a startup you need to scale as fast as you can. You might be lost in a variety of metrics figuring out how to analyze your performance. …Performance3 min readPerformance3 min read
Oct 13, 20225 SQL queries you must know (with examples) — PART 1In this article, we will discuss some of the problems of database searching. We will take a hypothetical construction company as an example and use open-source code from Github. The database description. There are three interconnected tables — suppliers, projects, and employees. Some projects are in the examination stage; some…Sql4 min readSql4 min read
Oct 7, 2022Search for a group dimension in SQL — HAVING clauseWhen you make a statistical calculation in SQL, you usually need to find something precise. Such as, for example, average sales by product category or the number of calories burned over different sports activities. In this situation, knowing how to use the HAVING clause is crucial. …Sql2 min readSql2 min read
Oct 7, 2022How to use INDEX and MATCH in Excel — exampleYou can use the INDEX and MATCH functions in Excel if you need to find and match the information in two tables. The combination of functions is used to retrieve the data based on the values of your particular cells. …Excel4 min readExcel4 min read
Sep 28, 2022Forecast revenue for a marketplace: example and templateSuppose you are an e-commerce marketplace or an online seller planning your promotions for special and profitable Black Friday or Cyber Monday events. In this article, I will explain how to prepare a revenue forecast analysis and provide you a template. In this case, we will look at the financials…Revenue4 min readRevenue4 min read
