15 YouTube views, likes subscribers in 10 minutes. Free!
Get Free YouTube Subscribers, Views and Likes

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

Follow
Absent Data

You will build an endtoend data analysis project in less an 1 hour. This is aimed at beginners who want to understand the whole endtoend 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.

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

posted by ruletamafw