HR Data Security 101

…to the internet. Data transmission Every mid-sized and larger company integrates their HR data with multiple system and outside vendors.  When you send and receive data between systems, it must…

Moving Data From Excel to SQL Server with PowerShell (Relatively Painlessly)

…= join-path $FolderName $FileName $FileNameWithFolder #Variables for Write-SQLTableData $SQLServerInstance = “ADAM2017” $Database = “RedThree” $SchemaName = “excel” $TableName = “Example1″ ,(Import-Excel -path $FileNameWithFolder -ErrorAction Stop) | Write-SqlTableData -serverinstance $SQLServerInstance -DatabaseName…

Seven Basics of HR Data Success

…applications Learn, learn, learn Consistency vs consolidation Data integration means two things: Making sure that data is consistent across all your systems Bringing data from diverse systems together so that…

Power BI and UKG Pro

…– Cognos BI We’ve created six reports for the sample. These four reports are designed to completely refresh the data every time they run: DW – Company Codes DW- Earnings…

An Introduction to HR Master Data Management

Many, many HR data analytics projects don’t work because proper Master Data Management is not in place. HR Master data management means that key data about every employee, every job…

UKG Reports as A Service in Postman

…body, you’ll see that the report completed. And it’s put data into “Report stream” Of course, if you’re not a computer, that data isn’t all that useful. There are ways…

Using Power BI with UKG Pro/UltiPro

data you need to Power BI. If you use Power BI as your general enterprise tool, it makes sense to use it for data of general interest. For example, folks…

Start a conversation with us

Call: 917-848-7284
Email: inquiries@redthree.com

Request a Consult