Delhi, India
Hello LinkedIn community! 👋I'm Himanshu Yadav, a data enthusiast passionate about uncovering hidden stories in complex datasets and turning them into actionable strategies using my analytical skills and project management expertise. In my current role, I’ve spearheaded the transition from Excel-driven reporting to Power BI automation: - Built interactive Power BI dashboards for Sales Team, replacing manual Excel workflows and reducing manual reporting time significantly. - Collaborated with Team to resolve master data mismatches, ensuring accurate inventory tracking and smoother product and category sales tracking. - Partnered with stakeholders to align KPIs with business goals, bridging the gap between raw data and strategic decisions. Tools and Technologies I work with :- 📊 Data Analysis & Visualization Excel: Advanced Excel (ODBC SQL, Power Query), Pivot Tables, Dynamic Reports Power BI: DAX, Data Modeling, ETL Workflows, BI Services, Interactive Dashboards Google Sheets: App Script Automation, Collaborative Reporting, Data Validation 🗃️ Database & Querying MS SQL Server: Query Optimization, Joins, Stored Procedures, Data Extraction Why I Love This Work: Inspired by David Goggins’ relentless mindset, I thrive on turning chaos into clarity – whether it’s debugging a stubborn SQL query or optimizing Excel, B.I. workflows for faster insights. Let’s connect to discuss data-driven retail strategies, APAC market insights, or how to turn raw numbers into growth!
• Power BI Development: Built, implemented and maintaining interactive dashboards, transitioned organization from Excel to BI reporting, using Power Query, DAX, BI Service and SQL, improving decision-making for various teams. • Workspace Administration: Managed workspaces on Premium and Pro Services, including capacity settings, scheduled refresh, semantic models and gateway. • Centralizing scattered Excel reports into a single source of truth and reducing from 2 hours/day ➔ 10 minutes/day. • Automated Reporting: Designed Excel workflows using ODBC SQL queries to extract, transform, and visualize daily sales and inventory data, replacing manual processes and saving 10+ hours/week for cross-functional teams. • Automation: Streamlined data collection with data engineer by extracting and validating datasets from APIs, FTPs, and web scraping. • Data Integrity Advocacy: Collaborated with Teams to identify and resolve data mismatches, ensuring accurate product sales and inventory tracking. • Stakeholder Collaboration: Partnered with teams like sales, logistics, merchandising etc. to align KPIs, refine reporting requirements, deliver actionable insights and iteratively refined visualizations based on user feedback. • Documentation & Training: Created user-friendly dashboards and conducted workshops to train users, ensuring adoption of self-service analytics tools.
• Providing end-to-end project management for online market research projects. • Responsible for intelligent data collection, transformation, loading, and monitoring. • Improving efficiency and accuracy in data-driven decision-making, showcasing adept project management and data analysis skills. • Performing data transformation and analysis of large structured and unstructured data sets extracted from various sources. • Incorporate various tools like Excel and Power BI to identify and enhance KPIs resulting in 40-45% improvement in data collection performance, and deliver efficient performance reports to clients and senior management. • Act as an accountable point of contact, ensuring seamless execution and timely delivery of actionable business insights w.r.t Quality prior to delivery. • Collaborated closely with key stakeholders to address complex issues, utilizing strong project management skills to drive successful resolution with organizational objectives. • Project Priority Mapping and Coordination. • Led project planning efforts, ensuring timely and high-quality delivery through effective communication and stakeholder engagement. • Initiative to map projects in the portfolio across different regions. • Supporting projects through completion. • Training new recruits and team members to harness analytic potential, foster a culture of collaboration and continuous improvement through training sessions. • Actively participate in the reconciliation of accounting books for the current financial year in coordination with the accounts team.