Shubham Chahal
Data Engineer | Data Analysis| SQL | DAX Query | ETL | MS Power BI | Power Query | Data Modeling | Cognos | Transforming Data into Actionable Insights
- Role
- Data Engineer Consultant Microsoft Fabric Specialist at IBM
- Location
- Pune, MH, IN
- LinkedIn followers
- 500 followers
About Shubham Chahal
Experienced business intelligence developer, proficient in Power BI and Cognos, with a proven track record of delivering insightful data solutions that drive informed business decisions. Skilled in data modeling and visualization and adept at transforming complex data sets into actionable insights. Strong background in SQL, ETL processes, and data warehousing, coupled with a deep understanding of business processes and requirements gathering.Key Responsibilities1. Power BI Development & Dashboard Design• Develop interactive dashboards, reports, and paginated reports using Power BI Desktop.• Write complex DAX expressions for calculated columns, measures, and aggregations.• Design high-performance data models with proper relationships, hierarchies, and aggregations.• Implement best UI/UX practices to enhance report readability and user experience.2. Power BI Service & Deployment (Enterprise-Level Implementation)• Deploy reports, datasets, and dashboards to Power BI Service (Workspace, App, Premium Capacity).• Manage Row-Level Security (RLS), Object-Level Security (OLS), and access control.• Schedule and monitor data refresh processes, resolving failures proactively.• Utilize Power BI Premium, Deployment Pipelines, and Dataflows for enterprise-wide reporting.3. Data Integration & ETL (Power Query, SQL, Azure, APIs)• Connect Power BI to SQL Server, Azure Data Lake, Azure Synapse, APIs, SharePoint, and other sources.• Use Power Query (M language) for data cleansing, transformation, and optimization before loading.• Work with Azure Data Factory (ADF) and Dataflows to streamline data ingestion.• Ensure ETL process efficiency by optimizing data transformation steps.Performance Optimization & Troubleshooting• Identify DAX performance bottlenecks and optimize queries using DAX Studio & VertiPaq Analyzer.• Improve Power BI dataset size and report load times using best practices (e.g, Star Schema, Aggregations).Performance Optimization & Troubleshooting• Identify DAX performance bottlenecks and optimize queries using DAX Studio & VertiPaq Analyzer.• Improve Power BI dataset size and report load times using best practices (e.g, Star Schema, Aggregations).• Implement incremental refresh for large datasets to improve performance.• Troubleshoot Power BI Gateway issues for on-premises data connectivity
Experience
Data Engineer Consultant Microsoft Fabric Specialist
Feb 2025 — Present · Pune, IN
Designed and implemented scalable data pipelines using notebook-based transformations with SQL and PySpark within Microsoft Fabric\'sData Engineering workload.Performed complex data cleansing, aggregation, and transformationlogic to prepare data for business intelligence use cases.Collaborated with cross-functional teams to define data models andreporting requirements, ensuring data accuracy and relevance forbusiness stakeholders. Implemented data validation and qualitychecks to maintain data integrity throughout the pipeline.
Education
AISSMS Institute of Information Technology
Bachelor of Engineering - BE, ENTC
2016 — 2019
Amrutvahini College of Engineering - AVCOE
Diploma of Education, ENTC
2013 — 2016
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.