Logo freelancerCách Hoạt ĐộngTìm công việc Đăng Nhập Đăng Ký Đăng dự án
KHÁM PHÁ
Data Processing Excel Microsoft Microsoft SQL Server Tableau
Profile cover photoundefined
Bạn đang theo dõi .
Lỗi khi theo dõi người dùng.
Người dùng này không cho phép người dùng khác theo dõi họ.
Bạn đã theo dõi người dùng này rồi.
Gói thành viên của bạn chị cho phép 0 lượt theo dõi. Hãy nâng cấp lên ở đây.
Đã bỏ theo dõi người dùng thành công.
Lỗi khi bỏ theo dõi người dùng.
Bạn đã đề xuất thành công
Lỗi khi đề xuất người dùng.
Đã xảy ra lỗi. Hãy làm mới trang và thử lại.
Đã xác thực email thành công.
Avatar người dùng
$25 USD / giờ
Cờ của UNITED KINGDOM
$25 USD / giờ
Hiện ở đây là 2:29 CH
Đã tham gia vào ngày tháng 3 9, 2016
0 Khuyến nghị

Depicting Data

@WardWarrior

5,0 (17 nhận xét)
5,2
5,2
$25 USD / giờ
Cờ của UNITED KINGDOM
$25 USD / giờ
95%
Công Việc Hoàn Thành
98%
Đúng Ngân Sách
97%
Đúng Thời Hạn
10%
Tỉ Lệ Thuê Lại

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

Liên hệ Depicting Data về công việc của bạn

Đăng nhập để trao đổi thông tin chi tiết thông qua chat.

Mục portfolio

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
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
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
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
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
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

Nhận xét

Đã lưu thay đổi
Hiện 1 - 5 trong số 17 nhận xét
Lọc nhận xét theo: 5,0
$180,00 USD
Fantastic job !
Microsoft Database Programming Database Development Tableau
Thêm 1
Avatar người dùng
Cờ của Rolly P. @RGP63
2 năm trước
3,0
£36,00 GBP
project not completed. too busy with other clients.
SQL Database Administration Database Programming Database Development Local Job
Thêm 1
B
Cờ của Elizabeth K. @bethking3
2 năm trước
5,0
£250,00 GBP
Very skilled, very happy with the project, intend to use this developer for additional projects.
Microsoft Database Programming Database Development Tableau
Thêm 1
E
Cờ của Matt R. @ENBS
3 năm trước
5,0
$1.320,00 CAD
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!
Avatar người dùng
Cờ của Rolly P. @RGP63
3 năm trước
5,0
$100,00 AUD
Looking forward to building bigger and better
Microsoft Database Programming Database Development Tableau
Thêm 1
Avatar người dùng
Cờ của Micole B. @micolecloud
3 năm trước

Kinh nghiệm

BI Developer

M&C Saatchi
thg 6 2017 - Hiện tại
• 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
thg 8 2016 - thg 1 2017 (5 tháng, 1 ngày)
• 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
thg 9 2014 - thg 7 2015 (10 tháng, 1 ngày)
•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

Học vấn

Computer Science

Leeds Metropolitan University, United Kingdom 1997 - 2000
(3 năm)

Bằng cấp

Securities & Investment Institute Securities Certificate

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

Liên hệ Depicting Data về công việc của bạn

Đăng nhập để trao đổi thông tin chi tiết thông qua chat.

Xác thực

Freelancer Ưa Thích
Đã Xác Thực Danh Tính
Đã Xác Thực Thanh Toán
Đã Xác Thực Điện Thoại
Đã Xác Thực Email
Đã Kết Nối Facebook

Chứng chỉ

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

Các kỹ năng hàng đầu

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

Xem Các Freelancer Tương Tự

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

Xem Các Trường Hợp Tương Tự

Microsoft
Tableau
Data Processing
Excel
Người dùng trước
Người dùng kế tiếp
Đã gửi lời mời thành công!
Người Dùng Đã Đăng Ký Tổng Số Việc Đã Đăng
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2022 Freelancer Technology Pty Limited (ACN 142 189 759)
Đang tải xem trước
Đã cấp quyền truy cập vị trí.
Phiên đăng nhập của bạn đã hết hạn và bạn đã bị đăng xuất. Hãy đăng nhập lại.