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

Подписаться 40 тыс.

Просмотров 55 тыс.

50% 1

You will build an end-to-end data analysis project in less an 1 hour. This is aimed at beginners who want to understand the whole end-to-end process of data analysis. It will help you develop skills and see a typical analysis request.
You are the Data Analyst in this Story:
You will act as a data analyst helping Toman Bike Share to understand if increasing prices next year is possible. All files and data provided. Here is the workflow below
1. Build a Database
2. Develop SQL queries
3. Connect Power BI to your database
4. Build a Dashboard
5. Make Analysis Recommendations
You can find all the files here for download
github.com/Gaelim/YT_bike_share
click the data file and download it as raw file.
Video Time Stamps:
0:49 Data Analysis Request Email
2:01 Downloading and Install Microsoft SQL Server and SQL Server Studio
5:22 Setting up your Database and Tables
10:25 Developing your SQL queries
22:43 Dashboard Preview
23:49 Connect Power BI to the Database
27:44 Building the Dashboard
55:05 Answer the Analysis Question
1:00 Recommending Price Increase
Check me out on Linked In or DM me:
For up to 50% at DataCamp, check out my affiliate link:
datacamp.pxf.io/KjO5ba

Опубликовано:

4 май 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 91

@JW-pu1uk Месяц назад

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 Месяц назад

That is a great comment and endorsement based on your experience. This definitely motivates me to keep sharing content! Thank you!

@diamondsandlipgloss 8 дней назад

@@absentdatamy thoughts exactly

@herculesgixxer 26 дней назад

Great vid- practical, easy to follow, applicable… thank you!

@olugbadebenjamin2273 Месяц назад

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.

@Sirigineedi_Navann Месяц назад

This was the most awaited video thanku so much 😊❤

@EnzoCossa 19 дней назад

This is my second video on data from Absent Data. I am extremely grateful for the content he has been providing.

@absentdata 19 дней назад

Glad you like the channel.

@femiajewole6891 14 дней назад

Thank you. Very informative

@Lone.wolf004 16 дней назад

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 16 дней назад

Thank you for the support. Please share it to anyone who you think I can help.

@aditya3david Месяц назад

This awesome as usual easy to understand and follow

@absentdata Месяц назад

Glad that is was easy to follow

@srab9260 Месяц назад

Pls do more of these! Your vids r super helpful for newcomers who r tryna break into DA industry.

@absentdata Месяц назад

Awesome, Please share these videos. I would love to do more. Your support is appreciated.

@raphaelemmanuel-gwar3757 27 дней назад

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 26 дней назад

So glad. It helped you make sense of things. Please share it with anyone you think it will help

@valenciawalker6498 Месяц назад

Thank you

@clair5385 Месяц назад

awesome work

@absentdata Месяц назад

Thank you

@cheesenutz3854 19 дней назад

im an aspiring data analyst and you channel is a gold mine thank you so much

@absentdata 19 дней назад

Great to hear! Its great that you a starting your journey as a data analyst. We need more good ones!

@sencxx6368 Месяц назад

we need more content like that please !

@absentdata Месяц назад

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!

@AnasM24 Месяц назад

Thank you sir

@absentdata Месяц назад

You're welcome

@alexiopfumai6299 4 дня назад

Good explanation...Please do more videos like these

@absentdata 4 дня назад

Thank you! I will. Please help me share the video.

@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?

@diamondsandlipgloss 6 дней назад

This was amazing, I learned so much. Do you have videos on how to write a recommendation ......PLEASE 🥺

@lijunchen 29 дней назад

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 28 дней назад

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

@newenglandnomad9405 Месяц назад

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 Месяц назад

What area do you want to improve? The channel has some intermediate to advanced SQL analysis and Python videos

@newenglandnomad9405 25 дней назад

@@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 25 дней назад

@@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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-oWP00-NNpYE.htmlsi=LZMwOd9S7lMNxuRk ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-lzvCn8Tt5_U.html&ab_channel=AbsentData

@Mr.NgameniGilbert 11 дней назад

Thanks for the video!! How came your dtedate at 36:42 happened to include all the year, months, day and quarter??

@absentdata 11 дней назад

Dates in Power BI. Have an automatic hierarchy. So date --> month--> quarter--> year is the hierarchy

@nw_content 13 дней назад

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 12 дней назад

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.

@MarcosPaulo-xt7xs 8 дней назад

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 8 дней назад

try some of the projects on this channel which cover Python also.

@MarcosPaulo-xt7xs 7 дней назад

@@absentdata for sure. I loved this channel and I will improve myself with the projects I learn here. Thank you again!

@DFact13621 29 дней назад

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 29 дней назад

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 7 дней назад

@@absentdata and I need hands on experience with it, so this project is EXACTLY what I need....THANK YOU A MILLION TIMES OVER!!!!!!

@marthaakhimien7182 Месяц назад

Awesome Visualization, please are u on LinkedIn?

@absentdata Месяц назад

Yes my LinkedIn is in the description

@diamondsandlipgloss 8 дней назад

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 8 дней назад

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.

@kwakuayisa8481 Месяц назад

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 Месяц назад

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 Месяц назад

@@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 Месяц назад

There are no instructions for MYSQL this is a completely different DBMS. I would require different instructions

@diamondsandlipgloss 7 дней назад

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.

@mrbartuss1 Месяц назад

Why do you calculate profit margin this way? Shouldn't it be (Revenue - COGS)/Revenue or simply Profit/Revenue?

@absentdata Месяц назад

Yes you can calculate it that way

@mrbartuss1 Месяц назад

@@absentdata The number is different then

@UzukwuMichael Месяц назад

@@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.

@rhodreque8155 Месяц назад

Hello, what if the data needs to be cleaned before analysis? How does 1 use SQL to go about that?

@absentdata Месяц назад

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 Месяц назад

@@absentdata Any instructional video on how to go about that?

@cjbrown3396 4 дня назад

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 4 дня назад

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 4 дня назад

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

@jujuthegerber 29 дней назад

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 29 дней назад

Yes, that's fine way to do it.

@jujuthegerber 29 дней назад

@@absentdata okay, thank you!!

@mohamedcfwoobay Месяц назад

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 Месяц назад

There is no part in the video that has XML files

@mohamedcfwoobay Месяц назад

@@absentdata I have resolved the issue, thanks

@absentdata Месяц назад

Awesome!

@tyebrown4264 27 дней назад

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 26 дней назад

Maybe turn of auto or rich data type feature

@hanansaeed3694 День назад

i am facing the same issue. Any luck solving it?

@chiomaozurumba2060 12 дней назад

Thank you, my server name didnt populate while installing, what do i do

@absentdata 11 дней назад

Be more specific. What name didn't populate

@ceyhunerdogan1310 Месяц назад

Thank you sir. can you share the dataset? excel file or

@absentdata Месяц назад

Yes all of this is in the description

@putulsaini6788 7 дней назад

@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 6 дней назад

Change the data types

@putulsaini6788 6 дней назад

@@absentdata done sir.... about to finish this project, thank u nd best explanation

@ronaldplumber8241 7 дней назад

Does anyone here provide 1:1 powerbi mentoring? At a decent price

@issasesay572 4 дня назад

so let say this is a real life scenario, will the company provide the data you work with?

@absentdata 4 дня назад

Yes, in a real-life scenario, a company will give you access to their data. Most companies house their data in a database

@issasesay572 3 дня назад

@@absentdata Thanks!

@dessi7692 12 дней назад

Where can i find sample data as these?

@absentdata 12 дней назад

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

@anindadatta164 26 дней назад

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 26 дней назад

Most data lives in databases. It's important as an analyst to be able to use SQL to extract data