Power BI Project End to End | Data Analyst Project Portfolio (Part 1) | Dashboard | For Beginners
#powerbi #dataanalytics #powerbitutorial
Power BI Project End to End | Data Analyst Project Portfolio | Dashboard | For Beginners
Part 2 – https://youtu.be/Yj7RUNWr7sk
⭐Download data and Files: https://drive.google.com/drive/folders/1vnI_RR3iDTLb6dH_tluCSsPqWcXPRHKR?usp=sharing
⭐For Tableau, Power BI and Excel Projects contact me on my mail id or WhatsApp number mentioned at the end of description box.
📱 Follow me on LinkedIn – https://www.linkedin.com/in/swapnjeet-s-58a673273
➖➖➖➖➖➖➖➖➖➖➖➖➖
In this video you will learn how to connect Power BI to MS SQL Server DB
In this Power BI video you will learn requirement gathering, data cleaning, processing, analysis and dashboard creation in Excel. Complete data analytics project for data analyst in Excel.
This video is specially made for beginners, intermediates, freshers, college students and recent pass outs. It will help in learning new skill. This video will help in getting a good hold on tools like Excel. By practicing this tool and developing similar dashboards one can even start with freelancing on international platforms.
Developing similar end to end deploy ready projects will help freshers/ beginners understanding the work flow of a project.
#powerbitutorial #powerbitutorialforbeginners #dataanalytics #project #powerbi
➖➖➖➖➖➖➖➖➖➖➖➖➖
Do you want to become a Data Analyst or learn data analytics ? This channel is all about learning data science skills, tips and projects. My goal is to help you learn everything you need to start or switch your career into data science. I teach different Data Analyst tools like Tableau Desktop, Power BI, Excel, Advanced Excel, SQL, Postgres, python, etc.
➖➖➖➖➖➖➖➖➖➖➖➖➖
⭐Content of Video
00:00 Introduction to Project
08:49 Steps in Project
09:44 Problem Statement
12:07 What you will Learn?
14:34 Data Walkthrough
20:30 Import Data in MS SQL Server DB
31:25 Connect Power BI to MS SQL Server DB
36:58 Connect Power BI to Flat File (.csv)
44:19 Creating Date Table
50:53 Data Modeling
52:58 Adding Background
57:30 Developing KPI’s
⭐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 – 8208804502
➖➖➖➖➖➖➖➖➖➖➖➖➖
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.