Friday 3 March 2017

Power BI – Introduction

I have uploaded the Power BI introductory video, which is the first video in my upcoming Power BI Training videos.
Please have a look of Power BI Overview , Products and How to setup for use.


Thanks
Prasad
(Know BI Tools)

Wednesday 13 April 2016

SSRS Data Driven Subscription - No Email When No Data in Report

SSRS Data Driven Subscription - No Email When No Data in Report


This Video is tell how we can restrict to send the Email subscription when there is no data in the Report




Thank you for watching this Video.
Any comments or suggestion's ,please provide.


Thanks
Prasad 


Learn Different BI ToolsVisit us:-  YouTube Channel

Tuesday 12 April 2016

SSRS Two Tablix Page Break with Same number of Rows and show in one page

SSRS Two Tablix Page Break with Same number of Rows and show in one page


Issue raised in MSDN Forum:- I have 2 tablix in a report. Both the table has 30 records each in it. I want to show both the tablix reports one after another in the front page. Initially the report should display 10 records from the first table and 10 records from the second table in the first page. Then in the second page, next set of 10 records from the 1st & 2nd tables and third page should display last 10 records from the 1st & 2nd tables.






Thank you for watching this Video.
Any comments or suggestion's ,please provide.


Thanks
Prasad 


Learn Different BI ToolsVisit us:-  YouTube Channel

Monday 11 April 2016

SSRS Report Parameter change does not refresh default values of dependent parameters Using SSAS Cube

SSRS Report Parameter change does not refresh default values of dependent parameters Using SSAS Cube


Workaround:- SSRS Report Parameter change does not refresh default values of dependent parameters Using SSAS Cube





Thank you for watching this Video.
Any comments or suggestion's ,please provide.


Thanks
Prasad 


Learn Different BI Tools
Visit us:-  YouTube Channel
 

Saturday 9 April 2016

SSRS Dataset Execution Flow Parallel or Single Transaction

SSRS Dataset Execution Flow Parallel or Single Transaction


What is the significance of Use Single transaction when processing the queries checkbox property in SSRS data source property.

This Video is to showcase Data Set Execution mode, with creating temporary table in one dataset and use in another dataset.

So if data set execute in parallel mode than it will failed for above case, and if it executes in the single mode than it will success of the temporary table creation happen in first top dataset.

For more details watch below video:-




Thank you for watching this Video.
Any comments or suggestion's ,please provide.


Thanks
Prasad 


Learn Different BI Tools
Visit us:-  YouTube Channel
 

Thursday 7 April 2016

QlikView Layouts Modification

QlikView Layouts Modification 

This Video is to showcase below things
  • Changing the default object layout options
  • Changing the default selection color scheme
  • Modifying the green, white, and gray selection color schemes
  • Using containers as an alternative to multi-boxes
  • Using the design menus to custom format a cell




Thank you for watching this Video.
Any comments or suggestion's ,please provide.


Thanks
Prasad 

Learn Different BI Tools
Visit us:-  YouTube Channel

Wednesday 6 April 2016

QlikView Charts Part 4- Pie Chart , Line Chart and Bar Chart


QlikView Charts Part 4- Pie Chart , Line Chart and Bar Chart 


Topics shown in below video are:-

  • Staggering labels in a pie chart 

  • Creating a secondary dimension in a bar chart 

  • Replacing the legend in a line chart with labels on each line.



Watch video for more detail.




Thank you for watching this Video.
Any comments or suggestion's ,please provide.


Thanks
Prasad 

Learn Different BI Tools
Visit us:-  YouTube Channel