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.