Project PowerBI & Datasets
Download and Install IHHPET Learning Application
Contact for IHHPET App Support
+91-7880-113-112
Virat Kohli ODI T20 Performance Index Dashboard
Download Dataset: [Link]
testodit20-stat
Dashboard Output:
Problem 1: Analysis of Virat's top 5 ground performance in the year 2021?
Problem 2: Analyze Virat batting performance data and show great performance monthly and
quarterly in the year 2018?
Problem 3: In which opposition team did Virat have the most top 5 batting performances in
the year 2021?
Problem 4 : How many cricket matches did Virat play for India in the year 2017, 2018, 2019
& 2020 ?
Install our IHHPET Android App: [Link]
Contact : +91-7880-113-112 | Visit Website: [Link]
Problem Statement 1: Analysis of Virat's top 5 ground performance
in the year 2021?
Problem Output 1: Runs By Top 5 Grounds
Install our IHHPET Android App: [Link]
Contact : +91-7880-113-112 | Visit Website: [Link]
Problem Statement2: Analyze Virat batting performance data and show
great performance monthly and quarterly in the year 2018?
Problem Output 2: 2018 performance by Monthly & Quarterly
Install our IHHPET Android App: [Link]
Contact : +91-7880-113-112 | Visit Website: [Link]
Problem Statement 3: In which opposition team did Virat have the
most top 5 batting performances in the year 2021?
Problem Output 3: Maximum Runs Vs Opponent Team in Year 2021
Install our IHHPET Android App: [Link]
Contact : +91-7880-113-112 | Visit Website: [Link]
Problem Statement 4 : How many cricket matches did Virat play for
India in the year 2017, 2018, 2019 & 2020 ?
Problem Output 4: Total number or Match in the year
2017 : Opponent’s Match’s 52
2018 : Opponent’s Match’s 47
2019 : Opponent’s Match’s 46
2020 : Opponent’s Match’s 24
Power BI Dashboard Preview:
Install our IHHPET Android App: [Link]
Contact : +91-7880-113-112 | Visit Website: [Link]
Netflix Dashboard
Netflix Power BI Video:
Power BI Dashboard (Watch Now Part 1 Video):
[Link]
Install our IHHPET Android App: [Link]
Contact : +91-7880-113-112 | Visit Website: [Link]
Netflix Python Code:
In [2]:
df= [Link](pd.read_csv("../input/netflix-stock-price-prediction/[Link]"))
[Link]()
Out[2]:
Date Open High Low Close Adj Close Volume
0 2018-02-05 262.000000 267.899994 250.029999 254.259995 254.259995 11896100
1 2018-02-06 247.699997 266.700012 245.000000 265.720001 265.720001 12595800
2 2018-02-07 266.579987 272.450012 264.329987 264.559998 264.559998 8981500
3 2018-02-08 267.079987 267.619995 250.000000 250.100006 250.100006 9306700
4 2018-02-09 253.850006 255.800003 236.110001 249.470001 249.470001 16906900
Setting Date to Index
In [3]:
df.set_index('Date', inplace=True)
[Link]()
Out[3]:
Open High Low Close Adj Close Volume
Date
2018-02-05 262.000000 267.899994 250.029999 254.259995 254.259995 11896100
2018-02-06 247.699997 266.700012 245.000000 265.720001 265.720001 12595800
2018-02-07 266.579987 272.450012 264.329987 264.559998 264.559998 8981500
Install our IHHPET Android App: [Link]
Contact : +91-7880-113-112 | Visit Website: [Link]
Open High Low Close Adj Close Volume
Date
2018-02-08 267.079987 267.619995 250.000000 250.100006 250.100006 9306700
2018-02-09 253.850006 255.800003 236.110001 249.470001 249.470001 16906900
In [4]:
df[['Open', 'Close', 'High','Low','Close','Adj Close']].plot(figsize=(18,5))
[Link](" Netflix Stock Plot for Overall Period", fontsize=17)
Out[4]:
Text(0.5, 1.0, ' Netflix Stock Plot for Overall Period')
Top-5 Dates with Highest Stock Price
In [5]:
a = df.sort_values(by='High',ascending= False).head(5)
a['High']
Out[5]:
Date
2021-11-17 700.989990
2021-11-19 694.159973
2021-11-18 691.739990
Install our IHHPET Android App: [Link]
Contact : +91-7880-113-112 | Visit Website: [Link]
2021-10-29 690.969971
2021-11-01 689.969971
Name: High, dtype: float64
Top-5 Dates with Lowest Stock Price
In [6]:
b = df.sort_values(by='Low',ascending= True).head(5)
b['Low']
Out[6]:
Date
2018-12-26 231.229996
2018-12-24 233.679993
2018-02-09 236.110001
2018-12-27 240.100006
2018-12-21 241.289993
Name: Low, dtype: float64
In [7]:
fig,axes= [Link](nrows=1,ncols=2, sharex=True, figsize=(12,5))
[Link]('High & Low Values Stock per Period of Time',fontsize=18)
[Link](ax= axes[0], y=df['High'],x=[Link], color='green')
axes[0].set_title('High Value Stock')
[Link](ax= axes[1], y=df['Close'], x=[Link], color='red')
axes[1].set_title('Low Value Stock')
plt.tight_layout()
[Link]()
Install our IHHPET Android App: [Link]
Contact : +91-7880-113-112 | Visit Website: [Link]
Power BI Dashboard Preview:
Install our IHHPET Android App: [Link]
Contact : +91-7880-113-112 | Visit Website: [Link]
Install our IHHPET Android App: [Link]
Contact : +91-7880-113-112 | Visit Website: [Link]
Scan and download
the App Now
Install our IHHPET Android App: [Link]
Contact : +91-7880-113-112 | Visit Website: [Link]