BI Blogs and Magazines – SQL Server, Excel, Reporting

Spark-TFRecord enables the processing of TensorFlow’s TFRecord structures in Apache Spark.

While you may be a data scientist, you are still a developer at the core. This means your code should be skillful. Follow these 10 tips to make sure you quickly deliver bug-free machine learning […]

Get back to fundamentals with this free eBook, Python For Everybody, approaching the learning of programming from a data analysis perspective.

Also: Automated Machine Learning: The Free eBook; Sparse Matrix Representation in Python; Build and deploy your first machine learning web app; Complex logic at breakneck speed: Try Julia for data […]

In this article, I am going to demonstrate how to access the Power BI PowerShell commandlets. In the previous article in this series, we discussed how to programmatically access the Power BI Service […]

I have already blogged about validating positive integer numbers in this post (SQL SERVER – UDF – Validate Natural Integer Function).First appeared on SQL SERVER – UDF – […]

Question: How to Alter Index to Add New Columns in SQL Server? Answer: It is not possible to Alter Index definition to add or remove columns.First appeared on How to Alter Index to Add New […]

Today is the fourth post in the six post series. We are going to learn about Mapping Relational SQL in MongoDB. Stay Tuned for more learning.First appeared on MongoDB Fundamentals – Mapping […]

Stanford's Natural Language Processing with Deep Learning is one of the most respected courses on the topic that you will find anywhere, and the course materials are freely available online.

Many statisticians in industry agree that blindly imputing the missing values in your dataset is a dangerous move and should be avoided without first understanding why the data is missing in the […]

Agile project management for Data Science development continues to be an effective framework that enables flexibility and productivity in a field that can experience continuous changes in data and […]

In this article, we will talk about SQL interview questions and answers that can be asked in the second-round technical stage. These interview questions are based on real-life experiences. Therefore, […]

In my previous article, Getting started with Azure CLI 2.0, I have explained how to get started with the Azure CLI 2.0. I have also explained how to install it on a local machine and demonstrated a […]

A beginner’s guide to train and deploy machine learning pipelines in Python using PyCaret.

Today is the fourth post in the six post series. We are going to learn about CRUD operation: Deleting Objects in MongoDB. Stay Tuned.First appeared on MongoDB Fundamentals – CRUD: Deleting […]

Also: Everything you need to become a self-taught #MachineLearning Engineer ; SQL Cheat Sheet (2020) - a useful cheat sheet that documents some of the more commonly used elements of SQL;

Caserta is offering a limited number of virtual pro-bono data and analytics workshops conducted by industry leaders Joe Caserta and Doug Laney exclusively for eligible senior leadership. Learn more […]

This article focuses on design principles of the PCA algorithm for dimensionality reduction and its implementation in Python from scratch.

This is the second part of a conceptual article for data professionals and enthusiasts interested to work on a test-driven data warehouse development concept by using tSQLt an industry recognized SQL […]

There's no free lunch in machine learning. So, determining which algorithm to use depends on many factors from the type of problem at hand to the type of output you are looking for. This guide offers […]

This article guides you through importing XML documents into SQL tables using SSIS packages. Introduction to XML Extensible Markup Language(XML) is a simplified markup language. It is an open-source […]

In this article, I’ll introduce you to a hot-topic in financial services and describe how a leading data provider is using data science and NLP to streamline how they find insights in […]

Today is the fourth post in the six post series. We are going to learn about CRUD operation: Updating Objects in MongoDB. Stay Tuned.First appeared on MongoDB Fundamentals – CRUD: Updating […]

Pandas is instantly familiar to anyone who’s used spreadsheet software, whether that’s Google Sheets or good old Excel. It’s got columns, it’s got grids, it’s got rows; […]

We show a comparative performance benchmarking of Julia with an equivalent Python code to show why Julia is great for data science and machine learning.