View My Drafts
Hello from Austin, Texas!I called myself "Data Analyst/BI Developer" when I began this job (about a year and a half ago). But we haven't actually gotten to much of the Data Analyst part.I have walked into a company with 13 years of data in a Dynamics GP database, along with some other applications, but not much of an idea what to do with all this data.There are people whose full-time jobs are to ask IT for reports, export the reports, cut and paste fields and columns from the reports into a new Excel file, and modify things and move them around until the data is presented in the way their manager wants to see it, and distribute that output. And the next month, or next quarter, do it all again.Mind-boggling!I am pleased to be working for a CFO who wants all the data in all those reports in real-time, on demand, displayed on easily available, interactive reports. He is working on the other C-level and director-level execs to get them on board, and they are all getting excited about the dashboard and reports I am creating (they are not so excited about the data models behind them - not realizing that's where the magic happens!). I am also discovering a lot of what I call "tribal knowledge" that people "just know". It just lives in their heads. "Which warehouses are the ones to be reported on this particular report for this region?" You just know them and type in the list when you program the report. When the list changes you better remember every query you put that hard-coded list in, to revisit and add to it. Unacceptable in my way of doing business!So now I am realizing that we have a Master Data Management and Managed Self-Service BI nightmare coming, and I'm the only one who can see it. And I want to be the one to solve it. I have no MDM experience, so will likely be reaching out to you ladies from time to time.
There are also few women in high positions in this old and old-fashioned organization, outside of Communications, HR, and Accounting. They are not knowingly, deliberately sexist - but they really don't know what I do, or what I can do, or what I should be doing. They tend to think that they just tell me "give me a report with these things on it, arranged this way," blah blah and that my job is to simply produce what they said - like typing.
It will be an exciting, but anxiety-provoking, process to educate them on moving to a data culture.