I am delighted to welcome Carmel Gunn from Prodata SQL Centre of Excellence in Dublin, company well-known in Ireland, and around the world in the SQL community for its BI expertise. Carmel works with large enterprises as a Data Management Specialist. Carmel is our newest author, and she has kindly agreed to record Excel BI for Enterprises online video training, focusing on the neglected aspect of corporate BI: the user. She teaches how to use Excel to explore, analyse, and report data insights contained in powerful corporate BI models, usually provided by an IT department, such as multidimensional OLAP cubes, tabular models, or models created with Power Pivot.

Start by watching her free “How to Make Enterprise Dashboards” in Excel video, in which she carefully shows how to create a professional-looking, fully functional dashboard, in under 30 minutes. The follow up with fundamental Excel BI concepts, such as: measures, dimensions, attributes and hierarchies, by listening to her no-nonsense explanations aimed at BI users in the “Excel BI: Basic Concepts” video, which is also designed to help you become an adept user of Excel Pivot Table functionality.

• 4 September 2013
• 1537 views

If you ever wanted to learn decision trees, the most fundamental, easy to build, fast to run, and, above all simple to interpret yet powerful analytical technique, start now! We have just published two new videos on this subject, by Rafal Lukawiecki. In the first, he answers the question “What are Decision Trees?” with a short, 10-minute demo. The second video, “Decision Trees in Depth,” goes way into the subject: almost 2 hours of discussing and seeing decision trees in action, covering flattened-data (case-level) trees, nested cases for associative trees, and even regressive decision trees, useful for price elasticity simulation and other powerful—but still easy!—forms of numerical modelling. You will also see the very new, just-introduced, SQL Server Data Tools 2012 in a data mining action. Go ahead, learn this amazing bit of powerful but easy analytics today.

• 29 March 2013
• 954 views