## Introduction to M, the Power Query Formula Language

Its name is Power Query Formula Language. But if you call it that, no one will know what you are talking about. The original informal language name M seems to have stuck, and even the Microsoft documentation refers to M. Every time you create a query in Power Query, whether in Excel or Power BI, […]

## SQL Server vNext (aka 2017) CTP2 Includes Python Scripting

More Analytic Excitement in SQL Server 2017 Last week (the third week in April 2017) Microsoft released its Community Technology Preview 2.0 for SQL Server vNext, more often referred to as simply “SQL Server 2017”. Among the many new features of interest to business intelligence analysts, data scientists, and machine learning afficianados is support for […]

## Monte Carlo Methods in Excel: Part 4 – The Triangle Distribution

A mathematician friend of mine worked for the Navy on calculations involving the movement of sound waves through water. It’s a difficult problem, since the speed of sound varies with temperature and salinity. Being a mathematician to the core, he always wanted the exact answer. At times the Navy had to shake him by the […]

## Monte Carlo Methods in Excel: Part 3 – Some Helpful Tricks

Monte Carlo Methods in Excel: Part 3 – Some Helpful Tricks Andea S. , a student in Learning Tree’s course Power Excel: Analyzing Data to Make Business Decisions, expressed dismay about a problem at work. When she attempted to plot the results of her Monte Carlo inventory and production model, her entire set of model […]

## Monte Carlo Methods in Excel: Part 2 – Random Numbers

Monte Carlo Methods in Excel: Part 2 – Random Numbers All Monte Carlo methods rely on a source of random numbers. Most such sources would more precisely be called pseudorandom numbers, since a deterministic algorithm cannot, by definition, ever produce truly random numbers. If you Google “random numbers” you will encounter a daunting list of […]

Type to search blog.learningtree.com

Do you mean "" ?