Freelancer logo How It Works Browse Jobs
Log In Sign Up
Post a Project
EXPLORE
Data Processing
Excel
Microsoft
Microsoft SQL Server
Tableau
Profile cover photo
You're now following
Error following user.
This user does not allow users to follow them.
You are already following this user.
Your membership plan only allows 0 follows. Upgrade here.
Successfully unfollowed
Error unfollowing user.
You have successfully recommended
Error recommending user.
Something went wrong. Please refresh the page and try again.
Email successfully verified.
User Avatar
$25 USD / hour
Flag of UNITED KINGDOM
leeds, united kingdom
$25 USD / hour
It's currently 8:20 AM here
Joined March 9, 2016
0 Recommendations

Depicting Data

@WardWarrior

 5.0 (17 reviews)
5.2
5.2
100%
100%
$25 USD / hour
Flag of UNITED KINGDOM
leeds, united kingdom
$25 USD / hour
95%
Jobs Completed
98%
On Budget
97%
On Time
10%
Repeat Hire Rate

Data & Dashboard Specialists - Power BI & Tableau

Hi, We have 10+ years specialising in analysing company data and presenting business insights using visualisation tools. Creating dashboard reports showcasing how your business's KPI is currently performing or producing historical/investigative analysis to find trends and improve business processes. As senior consultants, we understand the key performance areas across various industries including marketing, finance, retail, healthcare, government, insurance and hospitality industries. Data Analysis & Visualizations - over ten years experience working with various software solutions to analyse databases, create reporting queries and developing dashboards (including MSSQL, Azure, SSRS, SSAS, SSIS, Tableau and Power BI).
Freelancer Microsoft Developers United Kingdom
See all Microsoft Developers in United Kingdom

Contact Depicting Data about your job

Log in to discuss any details over chat.

Portfolio

5408932
My client wanted to understand the demographics of their customers so that they could identify profitable products and produce targeting promotions. I was able to show the clients sales across each of their product categories by age, gender and location. We then worked together to understand how best to use this information to target key demographics by product category and state. We successfully improved the client's sales, which we continue to review on a regular basis.
Tableau Sales Demographics Dashboard
5408909
This project aimed to analyze and restructure my client's email marketing campaign. 1) I was able to breakdown the email recipient lists and show how many people were accessing the email as well as how many were following the link through to the promotions. We were able to use this information to find subscribers who were not accessing their email and verifying their details leading to an increase in email activity. 2) I presented the effectiveness of various types of marketing emails that had been sent out to each of the email recipient lists. By producing custom marketing campaigns targeted to each email list, we improved response rates to promotions. 3) We could see when emails were being accesses and wanted to know when was the best time for each type of email by email list. The new email schedule we created from this analysis positively impacted the total clicks for each type of email promotions.
Tableau Email Marketing Impact Dashboard
5274697
The project was to create a full suite of business dashboards for a retail client. I was able to breakdown live data for sales, profit, inventory transactions. Due to the nature of the business, it was key to be able to view the different areas of the business by various periods as each product type had its own sales seasons. - Using my analysis the business was able to create promotions to reduce excessive inventory. - I could clearly identify when to increase inventory holdings of different product types for when seasons started. - Breaking down profit by department and product category allowed the client to remove low-profit areas and concentrate on products that brought in >80% of profits. - I continue to work with this client to provide valuable insights for his onging business needs.
Power BI Retail Sales & Inventory Dashboard
The project was to create a full suite of business dashboards for a retail client. I was able to breakdown live data for sales, profit, inventory transactions. Due to the nature of the business, it was key to be able to view the different areas of the business by various periods as each product type had its own sales seasons. - Using my analysis the business was able to create promotions to reduce excessive inventory. - I could clearly identify when to increase inventory holdings of different product types for when seasons started. - Breaking down profit by department and product category allowed the client to remove low-profit areas and concentrate on products that brought in >80% of profits. - I continue to work with this client to provide valuable insights for his onging business needs.
Power BI Retail Sales & Inventory Dashboard
The project was to create a full suite of business dashboards for a retail client. I was able to breakdown live data for sales, profit, inventory transactions. Due to the nature of the business, it was key to be able to view the different areas of the business by various periods as each product type had its own sales seasons. - Using my analysis the business was able to create promotions to reduce excessive inventory. - I could clearly identify when to increase inventory holdings of different product types for when seasons started. - Breaking down profit by department and product category allowed the client to remove low-profit areas and concentrate on products that brought in >80% of profits. - I continue to work with this client to provide valuable insights for his onging business needs.
Power BI Retail Sales & Inventory Dashboard
The project was to create a full suite of business dashboards for a retail client. I was able to breakdown live data for sales, profit, inventory transactions. Due to the nature of the business, it was key to be able to view the different areas of the business by various periods as each product type had its own sales seasons. - Using my analysis the business was able to create promotions to reduce excessive inventory. - I could clearly identify when to increase inventory holdings of different product types for when seasons started. - Breaking down profit by department and product category allowed the client to remove low-profit areas and concentrate on products that brought in >80% of profits. - I continue to work with this client to provide valuable insights for his onging business needs.
Power BI Retail Sales & Inventory Dashboard
5202617
The goal of this analysis was to breakdown the client's promotions over sales in 2017 to show which promotions had the most impact on sales. I was able to highlight how many promotions were active for each week of sales, which made it easy to review the successful promotion vs underachievers. The client was able to restructure their promotional campaign for 2018 which showed an improvement in sales based on active promotions.
Tableau Promotions Dashboard
4315450
The client wanted a clear analysis of their sales broken down by the type of delivery and the country the customer was based. I was able to provide dynamic dashboards showing sales by country and delivery type also showing total sales by selected countries vs unselected countries. This work allowed the client to prioritize clients and renegotiate rates with shipping companies. This has led to an increase in profit and a streamlining of client prioritization
Power BI Dashboards: Sales
The client wanted a clear analysis of their sales broken down by the type of delivery and the country the customer was based. I was able to provide dynamic dashboards showing sales by country and delivery type also showing total sales by selected countries vs unselected countries. This work allowed the client to prioritize clients and renegotiate rates with shipping companies. This has led to an increase in profit and a streamlining of client prioritization
Power BI Dashboards: Sales
4315446
The client wanted to redesign and improve upon their current stock tracking reports. I was able to create a dynamic set of dashboards allowing users to compare historical performance of KPI, view various breakdown of KPI over time ( year on year, 5 year trend, 5 year standard deviation). I created a custom interface for the clients reporting calendar and KPIs. The project allowed clients to preview alot of complex data in an intuitive and clear manner. We were very happy with the results and sued this product as a template for other companies.
Power BI Dashboards: Stock Analysis
5408932
My client wanted to understand the demographics of their customers so that they could identify profitable products and produce targeting promotions. I was able to show the clients sales across each of their product categories by age, gender and location. We then worked together to understand how best to use this information to target key demographics by product category and state. We successfully improved the client's sales, which we continue to review on a regular basis.
Tableau Sales Demographics Dashboard
5408909
This project aimed to analyze and restructure my client's email marketing campaign. 1) I was able to breakdown the email recipient lists and show how many people were accessing the email as well as how many were following the link through to the promotions. We were able to use this information to find subscribers who were not accessing their email and verifying their details leading to an increase in email activity. 2) I presented the effectiveness of various types of marketing emails that had been sent out to each of the email recipient lists. By producing custom marketing campaigns targeted to each email list, we improved response rates to promotions. 3) We could see when emails were being accesses and wanted to know when was the best time for each type of email by email list. The new email schedule we created from this analysis positively impacted the total clicks for each type of email promotions.
Tableau Email Marketing Impact Dashboard
5274697
The project was to create a full suite of business dashboards for a retail client. I was able to breakdown live data for sales, profit, inventory transactions. Due to the nature of the business, it was key to be able to view the different areas of the business by various periods as each product type had its own sales seasons. - Using my analysis the business was able to create promotions to reduce excessive inventory. - I could clearly identify when to increase inventory holdings of different product types for when seasons started. - Breaking down profit by department and product category allowed the client to remove low-profit areas and concentrate on products that brought in >80% of profits. - I continue to work with this client to provide valuable insights for his onging business needs.
Power BI Retail Sales & Inventory Dashboard
The project was to create a full suite of business dashboards for a retail client. I was able to breakdown live data for sales, profit, inventory transactions. Due to the nature of the business, it was key to be able to view the different areas of the business by various periods as each product type had its own sales seasons. - Using my analysis the business was able to create promotions to reduce excessive inventory. - I could clearly identify when to increase inventory holdings of different product types for when seasons started. - Breaking down profit by department and product category allowed the client to remove low-profit areas and concentrate on products that brought in >80% of profits. - I continue to work with this client to provide valuable insights for his onging business needs.
Power BI Retail Sales & Inventory Dashboard
The project was to create a full suite of business dashboards for a retail client. I was able to breakdown live data for sales, profit, inventory transactions. Due to the nature of the business, it was key to be able to view the different areas of the business by various periods as each product type had its own sales seasons. - Using my analysis the business was able to create promotions to reduce excessive inventory. - I could clearly identify when to increase inventory holdings of different product types for when seasons started. - Breaking down profit by department and product category allowed the client to remove low-profit areas and concentrate on products that brought in >80% of profits. - I continue to work with this client to provide valuable insights for his onging business needs.
Power BI Retail Sales & Inventory Dashboard
The project was to create a full suite of business dashboards for a retail client. I was able to breakdown live data for sales, profit, inventory transactions. Due to the nature of the business, it was key to be able to view the different areas of the business by various periods as each product type had its own sales seasons. - Using my analysis the business was able to create promotions to reduce excessive inventory. - I could clearly identify when to increase inventory holdings of different product types for when seasons started. - Breaking down profit by department and product category allowed the client to remove low-profit areas and concentrate on products that brought in >80% of profits. - I continue to work with this client to provide valuable insights for his onging business needs.
Power BI Retail Sales & Inventory Dashboard
5202617
The goal of this analysis was to breakdown the client's promotions over sales in 2017 to show which promotions had the most impact on sales. I was able to highlight how many promotions were active for each week of sales, which made it easy to review the successful promotion vs underachievers. The client was able to restructure their promotional campaign for 2018 which showed an improvement in sales based on active promotions.
Tableau Promotions Dashboard
4315450
The client wanted a clear analysis of their sales broken down by the type of delivery and the country the customer was based. I was able to provide dynamic dashboards showing sales by country and delivery type also showing total sales by selected countries vs unselected countries. This work allowed the client to prioritize clients and renegotiate rates with shipping companies. This has led to an increase in profit and a streamlining of client prioritization
Power BI Dashboards: Sales
The client wanted a clear analysis of their sales broken down by the type of delivery and the country the customer was based. I was able to provide dynamic dashboards showing sales by country and delivery type also showing total sales by selected countries vs unselected countries. This work allowed the client to prioritize clients and renegotiate rates with shipping companies. This has led to an increase in profit and a streamlining of client prioritization
Power BI Dashboards: Sales
4315446
The client wanted to redesign and improve upon their current stock tracking reports. I was able to create a dynamic set of dashboards allowing users to compare historical performance of KPI, view various breakdown of KPI over time ( year on year, 5 year trend, 5 year standard deviation). I created a custom interface for the clients reporting calendar and KPIs. The project allowed clients to preview alot of complex data in an intuitive and clear manner. We were very happy with the results and sued this product as a template for other companies.
Power BI Dashboards: Stock Analysis

Reviews

Changes saved
Showing 1 - 5 out of 17 reviews
Filter reviews by:
5.0
$180.00 USD
Project for Depicting Data -- 6
Fantastic job !
Microsoft
Database Programming
Database Development
Tableau
+1 more
User Avatar
Flag of Rolly P.
@RGP63
•
4 years ago
3.0
£36.00 GBP
Setting up SQL reports
project not completed. too busy with other clients.
SQL
Database Administration
Database Programming
Database Development
Local Job
+1 more
B
Flag of Elizabeth K.
@bethking3
•
4 years ago
5.0
£250.00 GBP
Project for Depicting Data
Very skilled, very happy with the project, intend to use this developer for additional projects.
Microsoft
Database Programming
Database Development
Tableau
+1 more
E
Flag of Matt R.
@ENBS
•
4 years ago
5.0
$1,320.00 CAD
Project for Depicting Data -- 3
This was my first project with Andy and he absolutely delivered. His work is exceptional and I will definitely be working with him again in the future!
User Avatar
Flag of Rolly P.
@RGP63
•
4 years ago
5.0
$100.00 AUD
Project for Depicting Data -- 4
Looking forward to building bigger and better
Microsoft
Database Programming
Database Development
Tableau
+1 more
User Avatar
Flag of Micole B.
@micolecloud
•
4 years ago

Experience

BI Developer

M&C Saatchi
Jun 2017 - Present
• Leading workshops to create project requirements and refinement with stakeholders based worldwide • Design of ETL scripts to facilitate data quality control for various client’s data sources and KPI • Creation of ETL process across Python, Redshift, Lambda, S3, QlikSense, Power BI and custom API scheduler • Writing of complex stored procedures to calculate conditional and hierarchical KPI • Analysing trends of customer product usage to determine client specific KPI

BI Consultant

Beachub
Aug 2016 - Jan 2017 (5 months, 1 day)
• Design and built cube to support end user requirements • Create cube structure and data hierarchies using MDX (SSAS) • Designing Report Content in SSRS • Validating and disseminating reports in the correct format to strict deadlines • Managing Report User Acceptance testing and reporting cycles • Additional dashboard/report refinement and development

Lead BI Developer

National Institute of Health Research – Leeds University
Sep 2014 - Jul 2015 (10 months, 1 day)
•Developed BI solution within an Agile Scrum Environment using SQL Server (2008R2), SSIS, SSRS, QlikView and Power BI • Extensive profiling to determine data integrity • Developed complex packages and workflows to facilitate ETL • Staging database developed for data cleansing and data standardisation • SSIS package developed to deal with all data cleansing, isolating duplicates and invalid records, standardisation of data-types and formats

Education

Computer Science

Leeds Metropolitan University, United Kingdom 1997 - 2000
(3 years)

Qualifications

Securities & Investment Institute Securities Certificate

Siti
2006
Securities Paper: Financial Regulation/ Principles of Financial Regulation

Contact Depicting Data about your job

Log in to discuss any details over chat.

Verifications

Preferred Freelancer
Identity Verified
Payment Verified
Phone Verified
Email Verified
Facebook Connected

Certifications

preferredfreelancer-1.png Preferred Freelancer Program SLA 1 92%
SQL_1.png SQL 1 85%
us_eng_1.png US English 1 85%

Top Skills

Microsoft 12
Tableau 10
Data Processing 2
Excel 1
Microsoft SQL Server 1

Browse Similar Freelancers

Microsoft Developers in United Kingdom
Microsoft Developers
Tableau Experts
Data Processing Executives

Browse Similar Showcases

Microsoft
Tableau
Data Processing
Excel
Previous User Next User
Invite sent successfully!
Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Freelancer logo US (International) / English Help & Support Freelancer Categories Projects Contests Freelancers Enterprise Membership Preferred Freelancer Program Project Management Local Jobs Photo Anywhere Showcase API for Developers Get Verified Desktop App About About us How it Works Security Investor Sitemap Stories News Team Awards Press Releases Careers Terms Privacy Policy Terms and Conditions Copyright Policy Code of Conduct Fees and Charges Partners Escrow.com Loadshift Warrior Forum Apps Apple App Store logoGoogle Play logo
Copy to clipboard failed, please try again after adjusting your permissions.
Copied to clipboard.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.