top of page

KNOWLEDGE HUB
Practical explanations for better data work
Articles on Excel, Power BI, Power Query, dashboards, and automation—kept focused enough to use in your next project.


Power BI Service: All Inclusive
Power BI Service is Microsoft’s cloud-based platform for sharing, collaborating on, and interacting with data and reports. Think of it as the online companion to Power BI Desktop. While Power BI Desktop (a free Windows app) is where analysts build data models and design reports, the Power BI Service ( app.powerbi.com ) is where you share and consume those reports, dashboards, and apps with others. In practice, you’d do your data cleanup, modelling, and report design in Desk

MirVel
May 11, 202516 min read


Power Automate for Real-Life Scenarios: From Personal Productivity to Business Workflows
Imagine if many of your daily repetitive tasks could happen automatically while you focus on more important work. Microsoft Power Automate (formerly known as Microsoft Flow) is a cloud-based service that makes this possible. Without writing code, it lets you create automated workflows (called “flows”) between your apps and services. You can tell Power Automate: “When X happens, do Y.” This post will introduce Power Automate in plain English and then walk through real-life exa

MirVel
May 7, 202517 min read


Power BI Across Industries: Real-World Examples from Healthcare to Energy
Every industry in today’s data-driven world is discovering the value of turning raw data into actionable insights. Microsoft Power BI, a leading business intelligence tool, is helping organizations large and small do precisely that. Power BI leads many BI implementations – holding about 15% of the global BI market share as of 2024. Its intuitive dashboards and real-time analytics transform healthcare, finance, retail, manufacturing, education, logistics, marketing, and more d

MirVel
May 6, 202512 min read


Making Power BI Visuals Dynamic with Field Parameters
In Power BI, Field Parameters enable users to choose how they want to view the data, eliminating the need to build multiple separate visuals. Instead of creating different charts for Region, Department, or Category, you can create one smart visual where users can easily switch what they want to analyze. This tutorial demonstrates how to create a dynamic bar chart that allows users to select whether they want to view Sales by Region, department, or product category with a sing

MirVel
Apr 26, 20253 min read


From Inbox to SharePoint—Automatically Unzip, Upload and overwrite Files with Power Automate
Manually downloading ZIP email attachments, extracting files, and uploading them to SharePoint can be time-consuming and error-prone. What if you could automate the whole process? In this guide, I’ll walk you through a simple Power Automate flow that does exactly that. Every time you receive an Outlook email with a ZIP attachment (like a CSV report), it will automatically save the file, extract the contents, update the correct folder in SharePoint, and even clean up the old f

MirVel
Apr 24, 20252 min read


The Best AI Websites in 2025: Features, Pricing, and Pros & Cons
Artificial Intelligence (AI) has revolutionized the digital landscape, offering tools that enhance productivity, creativity, and efficiency. In 2025, several AI platforms stand out for their innovative features and user-friendly interfaces. Here's a curated list of the top AI websites you should consider: 1. OpenAI's ChatGPT https://chatgpt.com/ Logo of ChatGPT, featuring an abstract geometric design above the text. Features: Advanced conversational AI capable of understandin

MirVel
Apr 21, 20254 min read
bottom of page
