Latest News

Microsoft Business Analytics Roadshow 2014

I am pleased to announce the schedule of our 7th annual business analytics roadshow. I will focus on the very newest Power BI in Oﬃce 365 and in Oﬃce 2013, SQL Server 2014, HDInsight, Parallel Data Warehouse, and SharePoint 2013, and a few, as-of-today super-secret advanced analytics subjects. This year’s tour will include: Austria, Denmark, Finland, Ireland, Norway, Spain, South Africa, Sweden, Switzerland, United Kingdom, and United States.

1 April 2014
6 comments
4880 views

Common Business Calculations with MDX

There is a group of very common business calculations—previous period growths (are our sales up compared to last quarter?), time-to-date (year-to-date etc) comparisons, percentage shares, and moving averages—that we all require in our reports from time to time. Chris Webb, the undisputed authority on MDX introduces them in his two newest videos.

25 February 2014
887 views

What is Power BI?

Microsoft Power BI has just been launched, minutes ago, and is now generally available for purchase. Think of it as a pre-built, fully-managed-for-you, SharePoint-like environment that lets you grow an ecosystem of user-created BI. Read this article for insight into what makes up the entire Power BI family.

10 February 2014
1 comment
3916 views

Speaking at SQL Server Konferenz 2014

I am delighted to have been asked to present the keynote at the SQL Server Konferenz 2014, organised by the German SQL PASS chapter. My opening session, titled Data Science with SQL Server, will outline approaches to advanced analytics that SQL Server enables, based on my decade-long experience of doing just that. I will, however, also talk about the future of this interesting occupation, in particular in view of the upcoming, new technologies.

1 February 2014
628 views

New Free MDX Course Modules and CurrentMember

We have just published two new modules in Chris Webb’s MDX training course, and we have made his earlier one, MDX Queries, freely available to all viewers! This month you can learn about the all-important CurrentMember function, and the key numeric functions, including Sum() and Aggregate().

31 January 2014
1215 views

Navigating MDX with Set and Member Functions by Chris Webb

Being able to think in sets is the key to being able to write more advanced queries and calculations in MDX. Chris Webb, world-authority on Multidimensional Expressions and SQL Server Analysis Services from Technitrain, introduces the commonest MDX functions that return sets in his newest, 40-minute, demo-focused video: Member and Set Functions. Amongst others, he explains: .MEMBERS, CROSSJOIN(), .PARENT, DESCENDANTS( ), ANCESTOR(), .NEXTMEMBER, .PREVMEMBER, .LEAD() and .LAG().

18 December 2013
552 views

Handle Hierarchies in Power Pivot or SSAS with DAX

Marco Russo, DAX and tabular modelling expert from sqlbi.com explains that, contrary to general opinion, handling even complex hierarchies, such as parent-child ones, in Data Analysis Expressions can be easy. There are a few interesting formulas that you need to be aware of, and a particular use of traditional bridge tables, to enable sophisticated hierarchical navigation and computation in Power Pivot or in SQL Server Analysis Services Tabular. To help you learn this, we have just published two new videos by Marco.

10 December 2013
542 views

Learn MDX with Chris Webb

I am very pleased that Chris Webb, the leading authority on Multidimensional Expressions from Technitrain, has kindly recorded a series of videos for his new MDX online course. There are three modules for you to enjoy: MDX Basics Concepts, and as of today, MDX Queries and MDX Calculated Members.

4 December 2013
2335 views

3 New DAX Patterns to Learn

We have just published two new videos by Alberto Ferrari, world-renowned BI and DAX expert from sqlbi.com. They teach you about three critically important patterns in DAX: banding (eg. prices), new-vs-old computation (eg. sales to new vs returning customers), and the all-important concept of working with many-to-many relationships. The ﬁrst video, Many-to-many Relationships in DAX, is short and free!—have a look at it if you have ever wondered how to use a many-to-many relationship in Data Analysis Expressions.

20 November 2013
711 views

Speaking at SharePoint Conference 2014

I will be speaking at both US and European SharePoint Conferences 2014, presenting about all that’s new and exciting in the world of BI and advanced analytics. In addition to my breakout presentations, at both conferences, I will also teach a full-day pre-conference seminar (2 March and 5 May), which will focus on the entire Microsoft BI stack, including the new Power BI, HDInsight for big data, and all the most recent news regarding advanced analytics.

18 November 2013
1359 views

Pages

More news

Search form

Pages