Watch the introduction video of Power Pivot in Excel 2013. Power Pivot add-in for Excel 2010/2013 is used to perform powerful data analysis, self-service business intelligence within the familiar framework of Excel on your desktop. Using Power Pivot you can import data from different source like RDBMS, data feeds, spread-sheets, […]
Read MoreTraining
How to Enable Power Pivot & Power View in Excel 2013
Watch the video demonstration of how to enable Power Pivot and Power View in Excel 2013. Power Pivot in Excel 2013 Add-in enable you to perform powerful data analysis using familiar interface of Excel from virtually any data source. Users can create their own reports, perform analysis and decision making. Power […]
Read More
Toggle Visibility Show As Expanded + – in SSRS
Watch this video demonstration for how to Toggle Visibility as Expanded in your SSRS Report, BICG Training Channel. Reporting Services provides some nice options to allow user’s to feel like they are interacting with the data, by expanding lower levels of detail when they click on the plus (+) sign […]
Read More How to check is null in a Reporting Services Expression
Watch this video demonstration for how to check is null in a Reporting Services Expression http://youtu.be/k2P4Qi20jkA. To perform the equivalent of isnull in a Reporting Services Expression use the IsNothing command. Begin by using IsNothing to determine if your measure is null, wrap it in a conditional IIf statement. […]
Read More SSRS – How to Add a Column Group to an existing Table
Watch this video demonstration for how to add a Column Group to an existing table in SSRS, i.e. converting your table from a Tablix to a Matrix http://youtu.be/zM5DRsnH3E0. You have created a table i.e. tablix control in SSRS which is working well however now you want to pivot the dates […]
Read More