Road Map to use Microsoft ML tools

I normally work with most of the Microsoft tools for the aim of doing machine learning. I came up with a roadmap that shows what option for machine learning we have with Microsoft tools in Data Platform. this roadmap is not completed yet, I need to update it one later with some tools such azure Read more about Road Map to use Microsoft ML tools[…]

R Chart into SSRS (ggplot2 package in SQL Server 2017)-Part 2

“In the last post, you have seen how we can create a chart by importing data from SQL Server 2017. By doing this, we have a reliable code for drawing chart. Now, we sure our codes work fine, we can put the codes in SQL Server 2017. In this post, I am going to show Read more about R Chart into SSRS (ggplot2 package in SQL Server 2017)-Part 2[…]

Microsoft SQl Server ML Services: RevoScaleR Package

  RevoScaleR Package RevoScaleR is packages created by Revolution Analytics (own by Microsoft) with the aim of importing, transforming, and analyzing data at scale. There are different categories of functions for the data store, imports and save as, data transformation, draw some charts such as histogram, line and so forth, descriptive analysis, predictive analysis, package Read more about Microsoft SQl Server ML Services: RevoScaleR Package[…]

Diagram your Database Tables using Power BI

Ever wanted to create a diagram of your MS SQL Database tables in Power BI?  Here is what I did to make that happen. The approach is to build a query that can be run against the catalog system views inside each MS SQL database.  The approach is to build a list of “From” and Read more about Diagram your Database Tables using Power BI[…]

Dynamic SQL Using Power Query

Every so often I find myself needing to import data, but only want data relevant to values already existing in my data model.  This is common where I build smaller models based on a subset of fact or transaction records.  Rather than bring in entire dimension tables, I may only need the dimension records that Read more about Dynamic SQL Using Power Query[…]

Power BI On-Premises; Hello World!

It has been a very long time request from users around the world to make Power BI available for on-premises, not for using on-premises data sources (this is available from long time ago with gateways), but for publishing reports into on-premises server. With the fast pace of development of Power BI this feature was looking Read more about Power BI On-Premises; Hello World![…]

Top 10 Blog Posts of 2016

2016 was the year of raising Power BI in my opinion, Here is the list of top 10 blog posts that you clicked mostly in this year; How to Do Power BI Mapping with Latitude and Longitude Only. This post was written when Power BI didn’t supported latitude and longitude only for map visualization. Nowadays Read more about Top 10 Blog Posts of 2016[…]

Step by Step Walk through: On-Premises Live SQL Server Connection with Power BI Enterprise Gateway

I have mentioned previously that one of the ways to step beyond Power BI 10GB limitation is to use Power BI with Live Connection. In this post I will explain in a full step by step walk through how to use SQL Server as a DirectQuery or Live source for Power BI, and how to Read more about Step by Step Walk through: On-Premises Live SQL Server Connection with Power BI Enterprise Gateway[…]

Temporal Tables and Their Roles in ETL and Data Warehouse

It is my pleasure to speak in PASS 24 Hours session for Evolution of Data Platform on the topic above. I look forward to meet you all in this webinar. registration is free, but limited. So reserve your seat now. Here are some information about my session and 24HOP. 24HOP 24 Hours of PASS is Read more about Temporal Tables and Their Roles in ETL and Data Warehouse[…]

Temporal Tables: A New Method for Slowly Changing Dimension

SQL Server 2016 CTP 3.0 is available, and some of you already played with it. There are great set of new features for BI in 2016 in all areas; SSIS, MDS, SSRS, and SSAS. However there are some features which are part of Database Engine but still relates to BI and Data Warehousing. Temporal Tables Read more about Temporal Tables: A New Method for Slowly Changing Dimension[…]