Portfolio - Tusshar Tarun Patnaik

PowerBI Project

Mitron Bank's new Credit Card market presence.

Mitron Bank is a legacy financial institution headquartered in Hyderabad. They want to introduce a new line of credit cards, aiming to broaden its product offerings and reach in the financial market.

View Project
Engagement

Mitron Bank's new Credit Card market presence.

Study population traits (age, gender, income, ethnicity) for insights into trends.

Analyze income for economic patterns, disparities, and financial well-being.

Project Details

Key Insights:

Mumbai leads with 27% customer base, followed by Chennai; Hyderabad ranks lowest.
Females comprise 50.03% of average income; males, 67.23% of total expenditure.
Income utilization rate is about 42.82%.
IT employees show highest income utilization.
IT segment holds 1,294 customers; government employees, 399.
Income utilization peaks in September (56.11%) and August (48.81%)

Live Interactive Dashboard

PowerBI Project

Atliq Hardware Business Report

Key learning from this project: 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. Deploying in Power BI service

View Project
Engagement

Atliq Hardware business report

Data model of 10+ tables

Project Details

Learnings:
- Offering tailored promotions for specific demographics.
- Introducing relevant features aligned with spending categories.
- Prioritizing customer engagement for sustained relationships.
- Integrating demographic factors such as age, location, and profession.
- Expecting a rise in card usage, spending, and brand image enhancement.

Key Insights:
- Mumbai leads with 27% of the customer base, followed closely by Chennai, with Hyderabad at the bottom.
- Females account for 50.03% of average income, while males represent 67.23% of total expenditure.
- Income utilization stands at about 42.82%.
- IT employees make up the largest customer segment, totaling 1,294, with government employees at 399.
- Income utilization peaks in September at 56.11%, followed by 48.81% in August.
- Income utilization among IT employees is notably the highest among occupations.

Project video

Live Interactive Dashboard

SQL Project

Consumer Ad-Hoc Requests

Introducing Atliq Hardwares, a leading player in the computer hardware industry, both domestically and internationally. Despite their prominent position, the company faces a crucial need for swift and informed decision-making. To address this challenge, we embark on a SQL journey to gain insights.

View Project
Engagement

Home Page of Consumer Ad-Hoc Requests

Snippet depicts FY 2020 and 2021 Gross Sales amt

Project Details

In our Sales Performance Enhancement initiative, our aim was to equip decision-makers with actionable insights geared towards elevating sales effectiveness. Our focus encompassed the following key priorities:

1. Conducting thorough data queries to uncover valuable insights.
2. Guiding decision-making processes with informed strategies.
3. Enhancing overall sales performance through strategic interventions.
4. Throughout the duration of this project, I honed the following skill set:

Advanced proficiency in SQL data querying, addressing a wide array of business inquiries.
1. Expertise in interpreting data and providing strategic decision support.
2. Aptitude in selecting and implementing effective visualizations for concise data representation.
3. Successful integration of SQL solutions within a business context.
4. Comprehensive analysis of pivotal sales metrics to facilitate informed decision-making processes.

Project video

PowerBI Project

AtliQo Telecom

AtliQo, a prominent telecom provider in India, embarked on its 5G journey in May 2022, aligning with industry trends and customer demands for advanced connectivity solutions.

View Project
Engagement

Other Tools

Excel

SQL

Provides Revenue Analysis for AtliqO Telecom

Provides City Analysis for AtliqO Telecom

Project Details

AtliQo, a leading telecom provider in India, joined the 5G revolution in May 2022, following suit with other industry players. However, following the launch, management noticed a downturn in both active users and revenue growth. In response to this development, AtliQo's Business Director commissioned our analytics team to craft a thorough comparison report of key performance indicators (KPIs) before and after the 5G rollout.

Project video

Live Interactive Dashboard

PowerBI Project

Coffee Shop Analysis

I meticulously developed an extensive report tailored for a coffee shop, where I conducted in-depth analysis of the dataset to extract valuable insights crucial for stakeholders.

View Project
Engagement

Report analyzing Coffee Shop Sales

Calendar Heat Map Depicting Total Sales

Project Details

After thorough ETL processes and report design, I am pleased to unveil this interactive report. It offers actionable insights derived from meticulous analysis, tailored specifically for a comprehensive Coffee Shop Analysis.

Learnt Tech Stacks:
> Microsoft SQL Server
> Microsoft Power BI Desktop
> Advance DAX Codes
Learnt Power BI Techniques:
> Creating Date table
> Interesting ways to use Date/Time Intelligence Functions
> Calendar Heat Maps
> Dynamic Titles based on the applied filters

Hello, I am

Tusshar Tarun Patnaik

4

1

About

Key

My

Mitron Bank's new Credit Card market presence.

Atliq Hardware Business Report

Consumer Ad-Hoc Requests

AtliQo Telecom

Coffee Shop Analysis

Contact Me

Email

Linkedin

Call

Tusshar Tarun Patnaik

Download Resume