DMX practice for Tourist Recommendation System


there is a first experience with DMX

I employed  DMX in my .NET code last year to create a travel mining model for predictions travel budget, length of travel, destination.

I need to predict via different algorithms.

so I have  added a reference to Microsoft.AnalysisServices.AdomdClient to my C# project

using Microsoft.AnalysisServices.AdomdClient;

public AdomdConnection connection = new AdomdConnection(“Data Source=****;Catalog=****”);

it was created a dynamic model..that traveller or admin of system can change the predict attributes also the algorithm type.

so user now able to create a model even for travel length, budget,activity and destination. Also there is a possibility to choose any algorithm that traveller interested

from clustering, associative rules …


after creating model now I can select the actual data to load them into model


and finally I

and finally I use the select query in DMX to show the result of prediction. in this example I employed the clustering algorithm .


Leila Etaati on LinkedinLeila Etaati on TwitterLeila Etaati on Youtube
Leila Etaati
Trainer, Consultant, Mentor
Leila is the first Microsoft AI MVP in New Zealand and Australia, She has Ph.D. in Information System from the University Of Auckland. She is the Co-director and data scientist in RADACAD Company with more than 100 clients in around the world. She is the co-organizer of Microsoft Business Intelligence and Power BI Use group (meetup) in Auckland with more than 1200 members, She is the co-organizer of three main conferences in Auckland: SQL Saturday Auckland (2015 till now) with more than 400 registrations, Difinity (2017 till now) with more than 200 registrations and Global AI Bootcamp 2018. She is a Data Scientist, BI Consultant, Trainer, and Speaker. She is a well-known International Speakers to many conferences such as Microsoft ignite, SQL pass, Data Platform Summit, SQL Saturday, Power BI world Tour and so forth in Europe, USA, Asia, Australia, and New Zealand. She has over ten years’ experience working with databases and software systems. She was involved in many large-scale projects for big-sized companies. She also AI and Data Platform Microsoft MVP. Leila is an active Technical Microsoft AI blogger for RADACAD.

Leave a Reply