Chris French

I'm excited to start my new role at Cigna Healthcare as a Senior Financial Data Analyst!!


#data #dataanalyst #job #newjob

Excel, SQL, and Tableau are the three main technical tools I use in my data advisor job.

Here is a breakdown of what I mostly use in each:

EXCEL

- Conditional formatting
- Data Validation
- Excel cleaning formulas, for example TRIM, CONCATENATE, PROPER, etc.
- Power Query
- Pivot Tables
- Visualizations
- XLOOKUP/VLOOKUP

SQL

- SELECT/FROM/WHERE
- AND/IN/OR/BETWEEN/LIKE
- ORDER/GROUP BY
- Aggregate functions (sum, avg, etc.)
- UNION/UNION ALL
- INNER and LEFT JOIN
- Window Functions
- CTEs and Subqueries

TABLEAU

- Calculated Fields
- Bins
- Parameters
- Hierarchies
- Dual Axises
- Tiled
- Utilizing Tableau Prep
- Lots of bar and line charts

If you’re starting your journey, I recommend learning these three. Learn just enough to create some confidence, make some awesome projects, and continue to learn as you conduct your job search!

*Python and PowerBI are great options too, this is just from my personal experiences.