Dimensional Model Report using Adventure Works sample data

Today we will show you how to: – Import data from MS Excel – Create dimensional model – Create relational data model – Create hierarchies – Create charts, diagrams, slices, matrix and maps – Create measures using Data Analysis Expressions (DAX) We will use Adventure Works sample data available at GitHub for this tutorial https://github.com/microsoft/powerbi-desktop-samples/blob/main/AdventureWorks%20Sales%20Sample/AdventureWorks%20Sales.xlsx…

Read More

Machine Learning, Classification using Nearest Centroid Classifier

In this tutorial, we will show you how to: – Read a csv file using Pandas library – Create and train a Nearest Centroid Classifier sklearn.neighbors – Use Principal component analysis (PCA) to compress dataframe – Predict #Iris dataset using Nearest Centroid Classifier – Create Visualizations using matplotlib #python #machinelearning #matplotlib #sklearn #scikitlearn #nearestcentroid #nearestcentroidclassifier…

Read More

Support Vector Machine for Classification

In this tutorial, we will show you how to: – Read a csv file using Pandas library – Create and train a Support Vector Machine (SVM) – Use Principal component analysis (PCA) to compress dataframe – Predict #Iris dataset using Support Vector Classification – Create Visualizations using matplotlib #python #machinelearning #matplotlib #sklearn #scikitlearn #supportvectormachine

Read More

How to create and train a neural network machine learning model using sklearn/scikit-learn

Today we will show you how to create and train a neural network machine learning model using sklearn/sci-kit learn. We will use MLP Regressor (Multi-layer Perceptron Regressor) as model, RELU (rectified linear unit) for activation, LBFGS (Limited-memory BFGS) as solver/optimizer. We will try to teach the model how to predict the average of eight random…

Read More