Dataset 008 – Functions and Queries

Dataset 008 is a return to our roots. Long ago we started our journey into Data in the IT world, so we’ve returned to see what we can do now.

00:00 – Introduction
00:56 – Dataset 008: Overview of plan
02:42 – Demo 1 – Create a Function from scratch
03:40 – Auto DateTime
07:40 – Dataset 008: Data sources (see below for URL’s)
08:35 – Dataset 008: Query Editor, how we built the datamodel
09:20 – Dataset 008: Calendar Dimension (including plans)
11:44 – Dataset 008: Incident Tables
13:10 – Dataset 008: Custom Function (see below for code)
19:00 – Dataset 008: Incident table final stages to build and manually editing “M” script
22:24 – Dataset 008: Mining Tables – 1 is a truer status history, 2 singles instance of each status for a ticket
25:20 – Conclusions

Download the data –https://archive.ics.uci.edu/ml/datasets/Incident+management+process+enriched+event+log
Random Names – https://www.randomlists.com/fake-name-generator

Code
let
CreatedID = (FindID) =>
let
LowerCase = Text.Lower(FindID),
RemovenonNumbers = Text.Remove ( LowerCase, {“a”..”z”}),
TrimString = Text.Trim (RemovenonNumbers),
lastchars = Text.End ( TrimString, 3 )
in
lastchars

in
CreatedID

%d bloggers like this: