Hi, I am Haq, a Data Analyst and Engineer. On this channel I talk/share tips and tricks on Business Intelligence tools, Data, Data Warehouse and Source Control. I have been involved in many Data Analytics and Process Automation projects. I am passionate about finding new ways and techniques to enhance the Data Analysis process.

On this channel I create tutorials for people who:
• are looking for a way to learn and use the power of Python in their day-to-day work.
• are looking to automate Data Analysis processes using PowerBI, Cognos and Python
• want to learn Data Analysis & Data Science to perform impactful analysis.
• are working with Data and want to find new ways to of doing things
• are looking to use Source Control to house their code

If this sounds exciting to you, consider subscribing and turning on the notifications, so you don’t miss any content.

Happy Coding everyone. May the power of the code be with you!


BI Insights Inc

We have put together the complete data engineering playlist that uses open source tools; Airbyte, dbt and dagster. There are additional videos covering SQL Server and Postgres install and setup. Happy holidays and coding.
www.youtube.com/playlist?list...

1 week ago (edited) | [YT] | 24

BI Insights Inc

🎙️ New Video Alert! 🚀

We will integrate Ollama with n8n workflow for automation! We will build on the workflow from the previous session. Catch it here. https://www.youtube.com/watch?v=jWmNg...


In the upcoming video we’ll walk through:
⚡ Ollama integration with n8n AI Agent
⚡ A real-world use case to show how powerful (and fun) automation can be

Once completed, you will have a fully automated AI Agent that's private. Open-source, self-hosted, and running on your hardware.
Video 🎥 coming soon. Stay tuned
#AI #n8n #AIAgents

1 month ago | [YT] | 10

BI Insights Inc

🎙️ New Video Alert! 🚀

Ever wanted to turn your voice recordings into text, all locally on your computer?
In our latest video, we’ll walk you through setting up and using a local Whisper model for speech-to-text transcription.

You’ll learn how to:
✅ Install and configure Whisper locally
✅ Transcribe audio files into accurate text
✅ Automate your workflow, no cloud required!

Perfect for developers, podcasters, and creators who want privacy + full control.

Video 🎥 coming soon. Stay tuned
#WhisperAI #SpeechToText #AItools

2 months ago | [YT] | 7

BI Insights Inc

🚀 Big news in the modern data stack world — Fivetran and dbt Labs are merging!

If you are part of dbt community then you should be paying attention to this, especially open source. Following are the potentional benefits and risks from this merger. Let's see what the future brings for dbt community.

Potential benefits:
✅ Seamless integration from extract → transform → activate
✅ More resources and investment for dbt Core
✅ Stronger competition against closed data platforms

Potential risks:
⚠️ Open-source community independence could be tested
⚠️ Commercial focus may shift features toward enterprise users
⚠️ Fewer “mix-and-match” tool options in the stack

If the new company keeps its promise to preserve dbt’s open-source spirit, this could be a turning point for the data ecosystem. Otherwise… the community will be watching closely.

#Fivetran #dbt #DataEngineering #ModernDataStack

2 months ago (edited) | [YT] | 12

BI Insights Inc

🚀 Exploring n8n for workflow automation! Stay tuned for the demo! 🔗

We’ll walk through:
⚡ Local install in just a few minutes
⚡ A real-world use case to show how powerful (and fun) automation can be

Open-source, self-hosted, and endlessly flexible — n8n is like Zapier, but without the limits.

4 months ago (edited) | [YT] | 13

BI Insights Inc

🚀 Coming Soon: Build an End-to-End Open-Source ELT Data Pipeline!

In the upcoming tutorial, we'll walk you through setting up a modern ELT stack using open-source tools:
• MinIO as the S3-compatible data source
• Airbyte for seamless data ingestion
• dbt for powerful transformations
• PostgreSQL as the data warehouse
• All orchestrated with Apache Airflow!

Stay tuned to learn how to integrate and automate the entire data flow—from raw files to insightful analytics. 🔄📊

#DataEngineering #OpenSource #Airflow #Airbyte #dbt #PostgreSQL #MinIO #ETL #ELT #ModernDataStack

6 months ago (edited) | [YT] | 62

BI Insights Inc

In the next video, we will cover AI Agent. An AI Agent is a large language model (LLM) like GPT-4 that not only responds with text but also knows how and when to use external tools (like calling APIs, running code, or querying databases) to complete complex tasks.

Think of an AI Agent as a smart assistant with both:

Reasoning ability (from the LLM)
Action ability (via tools you define)

Instead of hard-coding rules, you give it tools and let the LLM figure out which one to use based on the user's input.

7 months ago | [YT] | 13

BI Insights Inc

In the next video we are covering a cool project using AI to read text from images — like magic! 🪄
We will use the llama vision model with LangChain, so now we can upload an image (like a receipt or form) and the AI reads and understands the text inside. 🧠📸

It’s like giving eyes to a chatbot — perfect for automating boring stuff!
We are using a local model using Ollama. Make sure your ollama environemnet is setup:
https://www.youtube.com/watch?v=CE9um...

#AIForBeginners #LangChain #LLaVA #OCR #AI #LLM #FunWithAI #NoMoreManualTyping

8 months ago | [YT] | 21

BI Insights Inc

LangChain is taking the AI development to the next level. It provides a framework for AI development and makes it easy to build applications with LLMs. From chaining prompts to integrating tools, memory, and APIs, LangChain streamlines the process of creating smart, context-aware AI systems.
In the upcoming video we will cover LangChain and in the follow ups we will build AI apps using LangChain.

🔗 Automate workflows
📊 Connect to databases
🧠 Add memory for conversations
⚡ Power up with external tools

Ready to build the future of AI? Dive into LangChain today!
#AI #LangChain #MachineLearning #LLMs

10 months ago | [YT] | 22

BI Insights Inc

🚀 Running Apache Airflow on Kubernetes: A Quick Guide 🏗️

In the upcoming video we are deploying Apache Airflow on Kubernetes. Kubernetes offers scalability, flexibility, and better resource management for your workflows. This was commonly requested after the Airflow's installation series. Here’s a high-level approach to get started:

1️⃣ Use Helm – Deploy Airflow with the official Helm chart for easy setup.
2️⃣ Use Kind - To create a Kubernetese cluster
3️⃣ Use Kubectl – To manage the Kubernetese cluster and resources.

Kubernetes + Airflow = Robust, Scalable Workflow Orchestration! 💡

Have you deployed Airflow on K8s? Share your experience in the comments! ⬇️ #ApacheAirflow #Kubernetes #DataEngineering

11 months ago | [YT] | 38