Power BI Project End to End | IPL Analysis (Part 1) | Dashboard | Beginners | Power BI Tutorial 2023

#powerbi #dataanalytics #powerbitutorial
Power BI Project End to End | IPL Analysis | Dashboard | Beginners | Power BI Tutorial 2023

⭐For Tableau, Power BI and Excel Projects contact me on my mail id or WhatsApp number mentioned at the end of description box.

⭐Data Analyst Material available at very minimal cost of Rs. 999. This will include a complete Data Analyst Syllabus with video links, important pdf's, Q&A, this will also include Complete project on Excel (2 Projects), Tableau (2 Projects) and Power BI (1 Project). And the projects will be different from that uploaded on You Tube. If you are interested to buy contact me on my mail or WhatsApp.
Details mentioned below-
WhatsApp - [phone]

➖➖➖➖➖➖➖➖➖➖➖➖➖
In this video you will learn how to connect Power BI to MS SQL Server DB and PostgreSQL DB

This video is specially made for beginners, intermediates, freshers, college students and recent pass outs. It will help in learning new skill.

#powerbitutorial #powerbitutorialforbeginners #dataanalytics #project #powerbi

➖➖➖➖➖➖➖➖➖➖➖➖➖
⭐Content
00:00 Intro to Dashboard
07:44 Steps in Project
10:05 Requirement Gathering
11:44 Stakeholders
12:43 Power BI functionalities you will learn
14:48 Import Raw data in PostgreSQL DB
28:07 Connect Power BI to PostgreSQL DB
32:57 Import Raw data in MS SQL Server
41:40 Connect Power BI to MS SQL server DB
45:21 Connect to Flat Files
47:36 Walkthrough data
54:05 Data Cleaning
58:41 Data Processing
01:02:02 Data Modelling
01:07:27 KPI Design

➖➖➖➖➖➖➖➖➖➖➖➖➖
⭐Power BI Topics Covered
- What is Power BI
- How to connect Power BI to MS SQL Server and PostgreSQL DB
- Import data in Power BI
- Data Cleaning in Power BI
- Data Modelling in Power BI
- Power Query Editor
- DAX in Power BI
- Measures and Calculations in Power BI
- Charts in Power BI
- Filters and Slicers in Power BI
- Dashboard in Power BI
- Insights from Dashboard

➖➖➖➖➖➖➖➖➖➖➖➖➖
Checkout my other videos on dashboards design in Tableau, Power BI and Excel below-

⭐Tableau Dashboard-

⭐Power BI Dashboard

⭐Excel Dashboard

➖➖➖➖➖➖➖➖➖➖➖➖➖
⭐Tableau Material available-
1. Tableau hand written notes
2. Tableau printed Soft copy notes
2. Tableau important formulae notes
3. Tableau important interview questionnaire
All these are available at very minimal cost of Rs.200 only, ping me on WhatsApp to get these.

➖➖➖➖➖➖➖➖➖➖➖➖➖
WhatsApp - [phone]

➖➖➖➖➖➖➖➖➖➖➖➖➖
Related Keywords -
power bi tutorial ,power bi desktop tutorial ,power bi tutorial for beginners ,power bi desktop ,power bi dashboard ,power bi training ,power bi demo ,power bi for beginners ,power bi dashboard tutorial ,power bi tutorial for beginners excel ,power bi ,tutorial ,desktop ,dashboard ,excel ,microsoft excel ,power bi vs tableau ,tableau vs power bi ,mspowerbi ,Power BI Pro ,PowerBIPro , swapnjeet, Microsoft PowerBI, Microsoft Power BI, PowerBI, Power BI, PowerBI Tutorial, Power BI Tutorial, PowerBI Dashboard, PowerBI Data Visualization, Power BI Data Analytics, Power BI Analysis, PowerBI Report and Dashboard Design, Power BI End to End Tutorial, PowerBI End to End Project, PowerBI Data Modeling, What is PowerBI

Disclaimer: All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for.
Data used in the video is a demo data, modified data and does not belong to any real time industry/ company/ government etc. Data used is only for practice purpose.

[Burhanuddinawan]

Your videos are very much helpful . In it you are covering not just basic but some advance level tips and tricks .

[aniruddhadas]

Awesome project, just love it. Thanks! However @ 1:38:33 you have just taken sum of iswicket_delivery but while selecting the bowler you have filter with iswicket_delivery & dismisal_kind. iswicket_delivery includes runout for YS Chahal. So, I believe DAX filter should have dismisal_kind also.

[shahirajlakade]

Sir how to become expert in powerBI as i am not gaining confidence i had made 4-5 project on powerBI still no confidence

[feliciaonwudinjo]

You are amazing especially your video on road accident analysis, things i learnt was exaxtly what i was researching on. I am watching only your videos on powerBi. straight to the point and precise. I totally love your channel

[sundayamoo]

keep up the good work, great resources so far. and please keep maintaining the english usage, there are some videos of yours that i dont understabd due to language barrier. thank 💯❤👍

[yudhistarPandava]

Hello,

1:37:46
Let's say there are two bowlers with same number of wickets in a season, then how to display only one bowler record in KPI?
I think there is some exception in top when there are duplicates.

Thanks.

[akash.i]

Sir. is it possible to create a measure.. If I click all seasons...it should show which team has won more ipl trophies and count of the cups it won based on seasons..

[Travel_brat]

i am solving this with ipl 2008-2024 data. when I calculate orange cap holder, it shows batter name of latest season when slicer is at all settings. for eg: when slicer is at all, it will show virat kohli as per latest season, but when I calculate total runs, the card visual shows total scores/runs of all seasons for virat kohli. but I want it to show total runs of latest season only when slicer is at all selection. just like you have shown here.
how to achieve

[aditjain]

Thank you for making such a interesting dashboard for us. I enjoyed making this dashboard.

keep updating this kind of interesting dashboard and projects for us.

[SAHILKHAN-wurb]

your video is nice you teach one by one and from the very basic😇, bro your linkedin link is now working I want to connect with you .

[JyotiMishra-xm]

Hello yur vedio is really very helpful
Plz tell me that how to fix the background image of the dashboard my dashboard is very flexible it's moving with the kpi editing

[vishalbaldodia]

very informative video
Thank you so much

[rajpadwekar]

Hi! Keep up the good work, really helpful. Could you please specify link to the data source for the datasets used as I am unable to find them on Kaggle?

[pradoshpadhy]

Hi..I am using a slicer for Team..means I need the batter and bowler performances on basis of team...As there is Team 1 and Team 2 in the Match table, how can I make that as a one in my slicer filter?

[neerajmudgal]

Hi, your videos very useful, but i have one question in clean the data part in match data there is some rows have NA entry in this entry some need to replace with Dubai and some need to replace with Sharjah but when I have using replace function all change in Dubai or Sharjah,
Please help me in this.

[manasvi]

i was struggling trying to understand why can't a simple calculate function (check year and match_no = "Final" and return the match winner) be used instead of finding max date of a particular season to find out the title winner. is there a reason you chose the second option?

[Burhanuddinawan]

Can you please make a videos on DAX from Begineer to advance level .
Please

[sivaranjjanmani]

May i know where you get the data from? Is their any source to get live data into power BI!

[nikhilmahapatra]

Good Morning Sir

I am facing problem when i am selecting Select Season my all option coming blank why like orang cap, purple cap and all blowing option also coming blank why so please suggest me.

[ankurgautam]

sir in my visuals the most runs and most wickets and other some of the numbers are just doublein comparison to your visuals i am not able to understand the problem, please rply me sir