theScore’s Post

🚀 Do you have inquiries about launching your career in data analytics? Connect with my friend Sai Sharan Paspunuri for guidance and insights into his experience in the field. ✨

I'm thrilled to share that I have completed my second task as data analyst at CODTECH IT SOLUTIONS Topic : Predictive modelling with linear regression Objective : The project aims to predict median house values based on median income using a simple linear regression model. The model is trained on the California Housing dataset, and its performance is evaluated using Mean Squared Error (MSE) and R-squared (R²) metrics.

I'm thrilled to share that I have completed my first task as data analyst at CODTECH IT SOLUTIONS Title : Exploratory Data Analysis (EDA) Objective: The primary objective of this project is to perform Exploratory Data Analysis (EDA) on the Titanic dataset. EDA helps us understand the data’s characteristics, distributions, correlations, and outliers, providing insights into the factors influencing passenger survival rates on the Titanic. The analysis involves cleaning, visualizing, and interpreting data to draw meaningful conclusions.

Road mab to become a data analyst

I'm excited to share that I got promoted at SUN and will relocate to Philadelphia to join the Trading & Risk team as a data scientist. After 2,000+ hours of coding, I've learned it's easy to mislead with data. Cherry-picking rows to add or drop, calculating misleading percentages, overemphasizing statistical significance, and misrepresenting visuals can create mathematically correct but practically misleading insights. Lying with data is easy; what's difficult is pairing the right questions with sound statistical methods. So here's a better approach: 1) define the problem, 2) reframe the problem through different perspectives (how does this problem look for different teams?), 3) construct a hypothesis, 4) select a method, 5) acknowledge the method's limitations and assumptions, 6) test results, and 7) decide to maintain or change your view based on the evidence. I'm happy to work for a company that promotes intellectual honesty and can't wait to give my all in my new role! 😊

As I near my 1-month anniversary as a Data Analyst for the D.C. Department of Human Services (DHS) through The Midtown Group, I’ve gained valuable insights into how data can directly shape public services. Below are some of the key skills I’ve developed and continue to refine: - Data Manipulation & Cleaning: by preparing raw data for analysis by organizing, filtering, and correcting errors or inconsistency. - Decision-Making Support: by providing data-driven insights that help make informed policy decisions & guide strategy. - Data Visualization: by presenting data in visual formats like charts & graphs. - Pattern Recognition: by identifying trends and correlations that help uncover important insights. - Data Interpretation: once cleaned, now focusing on drawing conclusions and turning them into meaningful and actionable information that can be used in decision making. Overall, it’s been an incredibly rewarding experience. The skills I've gained in data analysis, along with the knowledge of how data can positively impact public services, have not only enhanced my technical expertise but also deepened my understanding of the important role data plays in supporting communities. I'm excited to continue growing and contributing in this meaningful work! 🎉

I'm taking a course to become a data scientist

💫 Excited to announce that I've completed Quantium's Data Analytics Job Simulation on Forage. 💫 During this job simulation: 💼 I worked on a project to conduct an analysis of a client's transaction dataset and identify customer purchasing behaviors. 🚀 Developed skills in data preparation & customer analytics. 📊 Extracted valuable insights & delivered data-driven recommendations. 🌈 Utilized data visualization to enhance insights. 📈 Created comprehensive reports for strategic decision-making. #dataanalytics #datawrangling #forage #quantium #customerinsights

Hey connections I am 🚀 excited to share my second project 𝗕𝗮𝗻𝗸 𝗖𝗥𝗠 𝗗𝗮𝘀𝗵𝗯𝗼𝗮𝗿𝗱📈 done in Power Bi. 🔍 𝗧𝗶𝘁𝗹𝗲 : Bank CRM(Customer relationship management) Development Dashboard. 📋 𝗦𝗧𝗘𝗣𝗦 𝗙𝗢𝗟𝗟𝗢𝗪𝗘𝗗: 1️⃣ 𝗗𝗔𝗧𝗔 𝗦𝗢𝗨𝗥𝗖𝗘: Gathered from Kaggle. 2️⃣ 𝗗𝗔𝗧𝗔 𝗧𝗥𝗔𝗡𝗦𝗙𝗢𝗥𝗠𝗔𝗧𝗜𝗢𝗡: Used Power Query to clean the data, removed nulls and duplicates, and fine-tuned data types. 3️⃣ 𝗗𝗔𝗧𝗔 𝗟𝗢𝗔𝗗𝗜𝗡𝗚: Imported the transformed data into Power View for analysis. 4️⃣ 𝗗𝗔𝗧𝗔 𝗜𝗠𝗣𝗟𝗘𝗠𝗘𝗡𝗧𝗔𝗧𝗜𝗢𝗡: Leveraged DAX to create calculated measures and columns, refining the data for deeper insights. 5️⃣ 𝗥𝗘𝗣𝗢𝗥𝗧𝗦 𝗖𝗥𝗘𝗔𝗧𝗜𝗢𝗡: Crafted user-friendly visualizations that tell a compelling data story through our dashboard. 𝗞𝗲𝘆 𝗣𝗲𝗿𝗳𝗼𝗿𝗺𝗮𝗻𝗰𝗲 𝗜𝗻𝗱𝗶𝗰𝗮𝘁𝗼𝗿𝘀 (𝗞𝗣𝗜'𝘀) 𝗜𝗻𝘀𝗶𝗴𝗵𝘁𝘀: 📊 ➼ 𝗥𝗲𝗴𝗶𝗼𝗻𝗮𝗹 𝗕𝗮𝗹𝗮𝗻𝗰𝗲𝘀: France leads in maximum balance, while Spain tops average balance. ➼ 𝗧𝗼𝗽 𝗘𝗮𝗿𝗻𝗲𝗿𝘀: Identified top 5 customers with high estimated salaries,  aiding targeted strategies. ➼ 𝗖𝗿𝗲𝗱𝗶𝘁 𝗖𝗮𝗿𝗱 𝗨𝘀𝗮𝗴𝗲: Customers with cards tend to adopt more products,  impacting retention. ➼ 𝗖𝗵𝘂𝗿𝗻 𝗔𝗻𝗮𝗹𝘆𝘀𝗶𝘀: Females show higher churn rates; credit scores correlate with churn. ➼ 𝗚𝗲𝗻𝗱𝗲𝗿 𝗗𝗶𝘀𝗽𝗮𝗿𝗶𝘁𝗶𝗲𝘀: Females earn slightly more but hold fewer active accounts on average. ➼ 𝗔𝗰𝘁𝗶𝘃𝗲 𝗔𝗰𝗰𝗼𝘂𝗻𝘁𝘀: France leads in active accounts, guiding resource allocation. ➼ 𝗖𝗿𝗲𝗱𝗶𝘁 𝗖𝗮𝗿𝗱 𝗜𝗻𝗳𝗹𝘂𝗲𝗻𝗰𝗲: Customers sans cards churn more, hinting at payment method's role. ➼ 𝗣𝗿𝗼𝗱𝘂𝗰𝘁 𝗔𝗱𝗼𝗽𝘁𝗶𝗼𝗻 𝗮𝗻𝗱 𝗖𝗵𝘂𝗿𝗻: Higher product adoption correlates with lower churn rates. 𝗕𝗲𝗵𝗮𝘃𝗶𝗼𝗿𝗮𝗹 𝗣𝗮𝘁𝘁𝗲𝗿𝗻𝘀 & 𝗥𝗲𝘁𝗲𝗻𝘁𝗶𝗼𝗻 𝗦𝘁𝗿𝗮𝘁𝗲𝗴𝗶𝗲𝘀: ➼ 𝗦𝗽𝗲𝗻𝗱𝗶𝗻𝗴 𝗕𝗲𝗵𝗮𝘃𝗶𝗼𝗿 : Long-term customers exhibit stable spending, signaling loyalty. ➼ 𝗥𝗲𝘁𝗲𝗻𝘁𝗶𝗼𝗻 𝗦𝘂𝗰𝗰𝗲𝘀𝘀: Stable spending among loyal customers reflects effective retention efforts. 𝗔𝘀𝘀𝗲𝘀𝘀𝗶𝗻𝗴 𝗠𝗮𝗿𝗸𝗲𝘁𝗶𝗻𝗴 𝗖𝗮𝗺𝗽𝗮𝗶𝗴𝗻 𝗜𝗺𝗽𝗮𝗰𝘁: ➼ 𝗖𝗮𝗺𝗽𝗮𝗶𝗴𝗻 𝗘𝘃𝗮𝗹𝘂𝗮𝘁𝗶𝗼𝗻 𝗦𝘁𝗲𝗽𝘀: Define metrics, monitor changes, segment customers, conduct tests, gather feedback, consider external factors, and apply simple analytics techniques. Any suggestions will be welcome 😊 #MicrosoftPowerBi #PowerQuery #DAX #Datamodeling #Ecommerce #networking #freshers #KPI #sales #RelationshipBuilding #DataVisualization #PowerBiServices #Deloitte #TigerAnalytics #Pwc #Kpmg #EY #HCL #Wipro #BIResearch##codebasics #DataAnalysis #MarketInsights #BusinessStrategy #ConsumerBehavior #Analytics #dashboard #research #Microsoft #kaggle #PowerQuery #Excel #sql #powerbi #powerbideveloper #data #businessintelligence