Most organisations have more tools than a bicycle shop.   It is therefore inevitable that the information consumers within your organisation will use more than one BI tool…. and hence it is not out of the question that someone in your business will one day ask …...

You have a Percentage measure to add to your chart and you want this to display on a Secondary axis (because the primary axis already has a sum measure and the difference between the two measures is too far out of proportion). First make sure you have already added your...

Watch the video demonstration of creating reports of top 10 product by sales amount. It is a common requirement to create TOP N reports to understand which product or product category or product sub category has maximum amount of sales amount. The video demonstrate how we can...

Watch the video demonstration of how to create Power Pivot model that helps you create report not just on calendar month and year but also on financial month and year. Introducing Date Table (Date Dimension) In BI technology it is a common practice to have a separate role playing...

Watch the video demonstration of creating Year to Date (YTD) measure using DAX in Power Pivot. What is DAX? DAX is a formula language to create calculations in Power Pivot and Tabular Model.  It is similar to excel formula and is used to create calculated columns or calculated...

Creating PowerPivot data sources As I have demonstrated there are a lot of things about PowerBI to get excited about. One of these is Microsoft’s adaption of the technology xVelocity. The true power behind PowerPivot is the xVelocity in-memory analytics engine. Why XVelocity is...

Watch the video demonstration of importing power pivot model to tabular model. In the last post, we have discussed the difference between Power Pivot and Tabular Model. Why do we need to Import Power Pivot in Tabular Model? In a scenario where Business users create a prototype...

Watch the video demonstration of creating simple Power View report using Power Pivot model. Power View is a very easy to use dashboarding tool that is part of Excel 2013. Using power view, business users can leverage self-service business intelligence. Power View is generally...

Watch the video demonstration of how to create hierarchy in power pivot. What is hierarchy? A Hierarchy is a set of members organized into a structure for convenient analysis.  A table/dimension can have multiple hierarchy for quick analysis. For example, in product table we can...

Watch the video demonstration of how to create calculated columns and fields in Power Pivot. For any newbie there is always a confusion between calculated columns and calculated fields and when to write what. Note: Calculated fields are also referred as Measures in BI terminology...