Creating SQL Server Reporting Services Reports

SQL Server Reporting Services (SSRS) is Microsoft most accomplishing reporting tool. No matter which tool you decided to use in the Microsoft Business Intelligence offerings, SSRS will likely play a part if you really want one solution that does most of what you need. SSRS is...

Create a Performance Point Dashboard

Performance Point Services Over the last few years Microsoft has been releasing a serious of new capabilities in in Business Intelligence offering. SQL Server has always been the central technology around the MSBI offerings and that makes sense. Now the current emphasis is...

Excel: Troubleshoot Formulas with Trace Precedents and Trace Dependents

Awaken the Force within, using Excel’s Trace Precedents and Trace Dependents functions to identify problems in your spreadsheet formulas, or just for better understanding. Blue arrows show formulas that work fine and red arrows show formulas in error. The direction of the...

SSIS Difference Between DT_DATE, DT_DBDATE, and DT_DBTIMESTAMP

Useful short reference on the difference between DT_DATE, DT_DBDATE and DT_DBTIMESTAMP.  In short, use DT_DATE to omit time, DT_DBDATE if you want time but are not worried about time precision, DT_DBTIMESTAMP if you do want time precision, or if you want a method that uses ISO...

Tableau Geographic Filtering – Cyclones and Sweat Zones

Nothing raises eyebrows in a meeting more than seeing the look of astonishment or curiosity on someone’s face… Particularly when you realise they have just had a light bulb moment, after seeing a story told geographically.  Ok, we will now look at a few powerful...

Tableau : Geographic Drilldowns – How Cold is Australia mate ?

Geographic drilldowns are one of my favourite Tableau features – perhaps nearly as cool as Tableau level of detail calculations. Being able to drill up and down through geographic data is something that lifts eyebrows every time and is much more exciting than a pivot table....

Tableau 9 Level of Detail Calculations – Ranking Dallas Buyers Club

Much like a puppeteer, writing a report involves pulling the strings behind the scenes, and animating an expression to the front stage. Tableau 9 brings a bucket load of new features to the already popular reporting tool…. Introducing LEVEL of DETAIL CALCULATIONS…. my...

Connecting to your Power Pivot data from Tableau

Most organisations have more tools than a bicycle shop.   It is therefore inevitable that the information consumers within your organisation will use more than one BI tool…. and hence it is not out of the question that someone in your business will one day ask …...

Power Pivot: Add a Secondary Axis to a Pivot Chart

You have a Percentage measure to add to your chart and you want this to display on a Secondary axis (because the primary axis already has a sum measure and the difference between the two measures is too far out of proportion). First make sure you have already added your...

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