At BICG we have been using Performance Point filters and connecting them with custom SharePoint solutions to deliver top notch functionality and dashboards to our customers that are not available out of the box. But there are many tweaks and settings in PPS which is not fairly documented and need […]
Read MoreArticles by: ANUPAMA AGARWAL
Count Measure Issue in Tabular 2016 DAX Query
At BICG we are among the early adaptors of SQL 2016 and upgraded existing SQL 2014 server to SQL 2016. We went ahead and started moving away from DataZen and started creating Mobile Reports against exiting upgraded Tabular Models. Everything started to looks good until we hit few roadblocks, first […]
Read MoreCreate DAX Query DataSet for SSRS 2016 Mobile Reports
If you are early adopter of SSRS 2016 and is excited to create Mobile Reports against your Tabular Model or want to migrate from DataZen to Reporting Service 2016 Mobile Reports, you will struggle to find any documentation on how to create DAX query based DataSet. Create Connection So like […]
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 MorePower BI Designer – Another tool?
Watch the video demonstration of building reports using Power BI Designer. Yes, Power BI Designer (download steps) is one more tool (desktop based) introduced by Microsoft to create Model and Report for Power BI dashboard. Now you may not feel good about it considering the fact that you are still scratching […]
Read MorePower BI – Beyond Introduction
Watch the video demonstration of adding Excel Dataset in Power BI. If you have signed-up for PowerBi, here is the link to access the app https://app.powerbi.com/ Power BI supports varied types of Data sources which can be defined as Dataset. We can connect to or import datasets from a variety of sources: […]
Read MoreIntroduction to Power BI
Watch the official video on Power BI PowerBI (still in Preview mode) is Microsoft self-service business intelligence solutions for Office 365 that includes features like Excel 2013 – Power Pivot, Power View, Power Query and Power Map on SharePoint 2013 environment. PowerBI in-short is a Cloud based BI service that […]
Read MoreActions in Tabular Model using BIDS Helper – Part 2
Watch 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 More