Data Category Archives - General Assembly Blog

Is a Data Science Career a Good Fit for You? Here’s What You Need to Know.

By

So you’re thinking of a career in data science, but you’re not sure if it’s the right fit for you.  Here is your data science guide, where we break down what data science is, day in the life of a data scientist, tips from GA’s data science alumni, career opportunities, and much more. 

WHAT IS DATA SCIENCE? 

According to Berkeley, data science is the ability to take data, understand it, extract value from it, visualize it, and communicate the findings. The term “data science” was coined in 2008 when companies realized the need for data professionals to analyze immense amounts of data. 

Continue reading

DATA ANALYTICS VS DATA SCIENCE: WHICH CAREER IS RIGHT FOR YOU?

By

First and foremost, it’s critical to understand the difference between data analytics and data science. To do so, let’s take a look at a definition of both.

According to Northeastern University, data analysis involves answering questions generated for better business decision-making. It uses existing information to uncover actionable data and focuses on specific areas with specific goals. 

On the other hand, data science focuses on discovering new questions that you might not have realized needed answering to drive business innovation. Keep reading for an in-depth overview of both disciplines to decide which career path would better suit your career aspirations.

Continue reading

Get Your First Data Analytics Job in 4 Steps (No Degree Required)

By

Making a career change can be scary, especially if self-doubt of “I’m not good enough” starts creeping in. However, there is no point in staying in a job or career that no longer brings you joy or fulfills you professionally. 

If you’re reconsidering your career, you’re not alone — over the last two years, over 50% of employed Americans have considered a total career revamp. Chances are, you know a relative or friend who is going through a similar career dilemma right now.

If you’re considering making a bold move to data analytics, we’ve got you covered. Understand if a career in Data Analytics is right for you in four easy steps.

Continue reading

Why You Should Consider a Career in Data Analytics

By

Data-Driven-UX-Design

Alert: approaching maximum storage capacity. 

The world’s data reached an all-time high in 2021. 79 zettabytes of data – which is enough storage for 30 billion 4K movies – was generated last year alone. 

This is a good thing – right? More data means more innovation, which means more advancements for society. 

Continue reading

5 Key Excel Skills You Can Learn in Minutes

By

Since it was created in 1985, Excel has practically become synonymous with data itself, and still is many years later. Spend a few minutes with our expert instructor in the videos below to learn the kinds of Excel tools that can help you be your own analyst—and make smarter decisions with data. 

How to Create an Excel Bar Chart

Bar charts are an important visual tool that can help express your data over time and tell a story in a visually appealing and digestible way. Learn more in our 2-minute lesson below:

How To Create an Excel Pivot Table

Pivot tables allow you to effectively summarize and highlight the importance of your data sets. They are an important presentation tool and can help you simplify your data. Learn more in our 3-minute lesson below:

How To Create a Histogram in Excel

Histograms provide a visual representation of variations within your data and can help display degrees of difference in an impactful way. Learn more in our 2.5-minute lesson below:

How To Create a Pie Chart in Excel

Pie charts can express percentages of a whole and represents a set period of time and can be helpful to show differences among a handful of categories. Unlike bar charts, it does not express changes over time. Learn more in our 2.5-minute lesson below:

How To Create a VLookup in Excel

A VLookup (vertical lookup) can help you lookup data that is organized vertically. It is useful in helping you spot trends and find important pieces of data that can be difficult to locate in large data sets. Learn more in our 2.5-minute lesson below:

A Beginner’s Guide To Tableau

By

Featuring Insights From Iun Chen & Vish Srivastava

Read: 2 Minutes

Tableau is a powerful data analysis and data visualization tool that anyone can use. It can be used by beginners to create simple charts and by advanced practitioners to solve complex business problems. It is user-friendly, easy to learn quickly, and includes a portfolio of business intelligence tools with the potential to give a wide range of roles the advantage of professionally analyzing data.

Simply put, if you can present data in a clear, compelling format, you gain a competitive advantage in today’s data-driven marketplace.

“Tableau enables you to quickly connect disparate data sources and utilize a drag-and-drop interface to analyze data and create dashboards,” says Vish Srivastava, who leads our Data Visualization & Intro to Tableau workshop. As a product leader at Evidation Health, he relies on Tableau to turn around fast data analysis. “For example, product teams use it to analyze user growth and analytics, BizOps teams use it to analyze operational data, and sales teams use it to analyze customer and revenue data.”

Businesses survive and thrive on data. The amount of data available to businesses today is impressive. To keep organizations on a successful path, analysts need to provide the key insights needed to make important decisions.

Here’s where Tableau comes in.

Tableau takes business intelligence to the next level, making it fast and efficient to analyze large amounts of data and create beautiful, presentation-ready visualizations that generate insights.

Data is the lifeblood of modern teams. Being able to quickly answer ad hoc questions and integrate data analysis into your day-to-day decision-making will make you an MVP. Though not all data analysts use Tableau, they do need some way to quickly create data visualizations.

Tableau is the data viz tool of choice.

Tableau is so popular in part because it is easy and fast to learn. In Iun Chen’s Intro to Data Analytics course, students learn the life-changing basics of Tableau in an afternoon. Aspiring analysts come to understand the power of data and the impact their numbers can have. As more data becomes available, there are more opportunities for data to be misused, a risk that every data scientist soon realizes. To quote the Nobel laureate and economist Ronald Coase, “If you torture the data long enough, it will confess.”

The ethics of data form the foundation of Chen’s syllabus so pitfalls are avoided from the start. “Overanalyzing and manipulating data too deeply can always give you the information you want,” says Chen. “Unfortunately, this is all too common in professional settings, though it’s usually unintentional.”

Tableau is a powerful tool.

Business insights are only as good as the data behind them, and the best data analysts understand that the human choices they make matter.

“Data is the perfect example of garbage in, garbage out,” says Srivastava, who defines good data as data that is ethically collected, complete, objective, and thoroughly analyzed. ”The double-edged sword of using powerful data analysis and visualization tools is that beautiful charts can create a false precision and obfuscate data integrity issues.”

To delve deeper into this topic, Chen recommends How Charts Lie, by Alberto Cairo, an exploration of how data can be altered:

“This book details how the use of data and data visualizations in journalism can be distorted and misleading, without the audience even realizing it, due to the urgency to present findings in a timely manner to the public.”

Want to learn more about Iun?
https://www.linkedin.com/in/iunchen 

Want to learn more about Vish? https://www.linkedin.com/in/vishrutps

7 Tips to Learn Tableau Fast

By

Featuring Insights From Iun Chen & Vish Srivastava

Read: 2 Minutes

Let’s get it straight: How difficult is it to learn Tableau for a complete beginner? Are there shortcuts to learning Tableau? Any tips, tricks, or time-saving work-arounds? Thankfully, the answer is yes. Try these top tips, approved by our expert instructors, and start data viz now.

“It’s a little overwhelming at first but as soon as you understand the basics, like what are dimensions and measures, everything falls into place pretty quickly,” says Vish Srivastava, product leader at Evidation Health and GA instructor.

“In essence, you need to understand two things: The basics on how data works — for example, what are common formats of data and what is a primary key? And a basic understanding of data visualization in a business setting. Can you answer the question: When is a time series vs. a pie chart valuable for decision making?”

But can you really learn the basics of Tableau in an afternoon?

“The best way to learn is to download a sample dataset and dive right in and start creating data visualizations. To keep going from there, check out various portfolios online to get inspiration, and try to build those.”

According to Iun Chen, who conducts internal Tableau training at LinkedIn, Tableau is easy to learn, but hard to master.

“The basic concepts of charting and color theory are easy to pick up and can take just a few weeks. However, if you are looking to be a subject matter expert, this can take years to perfect,” she says. 

Chen preps students in her Intro to Data Analytics course to achieve close-to-mastery in these key areas.

  1. Can they quickly prep and analyze large volumes of data?
  2. Identify key information and determine the best visual method to present them?
  3. Take business questions and determine which visualizations to use?
  4. Translate raw datasets to storylines with a beginning, middle, and end? 
  5. Format charts, graphs, titles, text, and images for a polished deliverable? 
  6. Articulate best practices on design and visualization techniques?
  7. Provide feedback on ineffective visualizations and how to improve them?

    This checklist is the closest thing to a Tableau cheat sheet you’ll find. Prioritize these skills, and you’ll waste no time learning Tableau. Now that you know what you need to succeed, you can choose whether to take our Data Analytics course fast or slow. Learn Tableau — along with data analytics tools SQL and Excel — in a 1-week accelerated format, or over 10 weeks in the evening.

Chen sums it up perfectly: “As long as you are actively learning, applying your learnings, and ensuring innovation of your work, you will be a data visualization expert in no time.”

Want to learn more about Iun?
https://www.linkedin.com/in/iunchen 

Want to learn more about Vish? https://www.linkedin.com/in/vishrutps

Top 3 Reasons To Learn Tableau

By

Featuring Insights From GA instructor Candace Pereira-Roberts

Read: 2 Minutes

Do you communicate data? Do you want to create more effective data visualizations? Tableau is the data analytics tool you’re looking for. Here are the top three reasons why you should learn how to use Tableau, the popular data viz software focused on business intelligence. Read on for the advantages of being a Tableau professional.

#1 Tableau Is Easy

Data can be complicated. Tableau makes it easy. Tableau is a data visualization tool that takes data and presents it in a user-friendly format of charts and graphs. And here’s the rub: There is no code writing required. You’ll easily master the end-to-end cycle of data analytics.


Need to showcase trends or surface findings? Tableau will make you an expert. Proficiency in business intelligence is a transferable skill that is quickly becoming the lifeblood of organizations. 

“I see students who are new to analytics learn Tableau desktop and be able to develop Tableau worksheets, interactive dashboards, and story points in a couple of weeks — essentially a complete data analysis project,” says Candace Pereira-Roberts, FinServ data engineer and one of our Data Analytics course instructors. She adds, “I like to share knowledge and watch people grow. I learn from my students as well.” 

 #2 Tableau Is Tremendously Useful

Would you rather tell visual stories with data? Or present the same old boring reports and tables? Is that even a question?

“Anyone who works in data should learn tools that help tell data stories with quality visual analytics.” Full stop.

The smart data analyst, data scientist, and data engineer were quick to adopt and use Tableau tool by tool, and it has given those roles a key competitive advantage in the recent data-related hiring frenzy. But their secret is out. And the advantages go beyond the usual tech roles. Having a working knowledge of data, and specifically knowing how to use Tableau, can help many more tech professionals become more attractive to recruiters and hiring managers.

Plus, it has a built-in career boost. Tableau’s visualizations are so elegant, you’ll be confident presenting the business intelligence and actionable insights to key stakeholders. Improving your presentation skills is par for the course.

#3 Tableau Data Analysts Are in Demand

As more and more businesses discover the value of data, the demand for analysts is growing. One advantage of Tableau is that it is so visually pleasing and easy for busy executives — and even the tech-averse — to use and understand. Tableau presents complicated and sophisticated data in a simple visualization format. In other words, CEOs love it.

Think of Tableau as your secret weapon. Once you learn it, you can easily surface critical information to stakeholders in a visually compelling format. That will make you a rockstar in any organization. 

“Tableau helps organizations leverage business intelligence to become more data-driven in their decision-making process.” Pereira-Roberts says. She recommends participating in Makeover Monday to take your skills to an even higher level. 


Want to learn more about Candace? Check out her thoughts on how to become a business intelligence analyst, or connect with her on LinkedIn.

What Is Data Visualization?

By

An Interview With Iun Chen

Read: 4 Minutes

Data is big, and it’s getting bigger. How do you parse and understand data when the sheer amount of information can be overwhelming? The answer is data visualization. Using concepts of design theory like elements of color and layout, the discipline of data visualization, or data viz, is essentially the graphic representation of data. We called on one of our data viz experts, Iun Chen, to break it down further. 

Let’s start with an introduction and how you came to the world of data viz.

IC: I’m Iun (pronounced ‘yoon’), and I work in the data analytics space focusing on business intelligence tools and building scalable resources for LinkedIn. I also teach the 10-week Intro to Data Analytics course for GA, which includes the professional skills of SQL, Tableau, and Excel.

In college, I was a business major with a specialization in marketing and advertising. I became more interested in how the ad business model worked behind the scenes and in how software and systems worked. As a result, I worked at many major media companies in a quantitative capacity — revenue planning, ad pricing, finance, ad sales strategy. That led me into a formalized analytics route.

How do you define data visualization?

IC: Data visualization is the idea of communicating information graphically. It’s the science of information design, in which you take massive amounts of data in whatever format it comes in and use it to surface high-level insights and findings in a visually compelling way so audiences can easily understand the main points.

How does data visualization differ from data analytics?

IC: Data analytics is the process of cleaning, prepping, analyzing, and presenting data. Data visualization is part of the presenting data step and is defined as the act of visually organizing data through the use of charts, graphs, and dashboards. Concepts of data visualization are closely aligned with concepts of design theory: color, font, scale, layout, organization.

Why is data viz important?

IC: Data visualization is easy to learn but hard to master. In my classes, I heavily emphasize the design element of data visualization. It’s easy to whip together a quick bar or pie chart, but is it the best way to communicate the point you are trying to make? The goal of collecting mass amounts of data is to be able to quickly translate it into insights that can help make smart business decisions. The final form of this translation is often a chart or graph, which is why the ability to design and visualize these mass amounts of data grows as we collect more of it.

What is a data narrative?

IC: People think in stories and narratives, not in black and white figures. Just like you would share a story with a friend using a beginning, middle, and endpoint, you would do the same when sharing details about data analysis. Here’s a simple example.

  1. Beginning: Sales are down year-over-year; identify the symptoms.
  2. Middle: Furniture sales — our largest segment — are doing poorly in the last six months; conduct the analysis to investigate reasons and uncover root causes.
  3. End: Review retail store reports and conduct manufacturer visits; recommend next steps.

The key point to any data narrative is that it should present a compelling business case and surface unrealized insights to the audience. The business challenges, rationale, and next steps should be clearly presented, and people in the room should be able to walk away and know what to action on. 

Which tech roles use data visualization?

Data visualization — like data analytics — is a skill set that can be applied to any job. But if you are looking for a job that has data visualization skills as part of the function and responsibilities, look for roles like business analyst, data analyst, business intelligence analyst, data scientist, and data engineer. Keep in mind that the formal skill of data visualization is still relatively new, so depending on the maturity of the company, those functions may not be fully established yet. However, with the increase of data in the world, there’s a growing need for experts who understand data visualization techniques more and more.           

Check out this Medium post which details how Spotify’s business has evolved with the creation of their data visualization roles.

What’s the future of data visualization?

As we continue to collect more and more data, the need for people with the skills to analyze and present data becomes ever-growing and critical in the workplace environment. More companies will need to generate insights quickly to keep up with advances and competition in their respective industries. The skill of data visualization will become more and more attractive as teams and organizations seek to translate their data into insights more efficiently and effectively. The ability to work with data is increasingly critical to the success of any company in any job function. 

Iun Chen’s Recommended Data Viz Reading List

FlowingData

StorytellingWithData

InformationIsBeautiful

Tableau Public Gallery

New York Times Data Journalism

The WSJ Guide to Information Graphics

Storytelling with Data: A Data Visualization Guide for Business Professionals 

Good Charts: The HBR Guide to Making Smarter, More Persuasive Data Visualizations

Edward Tufte’s The Visual Display of Quantitative Information

Want to learn more about Iun?
https://www.linkedin.com/in/iunchen