Praveer Tiwari

Data Analyst

[email protected] +91 9977559997

Hello, I am

Praveer Tiwari.

1

Excel
Project

3

PowerBI
Projects

1

SQL
Project

About Me

Hello! I'm Praveer Tiwari, a dedicated individual with a passion for Data. Currently on the journey to becoming a proficient Data Analyst.

Tools & Technologies I Work :-

📊 Excel Expertise: Proficient in data manipulation, analysis, and visualization using advanced Excel functions and features.

💡 Power BI Mastery: Actively expanding my skill set in Power BI to create interactive dashboards and reports that bring data to life.

🔍 MySQL Proficiency: Experienced in database management and SQL querying, enabling efficient data extraction and analysis.

I have a passion for transforming raw data into actionable insights. So, Let's connect, collaborate, and navigate the exciting world of data analytics together.

Key Skills

MySQL

Data Analysis

Tableau

Advanced Excel

Power BI

Python

My Projects

AtliQ Hardware Sales & Finance Analysis

Business Insight 360

Consumer Goods Insights

AtliQ Hospitality Analysis

Shield Insurance

My Experience

AtliQ Technologies - Data Analyst Intern
April 24 - May 24

• Performed data cleaning by correcting errors and eliminating duplicates to ensure the data's accuracy for subsequent analysis.• Leveraged tools such as Excel and Power BI to explore various business questions, including the number of remote employees and significant shifts in order volumes.• Reorganized disordered client data into a more structured format for easier access and manipulation.• Compared expected data to actual data to identify discrepancies, focusing on metrics like order quantities versus delivery quantities.• Fixed SQL query issues to ensure accurate data retrieval from our database.• Automated the creation of client network operation reports to streamline the reporting process.• Evaluated a specialized dashboard on the financial, performance, and customer behavior impacts of 5G technology implementation and provided insights.• Developed a sample dashboard in Power BI to monitor customer and revenue growth, featuring customizable options and trend visualizations.

Awards & Certificate

Excel: Mother of Business Intelligence

Get Job Ready: Power BI Data Analytics for All Levels 3.0

SQL Beginner to Advanced For Data Professionals

Data Analytics Bootcamp 5.0: Job Placement Support + AI Automation & Data Engineering Basics

Tableau Mini

Google Data Analytics Certificate

Let's Connect

Feel free to get in touch with me. I am always open to discussing new projects, creative ideas or opportunities to be part of your visions.

Mail Me

[email protected]

https://www.linkedin.com/in/praveer-tiwari-b5481320a/

Call Me

+91 9977559997

GitHub

https://github.com/Praveer-Tiwari

Excel Project

AtliQ Hardware Sales & Finance Analysis

Created actionable insights in the FMCG sector using extensive sales and financial data. Providing businesses with data-driven growth and expansion plans. Proficiency in ETL, Power Query, Power Pivot, and DAX.

View Project
Engagement

View Project
on GitHUB

Profit & Loss (P & L) :- Created P&L reports by FISCAL YEARS and P & L report by FISCAL MONTHS & QUARTERS.

Data Modelling - Diagram View

Project Details

Created an Excel sales report to assist businesses in determining suitable discounts for customers, communicating more effectively with them, and identifying new areas for growth.
- Technical Process Involved:-
- ETL - Extracted data from the source file, Transformed and carried data cleaning in Power Query, and Loaded data in the data model.
- Connected all the query connections and created relationships in the Power Pivot.
- Created calculated columns and measures by DAX.
- Created Pivot tables to analyze performance on various factors.
- Created a derived date table by using the M code formula.

PowerBI Project

Business Insight 360

AtliQ Hardware has been quickly expanding in recent years, and they have opted to deploy data analytics utilizing PowerBi in their organization for the first time to outperform their competition and make data-driven decisions. This initiative is intended to provide solutions to stakeholders.

View Project
Engagement

Home Page

Finance View

Project Details

The primary goal of this project was to produce a uniform report for stakeholders in sales, marketing, finance, and the executive team.
Tools Used:-
- Power BI
- Excel
- SQL

Throughout this endeavor, I gained the following abilities and knowledge:
- Power Query proficiency
- Basic and advanced DAX formulas.
- Data modeling
- Choosing acceptable visuals and formatting methods.
- Metrics analysis and reporting in sales, marketing, finance, and supply chain sectors.

Live Interactive Dashboard

SQL Project

Consumer Goods Insights

Atliq Hardware is a prominent computer hardware producer based in India, holding a leading position not only in the Indian market but also in various other countries.

View Project
Engagement

View Project
on GitHUB

Company's Market

Data & Requests

Project Details

Our aim in the Sales Performance Enhancement project was to provide actionable data to decision-makers.
I learned the following abilities while working on this project:
- SQL data querying proficiency, addressing a wide range of business questions.
- Data analysis and strategic decision support expertise.
- Choosing appropriate graphics for accurate data representation.
- Effective implementation of SQL solutions in a corporate setting.

Project video

PowerBI Project

AtliQ Hospitality Analysis

AtliQ Grands, a well-established player in India's hotel industry, is facing tough competition and declining revenue in the luxury and business hotel sector. AtliQ Grands proudly owns a collection of five hotels in the major Indian cities such as Delhi, Mumbai, Hyderabad, Bangalore.

Data Model

Dashboard

Project Details

AtliQ Grands, renowned for its chain of five-star hotels across India, boasts a rich 20-year history in the hospitality sector. Nevertheless, they currently grapple with diminishing market share and revenue in the luxury and business hotel segment.

Project Goal:
"To enhance Atliq Grands' market share and revenue in the luxury business hotel segment by implementing data-driven strategies and business intelligence.

Project video

Live Interactive Dashboard

PowerBI Project

Shield Insurance

Shield Insurance was found with a vision to provide comprehensive and innovative insurance solutions to individuals, families and businesses. Over the years, the company has built a reputation for excellence, trust, and unwavering commitment to the customers.

View Project
Engagement

View Project
on GitHUB

Homepage with all the Views and there descriptions

Data Model

Project Details

Shield Insurance wants to evaluate how the company is performing in terms of sales and revenue.
This presentation aims to provide valuable insights to the management of Shield Insurance so they can make informed data-driven decisions on key areas and take the company to new heights.