Billy Thomas ALLJOY Data
Billy Thomas ALLJOY Data
  • 62
  • 52 325
ALLJOY Data Consultant Profile: Michael Siconolfi #dataanalyst #dataquality #datamigration
Hello ALLJOY community!
Meet Michael Siconolfi!
Michael is a senior SAP data migration and data quality project lead. He holds qualifications in Economics and Commerce and is an experienced BI manager, SAP data analyst, HANA/DS developer and data quality, governance, and master data consultant. He attained his Syniti Advanced Data Migration certification in 2020 and has been working as a senior SAP data consultant, data quality lead and SAP DS developer since 2013. He also worked closely with MDG-EAM teams to ensure that master data validation rules in MDG-EAM are aligned with data migration and HANA config. Michael has been working on S4 HANA projects since 2018.
He has a high attention to detail with a focus on quality delivery. He is very talented, and clients love working with him. He has brilliant technical and communication skills and enjoys translating these into business knowledge. He excels at data cleansing, validation, and data quality methods to manage mapping errors quickly and satisfy the auditors and stakeholders. Before starting in SAP, he was a Business Intelligence manager and Information analyst for 14 years in various healthcare companies and organizations.
Areas of Strength
Data Migration - Rules, mapping, planning, pre-load and post-load validation, reconciliation, audit requirements, business liaison, rule workshops, data migration functional specifications, ETL.
Data Quality - Planning, rule building, business liaison, KPI’s, data analysis, deduplication, harmonization, data cleansing, rule workshops.
Master Data - Modelling and governance of master data
Data Analysis - Analysing large sets of data from systems to establish trends. Specifically with a data cleansing and harmonization focus.
Data Cleansing - Identifying data unfit for purpose and driving the cleansing of that data in source/target systems
Data Integration - Analysing integration requirements between source and target systems, from an As-Is and To-Be perspective.
Data base design and normalization.
Data objects expertise:
Plant maintenance - Functional and data migration knowledge. Migration and cleansing of master and transactional data.
Vendor (Supplier) - General master data, purchasing, roles, contacts, transactional data, info records, contracts, supply quotas and functional process knowledge. Understanding the supplier processes that require data to support it and how it integrates with the greater organization.
Customer - Migration of all master data and transactional data.
Product - Migration, cleansing, harmonization of all aspects of products in ERP’s.
Finance - AR, AP, Profit centres, Finance and Cost elements.
Inventory & Batch management (Quality management) - Migration of Inventory from legacy systems to enterprise warehouse systems.
Bills of Material - Migration and linking of BOM’s.
Industry expertise:
Retail
FMCG
Manufacturing
Defence
Mining
Oil & Gas
Technical tools of expertise:
SAP ERP (ECC & S4/HANA)
Microsoft D365 FO
BODS
SQL/SQL server
Information Steward
Syniti Advanced Data Migration (ADM)
Syniti Knowledge Platform (SKP)
มุมมอง: 13

วีดีโอ

ALLJOY Data #BusinessReadyData #dataanalyst #dataquality #datamigration
มุมมอง 194 หลายเดือนก่อน
There can be a huge disparity between the perceived quality of your data and your data actually being ready to be used by the business.
How to become a data analyst. | My journey to a life changing job!
มุมมอง 598 หลายเดือนก่อน
Join me as I interview Christian Mummert and we discuss how he got hired as a data analyst and now works with a fortune 500 company as a data analyst. 0:00 Intro 1:37 Education 2:45 Struggling to get hired 4:03 The importance of stepping stones 6:36 Data Analyst Skills 11:17 Do you have to be a nerd 12:47 Advise on becoming a data analyst
Create a SQL Server source connection in Collibra
มุมมอง 3199 หลายเดือนก่อน
Tutorial to explain how to add a cloud-based SQL Server database as a source in Collibra.
DATA ANALYST CHALLENGE! Will you be able to handle this level of complexity?
มุมมอง 439 หลายเดือนก่อน
In this video, we will use SAP's data model for Routings and Recipes to demonstrate how complex some data quality report requests can be. We will look at data objects in SAP, the tables and the lessons we've learned by working with this data model. If you need to create a data quality or custom report for SAP recipes, routings or task lists, this video is for you. SAP TCodes CA03 - display Rout...
Import data into GCP | Beginners Tutorial
มุมมอง 11310 หลายเดือนก่อน
In this video we will be importing data in the Google Cloud Platform. We will look at two scenarios. 1. Clean import 2. What happens when we get an error.
How to create a ODBC Connection to mySQL in Microsoft SQL Server # #mysql #dataanalyst #odbc
มุมมอง 1.2Kปีที่แล้ว
This advanced SQL Server video was a request from a member of the ALLJOY community. The ask was to do a video on ODBC connections. To be able to do that, we will install mySQL, create a database, a table, low a few rows and them pull that data from mySQL into SQL Server using ODBC in the Import / Export Wizard. 0:00 Introduction 1:07 Install mySQL 6:13 Set up environment variable 8:40 Create my...
How to create a SAP UOM Data Quality Report in SQL Server #dataanalyst #dataquality #sqlserver #sap
มุมมอง 75ปีที่แล้ว
Business Requirement: Create a data quality report in SQL Server for the SAP material master that checks the following UOM assignments: (FERT, HALB, HAWA, ROH are standard SAP material types) FERT = CS or EA HALB = PC HAWA = PC ROH = PC, EA, KG @0:00 Intro @0:45 Select values @4:00 Cross Join to MARA @5:56 Record count check @6:51 The bad guys (the actual MARA/MARM data) @10:02 Put it all toget...
SQL Server CharIndex Function Tutorial for Data Analysts
มุมมอง 32ปีที่แล้ว
In this video we will take a look a the SQL Server function CHARINDEX(). @0:00 Intro @0:16 Why we need CHARINDEX() @1:44 Simple String Examples @7:09 Example with SQL Table #dataanalyst #sqlserver #ssms #dataquality #alljoydata
Learn how to use RTRIM() on SQL Server | Billy Thomas | ALLJOY Data | Data Analyst Examples
มุมมอง 35ปีที่แล้ว
Learn how to use RTRIM() on SQL Server | Billy Thomas | ALLJOY Data | Data Analyst Examples
How to trim leadings zeros from an SAP extract using SQL Server with Billy Thomas ALLJOY Data
มุมมอง 255ปีที่แล้ว
How to trim leadings zeros from an SAP extract using SQL Server with Billy Thomas ALLJOY Data
SAP Data Extract using SE16N with Billy Thomas from ALLJOY Data | Export SAP data using SE16N
มุมมอง 1.1Kปีที่แล้ว
SAP Data Extract using SE16N with Billy Thomas from ALLJOY Data | Export SAP data using SE16N
SQL Server Coalesce Function | Billy Thomas | ALLJOY Data
มุมมอง 98ปีที่แล้ว
SQL Server Coalesce Function | Billy Thomas | ALLJOY Data
SQL Server Round Function with Billy Thomas | ALLJOY Data | ROUND() Function
มุมมอง 165ปีที่แล้ว
SQL Server Round Function with Billy Thomas | ALLJOY Data | ROUND() Function
SQL Server IDENTITY INSERT with Bill Thomas | ALLJOY Data
มุมมอง 42ปีที่แล้ว
SQL Server IDENTITY INSERT with Bill Thomas | ALLJOY Data
Senior Business Data Analyst Job - ALLJOY Data | Remote Consulting
มุมมอง 74ปีที่แล้ว
Senior Business Data Analyst Job - ALLJOY Data | Remote Consulting
SQL Server ROW_NUMBER() Tutorial with Examples | Billy Thomas ALLJOY Data
มุมมอง 56ปีที่แล้ว
SQL Server ROW_NUMBER() Tutorial with Examples | Billy Thomas ALLJOY Data
Create a Data Quality Report in SQL Server with Billy Thomas | ALLJOY Data.
มุมมอง 297ปีที่แล้ว
Create a Data Quality Report in SQL Server with Billy Thomas | ALLJOY Data.
SQL Server Cursor with Billy Thomas from ALLJOY data
มุมมอง 83ปีที่แล้ว
SQL Server Cursor with Billy Thomas from ALLJOY data
How to use SQL Server sys.objects, sys.colums, sys.all_sql_modules with Billy Thomas ALLJOY Data
มุมมอง 535ปีที่แล้ว
How to use SQL Server sys.objects, sys.colums, sys.all_sql_modules with Billy Thomas ALLJOY Data
SQL Server: Move/Copy a Database from Cloud to Local w/ Data Analyst Billy Thomas from ALLJOY Data.
มุมมอง 58ปีที่แล้ว
SQL Server: Move/Copy a Database from Cloud to Local w/ Data Analyst Billy Thomas from ALLJOY Data.
Sql Server: How To Detect Date Range Overlaps With Billy Thomas
มุมมอง 700ปีที่แล้ว
Sql Server: How To Detect Date Range Overlaps With Billy Thomas
Update Query using SQL Server SSMS with Billy Thomas
มุมมอง 17ปีที่แล้ว
Update Query using SQL Server SSMS with Billy Thomas
SQL Server Tutorial | 10,000 ft Overview of SQL Server for beginners | Sample Data | Examples
มุมมอง 53ปีที่แล้ว
SQL Server Tutorial | 10,000 ft Overview of SQL Server for beginners | Sample Data | Examples
SQL Server Union Query | Tutorial | Billy Thomas from ALLJOY Data
มุมมอง 28ปีที่แล้ว
SQL Server Union Query | Tutorial | Billy Thomas from ALLJOY Data
SQL Server Case Statement Tutorial | Billy Thomas ALLJOY Data
มุมมอง 22ปีที่แล้ว
SQL Server Case Statement Tutorial | Billy Thomas ALLJOY Data
SQL Server Nested Queries and Subqueries | Billy Thomas | ALLJOY Data
มุมมอง 59ปีที่แล้ว
SQL Server Nested Queries and Subqueries | Billy Thomas | ALLJOY Data
SQL Server Date Format | SQL Tutorial for Data Analyst with Billy Thomas ALLJOY Data
มุมมอง 154ปีที่แล้ว
SQL Server Date Format | SQL Tutorial for Data Analyst with Billy Thomas ALLJOY Data
SQL Server Group By with Billy Thomas ALLJOY Data for a beginner data analyst.
มุมมอง 29ปีที่แล้ว
SQL Server Group By with Billy Thomas ALLJOY Data for a beginner data analyst.
SQL Server Joins with Billy Thomas ALLJOY Data
มุมมอง 39ปีที่แล้ว
SQL Server Joins with Billy Thomas ALLJOY Data

ความคิดเห็น

  • @yasirblch7653
    @yasirblch7653 3 วันที่ผ่านมา

    Sir you just went to the point. nothing else, thats great. Now i can say my day was not wasted as at the end i got the solution. thank you sir normally i dont subscribe, but a one for you ☺

  • @Questioneeeeerrr
    @Questioneeeeerrr 16 วันที่ผ่านมา

    Is there a more modern way to pull full tables even if the number of rows are up there?

  • @ThelmaTelly-gb8yn
    @ThelmaTelly-gb8yn 16 วันที่ผ่านมา

    After trying with so many tutorial I finally got it right, thanks so much Billy. I appreciate

  • @jeffreymendozarosales7395
    @jeffreymendozarosales7395 20 วันที่ผ่านมา

    Thank youuu very much my GOD

  • @arielgaletti4350
    @arielgaletti4350 21 วันที่ผ่านมา

    Para los que ya instalaron SQL Express y no les da la opcion Integration Services, seleccionen Nueva instalacion, en la parte del video 2:29 tambien instalen Database Engine Services del minuto 2:45 Cuando se conecten a la DB haganlo en la nueva instancia y desde ahi usen los servicios de Integration Services😉

  • @장미김-t5c
    @장미김-t5c 23 วันที่ผ่านมา

    hi.. thank you for your tutorial. could you please make a tutorial to make a portfolio for data analyst?

  • @AbdulrhmanHadad
    @AbdulrhmanHadad 26 วันที่ผ่านมา

    I was losing my mind HOLY THANKS

  • @Evgeny-p8s
    @Evgeny-p8s 27 วันที่ผ่านมา

    I would never have been able to do it on my own. Thanks a lot. This solved my problem

  • @Cimarron_Radio
    @Cimarron_Radio หลายเดือนก่อน

    Excellent!

  • @Agustin_sh
    @Agustin_sh หลายเดือนก่อน

    Excelente, muchas gracias

  • @OZTutoh
    @OZTutoh หลายเดือนก่อน

    2:20 Is there any way to have Microsoft SQL Server 2022 Import and Export tools installed on my machine without installing an entire SQL server environment including an SQL database?

  • @xingzhouqian
    @xingzhouqian หลายเดือนก่อน

    Thank you so much bro! Solve my problem !!!

  • @ЕвгенийТеплицкий-у8о
    @ЕвгенийТеплицкий-у8о หลายเดือนก่อน

    Thank you so much!

  • @piyushkhadka1291
    @piyushkhadka1291 2 หลายเดือนก่อน

    too good

  • @karishma7103
    @karishma7103 2 หลายเดือนก่อน

    This video is a saviour :)

  • @vikasnagar8768
    @vikasnagar8768 2 หลายเดือนก่อน

    But here it will convert all the data types to varchar(50) in my System

  • @md.rehanshaikh1162
    @md.rehanshaikh1162 2 หลายเดือนก่อน

    i don't have integration services in shared features

  • @x9v8k
    @x9v8k 2 หลายเดือนก่อน

    Im missing all of the OLB DB dll files, not quite sure why a fresh installation does not install everything I need to run the application. Any fix to get the files?

  • @statisticlabs3900
    @statisticlabs3900 2 หลายเดือนก่อน

    Outstanding tutorial. Many thanks for the wealth of information you share with us🏆🏆🏆

  • @celiaputhur4435
    @celiaputhur4435 2 หลายเดือนก่อน

    thanks sir ,it worked 😇😇😇

  • @John-qw7qs
    @John-qw7qs 2 หลายเดือนก่อน

    You just saved me a lot of googling man, thank you very much!

  • @LuisdePina
    @LuisdePina 2 หลายเดือนก่อน

    Thank You !

  • @wardasoulaimana5174
    @wardasoulaimana5174 3 หลายเดือนก่อน

    thank you so much i was struggling to find o video to solve my problem

    • @alljoydata
      @alljoydata 3 หลายเดือนก่อน

      Your welcome!

  • @ricardoantonio5547
    @ricardoantonio5547 3 หลายเดือนก่อน

    I been on pathway to became an analyst since January, tried few different channels and so far your channel been the most helpful and enjoyable Thanks for the great work 👍

  • @adududuke3995
    @adududuke3995 3 หลายเดือนก่อน

    Thank you so much! 🍻

  • @ElaineLong-t1w
    @ElaineLong-t1w 3 หลายเดือนก่อน

    Best lesson on SE16N thank you!!!!

  • @dolphinarmy9871
    @dolphinarmy9871 3 หลายเดือนก่อน

    Ive been trying to go over this for 2 days - thank you for the super clear tutorial!

  • @ricardoantonio5547
    @ricardoantonio5547 3 หลายเดือนก่อน

    For some reason sql can not find it gives me a message saying "there is no file to be restore" any tips ? cheers

  • @ricardoantonio5547
    @ricardoantonio5547 3 หลายเดือนก่อน

    2nd day Lets go 😀

  • @katlegolebelwane3318
    @katlegolebelwane3318 3 หลายเดือนก่อน

    Welcome your new subscriber...ME! I've struggled for 3 days 😢. I got an error non stop. Thanks to you I was able to resolve it.

    • @alljoydata
      @alljoydata 3 หลายเดือนก่อน

      Oh wow! So glad I could help! Be sure to let me know if you get stuck and need any other SQL or data related videos.

  • @ricardoantonio5547
    @ricardoantonio5547 3 หลายเดือนก่อน

    Just found your channel watched couple videos solve the problems You save the day ! One stop channel for any issue Great tutorial Thanks alot

    • @alljoydata
      @alljoydata 3 หลายเดือนก่อน

      Let me know if there are any more data / sql videos that would be helpful. Have a great day!

  • @muradow
    @muradow 4 หลายเดือนก่อน

    This fixed my problem but when I tryna choose my destination just like you did in the video, my server name doesn't show up. Hope you help me to fix this too

    • @alljoydata
      @alljoydata 4 หลายเดือนก่อน

      Please send me a screen shot of your issue. Also, Did you create or attach a database in SSMS?

    • @muradow
      @muradow 4 หลายเดือนก่อน

      @@alljoydata Thank you very much to answer me. I have fixed that error too. By installing accessdatabaseengine.exe and run it on cmd with /quite command.

    • @muradow
      @muradow 4 หลายเดือนก่อน

      @@alljoydata Thank you very much to answering me. I hav fixed the error by installing accessdatabaseengine.exe and execute with /quiet on command prompt🫡

    • @muradow
      @muradow 4 หลายเดือนก่อน

      @@alljoydata Thank you very much to answering me. I have fixed the error by isntalling accessdatabaseengine.exe and executing it on command prompt with /quiet.

  • @muradow
    @muradow 4 หลายเดือนก่อน

    Thank God this video is exist

  • @NGKannur
    @NGKannur 4 หลายเดือนก่อน

    You rock man.. Thanks from Kerala, India

  • @SaidurRahman-c8w
    @SaidurRahman-c8w 4 หลายเดือนก่อน

    Thank You so much Billy, was stuck on this for few days. You treated my headache.

  • @daraudobong7195
    @daraudobong7195 4 หลายเดือนก่อน

    Thank you so much!! This was so helpful to me in my data analysis; I’m super grateful. God bless you!

    • @alljoydata
      @alljoydata 4 หลายเดือนก่อน

      Glad it was helpful!

  • @mariomazariegos3293
    @mariomazariegos3293 4 หลายเดือนก่อน

    Thank you thank you thank you man! U saved my ass lol been troubleshooting this all day long, u definitely got a new subscriber!

  • @wandalf1012
    @wandalf1012 5 หลายเดือนก่อน

    Freakin Legend. Very helpful.

    • @alljoydata
      @alljoydata 5 หลายเดือนก่อน

      AWESOME!

  • @mdagli2003
    @mdagli2003 5 หลายเดือนก่อน

    big big big thanks

  • @Magerun
    @Magerun 5 หลายเดือนก่อน

    WOW

  • @gastonrojas8237
    @gastonrojas8237 5 หลายเดือนก่อน

    I really appreciate this, thanks a lot!!! Very helpful video

  • @LeonardoFuciolo
    @LeonardoFuciolo 6 หลายเดือนก่อน

    tanks Billy, you sabe the day!

  • @arneshguru4263
    @arneshguru4263 6 หลายเดือนก่อน

    After some tiring tasks, the problem got fixed. Thanks for the video.

    • @alljoydata
      @alljoydata 5 หลายเดือนก่อน

      Glad it helped

  • @NafisAnsari-vr2xq
    @NafisAnsari-vr2xq 6 หลายเดือนก่อน

    Hey Billy, I have successfully installed SSMS Developer version along with SSIS, yet I'm not getting an option for choosing my data base while importing the data, can you please help here? Thanks for the great installation tutorials.

  • @koushikvenuganan3999
    @koushikvenuganan3999 6 หลายเดือนก่อน

    I only have localdb in the shared feature and nothing about integration services... Need ur help on this one Billy!!! BTW your contents were super helpful man

  • @nafisansari5854
    @nafisansari5854 6 หลายเดือนก่อน

    Thank you so much Billy, this was a clear explanation. Subscribed

  • @gaston8524
    @gaston8524 6 หลายเดือนก่อน

    GOAT !! 🙌

  • @XolileMaseleni
    @XolileMaseleni 7 หลายเดือนก่อน

    I followed all steps and it worked and went past the error, however upon uploading data it showed the same error again, care to help with this one

    • @BillyThomasYT
      @BillyThomasYT 7 หลายเดือนก่อน

      What is the error?

  • @tja1978
    @tja1978 7 หลายเดือนก่อน

    This is f**** gold.... thanks for this clearly instructed video... helped alot

  • @NgocNguyen-js8tm
    @NgocNguyen-js8tm 7 หลายเดือนก่อน

    Please help me, I dont see the Developer nor the Enterprises in SQL2022 folder. Mine only has Express :( is there anyway I could install?