Introduction:
The project overview for bike share project Karan Github Link, objectives, and tools used (SQL and Power BI).
Data Collection:
Explanation of the dataset and its source.
Importing the data into SQL.
Data Cleaning:
Removing duplicates.
Creating new columns.
Aggregating data.
Using SQL queries for data manipulation.
Data Analysis:
Writing SQL queries to extract insights.
Using joins and subqueries for complex analysis.
Visualizing initial findings.
Exporting Data:
Moving the cleaned and transformed data from SQL to Power BI.
Data Visualization:
Connecting Power BI to the SQL database.
Creating various charts and graphs.
Designing dashboards to present key insights.
