BI & Analytics Online Tutorials

Table of content (right and below) is organised by topic. Courses group content into recommended learning paths. Use AllLatest, and Popular menus to list everything. We also provide classroom-based training and consulting


Judy Soares · 14 March 2012

Hi Rafal,
I’ve just attended the SQL Server 2012 launch in Johannesburg, and I would like to say that I really enjoyed all of your presentations. You are an inspiration to anyone that works with SQL Server. Well done and thank you. Regards, Judy

MASIALETICK · 15 March 2012

The launch in Cape Town was fantastic. I have been greatly inspired.

Sue Whaits · 16 March 2012

Great Launch in Cape Town… love the stuff MS has brought in wrt BI

shaikh.iftikhar · 30 May 2012

Hi Rafal,
Your presentations in Canada were awsome. I just have a question for you. We already have Oracle and SQL Server 2008 R2. I can get SQL Server Business Intelligence 2012 too. Can you tell me for a complete architecture of DW project and what are your recommended components I would need (Dashboard or reporting tool, ETL, BI, DB)?

Rafal Lukawiecki · 1 June 2012

Hi Shaikh, thanks for your nice comment. The entire Microsoft-based BI stack starts with SQL Server database engine for the DW itself, SQL Server Integration Services (SSIS) for ETL, which works well with Oracle, SQL Server Reporting Services (SSRS) for reporting, and SQL Server Analysis Services (SSAS) for enterprise analytics (cubes, tabular, data mining). For dashboards, scorecards, additional reporting, and the new Power View, you need SharePoint Server, which also delivers sharing, collaboration, and manageability. Finally, Office Excel with PowerPivot for self-service analytics, and Office PowerPoint for presenting Power View reports completes the stack. In summary: Microsoft BI=SQL+SharePoint+Office. Bear in mind, you could use any part of the stack directly with your Oracle data, without the rest, if you wish. For example, you could use Excel and PowerPivot to analyse Oracle, or you could build an SSRS report from Oracle, without using the Microsoft DW. In reality, you need to assess the pros and cons of the entire architecture.

Have a look at the short videos in this section of the site, they introduce all the components of the Microsoft BI stack. I also recommend you have a look at some of these books, if you are new to the area.

abacusdotcom · 12 February 2014

Hi Rafal
I had gone through the free videos, they are nice and worth it. Am currently in Nigeria, but in Paypal payment portal, Nigeria is omitted in the country list. Kindly advice on alternate payment method. Many thanks.


Rafal Lukawiecki · 13 February 2014

Dear Abacus, thank you for your kind comments, I am glad to hear that you find our content worthwhile. I am sorry to say that our instant payment processor, PayPal, does not support transactions originating from Nigeria. You can, however, complete a purchase by selecting the “Pro-forma invoice, pay later” option, and by making a bank transfer—the details for the transfer will appear on the pro-forma invoice. I realise this is not as straightforward as an instant payment, and I promise you that we have been looking into adding additional payment options. I hope to see you as a new subscriber, soon.

dmayi · 7 October 2014

HELP please: I am stuck on trying to get a rolling sum, quarter over quarter in MDX

Month Measure_x Expected Cumulative
Jul 12 12
Oct 30 42
Sept 14 56


WITH MEMBER Measures.[CumulMeasure] AS
‘SUM({NULL:[Fiscal Month].[FMName],[myMeasure])’

[Fiscal Month].[FMName].ALLMEMBERS *

Chris Webb · 14 October 2014

Hi Mayi,

I think the following query, based on the Adventure Works cube, should do what you want:

member measures.[Sales Minus Tax] as
[Measures].[Internet Sales Amount]-
[Measures].[Internet Tax Amount]

member measures.[Fiscal YTD Sales Minus Tax] as
[Date].[Fiscal].[Fiscal Year],
measures.[Sales Minus Tax]),

{[Measures].[Internet Sales Amount],
[Measures].[Internet Tax Amount],
measures.[Sales Minus Tax],
measures.[Fiscal YTD Sales Minus Tax]}
on 0,
[Date].[Fiscal].[Fiscal Year].members,
on 1
[Adventure Works]

Basically it calculates sales minus tax, then calculates a fiscal year-to-date total for sales minus tax based on the current month. Rather than be restricted to a single year, it will work for any month in any year.