In today’s post we are going to talk about the Analysis Services Tabular Models, specifically one of the latest news published earlier this year: The Calculated Groups. The Calculated Groups allow us to shorten the number of measurements we have in an Analysis Services model. Read More
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
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
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
Business Intelligence Consultant. Especializado en creación de Data Warehouse, Analysis Services, Power BI, SSIS y Reporting Services.
Usamos cookies propias y de terceros necesarias para que nuestro sitio web funcione adecuadamente pero también utilizamos otras que nos permiten personalizar el sitio y sus opciones, realizar labores analíticas de tráfico y uso, ofrecer funciones de redes sociales, mejorar la navegación, adaptarse a tus preferencias y poder mostrarte contenido relevante y personalizado. Dispones de más información sobre las mismas en nuestra Política de Cookies. Puedes aceptar todas las cookies pulsando en el botón "Aceptar" o configurarlas a tu gusto o rechazar las no necesarias, a través de las opciones que ponemos a tu disposición. AceptarMás información
Privacy & Cookies Policy
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.