Absolutely amazing video, I have finally realised that as a beginner in the financial investment market, you can achieve close to nothing yourself because you still have a lot to learn. Trading with a professional broker is more profitable and my advice for beginners is to always take advantage of that.
@greenquake11931
Жыл бұрын
Instead of timing the market, you should try to diversify your portfolio in order to get a dollar-cost average when it’s time to retire. Keep in mind that you don't need a ton of money to invest. Investing in small amounts can build long-term wealth too!
@stellamoore720
Жыл бұрын
I'm an amateur making terrible picks and I really need assistance.
@mayacho4910
Жыл бұрын
Trading is Profitable with the help of a seasoned broker managing your trading account.
@raymondbarnes5264
Жыл бұрын
@@stellamoore720 'BRIDGET MARY TUROW"".
@stellamoore720
Жыл бұрын
@@raymondbarnes5264 How can i reach her?.
@siddhantkhairnar7519
Жыл бұрын
I want to express my heartfelt gratitude for your dedication to sharing knowledge. It's evident that you have invested a lot of time and effort into creating this tutorial, and it has undoubtedly made a significant impact on my learning journey. Thanks to you, I now feel empowered to tackle SQL and Power BI projects confidently.
@Kishormurade02
7 ай бұрын
Hey, can you please tell me if interviewer asked question that, what the actual use of SQL in this project, then what should be the expected answer can i give, please let me know, I`m confused in this?
@nishantnandkeolyar13289
5 ай бұрын
Absolutely right 😊
@UtkarshShukla-m8g
3 ай бұрын
@@Kishormurade02 SQL databases are more suited for handling large volumes of data with complex querying, transformation, and real-time access capabilities, while Excel sheets are useful for smaller datasets, manual analysis, and simpler reporting tasks. The choice between the two depends on the specific requirements of the BI project, including data volume, complexity, collaboration needs, and the desired level of automation and performance.
@truemufti
2 ай бұрын
Great tutorial, I have a lot of queries in power bi but after watching this tutorial I cleared those. Thank you so much.
@datatutorials1
2 ай бұрын
Glad it helped
@RaviYadav-zi7eb
8 ай бұрын
for those who are using mysql will have problem with datename coz video is on sql server which supports datename but mysql wont so here is the solution SET SQL_SAFE_UPDATES = 0; update pizza_sales set order_date=str_to_date(order_date,"%d-%m-%Y"); alter table pizza_sales modify order_date date select dayname(order_date) as order_day, COUNT(DISTINCT order_id) AS total_orders from pizza_sales GROUP BY dayname(order_date) order by count(distinct order_id)desc
@sumijasukumaran1394
Жыл бұрын
This project looks like real time .This makes as understand how SQL and power bi works together. Please upload python ,power bi project
@shahnawazatharkazmi2826
Жыл бұрын
Dear sir same question in my mind, what is the role of python in data analyst. Bcoz powerbi already have power query editor to cleaning data then role of python plz guide us
@Freakouts_and_found_Insane
Жыл бұрын
@@shahnawazatharkazmi2826 here data we get clear format but most of time data we get in multiple sources in different format their python is used in which numpy and pandas library are useful
@thanhien3282
9 ай бұрын
I think so 🤔
@sasacademy4761
9 ай бұрын
@@shahnawazatharkazmi2826 AA vP by by by by by by by Dr ko CT CT CT
@drbh6331
8 ай бұрын
@@shahnawazatharkazmi2826first of all python had less role in data analysis its more towards data science and data engineering
@TechKeeda0708
Ай бұрын
I'm out of words sir....it does look like some real project now❤....the feeling after watching the whole video of more than 2.5 hrs is really good....thank you for this sir🎉❤
@Allokkkkkk
7 ай бұрын
i am using mysql workbench and the query for monthly trend and daily trend not supporting due to datename invalid function .and i tried other function like date,week but not getting the result .. can anyone help me in this.
@mohamedlashin4462
2 ай бұрын
Thank you for this video, but I have a question: what is the use of SQL queries? I feel that we can go directly to Power BI, or is this just for practice?
@swapnilkushwaha5772
Жыл бұрын
Sir is it necessary to import order_date in date time format........i haven't watched full video.....if yes then how can i do this in mysql I'm facing an error
@shashankreddysai
6 ай бұрын
Best Video for PBI! Great work
@morratunoobs423
Жыл бұрын
Thak you bro make this wonderful video please do this like video more 🙏🙏🙏
@VincentBjuremark
Жыл бұрын
Thank you for this video, you took your time and effort into putting this video together - step by step - so that we all could follow along. The quality of this content is something that I and probably many others would pay a considerable amount of money to be able to benefit from, and yet you did it for free! Thanks again!
@uzoamakaogbonna
10 ай бұрын
You’re such a good teacher
@vshal3880
19 күн бұрын
Bro, for whatever reason i am unable to load my MySQL data in Power BI. I am using 127.0.0.1:3306 as server name but it's not connecting. Any help from your side? I really want to make this project.
@yamkelamatomane7027
Жыл бұрын
Hi, I am getting a "input string was not in a correct format. (mscorlib)" How do I fix this, this happens on the final step when I import the flat file
@koiroi1854
8 ай бұрын
Hi, I am experiencing the same thing , were you able to resolve this error?
@softskills6
Жыл бұрын
It is really an excellent tutorial in an easy way, which is very helpful for beginners
@slycop221
Жыл бұрын
THE BEST YT CHANNEL FOR PROJECTS
@plaguepulse1
Жыл бұрын
Hello! I am having this error when I try to create the table and I don't understand where to look for the problem. TITLE: Microsoft SQL Server Management Studio ------------------------------ Error inserting data into table. (Microsoft.SqlServer.Import.Wizard) ------------------------------ ADDITIONAL INFORMATION: Error inserting data into table. (Microsoft.SqlServer.Prose.Import) ------------------------------ Input string was not in a correct format. (mscorlib) ------------------------------ BUTTONS: OK ------------------------------
@plaguepulse1
Жыл бұрын
I realised it was due to the unit and total prices being "floats" so I just imported them as varchar(50) and then used ALTER TABLE to change them to decimal(10,2) before I started. If anyone gets the same error :)
@joe1171
8 ай бұрын
@@plaguepulse1 this took me hours to figure out, order_id also has to be set to int because it contains a value of 256, tinyint is maximum -255 to 255 where you modify columns, do as @plaguepulse1 says and set unit_price and total_price to varchar(50) after data has been imported this is the queries to alter table alter table dbo.pizza_sales alter column unit_price decimal (10,2) and alter table dbo.pizza_sales alter column total_price decimal (10,2)
@TiamiyuAjibola
Жыл бұрын
I'm really grateful for the immense knowledge I've gathered from you. Within 2 months I've designed 3 completely interactive dashboard with you. . 2: Please, try and always include data dictionary of each dataset for those of us that are documenting. I've documented the Ecommerce, HR and working on this pixza dataset. Thanks once again
@santhuzestvlog7330
Жыл бұрын
Thank you for sharing your knowledge. I understand you have connected the SQL server to Power BI but you didn't use the queries that you created. I see you have used only DAX functions in your visual then what's the purpose of creating queries in SQL. I just wanted to learn! But very informative session
@rizwanahmed1580
Жыл бұрын
Ohh men Don't know how many times you use particular word 😂😂 but very well explained hats off to yoo
@Omnist-
8 ай бұрын
Anyone else struggling to import data file?? 😢
@Data-Load-Analytics
6 ай бұрын
No 😂
@omotayocrownwealth4745
7 ай бұрын
I'm amazed by how proficiently you demonstrated the use of both SQL and Power BI in a single project (start to finish).Your approach makes it easy to comprehend and practicalise, yet simple to follow, even for an average user. I am happy to have encountered your work. Thank you for sharing your expertise!
@datatutorials1
7 ай бұрын
Thabks
@govnny
6 ай бұрын
Hi, thank you for the tutorials. This is my 2nd I am replicating from your channel as practice for interview. I am using mysql as I could not set up the server process for sql mgmt studio. In mysql many functions are either changed or not functioning so i got stuck at DATENAME query at 46:30. Solved this step today with DAYNAME, str_to_date and coalesce, as the order_date column was imported as text by default and the date data is formatted in 2 different ways: d/m/y and d-m-y. if someone is interested, this is the query: SELECT DAYNAME(coalesce( str_to_date(order_date, '%d-%m-%Y'), str_to_date(order_date, '%d/%m/%Y')) ) as Order_day, COUNT(DISTINCT order_id) AS Total_Orders from pizza_sales GROUP BY Order_day ORDER BY Total_Orders DESC
@mansimahajan388
3 ай бұрын
thank u so much for ur comment...i have literally been struggling to resolve this issue and tried every possible way to fix it but failed but the code u provided worked perfectly....can u help me with one more thing that if he is using dax functions whts the use of SQL queries.
@KartikeyaMaich
Жыл бұрын
can you please share the code for this project using mysql?? Please it's urgent
@athanaaa9846
Жыл бұрын
Very good explanations and thanks you man for share your knowledge to us without any expectations ❤❤❤❤❤
@swaroopbabu-b7j
6 ай бұрын
Why you cast that much time only single cast is enough i think Select cast((SUM(total_price) / Count (Distinct (order_id))) as decimal(10,2)) as Avg_Pizza_Per_Order from pizza_sales OutPut: Avg_Pizza_Per_Order 38.31
@amaansiddique4759
3 ай бұрын
Definitely I have learnt a lot from this end to end project , plss make a real time project more and more atleast two in a month
@Mokshtak
8 ай бұрын
It's showing me error when i run this query in MySQL Server. if anyone suggest what's wrong into it ? or another query to run. SELECT DATENAME(DW, order_date) AS order_day, COUNT(DISTINCT order_id) AS total_orders FROM pizza_sales GROUP BY DATENAME(DW, order_date)
@RaviYadav-zi7eb
8 ай бұрын
alter table pizza_sales modify order_date date SET SQL_SAFE_UPDATES = 0; update pizza_sales set order_date=str_to_date(order_date,"%d-%m-%Y"); select dayname(order_date) as order_day, COUNT(DISTINCT order_id) AS total_orders from pizza_sales GROUP BY dayname(order_date) order by count(distinct order_id)desc
@R1_Rover
8 ай бұрын
@@RaviYadav-zi7ebI tried this and it still didn’t work for me
@RaviYadav-zi7eb
8 ай бұрын
@@R1_Rover what's the error?
@remyak68
3 ай бұрын
Can you please tell me why he connects sql with power bi bcz in sql he created kpi and the same thing he is doing in power bi no...so we can only use power bi to do this project...please help me..i didn't understand thats why..
@bisiiscoaching3900
7 ай бұрын
TITLE: Microsoft SQL Server Management Studi Error inserting data into table. (Microsoft.SqlServer.Import.Wizard) ------------------------------ ADDITIONAL INFORMATION: Error inserting data into table. (Microsoft.SqlServer.Prose.Import) ------------------------------ Column 'order_date' does not allow DBNull.Value. (Microsoft.Data.SqlClient) I am getting this error
@sonalwandhare8039
8 ай бұрын
Hi please help to run this command in my sql as it is giving me an error for SELECT DATENAME(DW, order_date) AS order_day, COUNT(DISTINCT order_id) AS total_orders FROM pizza_sales GROUP BY DATENAME(DW, order_date) in my sql to run it please help
@RaviYadav-zi7eb
8 ай бұрын
alter table pizza_sales modify order_date date SET SQL_SAFE_UPDATES = 0; update pizza_sales set order_date=str_to_date(order_date,"%d-%m-%Y"); select dayname(order_date) as order_day, COUNT(DISTINCT order_id) AS total_orders from pizza_sales GROUP BY dayname(order_date) order by count(distinct order_id)desc
@rayaneBENAKSAS
15 сағат бұрын
SELECT EXTRACT(DOW FROM order_date) AS order_day FROM pizza_sales;
@Rytechnology
Жыл бұрын
Bhai maine file download kiya but SQL server me load krte smy error aa ja rha hai
@pranavsrivastava6834
3 ай бұрын
Thank you for this amazing portfolio project which will be truly helpful for mine data analyst journey. I just completed this amazing video, and I must appreciate your time & efforts behind such a great work which shows the real industry experience behind it. Glad to subscribe your channel. Much Appreciated!
@NithinKG-h7e
Жыл бұрын
Very very useful. Just awesome. Thank you so much
@Hyper67-c5b
2 күн бұрын
Love you Brother from Bangladesh 😍😍😍😍
@SandipanSarkar-c8v
17 күн бұрын
Finished watching
@InnovationInflux
4 ай бұрын
A great learning and beautiful visualization. Thanks ! Small suggestion to always create a date & time table and link it to the main table. this will reduce the complexity in main table and would query the results faster.
@SonamRastogi-gr8cj
Жыл бұрын
HOW TO EXTRACT DAY NAME IN mysql
@ishankhanijo4591
7 ай бұрын
This project walkthrough has been very helpful. Thank you sir!
@SujataMaurya-u2v
Жыл бұрын
kindly help DATENAME function not showing in mysql workbench ☹
@datatutorials1
Жыл бұрын
Try dateformat
@SujataMaurya-u2v
Жыл бұрын
@@datatutorials1 kindly help for mysql how to write date format?
@ShraddhaThawkar-j6p
10 ай бұрын
Sir some images not found in ur given dataset like avg pizzas per order etc
@ShraddhaThawkar-j6p
10 ай бұрын
Can u pls share
@er.sarthaksananse1704
Жыл бұрын
One of the best KZitem channel for all Aspiring Data Analyst 😊
@kevinndungu4511
10 ай бұрын
Amazing Amazing this is one the best well walked through project from start to end i have learned a lot keep up the good job!!
@datatutorials1
9 ай бұрын
Great to hear!
@parissaamin7996
7 ай бұрын
You are the Best ever!!!
@MachineLearning-q7k
5 күн бұрын
hats of bro! You are s genious
@aleksanderknurek2755
Жыл бұрын
Does anyone have a problem with importing data to database? I follow all steps and assign each data type to column name as shown in the tutorial and I get an error "Input string was not in correct format". Can someone help me with that?
@mo12mo12e
8 ай бұрын
got the same
@Aratv777
Ай бұрын
what did u do?
@Aratv777
Ай бұрын
@@mo12mo12e how u solved?
@mo12mo12e
Ай бұрын
@@Aratv777 Sorry can't remember. But I don't think I finished it. Think I probably left itat that point nor do I have those files. Apologies. Hope you solve it quickly. Best of luck.
@bhaktikhavle9307
6 ай бұрын
Thankyou for this video, learnt many new things from just 1 video.👍🏻
@Saviyu_lil_munchy
6 ай бұрын
Thank you somuch brother , I have done several dashboard by watching others tutorial. I personally felt this is the best . That too for free . I have learnt somany things. This is the first vedio I watched . As you said " I liked , subscribed and commenting ❤👏
@datatutorials1
6 ай бұрын
You are most welcome
@datatutorials1
6 ай бұрын
Thank you
@MD.ANISURRAHMAN-m9k
6 ай бұрын
Thanks, I have just completed your full tutorials. leaned a lot from your tutorials. Please give us more Power Bi and SQL Related Projects
@keshavkarki7775
6 ай бұрын
Thank you Data Tutorials it is really helpful and awesome !!!
@sunithakumari8297
6 ай бұрын
sir wonderful explaination...hand off for your patience and clear explanation of complete report. even a person how is using power BI for the first time can also understand and practice .....I was expecting dynamic text box in the project....like if we select category showing text box with highlights for the selected tenure or category. If possible can you please help us with dynamic text box.
@datatutorials1
6 ай бұрын
I will do it in next project
@kanhashukla6265
4 ай бұрын
Thanks for uploading this project. I learned a lot
@netishmb761
9 ай бұрын
1:47:26 i am getting error when adding days column OLE DB or ODBC error: [DataSource.Error] Microsoft SQL: There is insufficient memory available in the buffer pool
@netishmb761
9 ай бұрын
1:47:26 i am getting error when adding days column OLE DB or ODBC error: [DataSource.Error] Microsoft SQL: There is insufficient memory available in the buffer pool
@netishmb761
9 ай бұрын
1:47:25 when we add up day column I am getting error OLE DB or ODBC error: [DataSource.Error] Microsoft SQL: There is insufficient memory available in the buffer pool can anyone please help regarding this thankyou in advance 😢
@Saurabhkardile546
8 ай бұрын
if you are still facing error in flat file import ,change it to nvarchar(max).
@nidhi_singh9494
8 ай бұрын
I am watching this "particular" video on 1.5x speed and most of the time i can listen is "particular" thing... 😅 Jokes apart.. video is structured well with good understanding
@datatutorials1
8 ай бұрын
I will try to work on it, thanks for feedback
@ssbsection7824
4 ай бұрын
Can anyone tell me how much time does it take to learn whole SQL from start to end🤔🤔🤔
@ageofsuccessss695
4 ай бұрын
If you give 4 hours daily it's takes 1 months to understand whole sql and it's takes 3 to 6 month for becoming expert in sql
@english_speaking
3 ай бұрын
2 daya
@mathewmburu4920
6 ай бұрын
Many thanks so much for you time🧑🏫🧑🏫🧑🏫🧑🏫🧑🏫
@shahnawazatharkazmi2826
Жыл бұрын
One of the best project for power bi available on youtube
@datatutorials1
Жыл бұрын
Glad you think so!
@footballworld7734
5 ай бұрын
can you send a link or file with all this steps sone ?
@andreiadita309
7 ай бұрын
Hello. Can you help me with this please: I am trying to import the file to power bi but this error keeps on appearing “we couldn’t authenticate with the credentials provided. Please try again.” What can I do with this? Thank you
@SujataSharma-p6v
5 ай бұрын
It's a wonderful video and a great start for a beginner... Have one doubt while doing this project, the figure of Total Revenue and Total Pizza sold changed in card during visualization in Powerbi and I tried to seek it out but did not get where I was wrong... Kindly provide guidance.
@sabeeralii5971
5 ай бұрын
Thank you for such a detailed video. I have a question. How is SQL gonna help here in Power BI. Is it just for checking or does it have something to do with the Dashboard.
@aywinter6046
Жыл бұрын
First, thank you for this video which I find very helpful and easy to understand. But, I have one quick question. What if I have new data come in next year lets say 2016. How do I automatically pull in new data and update the KPI to include the 2016? Thank you.
@pavanthorat8324
5 күн бұрын
sir thanks for this project , but what is use of sql as we used dax for visulization for all chart and KPI , then why we used sql query
@akshayshirbhate7
8 ай бұрын
In mySQL, when i import the data, i have to import as default data types. So that date column has text type. If i change it while importing, data is not imported. Also i am unable change data type for date by running query
@Aratv777
Ай бұрын
u r great!!! Thank u
@ramesettyramya4528
3 ай бұрын
Hi , what should we use to find the daily trends of orders in mysql , DATENAME function is not working in mysql , please help me how to write it for daily trends and for the monthly trends of orders
@francoviveros1946
Жыл бұрын
First of all, thank you very much. Now, from my ignorance, please someone answer me, why do we work with SQL if we finally did the same in power bi? (maybe I missed something, English is not my native language)
@datatutorials1
Жыл бұрын
See chat section
@funa2939
4 ай бұрын
Hello, could you please make one with google stack? Bigquery etc. I keep getting error with ms sql, and it drives me crazy
@Polywell-i5v
2 ай бұрын
It's good explanation but I don't then why we perform SQL queries if its not help to make dashboard
@saadudeensaadu
10 ай бұрын
Thank you for creating and sharing this insightful video. I would like to request permission to replicate and incorporate the demonstrated project into my portfolio. Your consent would be greatly appreciated.
@datatutorials1
10 ай бұрын
Sure you can
@Kkk-mw8jk
5 ай бұрын
Is it a difference of using the ROUND FUNCTION insted of CAST?
@haseebahmed9953
Жыл бұрын
Your dedication to sharing expertise is commendable, and your video significantly contributed to my learning journey in BI. Thank you for your valuable contribution; I look forward to exploring more of your content.
@sabShrav
5 ай бұрын
Thank you so much for the great learning video . sir for me its showing error funciton db .datename doesnt exist.please advise on this .
@fanendranath2372
Жыл бұрын
Thank you sir . Your video is very helpful, you have explained very nicely
@datatutorials1
Жыл бұрын
Thanks and welcome
@Mina-ur5vm
Жыл бұрын
TITLE: Microsoft SQL Server Management Studio ------------------------------ Error inserting data into table. (Microsoft.SqlServer.Import.Wizard) ------------------------------ ADDITIONAL INFORMATION : Error inserting data into table. (Microsoft.SqlServer.Prose.Import) ------------------------------ The format of the input string is incorrect. (mscorlib) ------------------------------HELP ME PLEASE
@bandanachoudhury2674
7 ай бұрын
This project is very good for understanding. Can you please send the PPT of this project
@swarupasahu700
Жыл бұрын
Beautifully explained each and every concept. As I am new to power BI ,it is so helpful for me to understand the end to end process. Great work 👍
@chalanatyjostna2229
9 ай бұрын
we have used sql queries to get answers for all our problems,,, then why are we using dax and calculating again? why didnt we use our sql queries?
@gunathangam6344
5 ай бұрын
To compare the both values are match or wrong.
@swastikjainsj
7 ай бұрын
Sql u used to just see the results and docs right? Or have you created a column?
@Jackeychan-ve8sg
9 ай бұрын
Sir the datename is Microsoft SQL querry ,then what is the querry for mysql
@manaspattanaik2345
11 ай бұрын
Thanks But my request is instead of one table use 10 more table so that it is useful. my request is to show dashboard using more table with join option
@datatutorials1
10 ай бұрын
Noted! Will try
@chemistrylover8736
Жыл бұрын
i did not get what is sql use then? if we can calculate the same ín power bi?
@SamuelOlujide
Жыл бұрын
I want to appreciate you for the time spent and dedication to this work to instill the basic requirements and the needful things to know as a data analyst. I would love you to make a video on how to display our dashboard on our web page, Please.
@vasanthkumarcroos8605
Ай бұрын
Just awesome Thank you so much sir.
@NoBatmanOnlyHitman
3 ай бұрын
34:38 there are no duplicate records at order_id it was just specified as how many pizzas were order for paticular order id then you have calculated total_price for all order_id it doestnt make any sense
@jalabhoothamyt6088
Ай бұрын
HOW ARE YOU ENTERING THE HEIGHT AND WIDTH EASILY? IS THERE ANY RULE FOR THE DIMENSIONS FOR THE KPI AND GRAPH DIMENSIONS?
@yoke-yinp3188
10 ай бұрын
So, actually the SQL has nothing to do with the PBI? Right? Thank you.
@mahekgupta-o7r
Жыл бұрын
This is really informative. Can you also provide the link for ppt or upload it on same folder as of data provided link of drive for the problem statement that u had made
@piero141980
Жыл бұрын
Nice video, very informative however I fail to understand why we need to use sql for this exercise. I thought we would use the formulas created at the beginning of the video in SQL while creating the dashboard in powerbi but we didn't do that. I wonder why do we need to go through that exercise instead of uploading a cvs file into powerbi directly and saving time by doing that ?
@datatutorials1
Жыл бұрын
Whenever you are asked to build a project or dashboard in any tool you always have to validate your results shown in the dashboard. The results shown in dashboard are garbage in and garbage out, meaning it shows anything you want, how will you and client know the values are correct. It is always a best practice to test the report you build by firing SQL queries to database and validate the reports. This is explained in the video well
@yogeshpatole9595
Жыл бұрын
Please make video on how to get job in power bi
@fayejsheikh5689
11 ай бұрын
Thanks for project's. Can you please upload PPT file used in this video it will very helpful for us .
@MuhammadFaizan-ri3fl
6 ай бұрын
When i make a stack column chart first results are wrong for all days total orders remain same not know the reason then when i make a second area chart results are opposite . ? Kindly answer this
@tamiresronchini3355
2 ай бұрын
:30 you said to upload only cvs file, not excel. Any reason why?
@NSCFutureSuccess1111
5 ай бұрын
Hello sir also provide project description for mentioning in resume
@nutz3594
11 ай бұрын
this is content really helpfull for me as beginner which who want learn Data Analyst process.. i hope u cant keep update about simillar things coz i will follow ur update for further 👍🙏
@datatutorials1
10 ай бұрын
I will try my best, thank you
@sharonnwanne5098
11 ай бұрын
Thank you so much for your incredible work here. It was really amazing. Thank you...
@kashishagarwal8191
5 ай бұрын
sir DATENAME func is not working in my pgadmin what to do?
Пікірлер: 677