Data Analysis using Tableau & Python by visualizing the data using Maps, Graphs and Charts to derive insights and support decision making through the resulting dashboards. The Python script was written in the Spyder IDE. The repository consists of three projects as mentioned below
• Sales Analysis for "Value Inc"
• "Blue Bank" Loan Analysis
• "BlogMe" Sentiment and Keyword Analysis
The data being used for the first project is in .csv format whereas it is in .json and .xlsx formats for the second & third project's respectively
• json - to work with json data
• pandas - to work with data sets
• numpy - for numerical operations on large quantities of data
• matplotlib - Python visualization library
• vader - provides sentiment scores based on the words used
Data visualization simplifies complex data, making it easier to interpret through charts, graphs, and maps. While small datasets can be reviewed manually, large datasets require visualization to reveal trends, patterns, and outliers. It enables stakeholders, from analysts to executives, to quickly grasp insights and make data-driven decisions. Tools like Tableau help uncover hidden patterns, presenting clear, actionable insights efficiently
Here are some benefits of data visualization
• Helps to better absorb business information by enabling easy ingestion or understanding of large amounts of business data
• Visually stimulating to promote quick decison making by uncovering not so obvious trends and patterns
• Quick access to important metrics and helps to optimize business processes
• Helps to align dashboards to company's goals, business objectives and track key performance indicators (KPIs)
1. Sales Analysis for Value Inc
Value Inc is a retail store that sells household items all over the world by bulk. The Sales Manager has no sales reporting but he has a brief idea of current sales. He also has no idea of the monthly cost, profit and top selling products. He wants a dashboard on this and says the data is currently stored in an excel sheet.
Data Files for the project
Date File: (transactions.csv)
https://databudd.com/blog/python-and-tableau-the-complete-data-analytics-bootcamp
Value Inc Seasons:
https://finch-groundhog-9245.squarespace.com/s/value_inc_seasons.csv
Logo: (Value Inc. Logo.png)
https://finch-groundhog-9245.squarespace.com/s/Value-Inc-Logo.png
2. Blue Bank Loan Analysis
Blue Bank is a bank in USA that has a loan department which is currently understaffed. They supply loans to individuals and don’t have much reporting on how risky these borrowers are. Using Python and Tableau, they’d like to see a report of borrowers who may have issues paying back the loan.
Data Files for the project
Date File: (loan_data_json.json)
https://finch-groundhog-9245.squarespace.com/s/loan_data_json.json
Logo: (Blue Bank Logo.png)
https://finch-groundhog-9245.squarespace.com/s/Value-Inc-Logo.png
3. BlogMe Sentiment and Keyword Analysis
BlogMe, a famous blogging business has a dataset of news articles that they need further analysis on. Firstly, they’d like keywords to be extracted from headlines of the article. Secondly, they would need to determine the sentiment of the news articles. The data is in an excel sheet and they would like to see a dashboard outlying sentiment, top articles etc.
Data Files for the project
Date File: (articles.xlsx)
https://databudd.com/blog/python-and-tableau-the-complete-data-analytics-bootcamp
BlogMe_sources.xlsx
https://finch-groundhog-9245.squarespace.com/s/BlogMe_sources.xlsx
Logo: (BlogMe Logo.png)
https://finch-groundhog-9245.squarespace.com/s/BlogMe-Logo.png
Value Inc. Sales
Access the Value Inc. Sales Dashboard: https://public.tableau.com/app/profile/mandar.nadkarni/viz/SalesforValueInc__16622853233430/Dashboard1
Blue Bank Loan Analysis
Access the Blue Bank Dashboard: https://public.tableau.com/app/profile/mandar.nadkarni/viz/BlueBank_16992060274190/BlueBankLoan
BlogMe News Analysis
Access the BlogMe News Analysis Dashboard: https://public.tableau.com/app/profile/mandar.nadkarni/viz/BlogMeNewsAnalysis_16992666127230/BlogMeNewsDashboard