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 … “How do I connect […]
Read MorePower Pivot
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 percentage measure to the chart. […]
Read MorePower 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 create TOP N […]
Read MorePower 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 date […]
Read MoreDAX 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 fields we […]
Read MoreIntroduction 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 important Before Microsoft’s introduction of xVelocity […]
Read MoreImporting 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 power pivot model […]
Read MoreIntroduction 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 used to create pretty looking charts […]
Read MoreHierarchy 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 https://mgpharmacie.com. For example, in product table we can create a hierarchy of […]
Read MoreCalculated 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 and is used interchangeably. Calculated […]
Read More