Power BI Quick Reference Guide
Check out this structured reference guide to just about anything you want to know about Power BI and Power BI report development.
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
Automated PDF Document Summarization with Azure OpenAI
Use Azure OpenAI API and a custom Python class to create a summarization pipeline to take a PDF file and produce a summary of the contents.
Build Chatbot with a LLM and Azure SQL Database to Answer Questions
In this article, we look at how to enable a large language model (LLM) to answer questions based on data stored in Azure SQL Database.
Large Language Models with Azure AI Search and Python for OpenAI RAG
Infuse Azure SQL data with retrieval augment generation (RAG) for large language models (LLMs) such as GPT to provide answers to complex questions.
Time Series Forecasting using Python Prophet
Learn how to use the Python library Prophet for time series forecasting to predict a target variable over a period.
Generate PDF file using Azure Functions, Python Runtime and xhtml2pdf
Learn how to generate a PDF file using Azure functions, Python runtime, and the xhtml2pdf package.
Create SQL Server Objects with SQLAlchemy Core for Python
SQLAlchemy introduction to database metadata objects such as MetaData, Table, and Column and how to use them in your Python project.
Build an Object Detection Machine Learning Algorithm using Python
Learn how to build an object detection machine learning algorithm using Python in this step-by-step article.
Enabling Academic Research with Real-World Data Sets from Melissa
Learn how Melissa for Education is helping students with research projects, cyber security, GIS data, medical research, datathons and more.
DuckDB for Fast Analytical Query Workloads on Large Datasets
Learn about and how to use DuckDB a free, open-source database management system intended for fast analytical query workloads.
Know Your Business Data Verification Solution
Meet Know Your Business rules with Melissa Personator Identity Global to prevent fraud or money-laundering and meet legal regulations.
Python Bokeh for Visualizing Real-Time Data
Discover how to utilize Python to visualize streaming data in real-time on your browser with Bokeh.
Python and Jupyter Notebooks for Data Analytics and Data Science
This tip is a step-by-step tutorial on installing Python and VS Code, configuring a virtual environment, and running a Jupyter Notebook.
Combine Data in Python using Pandas Merge, Pandas Join and Pandasql
In this article, we explore three separate ways to join data in Python using pandas merge, pandas join, and pandasql library.
Plotly to Visualize Time Series Data in Python
Learn how to use the Plotly library to visualize time series data in Python in this step-by-step article.
Non Linear Relationship Analysis with Python
In this article, we look at examples of non-linear relationships such as exponential, logarithmic, quadratic, and cubic using Python.
Linear Correlation Analysis using Python with Code Examples
In this article, we look at how to perform linear correlation analysis using Python code along with several code examples.
Python Matplotlib to Present Data Interactively in VS Code
In this tip, we present a step-by-step guide on how to present your data interactively using matplotlib and Python in VS Code.
Python matplotlib for Data Visualizations
In this article, we will examine the matplotlib data visualization library for Python and how to generate charts to visualize data.
QR Code Generator with Power Apps, Azure Function and Python Runtime
Learn how to build a Power Apps application that can generate and read QR codes and interact with a set of data or database table.
Export Large SQL Query Result to Text File with Python
Learn how to export a very large data set from a SQL Server database using Python with pyodbc and dask libraries.
Python Keywords for Functions, Modules, Classes, Variables, Coroutines
In this tip, we learn about various Python keywords and how to use them related to functions, modules, classes, variables, coroutines, and others.
Python Tutorial on Boolean, Conditional, Logical Operator, Membership
Overview of Python keywords for Boolean, conditionals, logical operators, membership checks, exceptions, and loops, with explanations and examples.
Data Verification and Enrichment for Cleaner Data
Learn how to get high-quality data using the data verification and enrichment services Melissa Personator Consumer and Melissa Personator Identity.