Power BI VertiPaq engine uses a high compression algorithm based on Columnstore structure, enabling it to load the data into the data model with significant size reduction compared to the…
Category: BI

Show data for the last N months based on a selected month
Power BI doesn’t have out of the box features to cover all of the UI use cases and occasionally we need to use our DAX skills to keep the…

Analysing Twitter and Amazon by MongoDB and Power BI
Introduction Using MongoDB you can simply import a JSON file and create a database, apply natural language processing techniques using NLTK in python and lastly visualise your sentiments using…

Converting UTC to local datetime in Power BI
Nowadays many systems such as cloud services and IOT devices that work globally prefer to use the UTC time zone to be consistent across different countries. When it comes to…