In continuation with: BI Simplified Webinar: Analyzing Data with Pivot Pivots make the heavy lifting of summarizing and analyzing data simpler. It is easy to start with and has some useful…www.vivran.in The previous webinar outlined how a pivot table in Excel can be useful for summarizing and analyzing data. There are certain limitations with the regular pivot in data modeling and building complex business logic. …

Have you come across the following message while establishing a relationship between two tables and wondered what it means?

Pivots make the heavy lifting of summarizing and analyzing data simpler. It is easy to start with and has some useful features which simplify the slicing and dicing of data and view the performance from multiple perspectives. …

I am a fan of data visualization. After a long time, the Power BI team has released a few significant updates related to standard visualizations available in Power BI Desktop. This article highlights three such features. Grand Total in Stacked Charts Stack charts help in displaying results by multiple dimensions in a visual.

Pareto chart is a visual representation of the Pareto Rule. Pareto Rule, which is also popularly known as 80/20 rule, was coined by Italian mathematician Vilfredo Pareto. He stated that 20% of the population owns 80% of the land. Later, the quality guru Joseph Juran changed to 80% of the problems is due to 20% of the reasons. In simple words, the Pareto rule is all about prioritizing the vital few from the trivial many.

QuickBytes is a series of articles for simple and easy to implement techniques with exponential benefits I love the Data Preview feature in Power Query. As an analyst, I would prefer to get an overall summary of data. Data Preview is a great way to achieve this. Benefit# 1: Visual representation of the overall health of the column The bluish-green bar…

One of the key tasks as an analyst is to combine and transform data, before we start analyzing it. Power Query is very handy in such situations. Case: When the source data is in a different workbook than the output table The underlying assumption is that all sheets have the same data table structure. For source table same as the output table, refer to…

The first experience is always engraved in mind. It was our first motorcycle trip. We went for a 10-day long road trip to Himachal. We had a reality check on the very first day, as we met with an accident. Forced us to slow down, which eventually helped in taking time out & appreciating the beauty around us. It was my first time viewing a sunrise in the Himalayas. I captured this moment on the following morning.

We rode our motorcycles in the rain since morning. By afternoon, we realized that there is nothing called waterproof. The water seeped into every portion of clothing we wore, and also in the bag. Riding in the rain is tougher than it looks. We were scared as the Himalayas in the rainy season are scary. Beautiful, but scary. Rocks falling on the road, landslides causing patches of knee-deep slush, slippery roads, the raging Alakhnanda river. But we were riding among the clouds, seasonal waterfall all around, in a lush green backdrop.