Row 8070

Row ID: 8070 | Dataset Entry | Axioma AXP Content Repository

Content Data

This page contains data entry 8070 from the Axioma AXP content repository. The structured data below represents the complete record for this entry.

I work for a Third Party Claims Administrator for property insurance carriers.

Since it is a small business I actually have multiple roles managing our SQL database and producing KPIs/informational reports on the front-end via Excel and Power BI both for our clients and internal users.

Coming from a finance background and being a one-man department I do not have any formal guidance or training on programming languages other than VBA.

I am about 2/3rds of the way through an online Python programming course at Georgia Tech and am understanding how to write the syntax pretty well now. As they only show what prints out to the console, I am trying to figure out how I can plug this into a relational database in order to improve my KPIs and reports.

I am able to create new tables in our SQL Database via SSMS. If I can't manipulate the data from there, I manipulate it in Power Query Editor (M) or Excel (VBA). If there was a way I could create a column in our SQL Server or even PBI/Excel via Python, I can see where the syntax would be much more straightforward than my current SQL/M/VBA calculated columns syntax.

However, I have not been able to find any good tutorials on how to plug this into these applications. Although my current roles are not as a data scientist, I would like to create models in the future if I could figure out how to plug it into our front-end applications.

FieldValue
text I work for a Third Party Claims Administrator for property insurance carriers. Since it is a small business I actually have multiple roles managing our SQL database and producing KPIs/informational reports on the front-end via Excel and Power BI both for our clients and internal users. Coming from a finance background and being a one-man department I do not have any formal guidance or training on programming languages other than VBA. I am about 2/3rds of the way through an online Python progr…
label r/datascience
dataType post
communityName r/datascience
datetime 2024-05-18
username_encoded Z0FBQUFBQm5LakwzYWpiZjhLMlIxRHczZF8zUElPLWRSZkU0MlZlN2NUcU1QVnBhT3BiaVFCNDAzVTBOaXAxYVZBUlhBX1U1dEVUdnVfdDZWRDR1NlRQMFF2ZmphNldfRGc9PQ==
url_encoded Z0FBQUFBQm5Lak9ITGRBYTNpdzZBdmNaWWZPZU5ieU9TdkNiYzNhNUVLNlM1Y1ZWa2NkNkQxOFdCOWVGSElNR2J5cjM4Q0FuS1BmdGxNMi1aSmdqbGxlbllaSHNwcEdEQ2x6ZUxaU3NPQ0REYkFvZ1FkcjZlOVFxWi1Ybmluam52S2VCaHlXUXdFVHcweGhPdXFWNGQzSHBlNU5FTFpYa0N3U3Y4Ui1DemdVWkRVOWduUGZPcWJVcDdTUVoyb29GY0lIVlNnUDZ6QXBLZ1E2aWlzaHVheHBOX0R2eFh0YXVUQT09

Raw Record

{
  "text": "I work for a Third Party Claims Administrator for property insurance carriers.\n\nSince it is a small business I actually have multiple roles managing our SQL database and producing KPIs/informational reports on the front-end via Excel and Power BI both for our clients and internal users.\n\nComing from a finance background and being a one-man department I do not have any formal guidance or training on programming languages other than VBA.\n\nI am about 2/3rds of the way through an online Python programming course at Georgia Tech and am understanding how to write the syntax pretty well now. As they only show what prints out to the console, I am trying to figure out how I can plug this into a relational database in order to improve my KPIs and reports.\n\nI am able to create new tables in our SQL Database via SSMS. If I can't manipulate the data from there, I manipulate it in Power Query Editor (M) or Excel (VBA). If there was a way I could create a column in our SQL Server or even PBI/Excel via Python, I can see where the syntax would be much more straightforward than my current SQL/M/VBA calculated columns syntax.\n\nHowever, I have not been able to find any good tutorials on how to plug this into these applications. Although my current roles are not as a data scientist, I would like to create models in the future if I could figure out how to plug it into our front-end applications.",
  "label": "r/datascience",
  "dataType": "post",
  "communityName": "r/datascience",
  "datetime": "2024-05-18",
  "username_encoded": "Z0FBQUFBQm5LakwzYWpiZjhLMlIxRHczZF8zUElPLWRSZkU0MlZlN2NUcU1QVnBhT3BiaVFCNDAzVTBOaXAxYVZBUlhBX1U1dEVUdnVfdDZWRDR1NlRQMFF2ZmphNldfRGc9PQ==",
  "url_encoded": "Z0FBQUFBQm5Lak9ITGRBYTNpdzZBdmNaWWZPZU5ieU9TdkNiYzNhNUVLNlM1Y1ZWa2NkNkQxOFdCOWVGSElNR2J5cjM4Q0FuS1BmdGxNMi1aSmdqbGxlbllaSHNwcEdEQ2x6ZUxaU3NPQ0REYkFvZ1FkcjZlOVFxWi1Ybmluam52S2VCaHlXUXdFVHcweGhPdXFWNGQzSHBlNU5FTFpYa0N3U3Y4Ui1DemdVWkRVOWduUGZPcWJVcDdTUVoyb29GY0lIVlNnUDZ6QXBLZ1E2aWlzaHVheHBOX0R2eFh0YXVUQT09"
}
Explore Dataset Explore Row

Entry Information