End-to-End Data Analysis Project 2024 | SQL & Power BI | Beginner Friendly

  Рет қаралды 153,891

Absent Data

Absent Data

Күн бұрын

Пікірлер: 184
@ashantileigh2520
@ashantileigh2520 2 күн бұрын
Oh my goodness. This is gold. I am a current computer science major who recently figured out I am infatuated by data. I have been trying to figure out exactly how to start my journey to be becoming a data engineer or at least get close to the field. And you my good sir have given me that and so much more. Thank you so much and continue making awesome Informative content.
@absentdata
@absentdata 2 күн бұрын
What an awesome comment! You are very welcomed. Please share it with anyone you think it can help. Also check out the other projects in the playlist.
@JW-pu1uk
@JW-pu1uk 6 ай бұрын
This is phenomenal. I am an experienced Data Analyst and just clicked through some of the video, but the learning here is invaluable for people wanting to break into the field. I use Tableau in my job and some Power BI, so even I'm learning some new things. Thanks!
@absentdata
@absentdata 6 ай бұрын
That is a great comment and endorsement based on your experience. This definitely motivates me to keep sharing content! Thank you!
@diamondsandlipgloss
@diamondsandlipgloss 5 ай бұрын
@@absentdatamy thoughts exactly
@sandeepkhawas3367
@sandeepkhawas3367 7 күн бұрын
🥲🥲 literally i have tear in my eyes...it's been two year as i had lost in power bi and whenever i go to interview they ask have you done any project? also ask about SQL connectivity with BI .....now i just see your videos it's new hope for me !! ☺ we should never give up .. please upload such kind of videos more many thanks to you brother!
@absentdata
@absentdata 6 күн бұрын
This is truly the best comment ever! I'm glad it was helpful. Check out he other videos in the playlist. Also share with anyone you think it will help.
@sandeepkhawas3367
@sandeepkhawas3367 5 күн бұрын
@@absentdata thanks for your reply will do that !
@olugbadebenjamin2273
@olugbadebenjamin2273 6 ай бұрын
This is super good content! I'm a BI Analyst myself and when I was learning to be an analyst, I could not find anything like what you just did in this video.
@EnzoCossa
@EnzoCossa 5 ай бұрын
This is my second video on data from Absent Data. I am extremely grateful for the content he has been providing.
@absentdata
@absentdata 5 ай бұрын
Glad you like the channel.
@Erina-g5k
@Erina-g5k Ай бұрын
Very helpful video for beginners. Please upload more videos like this which will help beginners to step into data analyst job. Thanks for your valuable content
@absentdata
@absentdata Ай бұрын
Check out the playlist
@DanurOsda26
@DanurOsda26 4 ай бұрын
I want to say thanks a lot for your video. I decided to switch my career to be a data analyst/business analyst and started the journey a few weeks ago. After looking at other people's CV & portfolios, who switched careers, I wanted to start building some projects before I apply to any data analyst roles. Then I found this video and started to follow along two days ago. Given the limited time I have, because I also have a corporate job, I've finished the process today and feel like I've achieved something meaningful. Thanks again and please keep sharing. Best regards.
@absentdata
@absentdata 4 ай бұрын
Hii I wanted to wish you the best in your career shift. I know its a great idea because the demand for good analyst is growing. I am really happy my video help you. Please share it with anyone who needs help.
@ruchisinsinwar7359
@ruchisinsinwar7359 3 ай бұрын
hi, i also want to switch my career, can you please help me regarding this ?
@rohanmp1499
@rohanmp1499 Ай бұрын
bro even im planning on switching to datat analyst do you want to connect?
@rohanmp1499
@rohanmp1499 Ай бұрын
@@ruchisinsinwar7359 bro do you want to connect?
@vladovodenicharov6014
@vladovodenicharov6014 4 ай бұрын
Hey, I just wanted to let you know that I found out about your channel tonight and it is amazing. There are many great data-related channels on KZbin, but yours is pure gold. I would say this is the most practical content I have seen so far. One tip would be to switch to a better microphone because at some points, the audio quality is not great.
@niteshshet9143
@niteshshet9143 Ай бұрын
Thank You For this video, As a Beginner in Data Analytics it was extreemly helpful for me, got the understanding of how a Data analytics process would be done in a company.
@absentdata
@absentdata Ай бұрын
Glad you found it helpful
@PreplyshortVid
@PreplyshortVid 4 ай бұрын
I love all your vudeos i just finished your first two Data Analyst Portfolio projects and i can't wait to do the third. That would make it my fourth data analyst portfolio project
@absentdata
@absentdata 4 ай бұрын
Awesome! Thank you so much for watching the videos.
@srab9260
@srab9260 6 ай бұрын
Pls do more of these! Your vids r super helpful for newcomers who r tryna break into DA industry.
@absentdata
@absentdata 6 ай бұрын
Awesome, Please share these videos. I would love to do more. Your support is appreciated.
@amadurrahman2830
@amadurrahman2830 18 күн бұрын
I have been looking for this type of Video. Thank you for your work and sharing your knowledge! i am new to The Data Analyst World so this is really great for me. Even in my College They did not teach me like this.
@absentdata
@absentdata 18 күн бұрын
Glad you found it. Check out some other videos on the playlist. Also share with anyone you think it will help.
@amadurrahman2830
@amadurrahman2830 18 күн бұрын
@@absentdata Thank you again really valuable. But I wish your Audio Quality was little better i had hard time listening to what you were saying. But the video Quality is really good.
@lesliewilliams5510
@lesliewilliams5510 24 минут бұрын
#ThankYou ... Call to Action (CTA) "please provide analysis for raising prices next year ... Love that!
@emmanueloffei668
@emmanueloffei668 2 ай бұрын
Great Content. Picked up good analysis strategies and query techniques
@absentdata
@absentdata 2 ай бұрын
Glad to hear that
@raphaelemmanuel-gwar3757
@raphaelemmanuel-gwar3757 5 ай бұрын
Great video man 💯…was so lost in power BI but now I now I can integrate SQL, Excel and Bi all at once thanks to you
@absentdata
@absentdata 5 ай бұрын
So glad. It helped you make sense of things. Please share it with anyone you think it will help
@JulieAkin-John
@JulieAkin-John 4 ай бұрын
Thank you for this. I was able to complete this and add to my portfolio
@absentdata
@absentdata 4 ай бұрын
Awesome! I am glad you completed the dashboard. Feel free to share it on social media also
@uchejames409
@uchejames409 3 ай бұрын
Thank you so much. This video has given me great insight on a real-life project as I transition into data analysis. I appreciate this. 🙌
@cheesenutz3854
@cheesenutz3854 5 ай бұрын
im an aspiring data analyst and you channel is a gold mine thank you so much
@absentdata
@absentdata 5 ай бұрын
Great to hear! Its great that you a starting your journey as a data analyst. We need more good ones!
@jordanb4324
@jordanb4324 3 ай бұрын
Great video walkthrough on using SQL and Power BI. I learned so much!
@herculesgixxer
@herculesgixxer 5 ай бұрын
Great vid- practical, easy to follow, applicable… thank you!
@Mostafa-e1y
@Mostafa-e1y 2 ай бұрын
Very informative 🙏💯
@arshadsyed1440
@arshadsyed1440 2 ай бұрын
Shukriya Bhai is video k liye 😢، Allama Ehsan Elahi Zaheer ko Allah tala unko jannat firdous ala darzah de
@dinahany233
@dinahany233 Ай бұрын
THANK U SO MUCH FOR THE INFORMATIVE TUTORIAL .. APPRECIATE IT
@absentdata
@absentdata Ай бұрын
My pleasure!
@newenglandnomad9405
@newenglandnomad9405 6 ай бұрын
What a fabulous video. The sql query was very beginner level. The dashboard was relatively easy to make. Ran into a few issues in PowerBI that I had to research google to fix, but that was my issue, not due to your video. I struggle mostly with the recommendation at the end only because I've never been asked analyze anything before. I'll have to review the numbers more so i can understand what you recommended. The only issue I really have with it, is that the csv date days don't match. In other words, I don't think day 0 equals Sunday. However that would be data cleaning and the point of the video was dashboard project practice, which I'm grateful for. Thanks for making this, it was super helpful. Can you make an intermediate or advanced beginner level video?
@absentdata
@absentdata 6 ай бұрын
What area do you want to improve? The channel has some intermediate to advanced SQL analysis and Python videos
@newenglandnomad9405
@newenglandnomad9405 5 ай бұрын
@@absentdata I've gotten more practice with queries and dashboards. Personally, the recommendations are my struggle. Providing the solution to the stakeholder. I feel like I can only solve so much via fake data for projects. I'll look into your other videos. Thanks for all your fantastic content.
@absentdata
@absentdata 5 ай бұрын
@@newenglandnomad9405 If you are struggling with recommendations. I would advise you to start off with a actual problem statement or hypothesis. This gives you a clear path to answering stakeholder questions because this problem statement or hypothesis should be derived with the stakeholder. Then you can prove or disprove the hypothesis through analysis. Just randomly analyzing data and looking for insights is not effective at all. Here are a few videos that will help kzbin.info/www/bejne/pYizYWNjg7Ojj6csi=LZMwOd9S7lMNxuRk kzbin.info/www/bejne/oqvZdKFuidlolbc&ab_channel=AbsentData
@finishfinish4370
@finishfinish4370 4 ай бұрын
Thank you for making this video! it helped me get started with sql and power bi
@absentdata
@absentdata 4 ай бұрын
Glad to hear the video was easy ro approach.
@Sirigineedi_Navann
@Sirigineedi_Navann 6 ай бұрын
This was the most awaited video thanku so much 😊❤
@Lone.wolf004
@Lone.wolf004 5 ай бұрын
OMG this is so helpful. Thank you very much sir! more of this kind of tutorial/walkthrough for Data Analytics. more power to you as well!
@absentdata
@absentdata 5 ай бұрын
Thank you for the support. Please share it to anyone who you think I can help.
@mirgengjimi9377
@mirgengjimi9377 Ай бұрын
The measure for the profit margin should be calculated as : Measure(Profit Margin) = (sum(Query 1[revenue])- sum(Query 1[profit]))/sum(Query1[revenue]). This is because the definition of profit margin is that it is the difference between total revenue and profit all divided by total revenue, to understand what part of total revenue is real profit. We shouldn't divide it by profit itself. Definition of revenue: Total money that you get from sales. Definition of profit: Total money from sales after you have subtracted all business expenses(rent, electricity bills, gas, debt payments). Thank you for the helpful tutorial.
@FeliciaPrah-j6i
@FeliciaPrah-j6i 3 ай бұрын
Thank you for your video. It clarifies what a data analyst will possibly work on the job.
@absentdata
@absentdata 3 ай бұрын
I am glad it was helpful!
@alexiopfumai6299
@alexiopfumai6299 5 ай бұрын
Good explanation...Please do more videos like these
@absentdata
@absentdata 5 ай бұрын
Thank you! I will. Please help me share the video.
@aishwaryapattnaik3082
@aishwaryapattnaik3082 3 ай бұрын
Great content always 😍. Can you please upload advanced level complete Data Analytics projects in Power BI, Excel & SQL
@aditya3david
@aditya3david 6 ай бұрын
This awesome as usual easy to understand and follow
@absentdata
@absentdata 6 ай бұрын
Glad that is was easy to follow
@mariamintova5752
@mariamintova5752 3 ай бұрын
Thank you! Great content. 👏
@ariwinard7037
@ariwinard7037 Ай бұрын
Love it, helpful...
@absentdata
@absentdata Ай бұрын
Glad you enjoyed it
@EnterpriseDNA
@EnterpriseDNA Ай бұрын
Amazing content as always
@GabrielGarcía-v6o3m
@GabrielGarcía-v6o3m 3 ай бұрын
Great video i love it! One thing if the price is per rider the cost should be per rider as well on the revenue. Minute 22:21. Thank you so much for the video
@GabrielGarcía-v6o3m
@GabrielGarcía-v6o3m 3 ай бұрын
You solve it a min 44:15 LOL. It was all planned to cover Powerquery? Dude loved your video so much. Thank you!
@AntonioJrArbiz
@AntonioJrArbiz 2 ай бұрын
Thank you so much im learning some new things.
@absentdata
@absentdata 2 ай бұрын
Happy you are learning
@azamkhan001
@azamkhan001 Ай бұрын
Hi Gaelim, I hope this message finds you well. I’m currently transitioning from an Electrical Engineering background into Data Analytics, and I must say, your videos have been incredibly helpful in providing clarity on where and how to begin this journey. I've watched several of your tutorials, particularly those on becoming a Data Analyst, and they’ve been very insightful. I’m based in Australia, and I’m starting with SQL Server and Power BI, aiming to master these tools as they are widely used in the majority of companies here. Would you recommend any other key skills or tools that would be valuable for me to focus on at this stage? Thank you for your time and great content.
@sencxx6368
@sencxx6368 6 ай бұрын
we need more content like that please !
@absentdata
@absentdata 6 ай бұрын
Glad you enjoy this walkthrough. Please share this video with anyone you think will help! I would love to make more if it's successful!
@ChimpoTalksGaming
@ChimpoTalksGaming Ай бұрын
Hot dang, Kermit. Great job.
@absentdata
@absentdata Ай бұрын
Hilarious 😂
@MarcosPaulo-xt7xs
@MarcosPaulo-xt7xs 5 ай бұрын
I had some problems with different values ​​than yours when it came to the dashboard, I don't know what happened, for example: Number of riders on yours was 3M while on mine it was 5M, along with several other different values. I did everything like you from the beginning, but I downloaded the database via csv on kaggle, but I believe that wasn't what made this happen. Thanks for this video, i made my first Data Analyst project for my portfolio. Now I will search a project realized in Python and other in Excel for fill my Portfolio moreover.
@absentdata
@absentdata 5 ай бұрын
try some of the projects on this channel which cover Python also.
@MarcosPaulo-xt7xs
@MarcosPaulo-xt7xs 5 ай бұрын
@@absentdata for sure. I loved this channel and I will improve myself with the projects I learn here. Thank you again!
@femiajewole6891
@femiajewole6891 5 ай бұрын
Thank you. Very informative
@ntsps9614
@ntsps9614 3 ай бұрын
Hi, thank you for sharing this cool project! I use Mac M1 and have to download Azure data studio instead. Azure couldn't map the dteday column as datetime format and the files couldn't be imported. I had to format that column as string instead and it went through fine. I am wondering if there's any other way to import the file with the dteday properly imported as datetime with Azure?
@karimblake4684
@karimblake4684 3 ай бұрын
Another masterpiece, you always deliver great content. Question, should profit margin be revenue - cogs which gives gross profit or profit margin, then divide gross profit by revenue to get profit margin%? Thank you.
@diamondsandlipgloss
@diamondsandlipgloss 5 ай бұрын
This was amazing, I learned so much. Do you have videos on how to write a recommendation ......PLEASE 🥺
@luberengajohn3463
@luberengajohn3463 3 ай бұрын
Thank you so much!
@lijunchen
@lijunchen 6 ай бұрын
This is a great video from beginning to end. Using the new card visual as a placeholder for the sections is a great idea. But I just wonder whether this will slow down the visualization. Can we just use the Shape for the section background?
@absentdata
@absentdata 5 ай бұрын
There shouldn't be any performance issue if the value is turned off. If you did have a value there as long as it's not a calculated value that was created with DAX, no additional resources are needed. So either way no dlowdown
@clair5385
@clair5385 6 ай бұрын
awesome work
@absentdata
@absentdata 6 ай бұрын
Thank you
@SaadKhan-yd7ss
@SaadKhan-yd7ss 4 ай бұрын
I think you got the profit margin formulal wrong. It should be Profit / Revenue
@skova2735
@skova2735 3 ай бұрын
Great presentation. I have stuck with SUM issue. When I perform Measure = (SUM(Query1[revenue]-SUM(Query1[profit])/SUM(Query1[profit] function, the error pops up "The SUM function only accepts a column reference as an argument." Ive tried different approaches without success. Also, there is a message "cannot find parameter [revenue] Please help.
@john_blues
@john_blues 5 ай бұрын
The most accurate thing here was "...Please provide this asap". 😂
@bossonfire5110
@bossonfire5110 3 ай бұрын
Very important is that the per rider you have to subtract the COGS. in your video you made to much profit that makes no senes everey unit needs the same amount of COGS. (riders * price -(COGS * riders))/ 100 as profit
@frankdosu4651
@frankdosu4651 3 ай бұрын
Hi, thanks a lot for the video. i'm having some issue to calculate the revenue. everytime I try I have this message "Operand data type nvarchar is invalid for multiply operator" . i try to change the data type even if I can see number in the price riders column but then the price column is not regnized. Do you have an idea ? thank you
@AnasM24
@AnasM24 6 ай бұрын
Thank you sir
@absentdata
@absentdata 6 ай бұрын
You're welcome
@valenciawalker6498
@valenciawalker6498 6 ай бұрын
Thank you
@Mr.NgameniGilbert
@Mr.NgameniGilbert 5 ай бұрын
Thanks for the video!! How came your dtedate at 36:42 happened to include all the year, months, day and quarter??
@absentdata
@absentdata 5 ай бұрын
Dates in Power BI. Have an automatic hierarchy. So date --> month--> quarter--> year is the hierarchy
@jeilanyluna7161
@jeilanyluna7161 2 ай бұрын
@@absentdatahow do I fix this?
@ChraXoshnaw-u9p
@ChraXoshnaw-u9p 3 ай бұрын
I didn't understand how did you calculate the price settings, please clarify
@PratyushGautam-kh7nh
@PratyushGautam-kh7nh 2 ай бұрын
For me, There is no option coming in new card to add image URL. Here in image field it is coming like add data, when I click that it is showing all the Columns names and a search window 😢
@xzoo4033
@xzoo4033 Ай бұрын
You can algo make those formulas using DAX in Powerbi, but its good no know how to do it in sql.
@absentdata
@absentdata Ай бұрын
I totally agree with you.
@okongwukizito8876
@okongwukizito8876 5 ай бұрын
Thank you for this video, it is really helpful. A quick question, how did you take out the highlight 'invalid object name bike_share_yr_1' and for the cost_table?
@njacob4338
@njacob4338 3 ай бұрын
The error will be removed in SSMS by refreshing the local cache. Edit -> IntelliSense -> Refresh Local Cache
@mxrkb10
@mxrkb10 4 ай бұрын
This is easy and very helpful! Can I make this and add it for my portfolio?
@absentdata
@absentdata 4 ай бұрын
Of course, you can add it your portfolio
@osehiedavid4055
@osehiedavid4055 3 ай бұрын
How did you get to format the dteday column as a datetime? mine is importing as varchar.
@mildamaulida916
@mildamaulida916 4 ай бұрын
Thank you for this video I love it. but when I try to import data, the columns in the temp and atemp sections don't have dots (.) why? even though the data type is already float. Please reply
@DFact13621
@DFact13621 6 ай бұрын
Great content. Just a newbie question, may I ask why did you create database from SQL when you can just get the data from excel to PBI?
@absentdata
@absentdata 6 ай бұрын
Most data does not exist in Excel sheets. Most data is going to be in SQL databases. So as an analyst you need to know how to extract data from databases.
@diamondsandlipgloss
@diamondsandlipgloss 5 ай бұрын
@@absentdata and I need hands on experience with it, so this project is EXACTLY what I need....THANK YOU A MILLION TIMES OVER!!!!!!
@parajf
@parajf 4 ай бұрын
Please show how to connect realtime data streaming from Mysql to power bi
@CB-yc6wz
@CB-yc6wz 21 күн бұрын
Keep getting the error "Operand type clash: time is incompatible with float" when I add the profit query (riders*price -COGS as profit) -- Any idea what's causing this? My code looks just like yours
@elorm116
@elorm116 4 ай бұрын
Hello sir, in the weekday column, what days do the numbers 0 to 6 represent?
@marthaakhimien7182
@marthaakhimien7182 6 ай бұрын
Awesome Visualization, please are u on LinkedIn?
@absentdata
@absentdata 6 ай бұрын
Yes my LinkedIn is in the description
@diamondsandlipgloss
@diamondsandlipgloss 5 ай бұрын
1) 12:10 how are we able to see that the query has gotten larger? 2) would you advise that I complete this project & use it for my GitHub that's linked to my resume?
@absentdata
@absentdata 5 ай бұрын
1. Do you mean the data from the query. You can look at the rows of data brought in from the query over time. if more data is added the size of the data will change. 2. Its always good to have dashboards to present and portfolio and walk the interviewer through the data pipeline, transformation and visualization steps.
@Nuafufeyin
@Nuafufeyin Ай бұрын
i got a blank column before the months when creating the matrix visual how can i fix it please ..
@hungnguyen-ch4ui
@hungnguyen-ch4ui 15 күн бұрын
I changed the data type of "hr" to Whole Number, and then all cards turn into error. Could you please help me to navigate this error?
@jujuthegerber
@jujuthegerber 6 ай бұрын
Hello, great content, very educational. But, I have a question: Why would you calculate the profit margin as "( revenue - profit) / revenue" when in SQL you already did "revenue(riders*price) - COGS(riders*COGS)" and named it as "profit". It doesn't make sense to me to deduct the profit from the revenue and then divide it with the revenue. Shouldn't it be " profit/revenue " to get the profit margin? Thank you.
@absentdata
@absentdata 6 ай бұрын
Yes, that's fine way to do it.
@jujuthegerber
@jujuthegerber 6 ай бұрын
@@absentdata okay, thank you!!
@E-AKN
@E-AKN 2 ай бұрын
9:00 i did exactly like you but in results give me error about column "atemp" i fixed this problem by allow nulls but again give me warning about 6 data deleted.
@mrbartuss1
@mrbartuss1 6 ай бұрын
Why do you calculate profit margin this way? Shouldn't it be (Revenue - COGS)/Revenue or simply Profit/Revenue?
@absentdata
@absentdata 6 ай бұрын
Yes you can calculate it that way
@mrbartuss1
@mrbartuss1 6 ай бұрын
@@absentdata The number is different then
@UzukwuMichael
@UzukwuMichael 6 ай бұрын
@@mrbartuss1 please you will get same result if you calculate the profit by subtracting value of revenue from the COGS column. alternatively in the video he made it explicit by using the riders * price which will give you same value as the Revenue. so it's same thing.
@DDiveBK24
@DDiveBK24 Ай бұрын
do we have any version of SQL Server Management Studio (SSMS) for MAC users?
@absentdata
@absentdata Ай бұрын
I'm not sure about MAC but you should be able to use it
@rhodreque8155
@rhodreque8155 6 ай бұрын
Hello, what if the data needs to be cleaned before analysis? How does 1 use SQL to go about that?
@absentdata
@absentdata 6 ай бұрын
While that can be som data cleaning done tgrough SQL. It's better to have this done prior to loading in a database or do the cleaning after you extract the data from the database
@rhodreque8155
@rhodreque8155 6 ай бұрын
@@absentdata Any instructional video on how to go about that?
@ugochiohans4572
@ugochiohans4572 4 күн бұрын
The sql server isn’t opening even after downloading 😢
@kwakuayisa8481
@kwakuayisa8481 6 ай бұрын
Hi, not sure if I'm the only one running into this issue but for both the bike share tables the date format changes from cell A288 downwards and excel refuses to recognize it as a date. Any help with that would be appreciated.
@absentdata
@absentdata 6 ай бұрын
These are CSV, not Excel files. Follow the instructions there should not be any issues. Make sure you download the files as raw from Github
@kwakuayisa8481
@kwakuayisa8481 6 ай бұрын
@@absentdata let me clarify. I know they are CSVs. I opened them in Excel to inspect the data. Uploaded them into Power BI using MySQL and I noticed an error with the date format. So went back into the file to try and figure out what's wrong. That's when I noticed the difference.
@absentdata
@absentdata 6 ай бұрын
There are no instructions for MYSQL this is a completely different DBMS. I would require different instructions
@diamondsandlipgloss
@diamondsandlipgloss 5 ай бұрын
I was having a similar issue, but just click on the link to open the files & download them somewhere on your pc w/o changing the format...I was thrown off because the files in the video are Excel but the files in the link are csv. On another note, you can convert csv files to excel, but that's not req'd for this step. I hope I made sense.
@akhildharimisetty2767
@akhildharimisetty2767 2 ай бұрын
Iam unable to use riders individually 😢 tried a lot
@nishantkulkarni630
@nishantkulkarni630 4 ай бұрын
Hello, during this project I am facing an issue to load data into power bi from sql server. I tried several ways to resolve it but unable to solve. error occurs when I load the data into power bi in the last tab by selecting "Use Current credentials" after this step the error message is " We couldn't authenticate with the credentials provided. Please try again." IF anyone can help me with this it will be very helpful for me.
@rishithp3077
@rishithp3077 3 ай бұрын
I use linux , so what should i be downloading?? can anyone help me setup everything in linux please
@anindadatta164
@anindadatta164 5 ай бұрын
Good video but where is the need to bring in MySQL here, as you are not doing any transaction here. All excel files like bikeshare and others could have been straightaway imported into power BI, Tables could be merged in power query and links between tables could have been established in data model option
@absentdata
@absentdata 5 ай бұрын
Most data lives in databases. It's important as an analyst to be able to use SQL to extract data
@RK-wf7re
@RK-wf7re 4 ай бұрын
True
@issasesay572
@issasesay572 5 ай бұрын
so let say this is a real life scenario, will the company provide the data you work with?
@absentdata
@absentdata 5 ай бұрын
Yes, in a real-life scenario, a company will give you access to their data. Most companies house their data in a database
@issasesay572
@issasesay572 5 ай бұрын
@@absentdata Thanks!
@ugochiohans4572
@ugochiohans4572 4 күн бұрын
I wish you provided us with your data
@absentdata
@absentdata 3 күн бұрын
It's in the description
@cjbrown3396
@cjbrown3396 5 ай бұрын
Dude how do you show the column tools on 33:50 ? I can see you skip the process.. I can't find the column tools in report view, only in data view.
@absentdata
@absentdata 5 ай бұрын
To make the colum tools appear in the top menu, you just need to click on a column in your table, and the colum tools menu will appear in the top ribbon.
@cjbrown3396
@cjbrown3396 5 ай бұрын
@@absentdata Thank you so much. I have found it. Now I would like to know how do I adjust the month to numeric type? Appreciate you
@bossonfire5110
@bossonfire5110 3 ай бұрын
my Price column and my COGS column from cost_table is not a float value its 399 & 124 rather than 3.99 and 1.24 what can i do to fix it. Appears at minute 20:29. I couldn't fix it... I implement the list new and in the process i set the DATATYPE to navchar(50) now it shows correct float values BUT i cant multiply the values to revenue bbecuase of incorrect DATATYPE in first instance i fixed it with this piece of sh... with cte as ( select * from bike_share_yr_0 union select * from bike_share_yr_1) select dteday, season, a.yr, weekday, hr, rider_type, riders, price / 100 AS price, COGS / 100 AS price, riders * price / 100 as revenue from cte a left join cost_table b on a.yr = b.yr maybe its a bug in Microsfot SSMS
@mohamedcfwoobay
@mohamedcfwoobay 6 ай бұрын
Starting to love the content, but I'm facing difficulty inserting the XML file to my SQL database. It keeps giving No null error fr atemp, and temp column
@absentdata
@absentdata 6 ай бұрын
There is no part in the video that has XML files
@mohamedcfwoobay
@mohamedcfwoobay 6 ай бұрын
@@absentdata I have resolved the issue, thanks
@absentdata
@absentdata 6 ай бұрын
Awesome!
@nw_content
@nw_content 5 ай бұрын
Hi sir, just a quick question. The .csv files are normally extracted from a sales system or such. Do we need to clean the data in Excel again or no?
@absentdata
@absentdata 5 ай бұрын
It really depends on the data source. So data can be extract from a sales platform that is dirty and needs cleaning. However, usually when data is in a database. It has undergone some ETL which may fix many cleaning issues.
@ceyhunerdogan1310
@ceyhunerdogan1310 6 ай бұрын
Thank you sir. can you share the dataset? excel file or
@absentdata
@absentdata 6 ай бұрын
Yes all of this is in the description
@chiomaozurumba2060
@chiomaozurumba2060 5 ай бұрын
Thank you, my server name didnt populate while installing, what do i do
@absentdata
@absentdata 5 ай бұрын
Be more specific. What name didn't populate
@ChraXoshnaw-u9p
@ChraXoshnaw-u9p 3 ай бұрын
I need the link of your giphy animation...
@putulsaini6788
@putulsaini6788 5 ай бұрын
@absentdata sir in my data price showing 3.9900000, cogs showing 01:24:00.0000000,COGS showing time(7) as type, please sir help me in this
@absentdata
@absentdata 5 ай бұрын
Change the data types
@putulsaini6788
@putulsaini6788 5 ай бұрын
@@absentdata done sir.... about to finish this project, thank u nd best explanation
@tyebrown4264
@tyebrown4264 5 ай бұрын
I had trouble getting the data into SQL Server. It would not allow the date/time2 format for the dteday column. Did anyone else experiance this?
@absentdata
@absentdata 5 ай бұрын
Maybe turn of auto or rich data type feature
@hanansaeed3694
@hanansaeed3694 5 ай бұрын
i am facing the same issue. Any luck solving it?
@MadeForD
@MadeForD 4 ай бұрын
oh shiii Tokyo Revengers???
@absentdata
@absentdata 4 ай бұрын
Huh?
@MadeForD
@MadeForD 4 ай бұрын
@@absentdata nvm i thought you know the "Toman bike" reference. That sample data you got was probably from someone who's a fan of the anime Tokyo revengers. Basically Toman is the name of the gang of bikers that's in the anime. Nvm
@TheCodeWhisperer0o0
@TheCodeWhisperer0o0 3 ай бұрын
Please for god's sake improve your mic's quality, the video and the project is great, but the voice/mic is not 😭
@dessi7692
@dessi7692 5 ай бұрын
Where can i find sample data as these?
@absentdata
@absentdata 5 ай бұрын
Check Kaggle. Its a good source for sample data. You can also check out my website that has some data sources. absentdata.com/data-analysis/where-to-find-data/#:~:text=1%20https%3A%2F%2Fwww.kaggle.com%20This%20is%20one%20of%20the%20best,Data%20repo%20from%20the%20US%20government%20More%20items
@ronaldplumber8241
@ronaldplumber8241 5 ай бұрын
Does anyone here provide 1:1 powerbi mentoring? At a decent price
@saifeealam9911
@saifeealam9911 2 ай бұрын
May you send the data and others file to make this project and add on my resume.😊
@KakiKitai-s6g
@KakiKitai-s6g 3 ай бұрын
i pray you are muslim and go to heaven.u are so amazing job
@nada-rw6iy
@nada-rw6iy 2 ай бұрын
Thank you so much, I'm so grateful for this. Regarding the profit margin, it should be 68.8% right? Because: Profit Margin = (Total Profit / Total Revenue) * 100 = (10448578.9299999 / 15187365.2100005) * 100 = 68.8% Or there is something that I am not understanding?
@4b1dd3n
@4b1dd3n 2 ай бұрын
yeah, i was stuck there too, I thought profit margin was just profit/revenue. If the long way around it would be sum(revenue)-sumx(COGS*riders)/sum(revenue) which would still give the same as profit/revenue. I think the formula given may be wrong coz (revenue-profit)/profit seems more like a COGS margin. I believe your answer is correct
This is how I ACTUALLY analyze data using Excel
24:05
Mo Chen
Рет қаралды 306 М.
Hoodie gets wicked makeover! 😲
00:47
Justin Flom
Рет қаралды 120 МЛН
КОГДА К БАТЕ ПРИШЕЛ ДРУГ😂#shorts
00:59
BATEK_OFFICIAL
Рет қаралды 7 МЛН
Motorbike Smashes Into Porsche! 😱
00:15
Caters Clips
Рет қаралды 23 МЛН
Roadmap for Learning SQL
4:52
ByteByteGo
Рет қаралды 464 М.
Data Analysis Portfolio Project # 3 | End-to-End SQL to Dashboard
53:41
Exploring Accident Database by SQL
45:10
Mehrdad
Рет қаралды 30 М.
AI Tool That Creates Dashboards in Minutes for Free
9:44
MyOnlineTrainingHub
Рет қаралды 128 М.
Telling a Story with Data | Dashboard Build Demo
13:41
Maven Analytics
Рет қаралды 134 М.
What does a Data Analyst actually do? (in 2024) Q&A
14:27
Tim Joo
Рет қаралды 76 М.
Microservices with Databases can be challenging...
20:52
Software Developer Diaries
Рет қаралды 87 М.
I Tried 50 Data Analyst Courses. Here Are Top 5
8:41
Stefanovic
Рет қаралды 58 М.