Learn Data Skills
Beta
Fadhilah Rahenda

Fadhilah Rahenda

Data Analyst

University of Liverpool

Technologies

My Portfolio Highlights

My New Workbook

Introduction to SQL

My New Course

Introduction to SQL

Analytical wordsmith, crafting compelling narratives through data storytelling.

My Work

Take a look at my latest work.

DataLab

Introduction to SQL

course

Introduction to SQL

course

Intermediate SQL

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

My Work Experience

Where I've interned and worked during my career.

Marks and Spencer | Jan 2024 - Present

Finance Analyst

N/A

Luxfer MEL Technologies | Oct 2022 - Dec 2023

Data Analyst

• Analysing and providing a weekly sale, booking and backlog report to the Vice President, Sales Manager and Operation Manager. By identifying trends and generating actionable insights will lead to creating a weekly plan and reviewing the weekly performance for the sales and production team. • Collaborating with cross-functionals teams to define key performance indicators (KPIs) to pioneer a brand-new interactive dashboard using Power BI from the historical year to YTD data from the database to produce the data visualisation for the team from different departments. • Extract, transform and load the sales data using power query Developing and deploying the Star Schema, snowflake schema and dimensional data modelling technique using Power BI. • Monthly communication with the global sales team around pipeline, creation, and management, enabling me to improve and optimise the sales dashboard in Salesforce. • Experiencing in cleaning, transforming raw data, handling missing value and ensuring data quality for the net promoter score, customer retention, weighted opportunities, win/loss analysis, monthly sales report, total sales numbers. Collaborating with the finance team to get the business and territory contribution margins numbers. All this information is produced for the growth scorecard to the senior leadership team. • Creating budget splitting for each salesperson for the UK and USA branch, across different products and countries using statistical concept. Moreover, managing, and overviewing SKU (Stock Keeping Unit) forecast monthly for sales and production team using Macro in Excel. • Presenting data-driven insights and recommendations to senior management and stakeholders, enabling informed business decision for International Board Meeting (IBM) monthly.
Show More

Network Rail | Mar 2021 - Dec 2021

Customer Service Assistant

•Collaborated within a team of individuals to deliver high quality customer assistance whilst communicating as a team around important ever changing transportation updates, guiding customers to the most efficient way to travel. •Assisted customers with the train schedules, giving valuable updates on transport and sourcing the most effective route for customers to travel to their desired destinations. •Liaised with customers with additional needs such as wheelchair access, ensuring the relevant departments can ensure a successful customer journey for all. •Sourced the best solutions for clients to problematic issues regarding train cancellations. •Effective communication between team members and supervisor, ensuring a true collaborative effort, to ensure customers are well informed, safe, and delightful with the solutions presented to them, with accurate information on train cancellations or schedules.

PT. Netmarks Indonesia | Jul 2019 - Nov 2020

B2B Digital Marketing and Sales Support

marketing, leading to a more flexible marketing option for the business for which products would benefit from having organic or non-organic marketing. •Analysed engagement on Facebook, LinkedIn and Instagram for our security software products, utilising Google Ads analytics to build reports on key focus areas, helping to maximise the marketing of products in the highest engagement areas for the business, driving more leads and sales within the wider business. •Designed the posters, flyers, and content for advertisements and promotions, utilising creative problem solving to fulfil the brief to my best ability, presenting my work to the higher management and liaising with the board, my final work to ensure maximum customer engagement. •Writing useful and informative content such as blogs, newsletters, social media updates and leaflets alongside the full CMS management system, driving engagement from prospects and aiding the sales division in delivering detailed pitches, ensuring higher volumes of sales. •SEO development including keyword research, site optimisation, and outreach campaigns. Moreover, managed online marketing campaigns to drive relevant traffic to clients. •Developed and cultivated relationships with existing partners, vendors, and clients. •Assisted sales and marketing team by creating reports and dashboards to meet the KPIs targets in Power BI.

My Education

Take a look at my formal education

Master of Science - MS, Business Analytics and Big Data  · (NovemberUniversity of Liverpool | 2022
Bachelor's degree, Business Intelligence and Information System  · (JulyJames Cook University | 2019
Social SciencesLabschool Kebayoran | 2016

About Me

Fadhilah Rahenda

A unique people orientated and high skilled Data Analyst with 3 years experience and 4 years in Digital Marketing. Expert in data mining to extract valuable and actionable insights, resulting in improved business performance and growth.

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free