Class Level:
All levels
Other Categories in Tech
Price:
$3,950
8 seats
Start Date:
Tue, Nov 06, 6:30pm - Jan 24, 8:30pm (21 sessions)
Location:
Downtown, Washington, D.C.
1133 15th St NW 8th Fl
Btwn L & M Streets NW
Washington, District of Columbia 20005 (Map)
1133 15th St NW 8th Fl
Btwn L & M Streets NW
Washington, District of Columbia 20005 (Map)
Important:
No class: 12/25, 27/2018 & 1/1/2019
A computer will not be provided.
A computer will not be provided.
Age Requirements:
18 and older
Average Class Size:
20
What you'll learn in this data analyst training:
This is a part time course.
This course will teach you how to use large datasets to make critical decisions.
Unit 1: Exploring Data with Excel
Understanding the Value of Data
Understanding the Fundamentals of Databases and SQL
Exploring the Fundamentals of Tableau
This course will teach you how to use large datasets to make critical decisions.
Unit 1: Exploring Data with Excel
Understanding the Value of Data
- Explore the value of data.
- Work your way through the data analytics workflow.
- Unlock the power of Microsoft Excel to utilize its analytical tools — no matter your experience level.
- Learn best practices for collecting and cleaning data in Excel to ensure accurate analysis results.
- Manipulate real-world data sets using advanced nested logical functions (IF, OR, and AND).
- Clean large, unruly data sets by removing duplicate rows and performing text manipulations.
- Transform and rearrange columns and rows within spreadsheets to prepare data for analysis.
- Gain insight into data analysis by manipulating data formats.
- Use the VLOOKUP and HLOOKUP functions to manipulate data sets.
- Look up values in other tables using the functions INDEX and MATCH.
- Summarize data using pivot tables.
- Execute Excel aggregation commands (SUM, AVERAGE, COUNT, etc.) and their conditional variants (COUNTIF, COUNTBLANKS, etc.) to summarize data sets.
- Derive insights from data by highlighting cells based on conditionals.
- Use scatter plots, bar graphs, and histograms to visualize data.
- Explore color theory and how it applies to data visualization.
- Build your own data dashboard using industry best practices.
- Apply visual design principles to your dashboard to present your findings clearly.
- Understand the value of descriptive and inferential statistics.
- Learn to describe data and identify outliers using its mean, median, mode, range, and variance.
- Make predictions about larger populations using sample data.
- Learn best practices for describing analysis techniques.
- Communicate insights and implications for stakeholders.
- Deliver short, effective presentations sharing your findings.
- Provide context for your audience by identifying and presenting the salient statistics.
Understanding the Fundamentals of Databases and SQL
- Practice the fundamentals of Structured Query Language (SQL).
- Use database schema to design appropriate queries using SQL.
- Explore the differences between relational databases (tabular data storage) and document-based databases (key-value pairs).
- Collect data using standard SQL commands (Create, Update, Truncate, etc.).
- Filter data using advanced SQL commands (Where, Group By, Having, Order By, Limit).
- Obtain data by creating relationships between tables using Joins.
- Gather filtered data using SQL Boolean operators (AND and OR) and SQL conditional operators (=,!=,>,<,IN, and BETWEEN).
- Create relationships between tables and data points (including has_many and many_to_many) using Join tables.
- Write Boolean statements with SQL conditional operators (=,!=,>,<,IN, and BETWEEN) and null functions (“IS NULL,” “IS NOT NULL,” and “NVL”).
- Clean data using SQL mathematical functions (ABS, SIGN, MOD, etc.).
- Summarize data sets by employing aggregation commands (“Sum,” “Average,” “Count,” etc.).
- Determine data trends by applying aggregation methods.
- Use CASE statements to structure data and create new attributes.
- Combine multiple subqueries into one using “WITH AS.”
- Create a local database using data sets you bring into the classroom.
- Upload and export data using a local database.
Exploring the Fundamentals of Tableau
- Get hands-on, practical experience navigating the Tableau software interface.
- Connect your data to Tableau and identify the best ways to visualize and display your results.
- Use bubble graphs to visualize data.
- Display geocoded information for your data.
- Contextualize analysis results by creating Tableau dashboards.
- Incorporate charts and conditional formatting into your dashboard using supporting information specific to a particular data set.
- Understand the use of specific data analysis software.
- Apply all the tools and skills you’ve acquired in Excel, SQL, and Tableau to analyze a data set from start to finish.
- Identify strengths and areas for improvement in your analytical skills with feedback from peers, instructors, and guest panelists.
School Notes:
For students enrolling in 12 week part time and immersive classes, it is not recommended that you book more than one class simultaneously.
For students enrolling in 12 week part time and immersive classes, it is not recommended that you book more than one class simultaneously.
Still have questions? Ask the community.
If you can't make it to a class/workshop, please email us at [email protected] at least 7 days before the scheduled event date. No refunds will be given after this timeframe.
Map
General Assembly
Downtown, Washington, D.C.
1133 15th St NW 8th Fl
Btwn L & M Streets NW
Washington, District of Columbia 20005 Downtown, Washington, D.C.
1133 15th St NW 8th Fl
Btwn L & M Streets NW
Washington, District of Columbia 20005
Start Dates (1)
| Start Date | Time | Teacher | # Sessions | Price |
|---|---|---|---|---|
|
|
6:30pm - 8:30pm | Dave Bredesen, Carey Anne Nadeau, Irene Rix, Jim Byers, Roger Woodley | 21 | $3,950 |
|
This course consists of multiple sessions, view schedule for sessions.
|
||||
| Thu, Nov 08 | 6:30pm - 8:30pm | Dave Bredesen, Carey Anne Nadeau, Irene Rix, Jim Byers, Roger Woodley | ||
| Tue, Nov 13 | 6:30pm - 8:30pm | Dave Bredesen, Carey Anne Nadeau, Irene Rix, Jim Byers, Roger Woodley | ||
| Thu, Nov 15 | 6:30pm - 8:30pm | Dave Bredesen, Carey Anne Nadeau, Irene Rix, Jim Byers, Roger Woodley | ||
| Tue, Nov 20 | 6:30pm - 8:30pm | Dave Bredesen, Carey Anne Nadeau, Irene Rix, Jim Byers, Roger Woodley | ||
| Thu, Nov 22 | 6:30pm - 8:30pm | Dave Bredesen, Carey Anne Nadeau, Irene Rix, Jim Byers, Roger Woodley | ||
| Tue, Nov 27 | 6:30pm - 8:30pm | Dave Bredesen, Carey Anne Nadeau, Irene Rix, Jim Byers, Roger Woodley | ||
| Thu, Nov 29 | 6:30pm - 8:30pm | Dave Bredesen, Carey Anne Nadeau, Irene Rix, Jim Byers, Roger Woodley | ||
| Tue, Dec 04 | 6:30pm - 8:30pm | Dave Bredesen, Carey Anne Nadeau, Irene Rix, Jim Byers, Roger Woodley | ||
| Thu, Dec 06 | 6:30pm - 8:30pm | Dave Bredesen, Carey Anne Nadeau, Irene Rix, Jim Byers, Roger Woodley | ||
| Tue, Dec 11 | 6:30pm - 8:30pm | Dave Bredesen, Carey Anne Nadeau, Irene Rix, Jim Byers, Roger Woodley | ||
| Thu, Dec 13 | 6:30pm - 8:30pm | Dave Bredesen, Carey Anne Nadeau, Irene Rix, Jim Byers, Roger Woodley | ||
| Tue, Dec 18 | 6:30pm - 8:30pm | Dave Bredesen, Carey Anne Nadeau, Irene Rix, Jim Byers, Roger Woodley | ||
| Thu, Dec 20 | 6:30pm - 8:30pm | Dave Bredesen, Carey Anne Nadeau, Irene Rix, Jim Byers, Roger Woodley | ||
| Thu, Jan 03 | 6:30pm - 8:30pm | Dave Bredesen, Carey Anne Nadeau, Irene Rix, Jim Byers, Roger Woodley | ||
| Tue, Jan 08 | 6:30pm - 8:30pm | Dave Bredesen, Carey Anne Nadeau, Irene Rix, Jim Byers, Roger Woodley | ||
| Thu, Jan 10 | 6:30pm - 8:30pm | Dave Bredesen, Carey Anne Nadeau, Irene Rix, Jim Byers, Roger Woodley | ||
| Tue, Jan 15 | 6:30pm - 8:30pm | Dave Bredesen, Carey Anne Nadeau, Irene Rix, Jim Byers, Roger Woodley | ||
| Thu, Jan 17 | 6:30pm - 8:30pm | Dave Bredesen, Carey Anne Nadeau, Irene Rix, Jim Byers, Roger Woodley | ||
| Tue, Jan 22 | 6:30pm - 8:30pm | Dave Bredesen, Carey Anne Nadeau, Irene Rix, Jim Byers, Roger Woodley | ||
| Thu, Jan 24 | 6:30pm - 8:30pm | Dave Bredesen, Carey Anne Nadeau, Irene Rix, Jim Byers, Roger Woodley | ||
Benefits of Booking Through CourseHorse
Booking is safe.
When you book with us your details are protected by a secure connection.
Lowest price guaranteed.
Classes on CourseHorse are never marked up.
Ch Gift Card
School: General Assembly
General Assembly is a pioneer in education and career transformation, specializing in today’s most in-demand skills. The leading source for training, staffing, and career transitions, we foster a flourishing community of professionals pursuing careers they love.
What began as a co-working space in...
Read more about General Assembly
This school has been carefully vetted by CourseHorse and is a verified DC educator.
Ready to take this class?
BOOK NOW
Taking this class for work? Get exclusive perks & discounts for free.
Choose a Gift Giving Option
Know someone who would like this class but not sure of their schedule? (We recommend this!)
Know their schedule better than your own? Book a date and time directly.
(This school does not support a scheduled gift delivery date so if you book the class, the recipient will be notified right away.)
One last thing!
Add a name to your account.
What name do you want displayed with your post?
What name do you want displayed with your post?