Portfolio - Jason Hall

PowerBI Project

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

AtliQ Hardware is a consumer electronics company expanding rapidly but is not able to compete with other companies using data as most of their report still exists in Excel. My goal is to implement an advanced analytics solution using Power BI that will enable the company to get insights and make in

View Project
Engagement

View Project
on GitHUB

Other Tools

Excel

SQL

DAX Studio

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

User-empathetic landing page as a part of dashboard design

Data modelling involving 10+ tables

Project Details

In this project, the goal is to create one report that could be used by stakeholders from the sales, marketing, finance, and executive team. The focus is made on the following

1. Robust Data Modeling
2. User-empathetic Report design
3. Drillable Insights

I learned the following things in 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. Using bookmarks
7. Deploying in Power BI service
8. Stakeholder Feedback Implementation
9. Sales, Marketing, Finance & Supply Chain metrics

Project video

Live Interactive Dashboard

Excel Project

Sales Analytics(FMCG)

Created 2 reports for the sales team which will help them to evaluate customer performance and understand their market performance concerning their target.

View Project
on GitHUB

Provides net sales performance of each customer across years

Market performance vs Target report across years: Enables stakeholders to assess the country's performance and compare it to set targets.

Project Details

In this project, I created a sales report using Excel pivot tables which will enable businesses to determine effective customer discounts, facilitate negotiations with consumers, and identify potential business expansion opportunities in promising countries. The reports generated will provide actionable insights and recommendations for businesses to optimize their sales strategies, enhance customer satisfaction, and maximize revenue generation.

I have learned the following:

1. Pivot table
2. Power Query
3. DAX (Basics)
4. Conditional Formatting
5. Report Beautification
6. Sales Domain Metrics

Overall, this project aims to empower businesses with the necessary tools and insights to monitor, evaluate, and enhance their sales activities. By leveraging sales data analysis, businesses can unlock new opportunities, drive growth, and stay competitive in the dynamic market landscape.

PowerBI Project

Talent Acquisition Operational Dashboard

Recruitment is a top priority in organizations, and this dashboard provides an overview of the time efficiency and effectiveness, as well as demographic details of the applicant pool, to allow the company to optimize its recruitment processes.

View Project
on GitHUB

Other Tools

Excel

SQL

ATS

Talent Acquisition Operational Dashboard

Talent Acquisition Dashboard Preview

Talent Acquisition Data Model

Project Details

Introduction

Attrahunt is a multinational pharmaceutical company with around a thousand employees. In recent years, Attrahunt has upgraded most of its HR activities to become more professional.

Attrahunt’s recruitment manager has requested that you build an operational dashboard which allows them to optimize their performance. The company wants to have an operational overview of the cost, time efficiency, and effectiveness of different sourcing channels so it can hire faster and cheaper without decreasing quality.

Data

This dashboard will be based on database extracts from the company’s applicant tracking system (ATS).

Attrahunt’s IT team has provided database access to connect to the relevant data tables.

The dashboard contains created DAX measures to formulate a recruitment funnel to track applications from stage to stage of the recruitment process and measures to drill into how many workdays are spent in each stage of the process.

Live Interactive Dashboard

PowerBI Project

HR Headcount, Retention, and Turnover Dashboard

This project included building an HR headcount report from start to finish - modeling the data into a star schema using the Power Query Editor, building out DAX measures, designing a custom layout, and interactive features like a slicer panel to save space within the tool, visual tooltips.

View Project
Engagement

View Project
on GitHUB

Other Tools

Excel

SQL

HR Headcount, Retention, and Turnover Dashboard

Report Cover Page

Headcount Report

Project Details

This project included building an HR headcount report from start to finish, including modeling the data into a star schema using the Power Query Editor, building out DAX measures for headcount and employee retention & turnover, designing a custom layout, integrating interactive features like a slicer panel to save space within the tool, visual tooltips and designing a really cool cover page!

Hello, I am

Jason Hall

3

1

About

My

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

Sales Analytics(FMCG)

Talent Acquisition Operational Dashboard

HR Headcount, Retention, and Turnover Dashboard

Awards

Contact Me

Email

Github

Linkedin

Call

Jason Hall

Download Resume