Is Your Liberal Arts Or Computer Science Degree Helping or Hindering You?
There is an assumption that certain college degrees are more helpful than others when it comes to preparing for, learning, or succeeding at information technology (IT) careers.
If you believe this to be true then you may also be of the mindset that a Computer Science (BSc.) degree is more valuable than a Liberal Arts (BA) degree!
Surprisingly, there may be some evidence supporting this assumption. For example, it has been noted recently that engineering and computer science college graduates are more employable and better paid than liberal arts college graduates.
Nothing Great Was Ever Accomplished Without First Believing!
This question was submitted by LaTonya, a US Military Veteran. LaTonya’s question is:
I trained in the US military as a Maintenance Systems Data Analyst, but only worked in my position for about 4 months before being honorably discharged.
In my current position, I have transitioned from being a full-time payroll clerk to handling most of the same duties that I did as a data analyst.
How can I extend that transition into my pay grade / title without having a degree?
The Answer To LaTonya’s Question Is …
How To Jumpstart A Stalled Career!
It has been said that to “keep doing the same thing over and over again expecting different results is the very definition of insanity.“
On the other hand, “if you want something you have never hard, you must do something you have never done!“
So, if your career is stagnating, step back and take an honest look at your work.
Is your work everything you had hoped for?
If the smell of fresh-brewed coffee is the biggest reward after you walk through the office door each day, it’s time to truly perk up your daily grind and reboot your career.
Do You Want A Web Analytics Job?
With the ever-increasing focus on setting up an online presence or the increasing competitiveness of online businesses, there is a need for web data analysts who can help web-based business succeed or thrive online.
A web data analyst researches the activities of users as they interact with a website, identifies the measures critical to the survival of the web business and recommends actions in the form of web analytics reports for web managers, online marketing teams or business owners.
Data Analysis: Profiting From Numbers
Data Analysts have the opportunity to work in several different domains or sectors, for example as banking data analysts, retail data analysts, telecommunications data analysts and as marketing data analysts.
The marketing data analyst role is one of the more common ones and a marketing analyst may be found analyzing databases of prospects, leads and customers for the marketing department.
In this post, we will take a peak into the day of a marketing data analyst…
Master Complex SQL Queries
Many database professionals have a hard time writing complex, complicated or advanced SQL queries for the following reasons.
In a healthcare database project that I consulted on, I had to write fairly complicated and efficient SQL queries for physicians at several practices because of their specialized reporting requirements.
The real problem was not the complexity of the physicians database but it’s poor suitability to the physicians reporting needs.
Based on experience gathered from consulting on several database or data analysis projects, I have observed that writing complex or complicated SQL queries, may prove challenging because of the following:
The Data Analysts Career Path
Microsoft Excel is commonly used for data analysis because it’s part of the popular Microsoft Office Suite and it even comes pre-installed on some computers!
Unlike statistical analysis packages like, SAS and SPSS, Excel is relatively inexpensive and widely accessible to small businesses and mid-sized businesses in a variety of industries including healthcare, finance, sales and marketing etc.
Microsoft Excel is used in organizing and analyzing data, performing complex calculations as well as creating graphical displays.
Microsoft Excel’s user-friendly interface makes data entry convenient and it also comes loaded with a wide array of mathematical, statistical, financial functions and a Data Analysis ToolPak.
The Data Analysts Career Path
This question was posted by a Microsoft Office Data Analyst who wants to know “How to Upgrade Microsoft Access or Excel Data Analysis skills!“
If you need help with a Question or Challenge, be sure to ask it as a comment on this page and I will answer it fully just as I am answering this questions now!
The Challenge Facing A Microsoft Access or Excel Office Data Analyst
My toughest challenge I face today with my career is I am itching for a move within the company I work for.
Ace your Data Analyst Interview
If you are looking for a scientific way to boost your data analysis skills or ace your Data Analyst job interviews, start using practice tests.
Research has shown that practice tests or quizzes improve retention, recall or understanding.
Research has also proven that workers who study and take quizzes have better long-term recall than their colleagues who study without taking quizzes.
Don’t use practice tests only in preparation for certification exams because they are useful for much more than that!
How To Become A Data Analyst
The data analyst career is one of the popular Information Technology (IT) career tracks available today.
The term data analyst is loosely associated with business data analysts, systems analysts, database analysts, reporting specialists, data researchers, statistical data analysts or marketing data analysts!
However, in this article, I will explain who a data analyst really is and provide a career roadmap or plan for becoming a data analyst.
Who Is A Data Analyst?
The term data analyst refers to someone who works with data or makes sense of the information buried in raw data or draws inferences and conclusions from it.