Learn the difference between calculated columns and measures in Data Analysis Expression (DAX) in this free, 10-minute video by Marco Russo, a well-known book author on the subject. Calculated columns are calculated row-by-row when the content of a table is refreshed, whereas measures are computed at query time, by aggregating rows. However, they have different uses, including filtering or classifying data, so you often need to make a trade-off between purpose and performance.

• 16 August 2012
• 46761 views

See the power of Data Analysis Expression (DAX) language in BI Semantic Model (BISM) with PowerPivot and SQL Server Data Tools (SSDT) in this free, 20-minute video by Alberto Ferrari. In the demo shown in this video we create a simple data model, based on the AdventureWorks sample database. We show you how to write a challenging formula: counting how many new and returning customers make a purchase every month. If you would like to gain DAX skills, this video, first one in our series focusing on DAX, shows you what could be accomplished without even having to change the model of your data.

• 30 July 2012
• 30677 views

CALCULATE is the most important function in Data Analysis Expression (DAX) because it allows you to manipulate filter context, which is necessary for building real-world calculations. Let Marco Russo explain it to you in this 47-minute video tutorial that contains 5 detailed demos. You will learn: when to use CALCULATE, its syntax, how to manipulate filters at column granularity level, and how to transform a row context into a filter context. Learning these concepts will enable you to write advanced calculations in DAX, and it will make following the remaining modules of our DAX video series easier.

• 19 December 2012
• 16718 views

Create zoomable world maps that show your data using Power View in Excel 2013, and Bing! Rafal also shows geospatial aggregations, and a SharePoint dashboard with an animated bubble chart, in this free, 16-minute video.

• 4 March 2013
• 12460 views

This 50-minute video introduces the fundamental concepts of Data Mining, a powerful analytical technology. You will learn about the process of data mining and the SQL Server Analysis Services (SSAS) Data Mining architecture, and its key concepts, including: Cases, representing your data, Mining Structures, used to describe Cases, Mining Models, and Mining Algorithms, which extract patterns hiding in your data. We briefly introduce 9 of the Microsoft data mining algorithms: Naïve Bayes, Clustering, Decision Trees, Association Rules, Sequence Clustering, Neural Networks, Logistics Regression, Linear Regression, and Time Series. You will also learn about Column Content and Data Types, Discretization, and data Distributions, as you follow the module and the 5 demos shown in it.

• 27 May 2012
• 10568 views

This short, free, 15-minute video by Chris Webb introduces Microsoft Power Query and its key functionality: data extraction from different sources, cleansing, transformation, aggregation, and loading of the results.

• 26 November 2014
• 8813 views

Evaluation Context is fundamental to understanding the behavior of DAX. Marco Russo explains: row and filter contexts, their propagation through relationships, and manipulation using: FILTER, ALL, EARLIER, VALUES, RELATED, and RELATEDTABLE functions in this 50-minute video that contains 8 detailed demos. Learning these concepts will enable you to write correctly functioning formulas, and it will prepare you to fully understand CALCULATE, the most important function in Data Analysis Expressions, as well as the remaining modules of our DAX video series.

• 30 September 2012
• 8276 views

This 1-hour-20-minute video discusses the entire lifecycle of a Data Mining Model. You will learn how to build models and mining structures, starting by creating a Data Source and Data Source View, how to train it with your data, and how to view the results. Most importantly, you will also understand how to verify a model's validity, by applying tests of accuracy, reliability, and usefulness. You will understand, and you will also see being used, such key verification techniques as: a Lift Chart, Profit Chart, Classification Matrix, and Cross Validation. Finally, you will see how to predict unknown outcomes using your model. Not only will you hear in-depth explanations, but you will also see 11 live demos, showing you all the aspects of working with Data Mining Models, including using SQL Server Data Tools (SSDT), and Microsoft Excel, for predicting (scoring) sales to future, potential customers, based on their demographic characteristics, and their shopping habits, just discovered using a Decision Tree, and a simple mining model.

• 30 June 2012
• 7850 views

Predictive Analysis is an advanced form of Business Intelligence, which uses Data Mining. In this short demo you will see how Microsoft Excel makes it easy to use.

• 17 September 2011
• 7016 views

Microsoft Business Analytics combines Business Intelligence with Data Warehousing and Big Data Analytics. This 1-hour 20-minute video by Rafal Lukawiecki introduces this concept by showing you how real-world analytics, created by a power user in Excel 2013, can be shared with others in a company, using SharePoint Server 2013, and subsequently scaled-up to the needs of an enterprise, by means of a SQL Server 2012 SP1 Analysis Services Tabular Model. Rafal covers the entire subject broadly, showing you some of the new Excel and SharePoint 2013 BI features, such as: the new Power View, Interactive Geospatial Maps, Data Models, Quick Explore, Timelines, and many more, in an extensive, 9-part, 55-minute, high-def demo, focusing on the enterprise lifecycle of user-created analytics, which forms the core of this video tutorial.

• 2 March 2013
• 6861 views

Time Intelligence is a set of techniques for performing time and date-based calculations. It covers a broad set of calculations needed for business reporting. Let Alberto Ferrari, book author and a renowned Data Analysis Expressions expert, show you an in-depth tour of these functions, in this 1-hour video that contains 6 detailed, hi-def demos. You will learn about: calendar tables, time-based role dimensions, TOTALYTD, TOTALQTD, TOTALMTD, and the CALCULATE function used with time-oriented, predefined and custom filters, and dealing with semi-additive measures, including last-day, or last-non-empty aggregations.

• 27 August 2013
• 6172 views

Hierarchies, including parent-child ones, can be created using a combination of a few DAX formulas and a data model in Power Pivot or SSAS Tabular. Marco Russo, BI expert from sqlbi.com, shows you how to work with them in this 55-minute video. Well-implemented hierarchies can greatly enhance navigation and usability, so learn how to implement their calculation logic by watching this demo-rich tutorial.

• 10 December 2013
• 5674 views

Decision Trees are the most useful Microsoft data mining technique: they are easy to use, simple to interpret, and they work fast, even on very large data sets. At heart, a decision tree is just a tree of nodes. Each node represents a logical decision, which you can just think of as a choice of a value of one of your inputs that would make the most profound difference to the output that you wish to study. This almost 2-hour, in-depth video by Rafal starts with an explanation of the three key uses of decision trees, which are: data classification, regression, and associative analysis, and then takes you on a comprehensive tour of this data mining algorithm, covering it in slides and detailed, hi-def demos, which you can follow. Once you try a decision tree a few times, you will realise how easy, and useful they are to help you understand any sets of data.

• 29 March 2013
• 4825 views

Carmel Gunn, a Data Management Specialist from Prodata introduces fundamental concepts of Excel BI: measures, dimensions, attributes, and hierarchies, while explaining how to use them in your pivot tables. In the extensive, 30-min demo, you will also learn about the layout of the Excel BI tools, including the Pivot Table Fields List and its Fields Section, the Design ribbon, and even how to add a new calculated measure.

• 4 September 2013
• 4525 views

This video shows data being mashed-up from multiple sources using Microsoft PowerPivot and DAX, all by the end user, in a self-service way.

• 18 September 2011
• 3974 views

Let Chris Webb introduce the fundamentals of Power Query: connecting, transforming, and loading of the results, in this detailed, demo-driven, hands-on 45-minute video, which focuses on the Query Editor in Power Query.

• 26 November 2014
• 2778 views

Carmel Gunn and Bob Duffy explore the Irish Economic Crisis using Power Query, Power Map, Power View and Q&A in this 40-min video. Could Power BI prevent a small country run a shocking €200bn debt?

• 24 March 2015
• 2565 views

Following from his quick intro to Power View, Ben Watt presents a 50-minute in-depth tutorial leading you through all of the features of this data exploration and reporting tool. You will learn how to connect to data, use filters, all of the visualisations, how to format maps and how to share your reports using Power BI.

• 24 May 2015
• 1273 views

There are two ways to connect Excel on the desktop up to data stored in Power BI: you can use the Analyse in Excel feature that was shown in an earlier section, or you can use the Power BI Publisher for Excel add-in which is probably easier to use for most users. Once you have created the connection you can use an Excel PivotTable to browse data in Power BI.

• 17 November 2017
• 162 views