Tableau Dashboard
₹1500-12500 INR
Betales ved levering
Understanding Electricity Prices in Texas
The price of energy (i.e. electricity) in Texas is based on market demand rather than a fixed price determined by a regulatory body. This has implications for managing the cost of electricity consumption. An organization that has a better understanding of price fluctuations and factors that affect electricity prices in Texas can use this information to their advantage by managing consumption and the associated cost. So, a key challenge is to gain a better understanding of the price of electricity in Texas. Are there seasonal variations, does load and generation of electricity have an impact, what about the weather and how it may impact the price? We will take on the challenge of addressing these questions.
Available Data Files:
3 Files (2019 – 2021) that contain electricity pricing data
3 Files (2019 – 2021) that contain electricity generation data (generation is production of electricity)
1 File (2019 – 2021) that contains electricity load data (load is the demand for electricity)
1 File (2019 -2021) that contains weather data (temperature, humidity, and windspeed) for various cities in Texas.
1 File that contains the data descriptions of the variables in all the files
Important Note: Some of these files have duplicated and/or missing data. We’ll discuss these issues in class.
Objective:
To share insights on electricity prices in Texas between 2019 – 2021.
To examine the causes of price variation.
Outcomes:
Insights on electricity prices (descriptive analysis)
Dashboard for monitoring key data elements related to electricity pricing
Story line that narrates interesting insights from the data to inform an audience interested in learning about electricity prices in a deregulated market such as Texas
Ideas on how to extend the work (If you were asked to do further analysis what will be 2 suggestions that you will make? What additional data you think should be available to provide a more in-depth analysis?) Explain this in word document.
Hints for the project:
Initial Preparation:
Review the data files
Understand the data items and format
Data Modeling (performed in Tableau Prep)
Explore how to combine / connect the files
Explore data manipulation ideas (aggregation, pivot, etc.) needed to structure the data for analysis
Outline interesting questions that you think can be addressed by the data
This may be an iterative process because you may have to engage in additional data manipulation if the current data structure does not allow for answering the questions you outlined earlier.
You are allowed to choose a subset of data to use in this project. If you choose to use only a subset of the data, explain in the word document why.
You are allowed to recode the data such as change city to region, or vice versa.
There may possibly be duplicate data entry. In case
Descriptive Analysis
The main objective of descriptive analysis is to explore historical trends in the data. In this step, you may explore the followings, but can also explore other questions:
Explore if there is a seasonal pattern in electricity prices. Are there variations in the pattern across the regions?
How has power generation changed from 2019 to 2021 (or any subset of the data that you choose)?
What is the relationship between how power is generated and electricity prices?
What is the relationship between weather variables and electricity price? Does the relationship change across the regions?
What is the impact of changing the level of detail (one hour vs one day) on the results?
The above question are only suggestion. We will discuss more ideas in class. Your project must address three (3) business questions that can produce meaningful and actionable recommendations to the power company.
Deliverables
One TWBX file with at least 3 visual tools – each addressing different business questions, 1 dashboard, and 1 story
One TFLX file
Output file(s) from running the flow on Tableau Prep Builder (all in Excel formats after cleaning and data manipulation)
One MS Word Document that discusses the items listed in the Final Report Structure (See below). The document has to be at least 3 pages long, times new roman 12-sized font, and double space. All explanations must be completed in bullet format with exception of executive summary. The business questions have to be included in the document.
One Video (MP4) files (not more than 5 minutes) that shows how to use your project to reveal hidden knowledge from the data. You may use Zoom to record the video and do the discussion by using Story.
Another Video (MP4) files (not more than 5 minutes) that discuss how pre-attentive attributes are used in the project.
All files about must be put in 1 zipped folder. You must use group number as a part of the file names.
Final Report Structure (MS Word)
The written report length should be at least 3 pages. The report should include links to the dashboard and story line.
Title (Report Title)
Executive Summary (A concise summary (250 words) of the report with key insights)
Business questions.
Introduction (Outline the key challenge, trends in energy pricing, and variables impacting it)
Explain issues in Data Prep and a brief overview how the data was transformed for analysis
Explain why you choose a certain subset of data (if any)
Descriptive Analysis (Key insights from the descriptive analysis of the data)
Story/ Story line that narrates interesting insights from the data to inform an audience interested in learning about electricity prices in a deregulated market such as Texas
Ideas on how to extend the work (If you were asked to do further analysis what will be 2 suggestions that you will make)
List issues with data cleaning such as missing data, anomalies, recoding, etc.
Grading Criteria
The alignment between your project goals and use of Visual Tools, Dashboard, and Story.
How filtering, animation, set, groups, hierarchies and other tools are used unveil hidden knowledge in your data.
Variety of Visual Tools used in the project.
The interactiveness between visual tools on dashboard (s).
The use of pre-attentive attributes. This is very important because it accounts for 20% of your grade.
Extra Credits (To be announced)
A use of map with proper region coding will earn 30 extra points.
Check the following resources to work on Map Visual Tool
[login to view URL]
[login to view URL]
[login to view URL]
The 4th and 5th visual tool that you add to the project will earn up to 10 extra points each. The extra points will depends on the their relevance to the questions that you are trying to explore.
Early submission by Dec 1st with the basic requirements completed correctly will earn 15 extra points.
Prosjekt-ID: #37433486
Om prosjektet
27 frilansere byr i gjennomsnitt ₹7505 for denne jobben
Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are look Mer
I am a highly experienced industrial project manager with 12+ years of experience in planning, scheduling, and reporting. I have a proven track record of delivering complex projects on time and within budget.
Hi, I have 5 years of hands-on experience in Tableau,Power BI, 3 years in Alteryx Please share the dataset and problem statement so that I can create your dashboard Thanks, Sanjana
Hello sir, I am experienced with Web Search, Data Mining, Data Entry, PDF and Data Processing. I can collect all the required details from the website. I m also flexible with the budget. Eagerly waiting for your respon Mer
Strategic Management, Training, Public Speaking, Audiovisual Tools, Technical Computing, Intermediate Programming, Marketing, Social Networking, Quality of Service, Languages (English-Spanish), Sports Promoter (Footbal Mer
Results-driven and detail-oriented data analyst with a proven track record of extracting actionable insights from complex datasets to inform strategic decision-making. Possesses strong analytical skills and proficiency Mer
Hi There, Are you Looking Data Entry Operator that is the right place? I'm here to help you with any type of data entry copy paste job I am an established data entry expert who provides Excel Data Entry, PDF to E Mer
Hello, I have read the project description very carefully and I am interested to do this project and provide it to you within the specified time with accuracy. I am available 24x7.
Hello! My name is niranjan, and I am a professional expert in virtual assistant, data entry, data processing, web search, Google Sheets, and MS Excel. I have 10+ years of experience in these services. I understand tha Mer
Hey there! I wanted to inform you that as a dedicated data entry operator, I consistently ensure the timely completion of all assigned tasks. Meeting deadlines is a priority for me, and I take pride in delivering accur Mer
I have around 10 tears of experience and also certified. I have number persons i know. However good knowledgeable persons
Hi there , I hope you doing great I have keenly read your Job description which is very detailed to develop the understanding of the project and i found it relevant for my profile As far As i can understand you are s Mer
Being a tableau specialist, I can able to relate your objectives and preferable insights. Data preparation, data mining and processing the data are my key skills. In addition to that, I'm a strategic research analyst Mer
tengo habilidades para trabajar en hoja de cálculo de excel, en razon a que durante mi vida laboral he trabajado con este programa, al igual que hacer analisis de los resultados de la informacion
I pay meticulous attention to detail in all aspects of my work From understanding project specifications to delivering error free work I strive for perfection in every work
