In the previous entry of the series we learned to manage the access and use of data, but to be completely safe, it is not enough to just secure the data in use, we also have to protect it at rest and in transit. Why is Read More

Creating DimDates with Power BI is the perfect ally for your company’s data analytics. All our data models have a common dimension, the dimension of date or DimDate. Thanks to the date dimension we can make comparisons of data between ranges of dates, see how the annual production Read More

With Power BI Desktop we can create “Tooltip” with our reports to visualize it, when we keep the mouse pointer on the added visual objects. This “Tooltip” pages can be associated to one or several fields of reports as desired. In this post, we are going to follow the Read More

The team of Aleson ITC wishes you a Merry Christmas and a good start in SQL Server 2019, we leave you our Christmas in Power BI that this year is a little more international: PC: Move the mouse over the red points of the map (You can zoom in) Mobile: Keep clicking on Read More

It’s time to do more interesting things with PowerApps. In this entry, we will connect PowerApps to a SQL Server table by inserting a DataTable, because it is a good way to show data on the PowerApp. 1: Scenario. To begin, let’s create a blank PowerApp. At first, we will see Read More

Today we bring you the previous version of SQL Server 2019 CTP 2.2., so you can try it. In addition, we have provided the links so that you can download the latest updates for SQL Server 2017, SQL Server 2016 and SQL Server 2014. We remind you Read More

Once we have discovered and classified our data, we enter the second step on our way to comply with the GDPR, now it is the turn to manage access to the data and control the use that is made of them. Why is this important for the GDPR? The Read More