Powered by
Codebasics Bootcamp

Piyush Baweja

Data Aspirant

[email protected]

Resume

Hello, I am

Piyush Baweja.

1

PowerBI Project

About Me

[Portfolio WIP]

Experienced in data analysis, transitioning from a networking background. Proficient in Python, Power BI, SQL, and Excel. Demonstrated ability to clean and visualize data and develop insights to improve business performance.

Key Skills

Power BI

Microsoft Excel

Python

My SQL

ETL

Communication Skills

linux

wireless Network

My Projects

My Experience

Network Engineer – Guest-tek Private Limited Mar 2023 – Aug 2024

· Monitored network connection status, bandwidth usage, and equipment status using Power BI dashboards to provide real-time insights to clients.

· Automated workflows using Excel data manipulation techniques, reducing manual time by 40%.

· Collaborated with cross-functional teams to analyze equipment reset status and forecast optimal times for network refreshes, minimizing downtime and improving network performance for clients.

Awards & Certificate

Excel: Mother of Business Intelligence

Python: Beginner to Advanced For Data Professionals

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

SQL Beginner to Advanced For Data Professionals

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.

[email protected]

https://www.linkedin.com/in/piyushbaweja/

https://github.com/piyushbaweja99?tab=repositories

PowerBI Project

Atliq Sales Insight 360

Domain/Function: Brick Mortar and E-commerce

Having successfully completed the codebasics Power BI course, I gained valuable insights on problem-solving beyond the tools. The course covered essential tech skills like SQL, Power BI Desktop, Excel, DAX language, and DAX Studio for optimizing reports.

View Project
Engagement

Atliq Sales Insight 360

Sales View

Atliq Sales Insight 360

Marketing View

Project Details

Having successfully completed the codebasics Power BI course, I gained valuable insights on problem-solving beyond the tools. The course covered essential tech skills like SQL, Power BI Desktop, Excel, DAX language, and DAX Studio for optimizing reports.
✔ Crafted calculated columns and measures using DAX language.✔ Mastered data modeling techniques.✔ Leveraged Bookmarks to switch between visuals and enabled smooth page navigation with buttons.✔ Implemented divide function for error-free division.✔ Created dynamic date tables using M language.✔ Customized titles based on applied filters.✔ Incorporated KPI indicators and conditional formatting using icons and background colors.✔ Explored data validation techniques.
✔ Learned about Power BI services, report publishing, personal gateway setup, and app creation.✔ Acquired proficiency in collaboration, workspace management, and access permissions on Power BI services.✔ Analyzed Gross Price, Pre-Invoice Deductions, Post-Invoice Deductions.

Project video

Live Interactive Dashboard