Connecting to your Power Pivot data from Tableau

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 …...

Power Pivot: Add a Secondary Axis to a Pivot Chart

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...

Power Pivot – Top 10 Product Sub Category by Sales

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...

Power Pivot – Time Intelligence and Financial Year

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...

DAX Calculation – YTD or Running Total in Power Pivot

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...

Introduction To Building PowerPivot Datasource

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...

Importing Power Pivot to Tabular Model

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...

Introduction to Power View

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...

Hierarchy in Power Pivot

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...

Calculated Columns and Calculated Fields in Power Pivot

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...
12
Send