Data Solve
Data Solve
  • 11
  • 3 043
Transforming Spreadsheets into Web Apps
In this video, we dive into how DataSolve can help convert your spreadsheet to a web app-transforming static Excel files into dynamic, user-friendly applications! 🚀
Time Stamps
0:00 - Introduction and Context
1:42 - The Task
2:39 - Design Phase
3:50 - Front end
6:10 - Live Demonstration of the web app
Blog Post:
datasolve.tech/2024/11/03/transforming-spreadsheets-into-web-apps/
As a data consultancy, we specialize in turning complex spreadsheets into powerful digital tools that make data management easier and more interactive.
Our Process
We use a tech stack including React, Supabase, and Vercel to bring your data to life. From frontend development to backend database management and data visualization, we’ve got you covered.
🔵Portfolio building and Interviewing skills🔵
Build a data pipeline
ua-cam.com/video/uZXIvoWL2uo/v-deo.html
Top 10 SQL Interview Questions
ua-cam.com/video/HKLuyXhxZ0E/v-deo.html
Build a Data Warehouse in SQL
ua-cam.com/video/R_O02ZHGPto/v-deo.html
🟢Resources🟢
Integrate Bubble with Supabase (Api Connector)
ua-cam.com/video/E7q6VOWoCMQ/v-deo.html
SQL Beginner to Intermediate Toolbox Course:
www.udemy.com/course/t-sql-toolbox/
Raw Source CSV - Data Analyst Roles: Seek
shorturl.at/zSm7A
Переглядів: 92

Відео

Choosing the Right OLTP database8:37Choosing the Right OLTP database
Choosing the Right OLTP database
Переглядів 12Місяць тому
In this video, we dive into how choosing the right database can boost your company's performance and save costs. I'll walk you through key performance tests on your current database, show you how to optimize for efficiency 🔵Portfolio building and Interviewing skills🔵 Build a data pipeline ua-cam.com/video/uZXIvoWL2uo/v-deo.html Top 10 SQL Interview Questions ua-cam.com/video/HKLuyXhxZ0E/v-deo.h...
Land a Data Job! - No Degree, No Experience Needed13:11Land a Data Job! - No Degree, No Experience Needed
Land a Data Job! - No Degree, No Experience Needed
Переглядів 2232 місяці тому
Eager to break into the data industry but don't know where to start? In this video, I reveal how to land a data role without any prior experience. I analysed over 400 job listings on Seek (Australia) to identify the top skills and qualifications employers are looking for. We'll cover: Essential Skills: Technical and soft skills that make you stand out. Preparation Strategies: Best resources to ...
Build A Data Pipeline - Airflow, dbt, snowflake and more!16:21Build A Data Pipeline - Airflow, dbt, snowflake and more!
Build A Data Pipeline - Airflow, dbt, snowflake and more!
Переглядів 2923 місяці тому
Data Engineering with Apache Airflow, Snowflake & dbt Timestamps: 0:00 Introduction 0:43 Self-promotion 1:09 Snowflake Background 3:21 dbt Background 5:55 Apache Airflow Background 6:45 Github Background 7:35 Docker Background 7:50 High Level Diagram 9:06 Prerequisites 9:37 git clone 10:34 Configuration 10:55 High Level Detail 12:24 docker-compose build 13:23 docker-compose up 13:39 docker ps 1...
10 SQL Interview Questions you must know!22:1710 SQL Interview Questions you must know!
10 SQL Interview Questions you must know!
Переглядів 7513 місяці тому
Prepare for your SQL interview with these top 10 essential questions! Whether you're aiming to be a data engineer, SQL developer, or data analyst, this guide covers everything from basic SQL operations to advanced topics like window functions and query optimization. Boost your confidence and ace your next SQL interview! 0:00 Introduction 0:46 Q1: What types of joins do you know? 2:10 Q2: What i...
Cloud vs On-Premises Costing for Data Warehouse Solutions7:24Cloud vs On-Premises Costing for Data Warehouse Solutions
Cloud vs On-Premises Costing for Data Warehouse Solutions
Переглядів 944 місяці тому
0:00 Introduction 0:35 Preface 0:56 Use case #1 - Private Business 3:45 Estimate Costing For On Premise Data Warehouse 4:49 Break Even Costs On Premise 5:45 Enterprise Data Warehouse Costing Estimate 6:40 Final Conclusion In this video, I explore the costing for two types of business models: a private business and an enterprise. In modern times, it's common to opt for cloud solutions to avoid t...
Create a Data Warehouse in SQL Server - No External Tools Needed22:16Create a Data Warehouse in SQL Server - No External Tools Needed
Create a Data Warehouse in SQL Server - No External Tools Needed
Переглядів 1074 місяці тому
Creating a Data Warehouse in SQL Server - No External Tools 0:00 Introduction 0:37 datasolve.tech 0:58 You Will Fail! 1:55 Reasons for DW Failure 2:46 Resources 4:06 Business Use Case 4:50 Kimball Methodology 5:46 Creating an ERD 6:45 Normalization 7:48 Composite Primary Key 9:28 Dimensional Model 11:07 ETL Pipeline 12:22 SSMS SQL Server Code Review 20:20 Running Pipeline Please note: This is N...
Integrate Bubble.io and Supabase through the API Connector13:02Integrate Bubble.io and Supabase through the API Connector
Integrate Bubble.io and Supabase through the API Connector
Переглядів 1,4 тис.5 місяців тому
0:00 - Introduction 0:16 - datasolve.tech 0:55 - what is supabase? 2:16 - what is bubble.io? 3:33 - practical demonstration 4:22 - exposing custom schemas in supabase 4:38 - configure bubble api connector 5:17 - Get Response HTTP 6:30 - Get Response HTTP Parameters 8:25 - supabase functions used 8:57 - Manual JSON response 10:55 - POST response HTTP 12:05 - Conclusion Related video - turning sp...