The previous blog post discusses three common patterns for extracting feature from IoT sensor data: Window-based descriptive statistics Seasonal pattern Trend pattern This blog post introduces how to implement those three patterns in Python. Window-based descriptive statistics There are three main types of descriptive statistics based on what they describe: distribution (e.g., skewness and kurtosis), … Continue reading Extracting Features from IoT Sensor Data using Python
Feature Extraction of IoT Sensor Data
Feature extraction is an important step in IoT-related machine learning process that transforms the temporal data of machine component state into a format supported by machine learning algorithms. The extracted features need to be informative, i.e. need to carry the information that can contribute to the prediction. Due to the temporal characteristic of IoT sensor … Continue reading Feature Extraction of IoT Sensor Data
Refactoring the ChartJS SPFx Web Part Using IoC Container
In the previous blog post, I introduced how to create Chart.js enabled SPFx web parts. In the example I have used in that blog post, I created a IDataSource interface and implemented the interface with a MockDataSource class that was instantiated in the React component. However, there is an issue with this design as the ChartJs React … Continue reading Refactoring the ChartJS SPFx Web Part Using IoC Container
Building SPFx Client-Side Web Parts using Chart.js
Chart.js is a very handy Javascript charting library, lightweight, flexible, sleek UI and free of charge. In this blog post, I will walk through the steps to build SharePoint Framework client-side web parts using Chart.js library. I have created a demo client-side chart web part with the source code on github. This web part allows … Continue reading Building SPFx Client-Side Web Parts using Chart.js
Setup an Azure Dev VM for Testing Power BI + SQL Server 2016 Integration
This blog post walks through the steps to setup an Azure dev vm for testing Power BI + SQL Server 2016 integration: Provision the Azure VM using SQL Server 2016 developer image Configure the SSAS/SSRS services Install development software Install sample databases Integrate SSRS and Power BI Service Install and configure Personal Power BI Gateway (Optional) … Continue reading Setup an Azure Dev VM for Testing Power BI + SQL Server 2016 Integration
Automating Language Translations using Microsoft Flow and Translator Text Service
I had a quick play on the preview version of Microsoft Flow, one of the newest toys offered by Microsoft for creating automated workflows linking a broad range of online apps and services. One feature interested me is the Microsoft translator service which can automate the translation process between languages. So where can we use … Continue reading Automating Language Translations using Microsoft Flow and Translator Text Service
ABC Classification Analysis with Tableau
In one of my previous posts, I have conducted an ABC Classification analysis using MDX against a SSAS Cube. In this post, I will conduct an ABC Classification analysis using Tableau calculations. In this example, we want to classify the products based on their sales amount into three categories: ‘A’ (make up the top 5% of total sales), … Continue reading ABC Classification Analysis with Tableau
Inspecting SharePoint Metadata using Power Query
Power Query is a self-service ETL tool from Microsoft which is able to extract data from a broad range of data sources, transform the data, and finally load the data to PowerPivot. However, I have recently found that Power Query could also be a very handy SharePoint Metadata viewer to inspect the schema of SharePoint sites, lists, content … Continue reading Inspecting SharePoint Metadata using Power Query
Tableau #2 – Visualising Eurovision Voting Path
In the last blog post, I've created a box-and-whisker plot to compare UK's performance on Eurovision contest with others. That would be good to have a nice Viz to show where the votes from for each country. This can be achieved using Tableau Map and Path. It is straightforward to create this Viz using the Path … Continue reading Tableau #2 – Visualising Eurovision Voting Path
Tableau #1 – Analysis of UK’s Eurovision performance
Eurovision is my favourite song contest programme, not only because of the not bad songs but also the acid humour from the BBC presenter Terry Wogan. I have been watching this show for a few years, from my memory, UK has constantly performed poorly on the final voting which has been blamed as "tactical Eastern … Continue reading Tableau #1 – Analysis of UK’s Eurovision performance
Data Ninjago (Finsight-Tech Blogs) 
You must be logged in to post a comment.