Build a Power BI Dashboard in 70 min | Power BI Project | End to End | Beginner to Pro |

#powerbi #sql #tableau #excel
Build a Power BI Dashboard in 70 min | Power BI Project | End to End | Beginner to Pro | #powerbi
📱Data Analyst Materials & Projects - topmate.io/data_tutorials
📱Book 1:1 Call with me (Career Guidance, Mock Interviews, Resume Review, etc.) - topmate.io/data_tutorials
📱For Important Data Analyst Materials and Other Resources - topmate.io/data_tutorials
📱 Follow me on LinkedIn - / swapnjeet-s-58a673273
📱Follow me on Facebook - profile.php?...
Welcome to this comprehensive Data Analyst Project tutorial! In this tutorial, I will guide you through the complete process of building a data analysis project using popular tools such as Power BI, Tableau, SQL, and Excel.
Whether you are a beginner or an experienced data analyst, this tutorial will provide you with the necessary knowledge and hands-on experience to successfully complete a data analysis project. Join me on this journey and unlock the power of these essential data analysis tools.
Data Download - drive.google.com/drive/folder...
⭐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 - • Data Analyst Roadmap 2...
Details mentioned below-
email- swapnjeet555@gmail.com
WhatsApp - +91 9579005495
⭐For Tableau, Power BI and Excel Projects contact me on my mail id or WhatsApp number mentioned at the end of description box.
➖➖➖➖➖➖➖➖➖➖➖➖➖
Content
Introduction to Dashboard 0:00
My Website 05:10
Problem Statement 07:10
What You will learn? 12:04
Software Used 12:48
Data Walkthrough 13:44
Connecting Power BI to Database 18:30
Data Cleaning 20:14
Create Data table 23:00
Data Modeling 27:09
Header Design 28:40
KPI's Development 30:15
Chart's Development 45:34
Grid View Dashboard 01:05:21
Navigation Buttons 01:10:24
Outro 01:13:40
✅Data Modelling - • Data Modeling in Power...
✅Data Cleaning - • Data Cleaning in Power...
✅Data Analyst Portfolio Projects - • SQL & Excel Portfolio ...
✅Power BI Projects - • Power BI Dashboard fro...
✅Tableau Projects - • Tableau Dashboard from...
✅Excel Projects - • Dynamic Excel Dashboar...
✅SQL Projects - • Data Analysis SQL Proj...
✅Power BI Interview Questions with Answers - • Power BI Scenario base...
✅Tableau Interview Questions with Answers - • Tableau Scenario Based...
➖➖➖➖➖➖➖➖➖➖➖➖➖
Tableau Material available-
1. Tableau hand written notes
2. Tableau printed notes
2. Tableau important formulae print 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- swapnjeet555@gmail.com
WhatsApp - +91 9579005495
➖➖➖➖➖➖➖➖➖➖➖➖➖
Related keywords:
data analyst project,
data analyst project for beginners,
data analyst portfolio project,
data analysis project,
data analyst projects for resume,
data science project,
data analyst excel project,
excel tutorial,
excel tutorial for beginners,
end to end project for data analyst,
excel project for data analyst,
excel project,
report in excel,
dashboard in excel,
data analyst portfolio project
data analyst project
data analysis project
data analyst projects for resume
data analyst sql project
end to end project for data analyst
sql project for data analyst
project for beginners
sql portfolio project
data analyst sql project
data analyst full project
data analyst resume project
sql project
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, Tableau, tableau dashboard, tableau tutorial, SQL, SQL project

Пікірлер: 111

  • @datatutorials1
    @datatutorials16 ай бұрын

    Hello everyone, there might be date format errors in csv file I shared, i suggest all of you to change the data type of date field when you connect power bi to the csv file. This will resolve your issues. Also i will share excel xlsx file where you can download using same link description box which will have correct date format.

  • @AkoredeEjilakin

    @AkoredeEjilakin

    5 ай бұрын

    How do we change that pls i have tried to do that but getting the same thing

  • @olabukoyeoluwafemi2139

    @olabukoyeoluwafemi2139

    5 ай бұрын

    there is an error even when i change the data type of date field

  • @revalladhanunjay8690

    @revalladhanunjay8690

    4 ай бұрын

    hello sir....thankyou for your valuable information. recently i have graduated and searching for BI analyst job. meanwhile i have learnt power bi, mssql, msexcel. please give a better solution for my career sir.

  • @parulsharma330
    @parulsharma3308 ай бұрын

    Thank you for the video. Simple yet impactful

  • @samplaying4keeps
    @samplaying4keeps8 ай бұрын

    Thank you so much for this. I learned a lot!

  • @tinaliu8906
    @tinaliu89068 ай бұрын

    excellent dashboard, please keep making those amazing dashboard!

  • @newenglandnomad9405
    @newenglandnomad94052 ай бұрын

    Love the dashboard, thank you for the step by step to make it.

  • @ziddneyyy
    @ziddneyyy7 ай бұрын

    Thank u so much, I hope all of your good deeds will be back to u as a best form ud ever receive, Aameen.

  • @abhishekplaywithdata
    @abhishekplaywithdata8 ай бұрын

    Perfect .......... I have learnt many things from this Dashboard...... Thanks Buddy Keet it up.

  • @mrskbabu
    @mrskbabu9 ай бұрын

    Good learning experience thank you

  • @adisamashud2254
    @adisamashud22549 ай бұрын

    Good one brother always following your vidoes kudos

  • @deepakvishwakarma5231
    @deepakvishwakarma52312 ай бұрын

    Very impactful video

  • @AhmedGamal-mi1ns
    @AhmedGamal-mi1ns8 ай бұрын

    Thanks for your effort

  • @agungprayoga3205
    @agungprayoga32058 ай бұрын

    Excellent video, thanks sir 👍

  • @user-yu2vy4yz6o
    @user-yu2vy4yz6o9 ай бұрын

    Very Impressive..

  • @user-hd9hl1ie7q
    @user-hd9hl1ie7q6 ай бұрын

    Thank you for the video. I learnt a lot

  • @vinothkumars7421
    @vinothkumars74218 ай бұрын

    Covered all the basics within short span.. Great tutorial.. Thanks a lot

  • @satishshinde8768
    @satishshinde87689 ай бұрын

    Thankyou sir 😊

  • @investradelearn
    @investradelearn5 ай бұрын

    GREAT VID THANKS!!

  • @awaz4160
    @awaz41609 ай бұрын

    thank you

  • @sujanshetty26
    @sujanshetty268 ай бұрын

    Good Learning

  • @realitybeckons4120
    @realitybeckons41208 ай бұрын

    Thank you

  • @omsingh-sn5zs
    @omsingh-sn5zs2 ай бұрын

    thankyou, date formating me bhaut problem thi aur youtube ye kahi nahi ha thankyou you solve my problem

  • @ansh5150
    @ansh51509 ай бұрын

    sir please make video on how to study data for dashboards and which columns from dataset should be used for representing on dashboards

  • @user-lm5wb8vi1x
    @user-lm5wb8vi1x8 ай бұрын

    FINISHED PRACTICING

  • @user-by6ss5xc6n
    @user-by6ss5xc6n9 ай бұрын

    Bro you made a video on a prohwct ovwrview which consisted in sql and power bi about 2 months ago a black theme power bi report when is that video coming out Great project is superb as well 👍🏻

  • @punitchhatani1336
    @punitchhatani13369 ай бұрын

    Hello sir can you please make a dash board on stock market data . It would be really helpful.

  • @IndiaCountry-cx9zf
    @IndiaCountry-cx9zf9 ай бұрын

    Nice ones 😉

  • @GauravKumar-sn3jq
    @GauravKumar-sn3jq4 ай бұрын

    Great

  • @nikhilraut1135
    @nikhilraut11358 ай бұрын

    Much appreciated 💗

  • @datatutorials1

    @datatutorials1

    8 ай бұрын

    Glad you liked it 👍🏻

  • @madhumitharaveendran2947
    @madhumitharaveendran29475 ай бұрын

    Thank you so much I learnt a lot from the video it was very interesting.

  • @datatutorials1

    @datatutorials1

    5 ай бұрын

    Glad you liked

  • @srinivasareddymatta3641
    @srinivasareddymatta36416 ай бұрын

    nice tutorial

  • @namubiruevelyn2393
    @namubiruevelyn23935 ай бұрын

    Woooow🎉

  • @KenechukwuNweke-kk1cf
    @KenechukwuNweke-kk1cfАй бұрын

    You can use Format Painter option to make color customization easy and non repetitive.

  • @Rabbani_World_Flock
    @Rabbani_World_Flock6 ай бұрын

    Thanks a lot❤🎉

  • @datatutorials1

    @datatutorials1

    6 ай бұрын

    You're welcome 😊

  • @bolumekenejoan6360
    @bolumekenejoan63609 ай бұрын

    thank you so much, but could you please make a dashboard on sea cargo it related to and also one in agricultural business. i am curious as to how analysis can be done in this field. thank a bunch sir.

  • @ajaykumarreddy3242

    @ajaykumarreddy3242

    8 ай бұрын

    Please provide data analysis sample resumes I learn SQL, Power bi, excel

  • @lakshmig5939
    @lakshmig59399 ай бұрын

    Hi Sir, do you take online classes for beginners

  • @sripriyavemula788
    @sripriyavemula7887 ай бұрын

    can you please share a link of the original source from where you got the data?

  • @NehaSen10
    @NehaSen109 ай бұрын

    Sir please make a video to solve the problem - when i want to draw map it will just blank I search for it various platforms but this blank map problem not solved yet.

  • @romanahmed4754
    @romanahmed47546 ай бұрын

    hi, this is amazing

  • @datatutorials1

    @datatutorials1

    6 ай бұрын

    Glad it helped you

  • @romanahmed4754

    @romanahmed4754

    6 ай бұрын

    Bro, a proble here, when i create date table then show time 12:00 am, and then i creat Day column it show error?

  • @cutesidra9885
    @cutesidra98859 ай бұрын

    Plz do data cleaning in ms sql plz

  • @jatothveeresh2381
    @jatothveeresh23816 ай бұрын

    please do videos on health care domain

  • @user-dv7gz7hp5q
    @user-dv7gz7hp5q7 ай бұрын

    can i keep it in my resume please answer to me sir

  • @vijayprakash2743
    @vijayprakash27437 ай бұрын

    @datatutorials1 i am notable to download the datasets of call center. can you plz upload and letus know thanks in adavance

  • @prasadgaonkar5815
    @prasadgaonkar58159 ай бұрын

    How many dashboard you have provide in your website

  • @viraj7932
    @viraj79329 ай бұрын

    Sir novypro website m excel dashboard ko kese add krna h uspe video bnaiye na plzz.

  • @nathalie12156
    @nathalie121567 ай бұрын

    How long can it take to create such a dashboard in a real-world environment?

  • @KAMALSHARMA-xk1ov
    @KAMALSHARMA-xk1ov8 ай бұрын

    Do you also do one to one mentorship for Dashboard development? If yes please share contact details

  • @user-vt7xh9bg1r
    @user-vt7xh9bg1r9 ай бұрын

    Pls can you drop the resources for the images

  • @Anuradha-cy2zh
    @Anuradha-cy2zh3 ай бұрын

    Excellent in real time with problem statement they mention charts which chart as to use ?

  • @datatutorials1

    @datatutorials1

    2 ай бұрын

    Requirements they do provide, what charts to use that depends on client but sometimes yes sometimes no

  • @ashish90702
    @ashish907029 ай бұрын

    Please make a detailed video on DAX

  • @datatutorials1

    @datatutorials1

    9 ай бұрын

    In progress

  • @bolumekenejoan6360

    @bolumekenejoan6360

    9 ай бұрын

    i will be expecting this as well sir. Thank you@@datatutorials1

  • @francisspencer1803
    @francisspencer18038 ай бұрын

    When I tried to sort the column chart with the created “Day No” I keep getting an error message “A circular dependency was detected: Date Table[Day], Date Table[Date No], Date Table[Day].” Please I need help

  • @FunClip4u
    @FunClip4u9 ай бұрын

    There is no dashboard Excel sheet there is only data sheets provided

  • @ramyasrireddymitta6728
    @ramyasrireddymitta67287 ай бұрын

    Please share the data link for CSV file

  • @revanthchinnaswamy5384
    @revanthchinnaswamy53849 ай бұрын

    Sir I'm not getting colour saturation in filled map visualizations tab. Please help

  • @datatutorials1

    @datatutorials1

    9 ай бұрын

    Use shape map instead

  • @kuskus471
    @kuskus4718 ай бұрын

    how to download shape map

  • @shaikhrafae1458
    @shaikhrafae14589 ай бұрын

    i am facing a problem while making this Dashboard, Error Occurs when i am selecting Total call duration ??? why if anyone pls explain it to me

  • @Misayechaka

    @Misayechaka

    4 ай бұрын

    Same here is not working

  • @ajaysingh-xo4gs
    @ajaysingh-xo4gs8 ай бұрын

    Thanks for lecture , I too created this Dashboard but my navigation tab is not working, any suggestion Please ?

  • @datatutorials1

    @datatutorials1

    8 ай бұрын

    Did you take navigation button to create, try pressing alt and click

  • @Mohammadshehzad777
    @Mohammadshehzad7779 ай бұрын

    Hi sir I facing some issue in date section my date column in alphabetical order and when I change the type its show Error.

  • @chaitukumar61

    @chaitukumar61

    9 ай бұрын

    You should check with your local date and time

  • @snehasingh1342
    @snehasingh13422 ай бұрын

    Hii response time % pe error de raha sir a function placeholder has been in true /false expression that is used as table filter expression .please ans. how i can solve this?

  • @aidanthompson5053
    @aidanthompson50539 ай бұрын

    18:39

  • @aidanthompson5053
    @aidanthompson50539 ай бұрын

    35:39

  • @user-nz8bo3oc8t
    @user-nz8bo3oc8t5 ай бұрын

    my navigation is not working. what to do?

  • @pratikjugantmohapatra18
    @pratikjugantmohapatra189 ай бұрын

    While doing the total calls by day ........Iam not able to see any days in my x axis . I am only seeing one column .

  • @ankitakarmakar3680

    @ankitakarmakar3680

    8 ай бұрын

    Yes..i am also facing same issue

  • @francisspencer1803

    @francisspencer1803

    8 ай бұрын

    From the power query editor pane, right click and select “change type” then select “using Locale” and change data type to “date” and locale to “English UK” Once you do this you are good to go Give me feedback

  • @hrudaysahu2977

    @hrudaysahu2977

    8 ай бұрын

    You are correct

  • @AbhinavJha-ru1py

    @AbhinavJha-ru1py

    8 ай бұрын

    Same issue I had faced can someone help me how to check with the power query editor

  • @harisudhan967

    @harisudhan967

    7 ай бұрын

    ​@@AbhinavJha-ru1py 1) Go power Query change timestamp datatype from text into Date 2) Go to file select options &setting then options then go to current file change the regional setting into ENGLISH UK

  • @yashdubey8774
    @yashdubey8774Ай бұрын

    WHAT ARE THE INSIGHTS WE got .....can anyone can help me

  • @rahishillustration9332
    @rahishillustration93327 ай бұрын

    While plotting total calls by day in column chart im seeing all the datas are same for all the days how to fix this issue can anyone please help me with this 45:51

  • @User-lm4qq

    @User-lm4qq

    6 ай бұрын

    do u get the solution plzz i need help

  • @datatutorials1

    @datatutorials1

    6 ай бұрын

    Hi make sure that your date column is in correctly date data type in power bi. if it’s in text or other format try to change the data type to date format. Hope this helps.

  • @SSMB-dw2zr
    @SSMB-dw2zr7 ай бұрын

    Response time (%) formula is not correct

  • @chaitukumar61
    @chaitukumar619 ай бұрын

    I'm facing a problem while creating the column chart while adding the day column, it is showing as blank can you please address me.

  • @_rex.uxchiha5721

    @_rex.uxchiha5721

    9 ай бұрын

    I'm also facing this problem. 😢

  • @chaitukumar61

    @chaitukumar61

    9 ай бұрын

    I've figured it out, check with your locale time zone settings which has to be matched with the dataset which we are using @@_rex.uxchiha5721

  • @datatutorials1

    @datatutorials1

    9 ай бұрын

    Send you issue with screenshot on my WhatsApp number available in description of video

  • @healthy_ches

    @healthy_ches

    9 ай бұрын

    It looks like a data quality issue with the source csv. In my case, the call timestamp column data type was text. 1st I changed it to date then I had 61% errors in that column. I changed the local to English(UK) , now no more errors and that was the fix.

  • @chaitukumar61

    @chaitukumar61

    9 ай бұрын

    @@healthy_ches yes I have done the same my timezone was us and changed it to UK then it’s fine

  • @rameezkhan9352
    @rameezkhan93522 ай бұрын

    UR DATA SHEET UNMATCH

  • @plant.nursary

    @plant.nursary

    Ай бұрын

    Matching completely 💯