Is Your Liberal Arts / Computer Science Degree Helping Or Hindering?

Is Your Liberal Arts Or Computer Science Degree Helping or Hindering You?
Is Your Liberal Arts Or Computer Science Degree Helping or Hindering You?

Hi:

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!

Nothing Great Was Ever Accomplished Without First Believing!
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 Get Extensive Hands-on Experience In Information Technology

How To Gain Hands-on Experience in-Information Technology
How To Gain Hands-on Experience in-Information Technology

When it comes to the Information Technology Industry, getting more hands-on experience is one of your most important professional development activities.

In this post, I will explain how information technology workers including business analysts, computer programmers, database developers, data analysts, project managers, software testers and infrastructure / networking professionals can gain extensive, high visibility, career defining hands-on experience!

More Opportunities To Get Hands-on Experience

By far, the number one place to find hands-on project experience in the information technology industry is in web or software development projects!

Oracle Or Microsoft Access, Which Is Better?

Oracle Or Microsoft Access, Which Is Better For Me?
Oracle Or Microsoft Access, Which Is Better For Me?

Are you matching your strengths to your opportunities or are you just being ideological … interested only in following your own ideas even when they won’t get you any results?

Here is a situation that illustrates the challenges of being ideological versus being results oriented. It is a situation that illustrates the challenges of learning an enterprise software like Oracle compared to a poor man’s database like Microsoft Access.

Are you wondering about who this situation involves? You are safe my friend because today, I will mainly be talking about me 🙂

Do You Want to Learn SAS Data Analysis?

How to Find a Well Paying Job?
How to Find a Well Paying Job?

What do you do when you apply for a job and realize that you don’t have all the software skills listed on the job posting?

You may decide to stop your job search and get training or certifications in all the software packages listed on the job posting.

But what if these are enterprise software packages costing thousands of dollars to learn, then what?

And what if you are talking about not just one but multiple software packages?

How to Get a Job in Web Data Analytics?

Web Analyst Jobs
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.

A Day In The Life Of A Data Analyst

Data Analysis: Profiting From Numbers
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…

What Are The Required Skills for Entry-Level Data Analyst Jobs?

Entry Level Data Analyst Jobs
Which Skills Are Required For Entry Level Data Analyst Jobs?

Are there any required skills for entry-level data analyst job postings knowing that hiring managers are quite creative with their help wanted ads?

Keeping in mind that there is no “one size fits all” job requirement for data analysts or any information technology (IT) job, here are some of the more common skill requirements:

  • Number crunching, analytical or numerical skills & background
  • Reporting experience using Excel, Microsoft Access, Crystal Reports / Business Objects, SQL Server Reporting Services or any Graphing tool
  • Relational Database Design & Development with tools like MySQL, SQL Server, Microsoft Access or Oracle
  • A passion, interest, aptitude or background in number crunching or analytics

Many data analysts started out using Microsoft Access because it is a popular and versatile data analysis tool.

Microsoft Access provides a one-stop relational database, sql querying and reporting environment and it also provides data analysts with the ability to build a powerful graphical user interface (UI) for collecting data.

The Healthcare Data Analyst Job Description

healthcare data analyst job description
healthcare data analyst job description

Data Analysts interested in learning about the right tools, techniques or skills for their job, should read this.

I am going to address the challenges facing a data analyst” starting a healthcare data analyst job.

If you need help with a Question or Challenge, be sure to ask for help by posting a comment because I will answer it fully … just like I am answering this data analyst’s questions below!

How To Start A Healthcare Data Analyst Job?

Here is the challenging data analyst career situation:

How To Write Complicated Or Complex SQL Queries

Master Complex SQL Queries
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:

Giving Effective Feedback to IT Professionals

We Give Feedback!
We Give Feedback!

One of the challenges of self teaching, self learning, CBT courses or traditional class room training is the lack of personalized, one on one performance review or feedback.

Training courses where both instructors and trainees can post or respond to questions are few and far in between.

This is the case even when you pay thousands of dollars for traditional class room training!

This is because training providers typically have an in-flexible curriculum and a set amount of training time to communicate their message!

Career Spotlight on Microsoft Access Database Developers

Microsoft Access Developer Career
Microsoft Access Developer Career

The Microsoft Access Relational Database has been around for a while and it is used in many businesses, Information Technology (IT) Teams and organizations.

Microsoft Access is commonly used in building desktop software applications, data analysis programs and corporate databases where the number of records are as few as 2 billion records or the number of users who access the system at any one time are as few as ten concurrent users.

The ease with which Microsoft access database developers create functional relational databases, add data entry forms, build reports and distribute their database projects to multiple users creates a market for skilled Microsoft Access Relational Database developers.

Why Data Analysts Use Microsoft Excel?

The Data Analysts Career Path
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.

How Do I Transition Microsoft Access or Excel Data Analyst Skills?

The Data Analysts Career Path
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.

How To Answer Data Analyst Interview Questions Correctly

Data Analyst Interview
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!

Practice tests or quizzes are effective for improving Data Analyst skills, retention or recall which helps you ace your Data Analyst job interviews!

The Job Outlook for Data Analysts

There's Gold In Them Thar' Data
There's Gold In Them Thar' Data

According to projections by IDC (a well-known research firm), the amount of computing, web and digital data will increase fivefold by 2012 as a result of an upsurge in sensor signals, surveillance tapes, social network chatter, public records and more.

The increases in availability and storage of corporate transactional data within the last decade has left companies scrambling for data analysts trained in interpreting or making inferences based on data.

With the help of data analysts, companies can improve the speed and quality of their business decisions, manage risks better, predict the likelihood of favorable or unfavorable outcomes or provide their management team with improved predictive business intelligence.

Sticky: Learn Data Analysis Online – The Easy Way!

Learn Data Analysis The Easy Way!
Learn Data Analysis - The Easy Way!

Data Analyst Training Courses Are Usually Not Cheap …

But Now, By Using The Latest Advances In Technology …

Data Analysts May Get Trained At Home Or Office …

For A Fraction Of The Traditional Cost!

Full + Comprehensive Suite Of Data Analyst Courses In One Training Package!

  • Statistical Principles Course

  • Central Tendency & Dispersion Course

  • Goodness Of Fit Class

  • Curve Fitting Course

  • Control Charting Class

  • Time Series Analysis Course

  • SQL Data Analysis Courses

Your Opinion Counts – What Makes A Good Data Analyst?

Ask a Burning Question
Ask a Burning Question

In reply to a question by a Statistician transitioning to a data analyst career, I posted the article Are Statistics Or SQL Skills Required In Data Analyst Careers?

My reply also included a Skills Gap Analysis for Statisticians or Mathematicians who want to become data analysts.

I got a comment from another Mathematician / Statistician which I have posted below.

Let me know if you have a comment or opinion or feedback on this issue … here is my reader’s comment:

Jonathan’s Opinion:

I just read through the article entitled ARE STATISTICS OR SQL SKILLS REQUIRED IN DATA ANALYST CAREERS?

Are Statistics Or SQL Skills Required In Data Analyst Careers?

Are Statistics or Sql Skills Required For Data Analyst Jobs?
Are Statistics or Sql Skills Required For Data Analyst Jobs?

This post answers a question about the educational training requirements for a Data Analyst Career.

If you have a Burning Question or a Challenge that you need help with, Click Here To Ask Your Question and I will answer it fully just as I am answering the question below!

Is Statistics / Sql Required For Data Analyst Jobs?

I have a degree in Statistics and I am finding it hard to get a data analyst job even though people from other backgrounds are able to get data analyst jobs.

What Software Skills Do Business Analysts Need?

Have you noticed the increasing demand for business analysts with stronger software skills or a wider range of skill sets?

Because this is a top hiring trend, business analysts have expressed concern about the range of skillsets requested for on job postings.

Some of these strong concerns are often worded as:

  • What software skills do business analysts need?

  • Should business analysts be made to learn computer programming?

  • Which software programs are required for business analysis jobs?

Along the same lines, one of the concerns expressed is; should business analysts have in depth knowledge of SQL, Access, Customer Relationship Management (CRM) software and Reporting writing software?

How To Become A Rockstar In Your Industry

How To Become A Rockstar In Your  Industry
How To Become A Rockstar in Your Industry

Top performers, rockstars or successful professionals have a mindset or a way of thinking.

They practice a code or follow a set of principles that helps them achieve the best results in their industry.

This post features the “Rockstar Mindset” and other actionable strategies for becoming the best at what you do.

Always Be Learning

Stay Ahead of the Curve!
Stay Ahead of the Curve!

According to the Japanese Kaizen philosophy, consistence and commitment to studying, getting more information or improving your skills is better than sudden bursts of efforts.

Beginner To Advanced SQL Skills In Hot Demand

California Gold Rush Of 1949
California Gold Rush Of 1949

Beginner to Advanced SQL Skills are among the top-paying, hottest, in-demand tech skills.

The demand for SQL skills is strongest across the breadth of Information Technology careers that includes the business analyst, web developer, data analyst, report writer, computer programmer or IT manager.

This article explains the reason why IT professionals at different stages in their careers (beginners, intermediate or senior) experience a consistently high demand for beginner to advanced SQL Query Writing skills.

Live, Online, Hands-On, Instructor Led, Web Based Business Analyst Training

If you are interested in registering for Business Analyst Boot Camp, you need to consider the following information:

Business Analyst Career Roadmap Or Career Planning

BUSINESS ANALYST BOOT CAMP is for business analysts, data analysts, software developers, managers or IT professionals who want to master the core business analyst skills including:

a. UML

b. Requirements Gathering and Analysis

c. Use Cases

d. How to define Business Cases

e. How to define Project Vision and Scope

f. How to plan the Business Analysis Work

g. The Requirements Process, Definition and Documentation

Knowledge Workers Accept The Challenge To Be The Best Or Why IT Professionals Feel UnderValued

How you value knowledge tells me a lot about who you are … because knowledge capital is the most important resource in any organization.

In the digital age, what makes one employee more valuable than the next employee is simply stated … the amount of knowledge, skill, expertise, training and learning they have managed to acquire and put to use.

Now, managers are not interested in employees that know it all … only in employees that constantly put their knowledge capital to work by solving corporate problems or challenges … those employees are the gold mines in any organization.

How To Become A Data Analyst Or Report Writer Or Database Developer

Three Different Job Roles

The database developer job, data analyst job or report writer job are related job roles that may be performed by the same person depending on how the size of the organization.

In most organizations, the business analyst or software developer starts out performing all three types of jobs. As demand multiplies and the individual begins to feel overwhelmed, the jobs are split … and as time goes … into the three (3) different type of jobs.

For this reason, anyone performing the duties of a business analyst, software developer, database analyst, report writer or database developer needs to have a strong understanding of each of these job responsibilities as well as the areas of overlap.

How To Schedule An Online Training Class

If you are interested in registering for an online training class, here is some additional information that you need to consider before you sign up for the ongoing SQL BOOT CAMP or BUSINESS ANALYST BOOT CAMP or SOFTWARE DEVELOPER BOOT CAMP.

Career Roadmap and Career Planning

1. The online SQL BOOT CAMP class is for database developers, data analysts, report writers / developers, business analysts or software developers who want to learn or master two (2) core or fundamental programming skills:

a. Relational database design and database development

b. SQL query writing and SQL programming

Database Design Courses

The training courses at SQL Boot Camp is for data analysts, report
writers, SQL developers, business analysts, computer programmers and database
developers who want to improve their SQL or database skills .

Hands-On Training

The SQL training courses are a combination of hands-on, practical training
combined with real world projects.

Step By Step Training Courses

You study step by step the concepts you need to master to design efficient,
enterprise scalable relational databases at your own pace, schedule
and time and from the comfort
of your home or office.

How To Find Affordable, Flexible Career Training Programs

If you want to excel in an information technology career, you need to make a career plan or plot a career road map that will take you from your current skill level to a professional, highly skilled or expert level.

You will also need to create a plan for maintaining your skills at the level of
top performers or experts in your field when you get there.

Whatever your current career (business analyst, data analyst, software
developer, report writer, database developer, web designer, etc.), you need to
sharpen your skills using one or more of the following training options:

72 Hour Special For SQL BOOT CAMP

The online SQL Training at SQL Boot Camp is an on-going online training session
that you can join at any time.However there is a special that starts today
and ends on March 1, 2008 which offers you a $500.00 discount.

If you are interested, all you have to do is register for the special at
SQL BOOT CAMP and then place a special,
one-time discount code in your shopping cart when you order your online
training.

Here is the special, one-time discount code: XxT95763

This offer ends on March 1, 2008.

How To Become A Data Analyst

How To Become A Data Analyst
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.

Database Developer Training Special

The 2008 database developer training year begins on February 15, 2007.

Sign up now for the specially discounted enrollment fee because by February 15, the database training enrolment fee will be $500 or $750. Click this link to SQL BOOT CAMP to see how much you will save at the current enrollment fee.

Who Does The Database Developer Training Cover?

1. The database training covers everything you need to design and develop enterprise databases.

2. The database training covers SQL programming training or SQL developer training from the beginner to advanced topics as well.

SQL Training

Popular Programming Languages

SQL is one of the most popular programming languages. SQL is a programming language used to query or analyze data and develop databases. SQL is as widely successful as it is common in the software development industry. SQL is a language familiar to both geeks and the technically savvy business users or powers users as they are sometimes known.

Why Is SQL So Popular?

SQL is popular because it is the programming language used to manipulate relational databases. Relational databases are employed in practically every major business application, web development project or software application to store information.