Prem MandalPower BI Developer& Data Analyst
Welcome to my portfolio. I transform complex enterprise data into actionable executive insights. Specializing in Power BI, SQL, DAX, and Microsoft Fabric.
02+
Years Experience
15+
Projects Built
55K+
Community
Prem Mandal
Top VoiceSenior Data Analyst & BI Specialist
55.4K+
Followers
382K+
7-Day Imp
3,700+
Viewers
"I'm a data magician. I make boring data disappear and awesomeness appear."
ABOUT ME
Turning Data Into Business Decisions
Education
B.Com. (Bachelor of Commerce)
2022 - 2025Sikkim Professional University, Gangtok
12th Standard (JAC)
2019 - 2021Model School Bengabad, Jharkhand
10th Standard (CBSE)
2018 - 2019Anandalaya Public School Madhupur, Jharkhand
I'm Prem Mandal, a Senior BI Developer & Data Analyst with 2+ years of hands-on experience converting raw enterprise data into executive dashboards across manufacturing, steel, and tea sectors.
I specialize in end-to-end analytics — from architecting data models (Star/Snowflake) and writing complex DAX queries to orchestrating semantic models in Power BI Service and Microsoft Fabric.
Core Technical Skills
Career Journey
Super Smelters Ltd
Power BI Developer
Utkarsh India Ltd
Senior Data Analyst
2+
Years Experience
55K+
LinkedIn Network
15+
Dashboards Built
100%
Client Focus
TECHNICAL CAPABILITIES
Skills & Technologies
Power BI
KEY SKILLS:
- Power Query & M-Code Data Transformation
- Data Modeling (Star / Snowflake Schema)
- Advanced DAX & Complex Calculations
- Connecting to Multiple Heterogeneous Data Sources
- Creating Interactive Executive Dashboards
- Power BI Service, Gateway Setup & RLS
SQL
KEY EXPERTISE:
- DML (Data Manipulation Language)
- DDL (Data Definition Language)
- Window Functions & Advanced CTEs
- Date & Time Functions & Aggregations
- Complex Joins & Subqueries
- Writing Queries for ETL, Cleaning & Transformation
Microsoft Fabric & Azure
ENTERPRISE CLOUD BI:
- OneLake Storage Architecture
- Lakehouses & Data Warehouses
- Data Factory Pipelines (ETL/ELT)
- Direct Lake Semantic Models
- Azure Data Lake Storage (ADLS Gen2)
Python
CORE LIBRARIES FOR DATA ANALYSIS:
- Pandas & NumPy for Data Manipulation
- Matplotlib & Seaborn for Visualization
- Jupyter Notebooks & Automated Scripts
- Data Cleaning & Exploratory Data Analysis (EDA)
Advanced Excel
KEY EXPERTISE:
- Complex Formulas (XLOOKUP, INDEX/MATCH)
- Pivot Tables & Dynamic Dashboards
- Power Query in Excel
- Data Validation & Conditional Formatting
Statistics & Modeling
KEY EXPERTISE:
- Descriptive & Inferential Statistics
- Hypothesis Testing & A/B Testing
- Regression & Correlation Analysis
- KPI & Metrics Definition
CAREER PATH
Work Experience
Senior Data Analyst
Professional Senior Data Analyst responsibilities involving Power BI, SQL, data analysis, KPI reporting, data modeling, and business insights.
Power BI Developer
Created operational BI solutions, star schema data modeling, and automated KPI reporting for manufacturing and steel analytics.
MY WORK
Featured Projects
A quick glimpse at my recent BI & Analytics implementations.
IBM HR Data Analytics Tableau Dashboard
Comprehensive HR analytics dashboard analyzing employee demographics, department-wise average age, gender distribution, monthly income, and job roles across the organization.
Covid 19 Tableau Interactive Dashboard
Interactive Tableau Public dashboard tracking global & nationwide Covid-19 infection trends, recovery rates, testing metrics, and regional impact analysis.
Covid 19 Analysis & Dashboard (Power BI)
Comprehensive Covid-19 data analysis dashboard tracking nationwide infection rates, recovery metrics, testing trends, and regional impact analysis.
TESTIMONIALS
What People Say About My Work
Feedback from stakeholders, department heads, and teams I’ve collaborated with.
"Prem's Power BI dashboards completely changed how our HODs track weekly performance. His DAX optimization made report loading instant!"
Senior Manager
Frequently Asked Questions
Here are some common questions about my BI development background, data analytics expertise, and collaboration workflow.
Have a specific question?
Can’t find the answer you are looking for? Ask your question directly to Prem!
DIGITAL FOOTPRINT
My Presence in the Data Community
Engaging, building dashboards, and sharing analytical solutions across leading global platforms.
My Life Philosophy
"Our greatest weakness lies in giving up. The most certain way to succeed is always to try just one more time."
"Hard work becomes a habit, a serious kind of fun. You find satisfaction in pushing your limits, knowing all the effort will pay off."
"I believe it's possible for ordinary people to choose to be extraordinary."
GET IN TOUCH
Let's build something great together
Let's talk about your next project
Have an analytics initiative in mind, need a Power BI dashboard, or just want to connect? My inbox is always open — I usually reply within a few hours.