#powerbi #dataanalytics #powerbitutorial
Power BI Project End to End | IPL Analysis | Dashboard | Beginners | Power BI Tutorial 2023
Part 2 - https://youtu.be/CwsMbz_CF4o
Book a 1:1 Call with me (Career Guidance, Mock Interviews, Resume Review, etc.) - https://topmate.io/data_tutorials
For Important Data Analyst Materials and Other Resources - https://topmate.io/data_tutorials
Follow me on Facebook - https://www.facebook.com/profile.php?id=100095047697882&mibextid=ZbWKwL
Follow me on LinkedIn - https://www.linkedin.com/in/swapnjeet-s-58a673273L
Download data and Files: https://drive.google.com/drive/folders/1LRxSuftDb7jqa-H-nFCsJvYoddpxSfn4?usp=sharing
How to install MS SQL server - https://youtu.be/P6y0R3XzWlc
How to install PostgreSQL DB - https://youtu.be/0n41UTkOBb0
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.
For More info watch this Data Analyst Roadmap 2.0 video - https://youtu.be/_0i_VMeL-Zo
Details mentioned below-
email- [email protected]
WhatsApp - +91 9579005495
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-
Road Accident Dashboard - https://youtu.be/jhv_HPjtTyU
Sales Overview Dashboard - https://youtu.be/NoppQVdd8U8
HR Dashboard - https://youtu.be/oAIubTqg-Kw
Ecommerce Sales Dashboard - https://youtu.be/pCpvlIr1yvs
IPL Dashboard - https://youtu.be/LX1LokapH4Q
Customer Complaint Dashboard - https://youtu.be/_EcRJQa3ZDM
Power BI Dashboard
Road Accident Dashboard - https://youtu.be/Hn9f13uoLAQ
HR Dashboard - https://www.youtube.com/watch?v=-sOHVl_iCHA&t=0s
Excel Dashboard
Road Accident - https://youtu.be/XeWfLNe3moM
HR Dashboard - https://youtu.be/4WUzvr9jxGc
IPL Dashboard - https://youtu.be/urhI3pEBEBY
Ecommerce Sales Analysis - https://youtu.be/xHTUP1Dxu-M
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.
Reach out to me for any personal or Business related Dashboard/ Report development on my email- [email protected]
WhatsApp - +91 9579005495
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.