Performance Point Per User Filter Caching

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

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

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

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

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

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

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

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