About Me
I’m Pranjal Prateek, a data wizard who loves turning numbers into stories. My journey in data analytics has taken me from crafting dynamic dashboards at EuroAqua Plumtek to streamlining data magic at Planet E-Com Solutions.
Armed with Power BI, SQL, Excel, and Python, I dive deep into data to uncover the hidden patterns that can change the game.
With a Microsoft Power BI certification under my belt, I'm all about making data fun, insightful, and impactful. Together, we can conjure up powerful insights that will take your business to the next level!
Skills
Python
Excel
SQL
Power BI
Tableau
Featured Projects
1. Top Skills For DataNerds | Power BI
• Built a dashboard using Power BI to analyze key skills and job market trends (2,635,480 jobs data).
• Developed an interactive tool allowing users to filter data by 10 job title, presenting insights through a bar chart showcasing top skills, salary distribution, location distribution by number of jobs and top average paying companies.
2. CodeX - Energy Drink Survey Analysis | Power BI
• Analyzed survey data for CodeX's energy drink launch in India using Power BI, providing 5-10 demographic insights, consumer preferences, and competitive analysis.
• Identified key marketing strategies, including targeting males aged 19-45, emphasizing caffeine content, and focusing on online ads and TV commercials for brand promotion.
3. Airbnb Open Data - Exploratory Data Analysis | Python
• Conducted comprehensive data cleaning, including handling missing values, correcting categorical data errors, and transforming data types for accurate analysis.
• Created visualizations using scatter maps and histograms to analyze price distributions, neighborhood trends, and other key metrics.
4. Music Store Analysis | SQL
• Identified senior-most employee and best customer based on spending, providing key personnel and customer data.
• Analyzed top revenue-generating countries, cities, and invoice values, guiding market and promotional strategies.
• Determined popular music genres and top customers by country, aiding targeted marketing and inventory decisions.
Thank you for taking the time to visit my portfolio.
Feel free to email me, If you'd like to chat about me joining your team or you are just interested in data.
+91 9711740327