Analysis of Australian Electricity Market Retail Providers
Budget: $250 – $750 AUD
Project Overview:
We are seeking a freelance analyst to conduct a comprehensive analysis of the Australian electricity market retail providers. The analysis will focus on gathering information related to various providers, their plans, tariffs, service areas, payment types, discounts, and fees. The purpose of this analysis is to assist consumers in making informed decisions regarding their electricity providers. The freelancer will be responsible for collecting and organising data from multiple sources and presenting the findings in a concise and user-friendly format, specifically in the form of an Excel spreadsheet with pivot tables, charts, and graphs to showcase data comparisons between providers.
Scope of Work:
The scope of this project includes the following tasks:
Research and Data Collection:
a. Identify and gather information on a diverse range of Australian electricity market retail providers.
b. Collect details about the providers' plans, including plan names, pricing structures, and contract terms.
c. Gather tariff information, including peak, off-peak, and general usage rates, for each provider's plans.
d. Obtain information on feed-in tariffs offered by providers for solar power customers.
e. Compile data on the service areas covered by each provider.
Payment Types:
a. Identify the various payment types accepted by each retail provider, such as direct debit, credit card, bank transfer, etc.
b. Note any specific payment options or incentives offered by providers, such as bill smoothing or online payment discounts.
Discounts and Fees:
a. Collect details on any discounts or promotional offers provided by each retail provider.
b. Identify and document any additional fees or charges associated with the plans offered by each provider.
Data Analysis and Visualization:
a. Organize the collected data in an Excel spreadsheet.
b. Utilize pivot tables to summarize and analyze the data effectively.
c. Create charts and graphs to visually represent data comparisons between providers, such as pricing structures, tariff rates, discounts, and fees.
Deliverables:
The freelance analyst will be expected to provide the following deliverables:
An Excel spreadsheet containing the collected data and analysis of Australian electricity market retail providers, including provider names, plan details, tariff peak, off-peak, and general usage rates, feed-in tariff information, service areas, payment types, discounts, and fees.
Clear and concise pivot tables summarizing the data and enabling easy comparison between providers.
Visual representations of the data through charts and graphs, highlighting key insights and comparisons.
Recommendations for consumers based on the analysis, emphasizing important factors to consider when choosing an electricity provider.
Timeline:
The expected timeline for completing this project is 2 weeks, starting from the date of the freelancer's selection.
Qualifications:
The ideal freelance analyst for this project should possess the following qualifications:
Strong research and analytical skills.
Familiarity with the Australian electricity market and retail providers.
Excellent attention to detail.
Proficient in data collection, organization, and analysis using Excel.
Ability to create clear and visually appealing charts, graphs, and pivot tables.
Good written communication skills.
Proposal Submission:
Interested freelancers are requested to submit a detailed proposal outlining their approach, methodology, timeline, and budget for this project. Please include relevant experience and any previous work samples that demonstrate your ability to perform similar analyses, specifically involving Excel-based data analysis and visualization.
We are seeking a freelance analyst to conduct a comprehensive analysis of the Australian electricity market retail providers. The analysis will focus on gathering information related to various providers, their plans, tariffs, service areas, payment types, discounts, and fees. The purpose of this analysis is to assist consumers in making informed decisions regarding their electricity providers. The freelancer will be responsible for collecting and organising data from multiple sources and presenting the findings in a concise and user-friendly format, specifically in the form of an Excel spreadsheet with pivot tables, charts, and graphs to showcase data comparisons between providers.
Scope of Work:
The scope of this project includes the following tasks:
Research and Data Collection:
a. Identify and gather information on a diverse range of Australian electricity market retail providers.
b. Collect details about the providers' plans, including plan names, pricing structures, and contract terms.
c. Gather tariff information, including peak, off-peak, and general usage rates, for each provider's plans.
d. Obtain information on feed-in tariffs offered by providers for solar power customers.
e. Compile data on the service areas covered by each provider.
Payment Types:
a. Identify the various payment types accepted by each retail provider, such as direct debit, credit card, bank transfer, etc.
b. Note any specific payment options or incentives offered by providers, such as bill smoothing or online payment discounts.
Discounts and Fees:
a. Collect details on any discounts or promotional offers provided by each retail provider.
b. Identify and document any additional fees or charges associated with the plans offered by each provider.
Data Analysis and Visualization:
a. Organize the collected data in an Excel spreadsheet.
b. Utilize pivot tables to summarize and analyze the data effectively.
c. Create charts and graphs to visually represent data comparisons between providers, such as pricing structures, tariff rates, discounts, and fees.
Deliverables:
The freelance analyst will be expected to provide the following deliverables:
An Excel spreadsheet containing the collected data and analysis of Australian electricity market retail providers, including provider names, plan details, tariff peak, off-peak, and general usage rates, feed-in tariff information, service areas, payment types, discounts, and fees.
Clear and concise pivot tables summarizing the data and enabling easy comparison between providers.
Visual representations of the data through charts and graphs, highlighting key insights and comparisons.
Recommendations for consumers based on the analysis, emphasizing important factors to consider when choosing an electricity provider.
Timeline:
The expected timeline for completing this project is 2 weeks, starting from the date of the freelancer's selection.
Qualifications:
The ideal freelance analyst for this project should possess the following qualifications:
Strong research and analytical skills.
Familiarity with the Australian electricity market and retail providers.
Excellent attention to detail.
Proficient in data collection, organization, and analysis using Excel.
Ability to create clear and visually appealing charts, graphs, and pivot tables.
Good written communication skills.
Proposal Submission:
Interested freelancers are requested to submit a detailed proposal outlining their approach, methodology, timeline, and budget for this project. Please include relevant experience and any previous work samples that demonstrate your ability to perform similar analyses, specifically involving Excel-based data analysis and visualization.