Loading...
アイコン

Absent Data

チャンネル登録者数 5.96万人

21万 回視聴 ・ 7161いいね ・ 2024/05/05

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

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.

Check me out on LinkedIn
www.linkedin.com/in/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:
datacamp.pxf.io/KjO5ba

コメント

コメントを取得中...

コントロール
設定

使用したサーバー: wata27