Skip to main content

Nisal Mihiranga's Blog

Search This Blog

Talks

Get link
Facebook
X
Pinterest
Email
Other Apps

Microsoft Power BI Hands on Training at APIIT [2018-08-28]

Business Intelligence and Analytics Training at APIIT [2018-08-27]

Real-time Data Analytics using Microsoft Azure Stream Analytics and Power BI at SQL Saturday 750 [2018-08-04]

Unlock the Potential of Enterprise Data Assets using Azure Data Catalog - at SL Data Community [2018-07-18]

EduTech Australia - 2018 [2018-06-07]

Future of Big Data - Processing Big Data using Microsoft Azure Data Lake - Session at University of Sri Jayawardanapura Statistics Day [2018-05-10]

Introduction to Power BI - Hands of Training Session at University of Sri Jayawardanapura [2018-03-18]

Real-time Streaming Data Analytics using Microsoft Power BI - at SL Data Community November 2017

How to Solve the Slowly Changing Dimension Problem Using Temporal Tables - at SL Data Community March meetup, 2017

Microsoft Linear Regression Analysis - at SL Data Community September - 2016

Get link
Facebook
X
Pinterest
Email
Other Apps

Popular Posts

How to Get Row Counts for all Tables in your SQL Database

This is the simplest method to get the row counts of all tables in your SQL Server database. Might be useful when you are doing the data testing over your BI project. select schema_name (tab.schema_id) , tab.name as [table], sum (part.rows) as [rows] from sys.tables as tab inner join sys.partitions as part on tab.object_id = part.object_id where part.index_id IN ( 1 , 0 ) // 0 : Table without PK, 1 : table with PK and schema_name (tab.schema_id) = 'dbo' group by schema_name (tab.schema_id) , tab.name --order by sum(part.rows) desc

Joining Datasets using Multiple JOIN Conditions in Power BI

Joining datasets is a norm in any ETL process specially if you are working with more than one dataset. In Power BI, joining two datasets is super easy, even it is easier than you joining two tables in T-SQL. Thanks for the powerful Power Query language you can perform joining tasks visually. However, sometimes you may get confuse the joining in Power BI because there are close similarities in UI for Joining datasets and Build relationships between datasets. However, my today post is not about How to Join two tables in Power BI . For that, you can read my article on Demystify Joins in Power BI . In this article I'm going to explain to you how to join two datasets using multiple join conditions . I'm sure you have performed this task in SQL many times before. Scenario Assume that I have two tables, Product Table and Sales Table. In my product table I have, Product ID , Product , Color and Unit Price . My Sales table contain daily sales informatio...

Step-by-Step Twitter Sentiment Analysis Using Power BI Streaming Dataset, Microsoft Flow and Azure Text API

Sentiment Analysis is known as Opinion mining or emotion AI which is a branch of Natural Language Processing and text analytics where systematically identify, extract, quantify, and study affective states and subjective information. This kind a analysis widely apply to analyse the product or service reviews, voice of the customer, survey responses from online and social media feeds to analyze the attitude of the customer. Basically from the sentiment analysis the output would be either Positive, Negative or Neutral. There are various algorithms and methods to do a sentiment analysis out there. In this post here I'm doing a sentiment analysis for iPhone 8 product by analyzing twitter feeds. Because, I wanted to know what others are thinking about the latest phone released by Apple. In order to do this task I'm using, Microsoft Azure cognitive services : Text Analytics (to run the sentiment analysis algorithms to get out the results) Microsoft Flow ...

Powered by Blogger

Nisal Mihiranga