Project Details

At the core of AtliQ's data journey, our goal is clear: Create an interactive report that reveals valuable insights across finance, sales, marketing, supply chain, and the executive level.

Approach 🛣️ :
➡️ Project Planning
➡️ Data Collection, Exploration, Transformation
➡️ Data Modeling
➡️ Dashboard Preparation
➡️ Data Validation & Stakeholder Feedback Implementation

With creativity and the provided mockup dashboards as my guide, I'm building an interactive report that not only informs but also engages. 💡 Say goodbye to losses, and hello to a new era of smart decision-making.

Learnings ✨ :

1. Power Query (Basic and Advanced Operations)
2. Basic and complex DAX formulas
3. Data modelling involving 10+ tables
4. Choosing the right visuals and formatting
5. Dashboard designing principles
6. Using bookmarks
7. Deploying in Power BI service
8. Stakeholder Feedback Implementation
9. Sales, Marketing, Finance & Supply Chain metrics

Live Interactive Dashboard

Project Details

📈Brief Summary
- Scraped data from the screener.in using the Selenium library.
- Created EDA report on Python using Pandas, Matplotlib, and Seaborn.
- Hosted the EDA report on the web with the help of Git Hub.


🪨Challenges and 🧠learnings-
web Scraping | E.D.A. | Matplotlib | Seaborn | HTML

🤖Techstack-
Python | Pandas | Selenium | Matplotlib | Seaborn | HTML

🔡Data Scrapping & Cleaning -
For scraping used the Selenium Xpath method and created a CSV file
After that cleaned the data set using the Pandas library.

Project Details

📈 LINKEDIN_JOB_ANALYSIS - 📑 Brief Summary
We scraped data from LinkedIn using the Selenium library, which took approximately 4 hours. An EDA report was created in Python utilizing Matplotlib and Seaborn, and a dynamic dashboard was developed with Tableau. The user interface was built using the Streamlit library.

🪨 Challenges and 🧠 Learnings
Dynamic web page scraping
User interface design
Team management
Collaboration
🤖 Tech Stack
Python
Pandas
Selenium
Tableau
MS PowerPoint
Objective
This educational project, assigned by a reputable IT learning institute, aimed to analyze current job roles in Data Analysis and Data Science by scraping data from LinkedIn.

Visit here for the Streamlit UI: https://linkedin-job-analysis.streamlit.app/

For Tableau Dashboard - https://public.tableau.com/app/profile/manish.hemnani/viz/LINKEDIN_JOB_ANALYTICS/ANALYTICSDASHBOARD

Project Details

COVID-19 Analysis
Summary:
Utilized Pandas and JSON for data gathering from the official COVID-19 API.
Employed SQL for deriving KPIs and insights.
Visualized datasets in Excel and presented findings using MS PowerPoint.
Challenges and Learnings:
Faced challenges in API handling, error management, and creating impactful presentations.
Gained insights into effective API utilization, error handling techniques, and presentation skills.
Tech Stack:
Python, SQL, Excel, MS PowerPoint.
Objective:
Analyze COVID-19 impact across Indian states and forecast vaccination trends for proactive preparation.
Data Extraction & Cleaning:
Utilized official COVID-19 India API for data extraction.
Implemented thorough data cleaning and error handling procedures.
Project Impact:
Facilitated informed decision-making for a reputed pharmaceutical company.
Enhanced preparedness and response strategies against the pandemic.