Creating KPIs KPIs are a staple of many dashboards and provide a great way to quickly see trends and spot areas that need further analysis. One of the nice features about KPIs in PowerBI when it comes to creating KPIs that it allows you enhance existing measures and not create […]
Read More Introduction to PowerView Microsoft has been a leader in the Business Intelligence (BI) space. With SQL Server and Excel having been on the market for over 20 years it has always had a presence in data management. Today, one of the new initiatives in BI is self-service BI. I will […]
Read MoreWatch the video demonstration of using MDX in Caption, Condition and Expression for Action. This is Part 2 of 2 parts series about Tabular Action. In the last post we have seen how to create simple Drillthrough, URL and Report actions for Tabular Model using BIDSHelper. In this post we […]
Read MoreWatch the view demonstration of creating actions in tabular model using BIDS helper. In the demo I have created 3 types of Actions – Drillthrough, Url and Report. As discussed last time, Tabular model does not support actions out of the box and since this is one of the sought […]
Read MoreWatch the video demonstration of BIDSHelper add-in for SQL Server Data tool. BIDS helper is Business Intelligence Development Studio/SSDT add-in to enhance functionality of the BI projects. BIDS helper has lots of features to enhance your Tabular/Multidimensional Cube, Integration service package and Reporting service reports. So if you want to […]
Read MoreWatch 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 More 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 MoreWatch 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 MoreWatch 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 MoreWatch the video demonstration to add data to Power Pivot. PowerPivot can import data from multiple source like Access, SQL Server, Oracle, Sybase Informix, DB2, Teradata, Flat file, Excel and OData feed. The process to import data table is similar. Following are the high level steps. Create a data connection […]
Read More