Coder Social home page Coder Social logo

3amory99 / building-sales-data-mart-using-etl-ssis Goto Github PK

View Code? Open in Web Editor NEW
2.0 1.0 0.0 1.92 MB

By using AdventureWorks2022 Dataset I have built a Sales Data Mart using (SQL Server Integration Services SSIS) SQL Server involves leveraging the capabilities of Integration Services (SSIS) and the Modeling of SQL Server, This Data mart offers several benefits, making them valuable components in the main purpose of data management and analytics wi

TSQL 100.00%
database etl ingestion integration package sql ssis

building-sales-data-mart-using-etl-ssis's Introduction

Hi , I'm Omar Mahmoud

Data Engineer

Typing SVG


๐Ÿ’โ€โ™‚๏ธ About me

  • Professional Data Engineer with hands-on experience in Data Engineering, Big Data, Data Analytics, and visualization, including Business intelligence, Databases, Data Warehouse (DWH), Extract Transform Load (ETL), Data analysis, and Statistics, Natural Language Processing (NLP). Leverage all of them to provide data-driven solutions to help decision-makers
  • Enthusiastic learner focused on Big Data, Data Engineering, BI, and Data Analysis.
  • Graduated from Computer Science & Artifactual Intelligence at Beni Suef University, and also graduated from ITI Alex Data Engineering Track I worked on many projects and investigated a variety of datasets in different industries to explore historical data and help to improve their sales and answer their questions and support their decisions by emphasizing my analytics with some insights, Data Mining, and Machine Learning techniques like regression models, time series and association role in data major.



Skills

  • Programming Languages:

    Python Java C++


  • Data Engineering:

    Microsoft SQL Server PL/SQL BigDataConcepts ETL Data Warehouse NoSQL ApacheCassandra MongoDB


  • Data Analysis:

    Microsoft SQL Server PostgreSQL NumPy Pandas


  • Data Visualization:

    PowerBI Matplotlib Seaborn


  • Server Administrations:

    Windows Linux Red Hat CentOS Bash Scripting


  • Workflow Platforms:

    Airflow


  • Version Control:

    Git GitHub Virtual Machines


  • Virtualization:

    VirtualBox VMware Workstation


  • Microsoft Office Tools:

    Microsoft Excel Microsoft PowerPoint Microsoft Word Microsoft Project Microsoft OneNote


  • Design:

    Adobe Photoshop Adobe XD Figma



3amorrry



ย 3amory9999


3amory99

Connect with me:

3amory99 3amory/ 3amor omar2022/ abdalrhmanragab

Languages and Tools:

aws azure dart flask flutter gcp git heroku kotlin linux mssql mysql opencv oracle pandas postgresql python scikit_learn seaborn sqlite tensorflow

building-sales-data-mart-using-etl-ssis's People

Contributors

3amory99 avatar

Stargazers

 avatar  avatar

Watchers

 avatar

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.