Latest News

The CALCULATE Function—New DAX Video Tutorial Just Published

We have just published our newest, 47-minute video tutorial: DAX: The CALCULATE Function. Marco Russo, respected author and mentor from sqlbi.com, explains when to use this function and introduces its syntax, before showing you in-depth examples of how to manipulate ﬁlters at column granularity level, and how to transform a row context into a ﬁlter context, in 5 extensive, high-resolution demos. Learning these concepts will enable you to write advanced, real-world calculations in Data Analysis Expressions, such as percentage of a total, that work properly with other ﬁlters, slicers, and so on. This tutorial is part of our video series on DAX, and you should study it, ideally, after you have learned about DAX Evaluation Context.

19 December 2012
1247 views

SQL Server 2012 SP1, Hekaton, xVelocity, PolyBase, Data Mining, Mobility, Office & SharePoint 2013

Microsoft have just announced the immediate availability of SQL Server 2012 SP1. Let me explain why these are important to anyone involved in data mining, or in the rest of Microsoft Business Intelligence, and let me brieﬂy summarise the remaining announcements, regarding Project Hekaton, PolyBase, and mobility.

7 November 2012
2 comments
7871 views

Chris Webb Makes MDX Easy

Chris Webb, one of the world’s most read authorities on SQL Server Analysis Services and Multidimensional Expressions, has kindly agreed to record a series of training videos focussed on MDX for us. We have a new tutorial, already available online, introducing the most fundamental, and most important, three concepts: unique names, tuples, and sets. More modules will be published over the course of the next few months.

27 October 2012
1293 views

New DAX Training Module Published: Evaluation Context

Marco Russo’s newest addition to our growing learning series on DAX, Data Analysis Expressions, explains Evaluation Context, the fundamental aspect of this language. Click here to watch his 50-minute video, containing 8 detailed demos, in which Marco teaches you about row and ﬁlter contexts, as well as the many ways to manipulate it, so that you can express yourself fully in DAX. Amongst others, Marco explains how to use DAX functions that help you work with context, including those that propagate it across table relationships. FILTER, ALL, EARLIER, VALUES, RELATED, and RELATEDTABLE functions are covered in Marco’s explanations, demos, and a 1000-word article that accompanies the video.

30 September 2012
1310 views

SharePoint Conference 2012

Rafal will be presenting a full-day pre-conference seminar on Business Intelligence, on 11 November 2012, followed by a break-out session, “Attractive Business Intelligence”, during the main part of the conference.

28 September 2012
1 comment
4939 views

New DAX Course Module Just Published

We have just published the third module in our learning series focused on Data Analysis Expressions. Introduction to DAX is a rapid-pace, 40-minute video that introduces all the fundamentals of this new and important language for analytics. This video is a collaboration of two presenters: Marco Russo and Alberto Ferrari, well-known experts on this subject, and published book authors, from sqlbi.com. Marco explains DAX concepts, while Alberto shows them in his 9 detailed, high-resolution demos.

21 August 2012
1141 views

Marco Russo Knows His DAX

I would like to thank Marco Russo, a renowned expert on SQL Server Analysis Services and Data Analysis Expressions (DAX) guru, for agreeing to record a series of educational videos for our site, on which he has collaborated with Alberto Ferrari. If you are interested in becoming an expert on Data Analysis Expressions, Marco would suggest you start at the very beginning, by learning the diﬀerence between calculated columns and measures. He explains it in his free, 10-minute video: DAX: Calculated Columns vs. Measures.

16 August 2012
1119 views

Alberto Ferrari Welcomes You with DAX in Action!

Alberto Ferrari and Marco Russo are world-renowned for their in-depth knowledge of SSAS, and they would like to share their skills with you, no matter how advanced you are, through our brand-new, online video learning series focused on Data Analysis Expressions. To help you get started, Alberto has recorded a free, 20-minute video “DAX in Action!”, in which he shows how to build a formula for a DAX calculated measure, which lets you count the number of repeat, active customers who have made a purchase. We are also oﬀering a discount to celebrate our ﬁrst birthday and to welcome our new authors.

31 July 2012
977 views

Sample Data for Learning Data Mining Published

We have just updated, and published, our sample data set, HappyCars, which is useful for learning Data Mining. It has been specially formulated to help you study various data mining algorithms. This data set comes with SQL Server 2012 data tables and views, as well as a SQL Server Data Tools project, containing several data mining structures, and mining models. This set is designed as bonus material, to be used while practicing many of the demos shown in our data mining videos.

HappyCars is available to Full Access Members, and it can be found here.

6 July 2012
791 views

Data Mining: New Module Published on Model Building, Testing, and Predicting

We have just published the newest addition to the Data Mining online video training course. The third module in this series shows you how to: build, train, validate, and use for predictions (score) models, using your data. In this 1-hour-20-minute video you will also see 11 demos demonstrating every step in the process of working with a mining model, using a simple case of modelling customer characteristics, in order to predict sales to future, potential customers. You can ﬁnd this module by clicking here. You need to be a Full Access Member to view this video.

30 June 2012
940 views

Pages

More news

Search form

Pages