Power Query for Automation and Efficiency
This article is for all excel wizards, conversant with majority of excel features and functions but have not realised the potential of Power Query for data extraction and transformation automations and ease of use.
Power Query in itself is a powerful tool and needs mutiple articles to cover the features…
Learn the concept of Calculation Groups in Power BI
Microsoft in its Power BI July, 2020 release, introduced the ability to launch External Tools from Power BI desktop (currently a preview feature). With the help of this feature, Tabular Editor can now be integrated with Power BI and allows users to easily create Calculation Groups in Power BI.
What…
Power BI Tips and Tricks
All those who have spent significant time with Power BI know the importance of DAX. The purpose of Business Intelligence is to communicate the insights derived from the data to enable informed business decision making. However, it is not as simple as it sounds. …
Data Story telling through Power BI
Gender equality has garnered importance across the world to achieve socio-economic balance. Over the years, the world has slowly and steadily moved towards providing equal oppotunity to women in different areas. …
Startegies to prepare and pass Power BI certification
In the month of August, 2020, I passed Microsoft Power BI Exam:70–778. Since then a lot of my friends, contacts and Power BI community members have asked me about the exam, preparation tips and resources . …
Data Story Telling through Power BI
The other day I was looking at the India’s Covid-19 cases on the Ministry of Health and Family Welfare’s website which made me think of a way to depict the data in a way which is more interactive and easy to consume. …
