Data Analytics & Automation WorkFolio

Microsoft PowerBI

Project 1: Food Delivery App Data Analysis & Visualization

Built an interactive dashboard in Microsoft PowerBI for publicly available Blinkit grocery app market data.

Outlets, sales, goods sold and trend analysis were captured in this clean, s traightforward dashboard using Power Query and DAX.

Project 2: USA Electric Vehicles Data Analysis & Visualization

Designed and built an interactive dashboard in Microsoft PowerBI using publicly available, USA based Electric Vehicle data (post 2010)

This data analysis seeks to gain more data insights by Total Vehicles Model, Make, State and Clean Alternative Fuel Vehicle (CAFV) eligibility

Project 3: Power BI to capture real time data from a Think Tank PowerApp.

I created this Power BI dashboard for a 'Think Tank' Power App to spark new ideas and improve processes, client services, products, and training.

I designed it to help SMBs keep track of all their ideas from different departments. Ideas often get lost in emails or chats, but with this central platform, everything stays organized.

The best part? It has a multi-layer review system that turns simple thoughts into fully developed projects and achieved goals. It's like magic!

Project 4: Sales Team KPI Dashboard: Annual Performance Review

A DAX-powered KPI dashboard analyzes team sales performance using a sample data from the last financial year.

My goal was to highlight each salesperson’s monthly targets and by using custom DAX formulas to track sub-teams that met or exceeded goals. Also added Power BI's SmartAI (Co-Pilot) for custom summary. DataSource: Made up for sample project.

Microsoft PowerApps

Project: THINK TANK VAULT (Ideation, Innovation, Excellence)

Tools: PowerApps, PowerBI, PowerAutomate, SharePoint, Outlook

I built this Microsoft Power App for a 'Think Tank' to spark ideas, boost innovation, and improve processes, client services, products, and training.

Why? Because SMBs often lose great ideas in emails or IMs. This app creates a central hub to organize thoughts with a multi-layer review system, turning simple ideas into full-blown projects and goals. ✅

Perfect for SMBs, agencies, entrepreneurs, and content creators!

Bonus: It can be customized for things like issue management, brainstorming, and more. I even use my own version to track my content creation journey!

Welcome Screen

Welcome screen shows the demarcation between the Submit section and Review section.

There is a button that is solely meant for management/ CEO office to view all the submissions in 1 place

Submit Screen

Submit screen displays all the ideas/tickets submitted by a person.

You would click on 'submit new idea' and open a form to fill in details.

In this case, you see my submissions across departments, which won't be the case in real life scenario.

Here, you can switch between tabs to see 'all ideas submitted' and 'all approved ideas'. You can also use the filter function to dice and slice data per categories and title.

Form/ Questionnaire

Form displays a list of questions that is required for the ideation process.

Review Screen for one of many teams

This screen only displays all the ideas/tickets submitted for operations department. This is a 2 tier review layered system.

The access is also restricted to individuals from the operations department.

On the left panel, you can use the multiple filter options provided to locate the idea/ticket of your choice.

Can also access Power BI analytics Dashboard inbuilt on left panel.

Executive Screen for Management/CEO

A separate screen for the senior management/CEO team to view all submissions across departments.

Multiple filter options provided to dice and slice data.

Can also access Power BI analytics Dashboard inbuilt on left panel.

Power BI Inbuilt for Real Time Analytics

As an when new submissions and review decisions are made, the PowerApps connects to PowerBI to showcase real time status on a dashboard visually.

Microsoft Power Automate

Project 1

Power Automate for PowerApps

Problem Statement: "I want my PowerApps to send email/ Teams notifications as and when there are updates. How to use Power Automate here?"

Real Time Email Notifications

In continuation of the above PowerApps project, I built a workflow to connect Power Automate to my Power App to send emails in the following instances:

1. When a new idea/ticket is submitted

2. When there are changes to review

3. When the idea has been approved or rejected.

Sample Form for an Incident Reporting

This form contains the details one would require for an Operations /Risk/ Compliance Incident Reporting.

Project 2

Power Automate for Forms and SharePoint

Problem Statement: "I want my Microsoft Form responses to be 1) Auto saved to a SharePoint repository 2) Send notifications 3) have an approval workflow. Can PowerAutomate help?"

Auto Update SharePoint upon new Form submissions

SharePoint acts as a data repository and auto-capture all Form information along with any attachments (made possible via JSON code).

Real Time Email Notifications

As and when there is a new form submitted or any updates to the form entry, email notifications get sent out to the necessary individuals.