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

⭐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

#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-

⭐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

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.

[MD.ANISURRAHMAN-mk]

I am a beginner, but I really appreciate you and your great effort with the actual projects, I have completed your HR data analysis project.

[himnishchopra]

your videos are great, they are better than paid courses, you give a lot of value in these videos 😃

[vinodkumar.N]

I follow your videos, it's great, the way you explain and support you provide interms of resources, Thanks is a small word to say, but you deserve more than that, Hats off to you.

[mobnpcgamez]

I just completed this. Have learnt many things. Thanks a lot.

[SheetalBhagwat]

Rather than checking data type in Data view its easy to do data cleaning in power query..as a power query automatically detect data type..it will save our time

[vishwassharma]

Sir kindly upload tutorials of Google Data Studio.

[jorge]

Thank you !!! Would you have the original data set, not the one you loaded to your drive? Please

[gaurideshmukh]

Thanks for this Dashboard. It helps me to learn a lot..

[prajaktamane]

Thank you so much for this. You're doing a great work. I had a doubt, When im adding my area chart, and when im passing my cursor over it, im unable to see any value as shown in the video? Any reason why this could be And how to solve it?

[lovelyjha]

I like the way you have explained the steps to create the dashboard. Could you create a dashboard on standard price Vs discount price?

[gqcglsf]

You're doing a great job. I have a question, at 1:02, In Area Chart, why the YTD Sales was creating running total? When you have a moment, please explain.

[yashsaharan]

sir please make a video on data cleaning please when i working on different data set which is not clean its a living hell to me please make a video on that process

[laurabranham]

Thanks. I love your content. Do you have any videos on your process for cleaning data?

[chandrimakhastagir]

Thank you so much!!!I have already compleetd your IPL, Road accident dashboards and looking forward to completing this one soon!Can you please post an SQL project soon?

[frankkuukyee]

I have been following you for a while and impressed with your videos. Could you please share the source of the original data ? I would need it as part of my reference.

[RlUpadhyay-co]

ytd sales =
TOTALYTD(SUM(ecommerce_data[sales_per_order]), 'Calendar'[Date]) query bhi shi hai tabhi bhi

[oguedoihuchigozirim]

@Data Tutorial Your videos Boost my Confidence. I personally answer these you business questions using SQL and Tableau. Keep it up Boss. I am creating this with tableau, I will also answer the questions using SQL this weekend. What a motivator? 🥰🥰🥰🥰

[abiodunsadiq]

Thank you so much for sharing, your video is very informative, However I was not able to cleanse the ecommerce data because I ended up with 34, 650 rows, It'll be appreciated if I can get a feedback on how you were able to do the data cleansing to get the same data. I was able to convert the date data type and changed it to the appropriate data type 'TIME'.

Thanking you in anticipation

[Mhayriam]

For the Conditional formatting rule style, Update your Version of Power BI app..That did it for me

[shahriarnamvar]

Could you please share the link to the original dataset from Kaggle?