Power BI Report Preparation on Tesla Stock Market Dataset 2010-2024
Research Questions and Analysis Steps Using Tesla Stock Market Dataset (2010-2024) Open Dataset
Your dataset contains Date, Open, High, Low, Close, Adjusted Close, and Volume. Below are possible research questions along with Power BI steps for analysis
1. How has Tesla’s stock price changed over time?
✅ Objective: Identify long-term trends in Tesla’s stock price.
Steps in Power BI (Using Power Query):
1️⃣ Load the Tesla stock dataset into Power BI.
2️⃣ Go to Power Query Editor → Convert Date column to Date format.
3️⃣ Click on Close & Apply.
4️⃣ Create a Line Chart:
- X-Axis: Date
- Y-Axis: Close Price
5️⃣ Analyze the trend over time.
2. What is the highest and lowest stock price recorded?
✅ Objective: Identify Tesla’s highest and lowest prices over time.
Steps in Power Query:
1️⃣ Load data into Power Query.
2️⃣ Click on the High column → Select Transform → Click Statistics → Choose Maximum.
3️⃣ Click on the Low column → Select Transform → Click Statistics → Choose Minimum.
4️⃣ Close & Apply and display these values using Card Visuals.
3. What is the correlation between trading volume and stock price?
✅ Objective: Determine if high trading volume influences stock price movement.
Steps in Power BI (Using Power Query):
1️⃣ Load data into Power Query.
2️⃣ Select Volume and Close Price columns.
3️⃣ Click on Transform → Choose Correlation (if using Excel, use correlation function).
4️⃣ Create a Scatter Plot:
- X-Axis: Volume
- Y-Axis: Close Price
5️⃣ Analyze the relationship between Volume and Close Price.
4. Which year had the highest stock return for Tesla?
✅ Objective: Find Tesla’s best-performing years.
Steps in Power Query:
1️⃣ Extract Year from Date column:
- Click on Date Column → Transform → Extract → Year.
2️⃣ Group by Year and aggregate the first and last Close Price.
3️⃣ Calculate Yearly Return: - Add a new column:
(Last Close Price - First Close Price) / First Close Price * 100.
4️⃣ Create a Bar Chart with: - X-Axis: Year
- Y-Axis: Yearly Return.
5️⃣ Identify Tesla’s best and worst years.
5. How does Tesla’s stock perform across different months?
✅ Objective: Find seasonal trends in Tesla’s stock price.
Steps in Power Query:
1️⃣ Extract Month from the Date column:
- Click on Date Column → Transform → Extract → Month Name.
2️⃣ Group by Month and calculate Average Close Price.
3️⃣ Create a Column Chart: - X-Axis: Month
- Y-Axis: Average Close Price.
4️⃣ Analyze if certain months are better for Tesla’s stock.
6. What are the biggest daily price changes?
✅ Objective: Identify days with the largest price swings.
Steps in Power Query:
1️⃣ Create a new column:
- Click Add Column → Custom Column →
(High - Low).
2️⃣ Rename it as Daily Change.
3️⃣ Sort the dataset in descending order based on Daily Change.
4️⃣ Create a Bar Chart with: - X-Axis: Date
- Y-Axis: Daily Change.
5️⃣ Identify Tesla’s most volatile days.
7. How often does Tesla’s stock close higher than it opens?
✅ Objective: Find Tesla’s win percentage (days where it closed higher than opened).
Steps in Power Query:
1️⃣ Create a new column:
- Click Add Column → Custom Column →
if [Close] > [Open] then "Gain" else "Loss"
2️⃣ Count the number of Gain and Loss days.
3️⃣ Create a Pie Chart with:
- Categories: Gain, Loss
- Values: Count.
4️⃣ Analyze Tesla’s winning days.
8. How does Tesla’s stock perform on weekdays vs. weekends?
✅ Objective: Compare weekday and weekend stock performance.
Steps in Power Query:
1️⃣ Extract Day of the Week from Date column:
- Click on Date Column → Transform → Extract → Day of Week.
2️⃣ Group by Day of the Week and calculate Average Close Price.
3️⃣ Create a Bar Chart: - X-Axis: Day of Week
- Y-Axis: Average Close Price.
4️⃣ Identify which days Tesla’s stock performs best.
9. What is the volatility of Tesla's stock?
✅ Objective: Measure Tesla’s daily stock price volatility.
Steps in Power Query:
1️⃣ Create a new column:
- Click Add Column → Custom Column →
(Close - Open) / Open * 100
2️⃣ Rename it as Daily Volatility.
3️⃣ Create a Line Chart with:
- X-Axis: Date
- Y-Axis: Daily Volatility.
4️⃣ Identify periods of high and low volatility.
10. What is the moving average trend of Tesla’s stock?
✅ Objective: Smooth out short-term fluctuations to identify trends.
Steps in Power Query:
1️⃣ Duplicate the dataset and sort by Date.
2️⃣ Create a New Column for 7-day moving average:
- Click Add Column → Custom Column →
List.Average(List.FirstN([Close], 7))
3️⃣ Rename it as Moving Average Close.
4️⃣ Create a Line Chart:
- X-Axis: Date
- Y-Axis: Moving Average Close.
5️⃣ Analyze the trend.
0 टिप्पण्या
कृपया तुमच्या प्रियजनांना लेख शेअर करा आणि तुमचा अभिप्राय जरूर नोंदवा. 🙏 🙏