PowerBI
Projects
Hi, I’m Ishan Dutta, a freelance data analyst and BI professional actively seeking a full time role. I come with a solid background in business analytics. Over the past couple of years, I’ve worked across companies and consulting firms, helping teams turn raw data into meaningful insights. Whether it’s building dashboards in Power BI, writing SQL queries, or cleaning data in Excel and Python, I enjoy "talking to numbers" to solve real-world problems.
I’ve created dashboards that improved reporting efficiency, automated manual processes, and saved time for decision-makers. Some of my projects have led to up to 40% faster reporting and 25% better operational outcomes—things I’m genuinely proud of.
Right now, I’m sharpening my skills further through the Codebasics Data Analytics Bootcamp, working on hands-on projects like IPL impact analysis and business reporting for live data.
Power BI
Excel
Python
SQL
Data Cleaning
Problem Solving
power pivot
Philomath Research · Remote | New Delhi | Jan 2025 – May 2025
At Philomath Research, I worked on identifying trends in consumer behavior and market movement across industries. My work involved sourcing structured and unstructured data from third-party research platforms like Statista and IBISWorld. I then used Power Query in Excel to transform and clean around like 100 raw datasets, significantly streamlining the reporting process. These clean datasets were used to build weekly insight reports for internal teams, using PivotTables to support decision-making.
Innoforia Consulting · Hybrid | Delhi-NCR | Jan 2024 – Dec 2024
I played a key role in building and maintaining interactive dashboards for sales, operations, and customer engagement. My primary responsibility was to collect, query, and model CRM data using SQL and Excel. I then built 20+ dynamic dashboards in Power BI with drill-down visuals and slicers, enabling senior managers to gain deeper insights into performance. My work helped different departments cut down manual analysis and enabled faster, data-backed decisions.
The Sparks Foundation, Innomatics Labs & Feynn Labs · Remote | Jan 2023 – Dec 2023
During my internship period across these three organizations, I worked on several hands-on projects that involved cleaning raw data, building dashboards, and performing exploratory data analysis. I used Excel for preprocessing, and Python libraries like Pandas and Seaborn to uncover patterns and trends and visualize data, respectively. I also developed dashboards in both Power BI and Tableau, turning complex data into visual stories that were easier to understand and present to stakeholders.
Mideast Pipeline Products · New Delhi | Dec 2021 – May 2022
In the early phase of my career, I started as an operations trainee who was focused on streamlining procurement processes and managing vendor transactions. I took initiative to redesign internal tracking workflows using Excel, which significantly minimized reordering errors and contributed to noticeable cost reductions. Additionally, I created a centralized vendor master database from the ground up by collecting and organizing supplier information. This resource was uploaded for team-wide access, ensuring quicker procurement cycles and eliminating the need to source vendor details manually.
Feel free to get in touch with me. I am always open to discussing new projects, creative ideas or opportunities to be part of your visions.