Anaconda Python Installation and Package Management for Projects
Learn how to install and use Anaconda to easily keep your Python interpreter and packages separated for different project needs.
Hristo Hristov is a seasoned data professional with 10+ years of experience spanning the intersection of data engineering and smart manufacturing solutions. Since 2017, he has specialized in implementing advanced analytics solutions for bridging the IT/OT gap.
A technical writer with over 80 published articles on data and AI technologies, Python development, and cloud solutions. Passionate about transforming complex data into business value through innovative applications of Azure Data Platform, Python, IoT solutions, databases, and other cloud technologies.
Currently applying Industry 4.0 best practices, focusing on IoT connectivity, and implementing data and AI systems in manufacturing. Hristo holds a degree in Data Science and several Microsoft certifications covering SQL Server, Power BI, and related technologies.
- MSSQLTips Awards
- Achiever Award (75+ tips) - 2026
- Rookie of the Year - 2021
- Author Contender - 2022/2023/2024/2025
Reading and Profiling Data with Python Pandas
This article focuses on reading and profiling data with the pandas package when using Python as well as show how to build charts based on this data.
Python Functions – Median, Quantiles, Variance, STDev and Correlation
Learn how to use statistical functions in Python with data from a SQL Server database along with several different examples.
Read SQL Server Data into a Dataframe using Python and Pandas
Learn how to read SQL Server data and parse it directly into a dataframe and perform operations on the data using Python and Pandas.
Examine pyodbc an Open-Source Module to Access to ODBC Databases
In this tip we examine pyodbc an open-source module that provides easy access to ODBC databases along with several examples of how it could be used.
Python Exception Handling with Try, Except, Else, Finally Clause
Learn how to use exception handling when writing Python scripts along with many different examples using try, except, else and finally clause.
Python Statistics – mean, median, mode, min, max, range, variance
Learn how to use Python to get statistical data for mean, median, mode, min, max, range, variance, standard deviation and correcorrelation.
Python Iterable, Iterator and Generator Examples
In this article we continue the series about learning Python and cover the concepts of iterable, iterator and generator along with several examples.
Built-in Functions in Python with Code Samples
Learn various built-in functions in Python that can be very helpful when working with Python such as iter, len, help, hash, map, print and many more.
Example Python Loops FOR, WHILE, Nested and more
In this article we look at how to use looping logic in Python with various examples of how this can be done.
Python IF, ELIF and ELSE Control Flow Logic
In this article we look at Python control flow and how to construct if else statements along with several Python examples.
Learn Python Functions with Parameters, Nested Functions, Scope Rules
In this article we look at how to create Python function and various aspects of creation and use to simplify coding.
Learn Python List Comprehension for Lists, Tuples, Dictionaries, Sets
Learn how to use Python comprehensions to take advantage of Python's efficient syntax which are applicable to lists, tuples, dictionaries, and sets.
Python List, Tuple, Range, Dictionary and Set Data Type Examples
In this article we present complex built-in data types in Python along with several examples of how to use complex data types.
Basic Built-in Python Data Types
In this article we take a look at the different data types available in Python along with examples of how they can be used.
Setting up Python with Anaconda, VS Code, Power BI, SQL Server
Learn how to get started with Python by setting up your environment using Anaconda, VS Code, Power BI and SQL Server.
5 Valuable Power Apps Functions for Developers
Learn about different functions you can use in Power Apps such as: assert, print, datasourceInfo, showColumns, countRows and isMatch.
Python for Data Professionals
Explore some examples of why a data professional would want to use Python instead of other tools like Azure Data Factory or Power BI.
Power Apps to read and write data to a SQL Server database in Azure
In this article we look at how to create a Power Apps app and read and write data to a SQL Server database in Azure.
Working with SQL Server Data in Power Apps
In this article we look at how to create a basic Power App that allows saving data to a database table.
Display Power BI Dashboards and Reports in Power Apps
In this article we will look at how to display Power BI reports and dashboards in Power Apps.
Power Apps Tips and Tricks
No matter if you are a seasoned Power App developer or just starting, the platform has some caveats and knowing will save you some time and effort.
Edit and Version Power Apps Outside of Power Apps Studio
Learn to use ALM (built-in versioning) and enterprise ALM (Azure DevOps integration) with Power App source files for editing and versioning.
Getting Started with Microsoft Dataverse
Learn about Dataverse which is part of the Power Platform. The article explains advantages and how this could be used for Power Apps and Power BI.