In the daily operations of companies it is often necessary to extract daily data from the database and give it to an Excel. In these Excels we usually want to have some specific name along with a date and to… read more
How to load data into Microsoft Excel from a database using Power Query
Microsoft Excel one of the first Microsoft programs. From its first versions, it had the ability to collaborate with software from other companies. In this article we will explore how to connect Excel to any… read more
What are the differences between MDX and DAX queries?
They are both expression languages used for data analysis in Power BI, Excel and Analysis Services. If we would like to answer our question with a sentence, MDX (Multidimensional Expressions) you use to analyze multidimensional… read more
What are models in Data Science
What are models in Data Science? In a simple sentence, models are built so that we can make predictions about a trend we are investigating. There are two categories of models: supervised, which we train, and unsupervised, which is done through... read more
How to visualize data on a map using Python
In this article with the help of jupyter notebook and python we will make a heatmap. We will do a complete analysis using dataframe, polynomial regression scatter plot, bar plot. Let's start by loading the libraries we'll need: What… read more
How to make charts in Microsoft Excel using Python
In Microsoft Excel, in addition to using functions and pivoting, we have the possibility to add graphs based on this data. But we know that graphs can also be made using Python with libraries such as matplotlib and seaborn.… read more
What is a Data Warehouse?
In this article we will analyze what Data Warehouse is, what it consists of and what is its usefulness. In the age of IT, managing the ever-increasing data is becoming more and more difficult. We want to leverage the data… read more
Pivoting in Microsoft Excel using Python
In an earlier article we have seen the possibilities to perform Excel functions such as vlookup through Python. In this article we will see how we can perform pivoting through Python. We will analyze ways so that we can find information… read more
How to make our first graph using Python
In the article we will see how we can make barplots using Python easily and quickly. To begin with, we should load 3 libraries that we have ready with the functions we will need: In the variable df we loaded a dataframe... read more
