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
https://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:
https://www.linkedin.com/in/gaelimholland
For up to 50% at DataCamp, check out my affiliate link:
https://datacamp.pxf.io/KjO5ba