Powered by
Codebasics DA Bootcamp

Hark Poon

Power BI Consultant

+91 7972783361 [email protected]

Resume

Hello, I am

Hark Poon.

2

Python Projects

1

PowerBI Project

1

SQL Project

About Me

Hello there!

As a experienced BI professional with a successful track record in Power BI consulting, I specialize not only in data analysis and insights but also in the aesthetics design of BI report to ensure a seamless user experience. With experience across various sectors, including finance, sales, inventory, production, and trade, I’ve developed customized BI solutions that address unique business challenges.

Whether it's designing customized reports to meet specific business requirements or optimizing existing Power BI solutions for scalability and efficiency, I am dedicated to driving innovation and helping organizations unlock the full potential of their data assets.

Feel free to connect with me for networking opportunities, collaboration on projects, or to discuss how we can work together to drive your data-driven initiatives & business success.

Key Skills

Reporting & Analysis

SQL

Python

Data Manipulation & Cleansing

Statistics & Probability

Data modeling & Visualization

My Projects

My Experience

May 2024 - Present

Robosoft Solution Pvt Ltd, Mumbai - Power BI Consultant

Collaborated with 3 Gulf-based clients on Power BI development by creating and altering 20+ Power BI reports, which reduced the time spent in manual reporting by 80%.
Developed an automated analytics solution using Power BI for Inhouse team as well as for the client to automate MIS reporting processes saving 50+ hours per month.
Developing end-to-end hedging report to analyze commodity risk in international trade, empowering businesses to make informed decisions and potentially reduce risk by 40%.
Delivered 5+ training workshops to 12+ clients on Power BI functionality, resulting in a 30% improvement in their data visualization capabilities and overall analytics efficiency.
Provided ongoing support and maintenance for Power BI solutions, resulting in a 99% data accuracy rate and a 20% reduction in report loading times.

Awards & Certificate

Microsoft Certified: Power BI Data Analyst Associate (PL -300)

Microsoft Certified: Power BI Data Analyst Associate (PL -300)

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/harkpun

+ 91 7972783361

https://github.com/harkpun

Python Project

EDA | Netflix movies & TV shows

Domain/Function: Video Streaming Service

The goal of this project is performing EDA on Netflix data to classify/group the Netflix shows into certain clusters such that the shows within a cluster are similar to each other and the shows in different clusters are dissimilar to each other.

View Project
on GitHUB

EDA | Netflix movies & TV shows

Project Struture

EDA | Netflix movies & TV shows

Imported Libraries

Project Details

The dataset contained about 7787 records, and 11 attributes.

1. Started by dealing with the dataset's missing values and doing exploratory data analysis (EDA).

2. Created cluster using following attributes: director, cast, country, genre, rating and description. The values in these attributes were tokenized, preprocessed, and then vectorized using TFIDF vectorizer.

3. Used Principal Component Analysis (PCA) to handle the curse of dimensionality.

4. Built two types of clusters using the K-Means Clustering and Agglomerative Hierarchical clustering algorithm and find out optimal number of clusters using different technique such as elbow method, silhoutte score and dendogram etc.

5. A content based recommender system was built using the similarity matrix obtained after using cosine similarity. This recommender system will make 10 recommendations to the user based on the type of show they watched.

Project video

PowerBI Project

Business Insight 360 | Bricks & mortar and e-commerce

Domain/Function: E-Commerce

Fast-growing consumer electronics company AtliQ Hardwares struggles with scattered Excel reports, hindering data-driven decisions. Project implementation on Power BI for business insights will unify data, reveal trends and empower smart choices for optimal operations and a competitive edge.

View Project
Engagement

Business Insight 360 | Bricks & mortar and e-commerce

Home page

Business Insight 360 | Bricks & mortar and e-commerce

Complex Data Modeling involving 12+ tables.

Project Details

This project aims to design a single report with multi-view Power BI dashboard for AtliQ Hardware. This interactive tool will empower stakeholders across sales, finance, supply chain, marketing, and executive teams to understand business trends and make data-driven decisions to scale operations

Key areas of focus include:
1. Robust Data Modeling
2. User-empathetic report design
3. Drillable Insights

Here is the list of topic implemented on this report -
1. Power Query (Basic and Advanced operation)
2. Complex Data Modeling involving 12+ tables.
3. Basic and Advanced DAX functionalities
4. Choosing the right visual and formatting
5. Dashboard design principle
6. Page Navigation and Bookmarks
7. what-if parameter & field parameter
8. UI / UX design
9. Deployment in Power BI service
10. On premises Data Gateway (Personal mode)
11. Stakeholder feedback Implementation
12. KPI metrics for Finance, Sales, Supply chain, Marketing
etc. & many more....

Live Interactive Dashboard

Python Project

EDA | Google Play Store

Domain/Function: Digital Distribution Service

The Play Store apps data has enormous potential to drive app-making businesses to success. Actionable insights can be drawn for developers to work on and capture the Android market. Explore and analyze the data to discover key factors responsible for app engagement and success.

View Project
on GitHUB

EDA | Google Play Store

Libraries used

EDA | Google Play Store

Project Structure

Project Details

This project is divided into two parts.

1. Data Preprocessing
- Analyze and explore the data, converting data type of columns from object to numerical or datetime format as per needed to make it ready for our analysis.
- Dropping irrelevant columns, removing null values and deleting the duplicate row which are present in dataframe.
- Imputing null values with Mean or Median for numerical attribute and Mode for categorical attribute.

2. Data Visualization
- Plotted several graphs and extracted more insights from our dataset which will help the developers in rolling out the app in the play store.

SQL Project

Ad-hoc Analysis | Consumer Goods

Domain/Function: Consumer Goods | Executive Management

Project task involves addressing 10 Ad-hoc requests from management using SQL queries and transforming the results into insightful visualization to present actionable insights to top-level Management based on analysis.

View Project
on GitHUB

Ad-hoc Analysis | Consumer Goods

Request page

Ad-hoc Analysis | Consumer Goods

code

Project Details

Atliq Hardwares is one of the leading computer hardware producers in India and well expanded in other countries too.

However, the management noticed that they do not get enough insights to make quick and smart data-informed decisions. Project task involves addressing 10 Ad-hoc requests from management using SQL queries and transforming the results into insightful visualization to present actionable insights to top-level Management based on analysis.

Task:
1. Check ‘ad-hoc-requests.pdf’ - there are 10 ad hoc requests for which the business needs insights.
2. You need to run a SQL query to answer these requests.
3. The target audience of this dashboard is top-level management - hence you need to create a presentation to show the insights.

Domain: Consumer Goods | Function: Executive Management