top of page

Power BI / Data Analytics

In 2021, I was given the unique opportunity to become the Power BI SME (Subject Matter Expert) whilst in my Provisioning Role at Proofpoint and in doing so, greatly accelerated the creation and improvement of Power BI Metrics for my boss, the Director of Provisioning, Global Logistics & Trade Compliance.

​

The Power BI Dashboards I created and worked on for Proofpoint contained contents that are internal to my company, thus I cannot share them. Therefore the Reports I will be showing below will be based off of publicly available data.
 

I can, however, describe the work that I did at Proofpoint as Power BI SME which included:

​

  • Using Power BI desktop, create visual reports, dashboards, and KPI scorecards.

  • Using excellent analytical thinking skills for converting data into visually appealing reports and graphs.

  • Being capable of fully comprehending company requirements and developing data models in accordance while managing resources.

  • Understanding business requirements in the context of business intelligence (BI) and create data models to transform raw data into useful information.

  • Migrating all data sources used in reports from Data Warehouse 1 to Data Warehouse 2 (Jira, SFDC, AD, CTS) and editing column names to match new names using advanced editor

  • Utilizing Microsoft SQL Server and DBeaver to query databases

  • Using SQL skills to mine data and provide the company with beneficial information

  • Performing DAX queries using Power BI tools

  • Developing 20+ reports by utilizing knowledge of SQL queries

  • Collaborating with business users, collected requests, and updated the set of existing BI reports to accommodate business needs

  • Developing and maintaining data models in Power BI for reporting and analysis

  • Improving dashboard usability by implementing interactive visualizations

  • Improving client decision-making by providing interactive and static reporting using data visualization techniques

  • Creating Power Bi Dashboards to track the following (and more):

    • Automation Failures in CTS Calls

    • Logistics and provisioning throughput for Jira/CTS tickets

    • Provisioning Team's Qualing throughput

    • When a non provisioning employee changed provisioned product's parameters (things that only provisioning is supposed to do.)

    • Expiring TRAP products to notify and remind renewals teams to submit their shiprecs on time

    • When a Non Provisioning Person Changes the call to a non assigned/Wrong status.

    • SLA Service agreement to show how long it takes for a cts call to go from new to complete.

    • How many clusters are converted per year/quarter/month/etc

    • How often we send calls back to OM

    • Statuses of the Jiras that the Provisioning Team submits to CTS

​

Maven Northwind Challenge

This Project is for the Maven Northwind Challenge which has the prompt of working as a BI Developer for Northwind Traders (a fictitious gourmet food supplier), where the task is to build a top-level KPI dashboard for the executive team to help them quickly understand the company's performance in the key areas of Sales trends, Product performance, Key customers, and Shipping costs.

Maven Northwind Challenge Walkthrough

Use of Bookmarks

Use of Custom Tool Tips

Use of M Query and Advanced Editor

Northwind Report
2.png

Northwind's most popular products are their beverages.

3.png

Q1 of 2015 was the best quarter across all of their products - with beverages taking the lead as the most popular product type.

1.png

Northwind's most popular beverage is the Raclette Courdavault - with its top customer being Hungo

5.png

Overall, the top 3 products most popular products are:

  1. Raclette Courdavault

  2. Camembert Pierrot

  3. Gorgonzola Telino

5.a.png

Despite that, the most profitable product was actually Cote De Blaye, bringing in 127.73K

4.png

Year over year, Beverage, Meat & Poultry and Produce purchases went up, while everything else went down.

8.png
7.png
6.png

In 2013, the most popular Product was the Gorgonzola Telino

In 2014, the most popular Product was the Gnocci di Nonna Alice

In 2015, the most popular Product was the Konbu

17.png

United Package, who has delivered 320 orders for Northwind, comes in as the most expensive shipping service with an average of $87 per shipment - though it looks like they ship the fastest, as Orders that were shipped out AFTER the required date usually used United Package.

18.png

Most of Northwind's customer base resides in the US and Europe

9.png

Northwind's top customers are:

  1. QUICK

  2. ERNSH

  3. SAVEA

10.png

Northwind's #1 Top customer, QUICK, spent nearly 110K with Northwind, with their top purchases being in the Beverages Category.

11.png

Northwind's #2 Top customer, ERNSH, spent nearly 105K with Northwind, with their top purchases being in the Dairy Products Category.

12.png

Northwind's #3 Top customer, SAVEA, spent about 104K with Northwind, with their top purchases being in the Dairy Products Category.

13.png

Across all the years, Margaret Peacock was the Employee that generated the most sales, coming in at 229K in sales. The product she sold the most was Gnocci di nonna Alice

14.png

In 2013, the best performing Sales Rep was Margaret Peacock, generating, Quarter-over-Quarter, an additional 12k in sales for a total of 50k.

15.png

In 2014, the best performing Sales Rep was, once again, Margaret Peacock generating 126k in sales.

16.png

In 2015, the best performing Sales Rep was Janet Leverling, generating 77k in sales.

End of Report
bottom of page