Wiki Localbike - astachov/dbt_final_project GitHub Wiki
Home
Welcome to the Local Bike wiki! Local Bike is a company that specializes in selling bicycles and organizing cycling events. Our mission is to promote sustainable mobility and create a strong cycling community.
Context: The history of Local Bike and its mission
Objectives: The objectives of the project and the analysis axes
Data Architecture
The data architecture of Local Bike is designed to support data analysis and visualization. The data is stored in BigQuery and structured in a DBT project.
Raw Data: The raw data is imported into BigQuery
Data Structuring: The data is structured in a DBT project to facilitate analysis
Data Models: The data models are created to support analysis and visualization
Data Models
The data models of Local Bike are created to support data analysis and visualization. The models are designed to meet the needs of the company and provide strategic insights.
Data Models: The data models are created to support analysis and visualization
Data Testing: Data testing is performed to validate the data models
Data Testing
Data testing is performed to validate the data models and ensure that the data is accurate and consistent.
Data Testing: Data testing is performed to validate the data models
Test Results: The test results are analyzed to identify problems and opportunities for improvement
Production Deployment
The production deployment of the Local Bike project is done using GitHub and a BI tool such as Power BI or Tableau.
Hosting on GitHub: The project is hosted on GitHub to enable collaboration and code review
Data Visualization: The data is visualized using a BI tool to provide strategic insights
Dashboard: A dashboard is created to present the insights in a visual way and to address the problem of optimizing Local Bike's revenue### ### ###