I am a detail-oriented Data Analyst, Business Analyst, and Power BI Developer with a strong passion for transforming data into actionable insights that drive strategic decision-making. With hands-on experience in data analysis, business intelligence, and visualization, I excel at identifying trends, solving complex problems, and providing data-driven recommendations. Proficient in leveraging Power BI, SQL, Excel, and other analytical tools, I specialize in creating interactive dashboards and reports that communicate data stories clearly to stakeholders. My expertise in business analysis enables me to bridge the gap between data and business needs, ensuring that solutions align with organizational goals. I am committed to delivering high-quality insights, optimizing processes, and helping businesses make informed decisions. Whether working independently or as part of a team, I thrive in dynamic environments that challenge me to think critically and creatively.
A data-driven professional with expertise in data analysis, business insights, and Power BI development, skilled in transforming complex datasets into actionable intelligence for strategic decision-making.
Welcome to my portfolio, where data meets strategy and insights drive action. As a skilled Data Analyst, Business Analyst, and Power BI Developer, I specialize in transforming raw data into meaningful insights that empower businesses to make informed decisions. This portfolio showcases my ability to blend analytical skills with business acumen, demonstrated through a range of projects involving data visualization, reporting, and problem-solving. Each project reflects my commitment to data accuracy, storytelling, and delivering value through interactive dashboards, comprehensive reports, and strategic analysis. Explore my work to see how I leverage tools like Power BI, SQL, Excel,Python and more to turn complex data into clear, actionable insights that support business growth and efficiency.
Data‑driven and results‑oriented Data Analyst with hands‑on experience in data visualization, database management, and financial analysis across diverse industries. Proficient in leveraging tools like PowerBI,Tableau,and SQL for developing interactive dashboards and extracting actionable insights. Experienced in handling end‑to‑end data projects, from data collection and cleaning to hypothesis testing and storytelling with data.
January 2023 - July 2023
• Managed and maintained the customer and order databases for a renowned café. Performed data entry,cleaning,and ensured data integrity across multiple
platforms. Assisted in optimizing database queries to improve performance.
• Developed strong SQL skills for querying and database optimization. Gained proficiency in database management tools such as MySQL and learned best
practices in data cleaning and validation.
• Improved query performance by 30% through database optimization techniques. Successfully automated regular data updates, reducing manual data
entry efforts by 20%,minimized errors and ensured real‑time accuracy across platform.
• Worked with the café’s management and IT team to ensure smooth data flow and address any database issues promptly. Collaborated with the analytics
team to provide accurate datafor reporting and decision‑making
July 2024 - Present
• Developed multiple dashboards on customer service, finance, and orders, showcasing proficiency in data visualization. Framed a business problem focusing on the "Career Aspirations of Gen-Z," leading the project from data collection to analysis and visualization.
• Gained expertise in dashboard creation using Power BI, SQL for data cleaning and analysis, and Power Query Editor for data manipulation. Improved skills in data storytelling and hypothesis testing through SQL and Power BI.
• Created and presented three in-depth, focused dashboards with KPIs, summarizing insights on Gen-Z's career, learning, and mission aspirations. Delivered high-quality data visualizations, influencing business decision-making.
• Worked closely with stakeholders to understand data needs and provide actionable insights. Led a project on employer-focused recommendations through data storytelling and presentation, collaborating with various departments.
Sept 2024 - Jan 2024
• Designed and developed a Power BI data model for pharmaceutical sales,healthcare analytics of diabetes patients and HR analysis, focusing on schema design, relationship building, and role-playing dimensions for key entities such as "Sales Rep" and "Manager."
• Gained proficiency in Power BI and DAX, learning to create calculated columns, measures, and custom visuals to enhance data storytelling.
• Improved knowledge in schema design, relationships, and star schemas, optimizing data models for better performance and report accuracy.
• Collaborated with the sales and management teams to understand business needs and tailor Power BI reports to their requirements.
• Worked alongside the data engineering team to ensure proper data loading and model optimization, ensuring the data model was effective and accurate for business reporting.
• Collaborated closely with HR teams to design custom KPIs for employee performance, enabling them to make data-driven decisions through interactive Power BI reports.
• Worked closely with the healthcare analytics team to create meaningful metrics and visualizations that provided insights into employee health conditions, particularly related to diabetes management.
May 2024 - Aug 2024
• Built a decision tree classifier to predict whether a customer would subscribe to a term deposit based on demographic and behavioral data, using the Bank Marketing dataset from the UCI Machine Learning Repository.
• Processed and analyzed the dataset containing direct marketing campaign data of a Portuguese banking institution, focusing on identifying patterns in customer responses to phone calls.
• Performed data cleaning, feature engineering, and data preprocessing to prepare the dataset for machine learning algorithms.
• Gained proficiency in Python for data manipulation and machine learning, specifically using libraries like pandas, scikit-learn, and NumPy.
Developed a strong understanding of decision tree classifiers, model evaluation techniques, and feature selection methods.
• Successfully developed a decision tree model with an accuracy of 85%, predicting customer subscription behavior for the bank’s term deposit service.
2020 - 2024
• Specialized in Data Science with a focus on machine learning, artificial intelligence, and data analysis.
• Gained hands-on experience with data science tools and technologies such as Python, R, SQL, and big data platforms like Hadoop and Spark.
• Developed a strong foundation in algorithms, data structures, database management, and statistical analysis.
• Completed various projects involving data visualization, predictive modeling, and business intelligence using tools like Power BI and Tableau.
• Actively participated in workshops and hackathons related to data science, enhancing practical knowledge in real-world applications.
I have earned multiple certifications to enhance my expertise and stay updated with the latest industry trends. These certifications validate my proficiency in data analysis, business intelligence, and data visualization, equipping me with the skills necessary to deliver data-driven insights and solutions. These credentials, combined with my professional achievements, reflect my commitment to continuous learning and delivering data-driven solutions that create value and drive business success.
As a skilled Data Analyst, I offer a range of services to help you leverage data for better decision-making and business growth.
I'm always excited to connect with others who share a passion for data and business insights. Whether you have a project in mind, a question, or just want to discuss data-driven solutions, feel free to reach out. Let’s collaborate and turn your data into valuable insights!
Phone: (+91) 93021 17455
Palak Saxena
