Discover tomaztk/Applied-data-science-AML-online Open Source project

Apache Spark for data engineers

Spark-for-data-engineers

Using Python Pandas dataframe to read and insert data to Microsoft SQL Server

MSSQLSERVER_Pandas

DAX Functions with Power BI

DAX_Functions

Data Lineage for Microsoft SQL Server, Azure SQL Server and Azure Synapse

SQLServer-Data-Lineage

Real-Time data visualization with Dash Python and Microsoft SQL Server

Real_Time_Visualization_with_Dash_Python_and_SQLServer

List of useful R packages for data scientists

List_of_R_packages_for_Data_scientist

Powershell-scripts-for-PowerBI

Powershell Scripts for Power BI

PowerShell

Benchmarking-file-formats-for-cloud

Benchmarking file formats for cloud storage

SLODUG2017

Azure-Machine-Learning

Azure Machine Learning

Generate datasets for R projects

datasetR

Real_Time_Visualization_with_R_and_SQLServer

Real Time data visualization with R (R Studio) and Microsoft SQL Server

Install_setup_R_using_Powershell

Installing R and RStudio and setup R using Powershell

Using_Python_with_SSRS

Using Python with Microsoft Reporting Services (SSRS)

SQLPL

Working_with_system_commands_in_R

Working with system commands in R

workshop-spark-data-engineers

Workshop material for "Spark for Data Engineers"

Framework for using Microsoft R Service in SQL Server 2016 with lots of prepared statistics and analysis

r_framework_for_sqlserver2016

Finding_and_replacing_duplicates_across_columns_R

Finding duplicates in data frame across columns and replacing them with unique values using R

Business-rules-for-T-SQL

Manage your business rules in T-SQL

Using Python create, manage and use your Azure SQL Database

AzureSQL_with_Python

SQL Saturday statistics - Web Scraping with R and SQL Server

SQL_Saturday_statistics-Web_Scraping_with_R_and_SQL_Server

Popular 2048 game with T-SQL

2048_sql_game

Creating data frame using structure() function in R

R_dataframes_with_structure

DataType_R_TSQL_Integration

Code and tests for R and TSQL Data Type issues

PowerBI_R_visual

Power BI Desktop and R script visual

MSSQLServerRestAPI

REST API for reading and writing data to Microsoft SQL Server

JavaScript

input_data_parameter_R_TSQL

input_data parameter testing for R_TSQL procedure sp_execute_external_script

Azure-Data-Studio-Notebooks

Notebooks for Microsoft Azure Data Studio

Comparing K-Means and REvoScaleR K-Means

query_store_sql_server_2016

PLSQL

Compare_kmeans_rxKmeans

Microsoft-Fabric

Sudoku game with R Language

Sudoku_game_with_R

R_null_NaN_inf_Na_values

R nullable values: NULL NaN Inf Na

Installing_R_packages_using_TSQL

Installing R Packages / Libraries from SSMS using T-SQL

Passing_two_queries_to_sp_execute_external_script

Passing two queries to sp_execute_external_script

Assocication_Rules_on_WWI_SqlServerRServices

Association Rules on WideWorldImporters and SQL Server R Services

Resource_Governor_external_resource_pool_Microsoft_R_Services

Resource governor and external resource pool for Microsoft R Services

tomaztk

My Git

Common_DataScience_Mistakes

Common Mistakes Data Sciencists do

Multiparameters_R_SQL_Server

Using @param and @parameters1 parameters on sp_execute_externa_script for R execution

Analytics_AzureDatabricks

Analytics with Azure Databricks

Connect 4 game with T-SQL

Connect4_sql_game

SQL Server job title generator using T-SQL

Animated_Barplot_with_R

Animated Bar-plot with R

TSQL_Job_title_generator

Games-with-TSQL

Games with T-SQL

HTML

TSQL_Date_Time_Manipulation

T-SQL Date and Time manipulation

PLSQL

R_for_DBA_SQLSatSlovenia2016_

R Statistics and visualizations for DBA (SQLSat Slovenia 2016)

PowerShell

Finding_substrings_in_R

Looking up for frequent sub-strings in vocabulary with R

Analytics_MLNET

Analytics with ML.NET

Azure-Synapse-Analytics

Azure Synapse Analytics

Presentation to Machine Learning Algorithms in Azure

Analytics_CosmosDB

Analytics with Cosmos DB

Java

Azure_Machine_Learning_Algorithms

First_Release_Dates_R_Packages

First Release dates of R Packages and some other statistics

R_SSRS_reports

Using R in SQL Server Reporting Services (SSRS)

handling_required_R_packages

Handling required and missing libraries for Microsoft R Services

Azure_Powershell

Powershell scripts for Microsoft Azure automation

PowerShell

Analytics_AutoML

Analytics with Automater Machine Learning