Hampson russell remove mean normalize logs10/26/2023 ![]() I don't mean write one big giant query: I mean put your data in a new model designed for a machine learning project. These are some of the ways I make it work. ![]() The data is HIPAA protected and can't be moved off the server without being processed to remove PHI and de-identified. Even the unstructured data is stored in a table as varchar(max), I'm not recommending this architecture but it's what I have to work with. Where I work I have a vast data lake in SQL Server. This makes little sense if every domain / data ecosystem, but not every data scientist has control over the way data is stored and managed. ![]() ![]() This post is for SQL savvy analysts who want to know how to contribute to a data science project or a newer data scientist who grew your skills using comma delimited files from Kaggle and UC Irvine (Zot!) only to arrive at businesses who expect you to mine your data from a complex relational database using SQL.with or without the help of a data engineer.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |