Open to BI consulting & collaborations

Turning raw data into decisions that matter.

Senior Power BI Developer|

I'm Pankaj Namekar - a Microsoft-certified BI developer building enterprise Power BI & Microsoft Fabric solutions at Magna International, and founder of Data With Pankaj, where I teach 60,000+ professionals Power BI, DAX and Fabric for free.

View Projects Download Resume
Watch free Power BI tutorials on YouTube
6+Years Experience
60K+Community Members
68K+LinkedIn Followers
7xMS Certified
PL-300 Certified
MS Fabric (DP-600)
60K+ Learners
Magna International
Portrait of Pankaj Namekar
Scroll
About Me

Where business questions meet data-driven answers.

A Business Intelligence specialist who turns raw, scattered data into decisions leadership can act on.

Quick Facts
  • Role: Senior Power BI Developer, Magna International
  • Based in: India
  • Focus: Enterprise BI, Data Modeling & Analytics
  • Certified: PL-300 · DP-600 · Fabric Super User
  • Creator: Data With Pankaj (60K+ community)
Download Full Resume

Hi, I'm Pankaj Namekar, a Senior Power BI Developer at Magna International with 6+ years of experience in Data Analytics, Business Intelligence, Enterprise Reporting, and Modern Data Platforms.

My core expertise spans Power BI, DAX, Power Query, Microsoft Fabric, Azure Data, SQL, and AI-powered analytics. I specialize in building enterprise-grade BI solutions, scalable Star and Snowflake data models, automated ETL/ELT pipelines, Semantic Models, and interactive dashboards that transform complex data into actionable business insights.

I'm also actively exploring the intersection of Generative AI, AI-assisted BI, Copilot, AI Agents, MCP, and intelligent data analytics - helping professionals understand how AI is transforming the way we build, analyze, and consume data.

Beyond my professional work, I run Data With Pankaj, a free learning community and YouTube channel where I've helped 60,000+ data professionals learn Power BI, DAX, Microsoft Fabric, SQL, and AI for Data Analytics, and prepare for certifications including PL-300, DP-600, and AZ-900.

25+Dashboards Delivered
4Companies
60K+Community Members
7xMS Certifications
Skills

The toolkit behind every dashboard I ship.

A blend of BI engineering, data platform expertise, and the stakeholder skills that get insights adopted.

BI & Visualization

Power BI Desktop & Service
DAX & Data Modeling
Power Query (M)
Row-Level Security (RLS)
Custom SVG Visuals
UI/UX for Dashboards

Data Platform

Microsoft Fabric
SQL Server / T-SQL
Azure Fundamentals
Databricks
ETL / ELT Pipelines
SAP HANA
Star & Snowflake Schemas

Tools & Languages

Python for Data
Advanced Excel
JIRA & Smartsheet
Data Gateways & Refresh
ChatGPT / Claude for BI

Impact & Leadership

Stakeholder Management
Data Storytelling
Training & Mentoring
Business Requirements (BRD)
KPI & SLA Reporting
Career Path

6+ years of turning operations into insight.

From shop-floor supervision to enterprise BI leadership - every role sharpened how I translate business problems into data solutions.

Senior Power BI Developer

Jan 2025 – Present
Magna International · India
  • Lead end-to-end Power BI reporting across BDE & Marketing, Product, Finance, Supply Chain, Quality and IT - covering COQ, PPAP, OEE, DOH, Vehicle Launch Programs, Competitor Market Share, Wards Intelligence, Cycle Planning, Weld Health, Issue Tracking, AI & Automation, Trailer Aging and Supply Chain operations.
  • Designed and delivered 15+ enterprise-grade Power BI projects, owning requirement gathering, data modeling, DAX development, visualization, deployment and stakeholder enablement end-to-end.
  • Built scalable semantic models on star-schema architecture, optimized for large datasets and enterprise performance standards.
  • Developed advanced DAX measures for KPI tracking, trend and variance analysis, and time intelligence (YTD, MTD, YoY) across operational metrics.
  • Integrated and transformed data from Databricks, SQL Server (SSMS), PostgreSQL, SAP HANA, SharePoint and PowerApps using Power Query (M).
  • Implemented performance optimization techniques - query folding, incremental refresh, optimized relationships and efficient DAX patterns - and refactored existing reports using variables and virtual tables to eliminate redundant calculations.
  • Delivered role-based and department-level dashboards using Dynamic Row-Level Security (RLS), ensuring secure, governed and validated data access for business-critical reporting.
  • Collaborated with cross-functional stakeholders across operations, quality, supply chain, finance, IT and leadership, and conducted end-user training to drive self-service analytics adoption.

Senior Business Analyst

Apr 2022 – Jan 2025
Indegene · India (Remote)
  • Delivered 25+ enterprise Power BI dashboards and reports for project management, finance and operations across clients including Boehringer Ingelheim, Amgen, Gilead Sciences and CSL Vifor.
  • Led business requirements gathering (BRD/FRD), stakeholder collaboration, data validation and gap analysis for Power BI reporting solutions.
  • Designed star-schema data models and developed advanced DAX measures for KPIs including budget utilization, forecasting, SLA, TAT, milestones and resource allocation.
  • Performed end-to-end ETL using SQL and Power Query (M) across multiple data sources to align with business logic.
  • Built financial dashboards tracking cost variance, budget vs actuals, forecasting accuracy and operational performance, and automated recurring reporting to reduce manual effort.
  • Conducted root cause analysis of data and reporting issues (managed via Jira) and delivered Power BI training on data modeling, DAX and UI/UX best practices to enable self-service analytics.

Document Controller

Sep 2019 – Apr 2022
CPF India · India
  • Developed advanced Power BI reports using complex star-schema data models and relational database structures.
  • Created interactive dashboards with diverse visualizations - charts, KPIs, tree maps and navigation reports - featuring conditional formatting and synced slicers.
  • Implemented DAX for aggregation, logical and date-based operations to improve data accuracy and insights.
  • Conducted data modeling and documented technical solutions for business requirements, while proactively notifying business users of daily load statuses.
  • Collaborated with leadership to present strategic insights in monthly and quarterly business reviews.
Featured Work

Seven end-to-end BI case studies, start to finish.

Full-stack Power BI projects covering retail, hospitality, insurance, economics, sales and social analytics - from business requirements to the final published dashboard.

Live Report
End-to-End

Ecomm - Electronics Sales Analysis

Sales performance analysis for an electronics e-commerce business, covering revenue, product and category trends as a full Power BI case study.

Power BIE-CommerceSales Analytics
GitHub
Live Report
End-to-End

Retail - Walmart E-Commerce Analytics

Retail analytics case study with a full business requirements document, developer guidelines, and a star-schema data model built for scalable e-commerce reporting.

Power BIRetail AnalyticsData Modeling
GitHub
Live Report
End-to-End

Economics - Cost of Living Crisis

A global analysis of the cost-of-living crisis, tracking economic indicators across regions in an interactive Power BI report.

Power BIEconomic DataGlobal Trends
GitHub
Live Report
End-to-End

Hospitality - Airbnb Analytics

Full case study covering business requirements, a documented data dictionary, a custom Power BI theme, and a star-schema data model (dim_date, dim_host, dim_location, dim_property, fact_bookings).

Power BIStar SchemaBRD
GitHub
Live Report
Case Study

Insurance - Customer Insights (Allianz Case Study)

A Customer Insights Analyst case study for Allianz: policy, claims and CSAT analysis across 10,000 customers, styled with a custom Allianz-branded Power BI theme.

Power BIInsuranceCustomer Analytics
GitHub
Live Report
End-to-End

Sales - Product Performance Analysis

A sales and product performance case study built to surface revenue trends and performance across products and channels.

Power BIProduct AnalyticsSales
GitHub
Live Report
End-to-End

Social - LinkedIn Content Analysis

An analytics dashboard tracking LinkedIn content performance - impressions, engagement and growth over time.

Power BISocial AnalyticsLinkedIn
GitHub
"View Live Dashboard" opens the actual published Power BI report for each project, embedded right here.
Certifications

Microsoft-verified, continuously refreshed.

Seven Microsoft credentials spanning Power BI, Microsoft Fabric and Azure - kept current as the platform evolves.

Associate

PL-300

Power BI Data Analyst Associate

Issued Mar 2025 Verify
Associate

DP-600

Fabric Analytics Engineer Associate

Issued May 2025 Verify
Super User

MS Fabric

Microsoft Fabric Super User

Issued Jul 2025 Verify
Fundamentals

Azure

Microsoft Certified: Azure Fundamentals

Indegene Verify
Also certified in: SQL for Power BI Users Data Science with Python R for Power BI Users Geospatial Analysis in Power BI ChatGPT for Power BI Data Literacy for Beginners
Education

An engineering foundation for analytical thinking.

Formal training in mechanical engineering - the same structured, root-cause mindset I now apply to data.

Bachelor of Engineering (BE)

Mechanical Engineering · Savitribai Phule Pune University
2016 – 2019Grade: A+

Diploma in Engineering

Mechanical Engineering · Sanjivani Group of Institutes, Kopargaon
2013 – 2016Grade: A+
Beyond the 9-to-5

Building Data With Pankaj.

Free Power BI, DAX, SQL and Microsoft Fabric education for a growing community of data professionals.

Data With Pankaj
YouTube Channel

Free Power BI Tutorials

Step-by-step Power BI, DAX, Power Query and Microsoft Fabric tutorials, interview-prep playlists and certification walkthroughs.

Subscribe
68,836+
LinkedIn Followers

Daily BI Insights

I share practical Power BI patterns, DAX breakdowns and career advice for data professionals every week.

Connect on LinkedIn
1:1
Coaching Sessions

Personal Mentorship

Stuck on a dashboard, a certification, or your BI career path? Book a session for direct, personalized guidance.

Book on Topmate
Get In Touch

Let's build something data-driven together.

Open to Power BI consulting, freelance dashboard work, speaking opportunities, and collaborations with fellow data professionals.

Email
pankajnamekar8311@gmail.com
Location
India
Currently
Senior Power BI Developer @ Magna International
Send Me an Email Download Resume Book a 1:1 Session