Turning Data Into Decisions.
Data Analyst with 7+ years of experience building Power BI dashboards, automating reporting workflows, and delivering actionable insights through SQL, Python and Excel.
About Me
Data Analyst Who Speaks Business
I'm Prashant Karna, a Data Analyst with over 7 years of hands-on experience transforming raw data into strategic business intelligence. My work spans U.S. pharmacy analytics, financial MIS, campaign analytics, and event management.
I specialize in building Power BI dashboards that don't just look good — they drive decisions. From designing complex DAX measures to automating MIS workflows in Excel and Python, I bridge the gap between data complexity and business clarity.
Currently expanding expertise in Databricks, Apache Spark, and advanced SQL to stay ahead of the evolving data landscape.
Power BI Expert
Complex DAX, data modeling, enterprise dashboards
SQL Proficiency
Query optimization, reporting, stored procedures
Python Analytics
Web scraping, automation, data pipelines
Excel & MIS
Advanced formulas, automation, financial reporting
Portfolio
Featured Case Studies
Real-world Power BI projects that transformed raw data into strategic business decisions.
.jpg)
HR Analytics Dashboard
Built a comprehensive HR analytics dashboard analyzing employee attrition, demographics, and salary distributions across departments. Enabled HR leadership to identify at-risk segments and reduce turnover.
- 1,470 employees tracked
- 16.1% attrition rate analyzed
- Salary & age segmentation
- Job role breakdown
Credit Card Transaction Report
Designed an end-to-end credit card transaction report covering revenue by category, spending patterns, and monthly trends. Delivered insights enabling targeted credit limit adjustments and portfolio growth.
- $55M revenue tracked
- $8M interest analyzed
- 45M transactions processed
- Monthly trend analysis
Credit Card Customer Report
Created a customer analytics dashboard revealing behavioral patterns across income segments, education levels, and demographics, enabling targeted marketing and customer retention strategies.
- Customer segmentation by job
- Income & education analysis
- Marital status revenue split
- Dependent count impact
Data Science Salary Analysis
Analyzed global data science compensation data across job titles, experience levels, company sizes, and remote ratios. Provided benchmarking insights for hiring managers and job seekers.
- $137.57K avg salary
- 3,755 employees analyzed
- 10+ countries compared
- Remote work trend insights
Career Journey
Work Experience
7+ years across finance, pharma, politics, and events — always translating data into decisions.
Samvidhan Leadership Program
- Designed campaign analytics dashboards tracking election performance metrics
- Performed election data analysis to identify constituency-level trends
- Developed Power BI reports for leadership decision-making
- Built Python web scrapers for political data aggregation
Shivaji Infotech
- Owned U.S. pharmacy analytics dashboards used by operations teams
- Built Power BI reports from complex SQL queries across multiple data sources
- Validated data pipelines ensuring accuracy of pharmacy transaction records
- Created SQL-based automated reporting reducing manual effort by 60%
Choudhary Shah & Company
- Managed financial reporting and MIS for the company across all business units
- Automated recurring MIS reports using Excel macros and Power Query
- Led migration of static Excel reports to interactive Power BI dashboards
- Delivered weekly/monthly P&L and KPI dashboards to senior management
Vijayan's Fair & Exhibition Pvt. Ltd.
- Tracked event analytics and footfall data for exhibitions and trade fairs
- Maintained budget tracking dashboards to monitor expenditure vs. targets
- Generated ROI reports for sponsors and stakeholders post each event
- Streamlined data collection processes across event operations teams
Expertise
Skills & Technologies
A full-stack data analyst toolkit — from raw SQL queries to polished Power BI dashboards.
Business Intelligence
Data & Databases
Programming
Reporting & MIS
Tools & Platforms
Analytics
Growth
What I'm Working On
Continuously expanding from traditional BI toward modern data engineering and cloud platforms.
Databricks
Exploring Delta Lake architecture, Lakehouse patterns, and collaborative data engineering workflows.
Apache Spark
Learning distributed data processing for large-scale analytics beyond what SQL alone can handle.
Advanced SQL
Deepening SQL expertise with complex windowing, CTEs, and query performance tuning techniques.
PL-300 Certification
Preparing for the Microsoft Power BI Data Analyst Associate certification exam.
hr-analytics-dashboard
Power BI HR Analytics dashboard analyzing attrition, salary, and workforce demographics
credit-card-analytics
Credit card transaction and customer analytics built with Power BI and DAX
data-science-salary-analysis
Global data science salary benchmarking across countries, roles, and experience levels
Credentials
Certifications
Validated skills through structured coursework and industry-recognized certifications.
SQL for Data Science & Analytics
Udemy / Online Platform
Power BI Data Visualization & Reporting
Microsoft / Online Platform
Python for Data Analysis
Online Platform
Data Science and Analytics
Online Platform
Get In Touch
Let's Work Together
Open to Data Analyst and Power BI Developer opportunities. Let's discuss how I can add value to your team.
Prashant Karna
Data Analyst · Power BI Developer · 7+ Years Experience