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

Published: 05 May 2024
on channel: Absent Data
132,758
4.9k

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
https://github.com/Gaelim/YT_bike_share

click the data file and download it as raw file.

Check me out on LinkedIn
  / gaelimholland  

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:
https://datacamp.pxf.io/KjO5ba


Watch video End-to-End Data Analysis Project 2024 | SQL & Power BI | Beginner Friendly online without registration, duration hours minute second in high quality. This video was added by user Absent Data 05 May 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 132,75 once and liked it 4.9 thousand people.