Data Analytics

When we work with multinational companies, one of the key parts of our model is the Conversion to different Currencies, since, payments are made from different countries with different currencies and the users who view the reports must be able to see them in the currency they choose. Read More

In my last Post, I showed you a much faster and more intuitive alternative than Visual Studio, the Tabular Editor. Surely many of you will have been testing this new application, so if you liked it and found it really useful, you can not miss this Post! This Read More

In today’s post I will show you a Business Intelligence tool that will be of great help when creating Analysis Models. Last September, I had the opportunity to attend the data event held every year in Madrid, the SQL Saturday. In one of the sessions, specifically that of becoming Read More

In today’s post, we’re going to end up with the DimDate series in Power BI. To begin, I will show you some of the visualizations that Power Bi offers by default as well as the personalized visualizations that we can find in the Marketplace. 1.Slicer These are the types of Slicer that Power Bi Read More

At Aleson ITC we are fans of Game of Thrones, that’s why we wanted to make our particular tribute to the series, although after watching the 8 seasons we have different opinions about the end. Above all opinion, Game of Thrones is a series with a Read More

The purpose of this entry is to verify the connectivity to access a SQL Server Reporting Services using a trust relationship between two domains. This makes it possible to connect to the report with users from another domain. 1. Requirements: First we have to prepare Read More

By Xesco Abad Posted Wednesday April 10th, 2019 In SQL Server Spanish 0 1 One of the strengths of the DAX language is that it allows us to compare data for periods of time in a very simple and fast thanks to its intelligence functions of time. With the intelligence functions of time we Read More