How To Overcome Negative Perceptions of Your Job Title / Background

How To Overcome Negative Perceptions About You!

As humans we all process information through filters and one of those filters is your current job title / background!

Though your job title may work well for you right now, the moment you try and take on a different role, job title / background / responsibility, you end up running into a brick wall! … it is like people fold their hands and adopt a challenging, prove-it-to-me attitude!

So, in today’s post, I will answer a question submitted by (Jan) who has worked 15+ years for one of the largest IT Corporationsbut still feels boxed-in / walled-in” by his current job title!

Oracle Or Microsoft Access, Which Is Better?

Part 16 of 20 in the Series: Career Paths for Database Professionals
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.

Do You Want to Learn SAS Data Analysis?

Part 12 of 13 in the Series: Data Analyst Jobs or Careers or Work
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?

Part 11 of 13 in the Series: Data Analyst Jobs or Careers or Work
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.

What Personality Types Are DBAs?

Part 15 of 20 in the Series: Career Paths for Database Professionals
What Personality Types Are DBAs?
What Personality Types Are DBAs?

This post about the personality types of database administrators (DBAs) is in response to Sandra’s question.

Sandra, thank you for taking the time to tweet a number of my posts, I appreciate you 🙂

Personality types like the Jung Myers-Briggs Type are used to describe the psychological characteristics of an individual.

For example, the famous Myers-Briggs has 16 personality types grouped as: Extroversion vs. Introversion, Intuiting vs. Sensing, Thinking vs. Feeling, and Judging vs. Perceiving.

A Day In The Life Of A Data Analyst

Part 10 of 13 in the Series: Data Analyst Jobs or Careers or Work
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?

Part 9 of 13 in the Series: Data Analyst Jobs or Careers or Work
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.

The Healthcare Data Analyst Job Description

Part 7 of 13 in the Series: Data Analyst Jobs or Careers or Work
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

Part 9 of 20 in the Series: Career Paths for Database Professionals
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.

Why Data Analysts Use Microsoft Excel?

Part 8 of 13 in the Series: Data Analyst Jobs or Careers or Work
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.

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

Part 6 of 13 in the Series: Data Analyst Jobs or Careers or Work
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.

The Job Outlook for Data Analysts

Part 4 of 13 in the Series: Data Analyst Jobs or Careers or Work
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.

How To Become A Data Analyst

Part 2 of 13 in the Series: Data Analyst Jobs or Careers or Work
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.