To analyzed the database and extract the insights about cell phone Sales and Transactions which help business owner to understand the business performance.
• Analyzed the number of transactions for each model per zip code per state
• Analyzed the average price for each model in the top 5 manufacturers in terms of sales quantity and order by average price
• Figured out top 100 customers and their average spend, average quantity by each year, also analyzed the percentage of change in their spend
• Analyzed if there is any model that was in the top 5 in terms of quantity, simultaneously in 2008, 2009 and 2010To analyzed the database and extract the insights about cell phone Sales and Transactions which help business owner to understand the business performance.
• Analyzed the number of transactions for each model per zip code per state
• Analyzed the average price for each model in the top 5 manufacturers in terms of sales quantity and order by average price
• Figured out top 100 customers and their average spend, average quantity by each year, also analyzed the percentage of change in their spend
• Analyzed if there is any model that was in the top 5 in terms of quantity, simultaneously in 2008, 2009 and 2010
SQL Server Management Studio · Microsoft SQL Server
I'm an aspiring Data Analyst with a strong foundation in data manipulation and statistical analysis. I thrive on uncovering insights that drive decisions and am passionate about learning.
As a Data Analyst, I specialize in transforming raw data into clear, impactful insights using Python, SQL, and visualization tools like Matplotlib and Power BI. My educational background includes a Post Graduate Diploma in Business Administration in Finance, and I'm currently pursuing a Data Science program at AnalytixLabs.
My technical skills encompass Python, SQL, Statsmodel, and various statistical techniques, with a focus on machine learning libraries like Scikit-Learn and TensorFlow. I'm dedicated to turning data into compelling stories that influence business outcomes.
