- 62
- 52 325
Billy Thomas ALLJOY Data
United States
เข้าร่วมเมื่อ 16 พ.ค. 2023
Hello and welcome to my TH-cam channel! My name is Billy Thomas. I am an executive who has worked with data for over 30 years. I specialize in SAP enterprise master data. We will be covering topics like Data Strategy, Data Quality, Data Migration, Business Ready Data, SQL, Tableau, GCP and much more.
Working with data as a trusted data consultant for many fortune 500 companies has been a very lucrative, challenging and fun job. At the heart of this YT channel is a desire to share some of the knowledge and skills that others have invested into me and give back by passing that knowledge on to you.
Why ALLJOY data you may ask?? .... "it's ALLJOY data because working with data should make you smile"
Working with data as a trusted data consultant for many fortune 500 companies has been a very lucrative, challenging and fun job. At the heart of this YT channel is a desire to share some of the knowledge and skills that others have invested into me and give back by passing that knowledge on to you.
Why ALLJOY data you may ask?? .... "it's ALLJOY data because working with data should make you smile"
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)
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
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 ☺
Is there a more modern way to pull full tables even if the number of rows are up there?
After trying with so many tutorial I finally got it right, thanks so much Billy. I appreciate
Thank youuu very much my GOD
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😉
hi.. thank you for your tutorial. could you please make a tutorial to make a portfolio for data analyst?
I was losing my mind HOLY THANKS
I would never have been able to do it on my own. Thanks a lot. This solved my problem
Excellent!
Excelente, muchas gracias
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?
Thank you so much bro! Solve my problem !!!
Thank you so much!
too good
This video is a saviour :)
But here it will convert all the data types to varchar(50) in my System
i don't have integration services in shared features
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?
Outstanding tutorial. Many thanks for the wealth of information you share with us🏆🏆🏆
thanks sir ,it worked 😇😇😇
You just saved me a lot of googling man, thank you very much!
Thank You !
thank you so much i was struggling to find o video to solve my problem
Your welcome!
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 👍
Thank you so much! 🍻
Best lesson on SE16N thank you!!!!
Ive been trying to go over this for 2 days - thank you for the super clear tutorial!
For some reason sql can not find it gives me a message saying "there is no file to be restore" any tips ? cheers
2nd day Lets go 😀
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.
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.
Just found your channel watched couple videos solve the problems You save the day ! One stop channel for any issue Great tutorial Thanks alot
Let me know if there are any more data / sql videos that would be helpful. Have a great day!
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
Please send me a screen shot of your issue. Also, Did you create or attach a database in SSMS?
@@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.
@@alljoydata Thank you very much to answering me. I hav fixed the error by installing accessdatabaseengine.exe and execute with /quiet on command prompt🫡
@@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.
Thank God this video is exist
You rock man.. Thanks from Kerala, India
Thank You so much Billy, was stuck on this for few days. You treated my headache.
Thank you so much!! This was so helpful to me in my data analysis; I’m super grateful. God bless you!
Glad it was helpful!
Thank you thank you thank you man! U saved my ass lol been troubleshooting this all day long, u definitely got a new subscriber!
Freakin Legend. Very helpful.
AWESOME!
big big big thanks
WOW
I really appreciate this, thanks a lot!!! Very helpful video
tanks Billy, you sabe the day!
After some tiring tasks, the problem got fixed. Thanks for the video.
Glad it helped
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.
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
Thank you so much Billy, this was a clear explanation. Subscribed
GOAT !! 🙌
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
What is the error?
This is f**** gold.... thanks for this clearly instructed video... helped alot
Please help me, I dont see the Developer nor the Enterprises in SQL2022 folder. Mine only has Express :( is there anyway I could install?