Automating machine learning with SQL Server 2019 By Leila Etaati Machine learning is a powerful tool for making predictions based on data. With a plethora of models and approaches available to choose from, simply knowing where to begin can be a project in itself. Data scientists can spend a significant amount of time configuring, Read more about Automating machine learning with SQL Server 2019[…]
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[…]
“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[…]
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[…]
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[…]
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[…]
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![…]
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[…]
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[…]
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[…]