Made two mistakes in the video. At 26:35, I added weekdays twice. You should add weeknights also. Additionally, At 27:20 for discount it should be (1-discount)
Can you make a .bak file for the database and upload it to make it easier to get up and running? Loading via the data wizard is very problematic as I am using Studio 2019
@@brilliancetventertainment9416 Hi, it seems you are using Office 64 bit, to solve that issue it's very simple but known to many Open: SQL Server 2019 Import and Export Data (64-bit) or the exe file: DTSWizard.exe It will be in this path: C:\Program Files\Microsoft SQL Server\150\DTS\Binn\DTSWizard.exe Please let me know if this solved your issue.
Thanks for such a great video, But there are a few concerns I would like to point out, first of all, in regards the Revenue and I believe we can't just simply multiple days and adr, the total should subtract those reservation_status =" Canceled". Secondly, parking lot size question about the percentage of occupation soulld be equal "car parking spaces" /" reservation status "instead of "car parking spaces" /"Total nights" because no matter how many nights you stay, one reservation only corresponding one parking sport.
Great video! I think there's a mistake in minute 27.24. You sum the same columns (stays_in_week_nights + stays_in_week_nights) Instead is (stays_in_week_nights + stays_in_weekend_nights).
Thank you so much! Stumbled across this video, late one night. Watched it through first; was so easy and clear to follow! You made it all make sense and click for me!!! Thanks again!! Fastest I ever hit the subscribe button lol!
I completed the tutorial. I had issues downloading MSSMS and connecting to the server. I figured that out. Then, had trouble importing the data. I figured out that problem. Smooth sailing after that. Great practice project. Thank you!
Revenue = stays_in_weekend_nights+stays_in_week_nights *adr you write it stays_in_week_nights +stays_in_week_nights in adding Revenue column in Power BI it's 10.23M not 14.79M
I tried to do this in MySQL but the importing of the files was taking FAR TOO LONG so I downloaded MS SQL Server. First time using that flavor of SQL so this will be a learning experience on that front as well.
Great tutorial, but i am not sure if Revenue should really be including the bookings that have been cancelled? There is a field in the dataset called is_cancelled, and common sense is telling me that the records identified as is_cancelled = 1 should not be accounted for (customers most likely didn't pay for those bookings)
Absent Data after UNION you lost 40k rows. In [8:43] you can see totally is 141k rows and after union [9:10] is only 100k rows. I think you should use UNION ALL because UNION add only distinct values(rows) by default.
Thank you so much for this vid. it lifted some weight off my shoulders. Please can you make a video on automation. From database to powerbi? Thanks in advance
Hello, Thanks so much for this great tutorial. I was following the tutorial and realised my results were significantly different. I want to confirm if the dataset was updated after the time of the video. I want to be sure I am on the right path. Thanks again
Hello, Firstly it is a great project for beginners. 26:20, I think, you did a mistake if I am not wrong. Actually you add stays_in week_nights twice instead of adding stays_in week_nights and stays_in weekend_nights. Thanks.!
why is revenue multiplied by discount this would not give the real revenue after discount it should be multiplied by (1-discount ) correct me if i am wrong
Hi! Thank you for the guide! It gave me a lot of valuable insight. Can you please provide the kaggle link to the data set? I know that it is hosted in your website as well but I would like to view the kaggle dataset as well. Thank you very much!
great video. just started learning sql and data analytics but i watch these videos and i get a better understanding of what i am learning. question though, why not clean the data? for example where there were null values etc, or is that not always necessary?
Its depends on the use case. However, Power BI is designed for data cleaning. Sometimes, it's easier adlnd more prudent to do it in SQL. However , for a small dataset, its easier do any needed manipulation in Powe Ni
hi, first of all, I really enjoy this video and it was just so much helpful to understand the process to do a project of analysis. I have 1 question, with the union command, don't you leave some register out of the set? because with all the records from the 3 tables, the row count is much higher that the row count after doing the union
Hey! I accidentally wrote 2018 instead of 2019. And even after correcting it the sum command would only give me the sum of 2018 and 2020. What could possibly have gone wrong ?
@@019_devarghachattapadhyay5 By using (1 - [Discount]), we're calculating the discount value correctly as a percentage off the original price. E.g. if the discount is 0.2, it will calculate as 20% off, resulting in 0.8 (1 - 0.2) of the original price.
I feel there is one more mistake at 36:27 where took adr in place of avg of adr, the same error made for avg of discount. pls, correct me if I am wrong.
at start more thank you , at the second i start work as data analyst so i need excel file to start training and apply steps as i learn it from you , ath the last more thanks agine
I have been stuck for the past 2 hours trying everything possible (with chatgbt) to solve the error Microsoft.ACE.OLEDB.12.0 not found. I dont want to jump right into powerBI like others since the whole purpose for me is to get expereince in building databases and integrating that into my work ANY help would be appreciated to jump start this
In the dataset, I can see the 2nd column as "is_canceled". for this column we have true=1 and false = 0 value. Should not we have considered that for actual revenue calculation? Just need some clarification on my understanding.
@Absent Data can you make a proper data manipulation video series using SQL, I've searched everywhere and it seems there aren't many sources available online that dig deep into data manipulation using SQL.
Hello sir, this is much appreciated and very helpful project. However, I was enquiring if you can share the dataset so that we can also practice on it. Thank you
A few reasons. It most organization data is stored securely in database. For data governance and security, having a single source of data in a database, data lake or data warehouse is needed. You can bring in the data with manipulating it from the database to Power BI, However, if you can improve the performance by structuring the data in the database, you can improve the performance of the dashboard.
I'm having the hardest time with this error: TITLE: SQL Server Import and Export Wizard ------------------------------ The operation could not be completed. ------------------------------ ADDITIONAL INFORMATION: The 'Microsoft.ACE.OLEDB.16.0' provider is not registered on the local machine. (System.Data) ------------------------------ BUTTONS: OK ------------------------------ Any advice?
I am getting an error "The 'Microsoft.ACE.OLEDB.15.0' provider is not registered on the local machine. (System.Data)" I've installed accessdatabase_x64 for 64 bit OS and still not working when trying to import excel data into SSMS
I am getting an error when I try to import the data TITLE: SQL Server Import and Export Wizard ------------------------------ The operation could not be completed. ------------------------------ ADDITIONAL INFORMATION: The 'Microsoft.ACE.OLEDB.16.0' provider is not registered on the local machine. (System.Data) ------------------------------ BUTTONS: OK ------------------------------
I am trying to learn sql and I love how you are explaining everything. I tried to use union exactly as you did but I keep getting the same error. "Msg 205, Level 16, State 1, Line 1 All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number of expressions in their target lists." I honestly don't even know what this means or what to do next. I've been stuck for two hours. I just want to combine my three tables. I also looked up other ways. I keep running into issues using inner join and full join.
Thank you for the compliment. This error usually occurs when you have different number of columns in the Union. I would start from scratch again if you following along in the tutorial.
@@ngoziokonkwo5280 I am trying to use MS SQL but I have always been stuck even after uninstalling and reinstalling, I keep getting an error message like this "Error 0xc002f210: Preparation SQL Task 1: Executing the query "CREATE TABLE [dbo].['2018$'] ( [hotel] nvarchar(2..." failed with the following error: "Culture is not supported. Parameter name: culture 3072 (0x0c00) is an invalid culture identifier.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly."
Oops. Am i the only one who got stuck at the very beginning? Could anyone please help me to figure out what should i put into "Server name" field at 2:30? What i have is an empty one, and anything i add (name of my PC?) in it causes an error. How to connect to existing server or create a new one? Thank you.
anyone please help me to import this excel file into sql serve! it showing error "The 'Microsoft.ACE.OLEDB.16.0' provider is not registered on the local machine. (System.Data)" I installed but still showing same issue.
Would there be a reason why the tables do not appear after the importation process? I'm not seeing any of the tables I selected and everything said successful at the end.
just for clarity and a more realistic output, shouldn't one not count the information that contains cancellations? it would give a fluffed output in reality.
Measure or column would work. I wanted to keep it simple by using similar actions from SQL to Power BI. However measure works perfectly and keeps table smaller.
Hello, questions please... you mentioned that 2020 seem to have incomplete dataset... kindly explain why you concluded that. Thanks & am really enjoying working on this project step by step with your guidance 👍
I think he infered that by the numbers being quite a bit lower than 2019. It would either imply that 1) the dataset for 2020 is incomplete, or 2) the trend is going heavily downwards. You could easily verify this by examining the max date of the date column.
5 minutes into the video and I have run into a bunch of errors trying to debug the import wizard with SQL Server and SSMS. Had to save the file as compatibility given the different versions being used here, and again ran into errors. By any chance could you upload another similar guided project with an updated SSMS / SQL / Excel version? Or if anyone else has been running into Microsoft Jet database engine errors, how did you fix it?
Hello! I'm using MySQL for this project and trying to connect it to powerBI. I received an error message like this "Details: "Microsoft SQL: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)" Do you know how to fix it? I'm certain my database name is correct.
Hi there, great tutorial. Just have a question, I have installed on my laptop mysql and postgte SQL. Can I use them to follow the course or I m forced to download sql server? Thanks upfront
Thank you for your kindness of sharing this video. I am having trouble getting the SQL Serve Native Client 11.0. Will that affect being able to follow along with the video?
Made two mistakes in the video. At 26:35, I added weekdays twice. You should add weeknights also. Additionally, At 27:20 for discount it should be (1-discount)
Can you make a .bak file for the database and upload it to make it easier to get up and running? Loading via the data wizard is very problematic as I am using Studio 2019
kindly write out the formula to use for revenue..or what is the correct revenue...lol :,(
Why discount should be (1-discount)? Please explain
@@brilliancetventertainment9416 Hi, it seems you are using Office 64 bit, to solve that issue it's very simple but known to many
Open: SQL Server 2019 Import and Export Data (64-bit) or the exe file: DTSWizard.exe
It will be in this path:
C:\Program Files\Microsoft SQL Server\150\DTS\Binn\DTSWizard.exe
Please let me know if this solved your issue.
@@maxblack396 Revenue amount will be after discount i.e. 80% revenue and 20% discount.
By far the best SQL/Power BI training class thus far!
I love that comment. Share the video with anyone you think it helps
Great way to learn the actual flow of Data from SQL to power bi..
Thanks mate for your support...
can you please help me what should i write at revenue formula
at 26:35
The correct DAX for Revenue is: "=([stays_in_week_nights]+[stays_in_weekend_nights])*([adr]-([adr]*[Discount]))"
Thanks for such a great video, But there are a few concerns I would like to point out, first of all, in regards the Revenue and I believe we can't just simply multiple days and adr, the total should subtract those reservation_status =" Canceled". Secondly, parking lot size question about the percentage of occupation soulld be equal "car parking spaces" /" reservation status "instead of "car parking spaces" /"Total nights" because no matter how many nights you stay, one reservation only corresponding one parking sport.
Great video! I think there's a mistake in minute 27.24. You sum the same columns (stays_in_week_nights + stays_in_week_nights) Instead is (stays_in_week_nights + stays_in_weekend_nights).
Yes
Thank you so much! Stumbled across this video, late one night. Watched it through first; was so easy and clear to follow! You made it all make sense and click for me!!! Thanks again!! Fastest I ever hit the subscribe button lol!
I completed the tutorial. I had issues downloading MSSMS and connecting to the server. I figured that out. Then, had trouble importing the data. I figured out that problem. Smooth sailing after that. Great practice project. Thank you!
Awesome. So glad you were able to get things sorted. You should also try the other projects now
Did you also have a problem with importing thr data? Can you run me through what you did? I keep getting an error when importing from excel
Very useful resources to get familiar with complete data analyst project using sql database and powerBI tools
Glad to hear that
Revenue = stays_in_weekend_nights+stays_in_week_nights *adr
you write it stays_in_week_nights +stays_in_week_nights in adding Revenue column in Power BI it's 10.23M not 14.79M
This video is the end of my search for how to make a project or how a project is made in data analytics
wooohoo! Please share this video with anyone who you think it will help!
I tried to do this in MySQL but the importing of the files was taking FAR TOO LONG so I downloaded MS SQL Server. First time using that flavor of SQL so this will be a learning experience on that front as well.
This is a great alternative!
ua-cam.com/users/shortskWOBZOpyyTE?feature=share4 power bi Dax functions
Great tutorial, but i am not sure if Revenue should really be including the bookings that have been cancelled?
There is a field in the dataset called is_cancelled, and common sense is telling me that the records identified as is_cancelled = 1 should not be accounted for (customers most likely didn't pay for those bookings)
Absent Data after UNION you lost 40k rows. In [8:43] you can see totally is 141k rows and after union [9:10] is only 100k rows. I think you should use UNION ALL because UNION add only distinct values(rows) by default.
love u the great man i have never seen this type of project anywhere in any youtube channe
Thank you for sharing this Project sir. Very helpful and insightful.
Great! I am glad you like. Feel free to share it with someone who it might help.
Thank you so much for this vid. it lifted some weight off my shoulders.
Please can you make a video on automation. From database to powerbi?
Thanks in advance
Great suggestion!
Thankyou sir I love how calm methodical the video is it really helped me
Glad it helped
Great Video, thank you for sharing end-to-end project! I 've subscribed from this Tutorial.
Awesome, thank you!
Having problem in loading the excel file into mysql workbench. any help?
reservation_status_date datatype is text. Before doing Revenue Line chart need to change the data type to date.
The discount you multiplied should be (1-discount), so it will give the exact numbers.
Yeah, otherwise you only take into cosideration the discount amount. Great observation.
after joining the two tables my discount only has a value of 1 or 0. 1 for complimentary and 0 for everything else
This content is gold
Hello, Thanks so much for this great tutorial. I was following the tutorial and realised my results were significantly different. I want to confirm if the dataset was updated after the time of the video. I want to be sure I am on the right path. Thanks again
Hi, I found some of my values were different as well. Could you tell me your values so we can compare them?
Hello, Firstly it is a great project for beginners. 26:20, I think, you did a mistake if I am not wrong. Actually you add stays_in week_nights twice instead of adding stays_in week_nights and stays_in weekend_nights. Thanks.!
can you please fix the bugs of your website?70% of the website is covered with ads and when i remove the add the entire portion becomes white
Really good tutorial / walkthrough of a project!
Thanks! Please share the video and help the channel grow.
why is revenue multiplied by discount
this would not give the real revenue after discount
it should be multiplied by (1-discount )
correct me if i am wrong
Thanks so much for this video, it's tremendous helpful and useful!!
I like SQL, but I think Power query works more fluid for me
Good Point. Just all depends on your access and resources. The SQL will help you limit the am out of data coming into Power BI if required
@@absentdata yes, sometimes it's not possible to use M language, for example with direct query
Hi! Thank you for the guide! It gave me a lot of valuable insight. Can you please provide the kaggle link to the data set? I know that it is hosted in your website as well but I would like to view the kaggle dataset as well. Thank you very much!
great video. just started learning sql and data analytics but i watch these videos and i get a better understanding of what i am learning. question though, why not clean the data? for example where there were null values etc, or is that not always necessary?
Its depends on the use case. However, Power BI is designed for data cleaning. Sometimes, it's easier adlnd more prudent to do it in SQL. However , for a small dataset, its easier do any needed manipulation in Powe Ni
hi, first of all, I really enjoy this video and it was just so much helpful to understand the process to do a project of analysis. I have 1 question, with the union command, don't you leave some register out of the set? because with all the records from the 3 tables, the row count is much higher that the row count after doing the union
Yes, so it should be Union All
revenue calculation = ([stays_in_weekend_nights]+[stays_in_week_nights])*([adr]*(1-[Discount]))
Hey! I accidentally wrote 2018 instead of 2019. And even after correcting it the sum command would only give me the sum of 2018 and 2020. What could possibly have gone wrong ?
@@simplesingh5334 check the union of tables in power query, it's the only idea i think
ua-cam.com/users/shortskWOBZOpyyTE?feature=share4
Power bi dax
Why 1-discount ? Could you please explain it in brief?
@@019_devarghachattapadhyay5 By using (1 - [Discount]), we're calculating the discount value correctly as a percentage off the original price. E.g. if the discount is 0.2, it will calculate as 20% off, resulting in 0.8 (1 - 0.2) of the original price.
I feel there is one more mistake at 36:27 where took adr in place of avg of adr, the same error made for avg of discount. pls, correct me if I am wrong.
at start more thank you , at the second i start work as data analyst so i need excel file to start training and apply steps as i learn it from you , ath the last more thanks agine
Congratulations on your data analyst role. You can get the data set in description
Wow, thank you very much for this walkthrough. This is exactly what I was looking for :D
can you please help me what should i write at revenue formula
at 26:35
while importing the data got the error pre-execute stopped says culture is not supported
Great things to start 💙
grate analysis parts of SQL
I have been stuck for the past 2 hours trying everything possible (with chatgbt) to solve the error Microsoft.ACE.OLEDB.12.0 not found. I dont want to jump right into powerBI like others since the whole purpose for me is to get expereince in building databases and integrating that into my work
ANY help would be appreciated to jump start this
Very good tutorial, thank you.
good job but i think u ve made in error in calculating the revenue = ((stay_in_weekend _night + stay in week ) * adr) * (1-discount)
Thank you
In the dataset, I can see the 2nd column as "is_canceled". for this column we have true=1 and false = 0 value.
Should not we have considered that for actual revenue calculation?
Just need some clarification on my understanding.
Of course, you can consider it.
thanks for the walkthrough
You are most welcomed!
Thank you @ Admin
Thank you so very much for this excellent training Sir! Keep it up!!
Most welcome!
Interesting and great idea!
Glad you think so!
@Absent Data can you make a proper data manipulation video series using SQL, I've searched everywhere and it seems there aren't many sources available online that dig deep into data manipulation using SQL.
It's crazy, bi experts have a short term window to be savants then AI
It turns out you need to install sql server to use the ssms
why not apply this filter for me>>??
helped alot... thanks ...
The revenue calc is incorrect, adr * discount gives the discount value. It should be (1 - discount)
I noticed this also in my analysis,
Thank you so much for this great video. very kind of you. I am unable to correct the mistakes. Please help. Thank you very much again.
Hello sir, this is much appreciated and very helpful project. However, I was enquiring if you can share the dataset so that we can also practice on it. Thank you
The dataset is in the description. :)
@@absentdata URL is www.absentdata.com/hotel_reve...
I'm asking a question! Why do I utilize SQL Server when you have Power Bi and can join and combine all of your table with it?
A few reasons. It most organization data is stored securely in database. For data governance and security, having a single source of data in a database, data lake or data warehouse is needed. You can bring in the data with manipulating it from the database to Power BI, However, if you can improve the performance by structuring the data in the database, you can improve the performance of the dashboard.
Great tutorial!
I'm having the hardest time with this error:
TITLE: SQL Server Import and Export Wizard
------------------------------
The operation could not be completed.
------------------------------
ADDITIONAL INFORMATION:
The 'Microsoft.ACE.OLEDB.16.0' provider is not registered on the local machine. (System.Data)
------------------------------
BUTTONS:
OK
------------------------------
Any advice?
I am getting an error "The 'Microsoft.ACE.OLEDB.15.0' provider is not registered on the local machine. (System.Data)"
I've installed accessdatabase_x64 for 64 bit OS and still not working when trying to import excel data into SSMS
Hey I too got the same problem did you find the solution
Why I can’t upload the excel file on management studio ? It only accepts up to Excel 2016 and my office is 2019, I receive errors. What should I do ?
Turn it into a CSV. Just save the Excel file as CSV then upload.
9:13 can I know why you used union instead of union all. Thanks 🙏
Thanks for your work!
I am getting an error when I try to import the data
TITLE: SQL Server Import and Export Wizard
------------------------------
The operation could not be completed.
------------------------------
ADDITIONAL INFORMATION:
The 'Microsoft.ACE.OLEDB.16.0' provider is not registered on the local machine. (System.Data)
------------------------------
BUTTONS:
OK
------------------------------
I am trying to learn sql and I love how you are explaining everything. I tried to use union exactly as you did but I keep getting the same error.
"Msg 205, Level 16, State 1, Line 1
All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number of expressions in their target lists."
I honestly don't even know what this means or what to do next. I've been stuck for two hours. I just want to combine my three tables. I also looked up other ways. I keep running into issues using inner join and full join.
Thank you for the compliment. This error usually occurs when you have different number of columns in the Union. I would start from scratch again if you following along in the tutorial.
@AFIFI EL-KADY Thanks, I realized I forgot the ")" at the end of [ '$2020$' ]
make sure you're writing the query on the database you created by right clicking on the database name and select new query. that resolved my error
@@ngoziokonkwo5280 I am trying to use MS SQL but I have always been stuck even after uninstalling and reinstalling, I keep getting an error message like this
"Error 0xc002f210: Preparation SQL Task 1: Executing the query "CREATE TABLE [dbo].['2018$'] (
[hotel] nvarchar(2..." failed with the following error: "Culture is not supported.
Parameter name: culture
3072 (0x0c00) is an invalid culture identifier.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly."
Oops. Am i the only one who got stuck at the very beginning?
Could anyone please help me to figure out what should i put into "Server name" field at 2:30?
What i have is an empty one, and anything i add (name of my PC?) in it causes an error.
How to connect to existing server or create a new one?
Thank you.
I have exactly the same problem! Could use some help?
Solved it: ua-cam.com/video/-Na6Ub9gCOs/v-deo.html
Kinda strange this isn't explaiend in the video, but it does seem logical.
@@lucasdelange4153Thanks a ton, Lucas! I literally have been waiting for solution :)
anyone please help me to import this excel file into sql serve! it showing error "The 'Microsoft.ACE.OLEDB.16.0' provider is not registered on the local machine. (System.Data)" I installed but still showing same issue.
Have the same issue as well. Did you manage to solve it?
@@MrHassaballahJR I just directly imported in normal way as we do
Thank you so much Bro's
how did u get that year column at 41:00
Hai sir Iam facing a problem while importing data "The Microsoft. ACE.OLEDB.16.0 Provider is nit registered on the local machine.(system.Data)
Knowledgeable thank u
Thanks and welcome
Hello. Shouldn't the sparklines for adr and discount show the average and not the sum? Is this a mistake or am I thinking about it wrongly?
Would there be a reason why the tables do not appear after the importation process? I'm not seeing any of the tables I selected and everything said successful at the end.
Hi, this is wonderful. May I use this in my portfolio projects?
Yes of course!
thank you so much
just for clarity and a more realistic output, shouldn't one not count the information that contains cancellations? it would give a fluffed output in reality.
Sure. Add it to your anslysis
God work
im not getting native client option in dropdown list while importing please help
What in case of excel data updates every day..and we want to create data base
Hi Thank you very much for your tutorial. sir, can you please explain me how you copying and pasting visualization.
Thank you.
Copy and pasting which visualizations. You can export them out or you can just you the snipping tool and import it
27:15 why a custom column? A measure would work better? 🤔
Measure or column would work. I wanted to keep it simple by using similar actions from SQL to Power BI. However measure works perfectly and keeps table smaller.
wow your explanation is very good. do you have anything specific to sql where you teach from beginning ? Thanks
I will have some videos soon!
Hello, questions please... you mentioned that 2020 seem to have incomplete dataset... kindly explain why you concluded that. Thanks & am really enjoying working on this project step by step with your guidance 👍
I think he infered that by the numbers being quite a bit lower than 2019. It would either imply that 1) the dataset for 2020 is incomplete, or 2) the trend is going heavily downwards. You could easily verify this by examining the max date of the date column.
5 minutes into the video and I have run into a bunch of errors trying to debug the import wizard with SQL Server and SSMS. Had to save the file as compatibility given the different versions being used here, and again ran into errors. By any chance could you upload another similar guided project with an updated SSMS / SQL / Excel version? Or if anyone else has been running into Microsoft Jet database engine errors, how did you fix it?
am having error connecting my excel dataset to sql server
Did anyone have a problem import the data into MicroSQL? I received error messages for 2018-2019-2020. Can anyone help?
Did you find the solution to this error I got some error around 5:22 it stated “culture not supported”
Hello! I'm using MySQL for this project and trying to connect it to powerBI.
I received an error message like this
"Details: "Microsoft SQL: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)"
Do you know how to fix it? I'm certain my database name is correct.
Since this is a tutorial on Microsoft SQL Server, the instructions don't apply to MYSQL
If i can perform this kind of analysis can I already become a entry level DA? Or this activity is just the very basics? Pls answer
There quite a few analysis videos. I would finish those slso
I am having this error while importing Error 0xc002f210 it does not allow all the tables to be imported. Kindly assist
Please I had the same error did you manage to find a solution to this
Hi there, great tutorial. Just have a question, I have installed on my laptop mysql and postgte SQL. Can I use them to follow the course or I m forced to download sql server?
Thanks upfront
Yes but some of connection from MYSQL will not be the same as Microsoft SQL Server Studio
hello Can you tell me where I can get those data ? thank youuuu
In the description
hello sir , i have error importing my data " Exception of type 'System.OutOfMemoryException' was thrown. (mscorlib) " when importing data
Thank you for your kindness of sharing this video. I am having trouble getting the SQL Serve Native Client 11.0. Will that affect being able to follow along with the video?
Yes, you will but your SQL syntax might be slightly different..
I am getting an error when using with. any idea what could it be?
thanks for doing this
i installed Microsoft ACE OLEDB 16 , but the error does not disappear , if any one could helpe me ????
I am not getting SQL SERVER NAtive client in destination. What to do?
You need to pay attention to what version of MSS Studio you downloaded. Is it the one from the video or the new one
The new one. As of now I selected 'Microsoft OLE DB Provides (MSOLEDBSQL) for SQL Server' as destination. Is it correct?@@absentdata
hi @absentdata, is this server still accessible? I am unable to connect. Could you please help?
I think you need to rewatch the video the server is your computer so it is definitely available
I am not able to upload the files please help me anyone
it says (provide is not registred on the local machine(system.data)