datamodeling

There are 261 repositories under datamodeling topic.

  • Data_Modelling_Basics

    Language:Python1

  • Data_Engineering_Cleaning_Normalization_With_ERD

    World Health Organization-Modern Family Planning Data - Women of the world

    Language:Jupyter Notebook1

  • football_dataset_analysis_postgres

    This project involves working with comprehensive football dataset covering the Top 5 leagues in Europe from 2014-2020. I worked on Data Extraction,Data cleaning and manipulation,Data Modelling and Data Loading

    Language:Jupyter Notebook1

  • Quantitative-Finance-Modelling

    This project performs analysis on a loan portfolio dataset to forecast cash flows and evaluate portfolio present value. It includes code written in Python using the pandas and NumPy libraries.

    Language:Python1

  • sales-analysis-Using-Power-bi-

    power bi data analysis project using data from adventure work 2022 database

    1

  • data_engineering_diploma_2nd_practice

    This repo demonstrates the powerful combination of SQLite and Power BI 🚀. I use SQL to create indices, views, and transactions for optimized performance and data integrity. Power BI then transforms this data into stunning visualizations 📊. Explore the seamless fusion of database management and data visualization! 💡🔍

    1

  • Import-Company_Vis

    Used Power bi to create visual representations of data, uncovering patterns for analysis and enhancing data clarity and readability

    1

  • Building-a-Data-Model-and-a-Database

    A mini project to showcase my skills with Basics Data Models, starting from what is data model, why is data modelling important, relational model and database to ACID properties continued with an exercise of creating a table with PostgreSQL

    Language:Jupyter Notebook1

  • Walmart-sales-analysis

    Sales data analysis conducted using MySQL involves querying and analyzing data stored in a database. Power BI aids in visualizing this data, creating insightful reports,

    1

  • HR-Data-Report-Power-BI

    This Power BI report provides a comprehensive analysis of employee data, focusing on three main aspects: General Information, Attrition, and Others. The report is designed to offer insights into employee demographics, attrition rates, and promotions/layoffs .

    1

  • Road-Accidents-in-India-2017-to-2020

    Road Accidents in India from 2017 to 2020, Power BI interactive dashboard

    1

  • PowerBi-Project-Marketing-Insights

    About Challenge: Domain: F & B Function: Marketing CodeX is a German beverage company aimig to make its mark in the Indian market. A few months ago, they launched their energy drink in 10 cities in India. Their Marketing team is responsible for increasing brand awareness, market share, and product development.

    1

  • Airbnb-SQL-POWERBI

    Discover unique accommodations and unforgettable experiences around the world

    1

  • Udacity-Data-Analysis-and-Visualization-with-Microsoft-Power-Bi

    Projects for Data Analysis and Visualization with Microsoft Power BI Nanodegree from Udacity.

    1

  • Workout-Wednesday-Power-BI-Challenge

    This repository showcases my Power BI skills in data visualization & analysis. I participate in the Workout Wednesday challenge to demonstrate real-world dataset proficiency, advanced modeling, and appealing reports

    1

  • Enterprise_Data_Architecture

    The pragmatic technology journey for an Enterprise Data Model serving reporting, analytical, advanced data science and other digital use cases with integrated data from a variety of sources.

    1

  • Global-sales-Dashboard-POWER-BI-

    Interactive Power BI dashboard with some insights.

    1

  • Telecom-Customer-Churn_PowerBI

    Develop an overview dashboard for managers utilizing a telecom industry user churn dataset to present insights on the current churn situation.

    1

  • Cloud_DWH_Snowflake

    Snowflake ETL Project - Online Store

    Language:PLpgSQL1

  • SQL

    This repository discusses a research project on the employee database at Pewlett Hackard Corporation from the 1980s and 1990s In this project, a table was created that holds employees data in the CSVs, import the CSVs into a SQL database.

    1

  • AdvancedDataModeling

    Starts with a conceptual model ends with a Tableau interactive dash board. In between there is building ER diagrams, forward engineering to build normalized databases, dimensional data modelling and visualizations in tableau.

    Language:Io1

  • Business-Intelligence

    Design and Execute an end-to-end Business Intelligence Solution from scratch.

    1

  • Data-Modeling-and-Interactive-Dashboarding-using-Excel

    A data analytics project that includes data modelling and interactive dashboard design. The project is completed entirely in Excel.

    1

  • PredictionModels_HeartDiseases

    Comparison of various Machine Learning algorithms for Heart Diseases (Heart Attack) prediction.

    Language:Python1
  • Hotel-booking

    Hotel-booking

    This projec about reseveation and manage Hotel

    Language:Python1

  • NYC-Arrest-DW-BI

    Designed and developed Dimensional Model and performed data profiling, ETL operations for staging using Alteryx. Created data integration workflow in Talend to load data in AzureSQL and BigQuery DW and visualized analytical data reports dashboard using Tableau and PowerBI to get the insights and single truth story of the data

    1

  • GPE-Data-Modeling-Project

    This project is part of a digital transformation headed by me in a non-profit organization whose goal is to make education more democratic. The organization’s name is Grupo Pró-Estudar (GPE), and it offers preparatory courses for entrance exams in Brazilian universities for low-income individuals.

    1

  • ETL-Sales_Analysis_Report---MySQL-PowerBI

    This repo explains how ETL can be done in MySQL and PowerBi to generate insights!

    1

  • POSTGRES_DATAMODELING

    In this project, I'll apply what I've learned on data modeling with Postgres and build an ETL pipeline using Python. To complete the project, I will define the fact and dimension tables for a star schema for a particular analytic focus, and write an ETL pipeline that transfers data from files in two local directories into these tables in Postgres using Python and SQL.

    Language:Jupyter Notebook1

  • Data-Ware-House-modelling-using-ETL-Solutions

    This repository contains a Data ware house solution for Property Analysis: A one-stop online platform for property investors, managers, owners, tenants and service providers.

    1

  • Coffee-Chain-Analysis

    This repository discribs about the Data set used and the operation done in Tableau

    1

  • Employee-Database

    My first major task is a research project on employees of the corporation from the 1980s and 1990s. All that remain of the database of employees from that period are six CSV files.

    1

  • SDBMS

    This project is Implementation of Stream Data Model.

    Language:JavaScript1

  • DataQuality_Enhancement_Framework

    This project is an internal project with INTEL where a framework for monitoring data quality from disparate sources and automating it using python.

    1

  • DataModeling-With-Apache-Cassandra

    A Project of Data Modeling and ETL with Apache Cassandra and Python

    Language:Jupyter Notebook1

  • DataModeling_with_Postgres_ETL

    ETL implementation in Python to load the data of JSON files into postgreSQL database.

    Language:Jupyter Notebook1