I'm excited to start my new role at Cigna Healthcare as a Senior Financial Data Analyst!!
#data #dataanalyst #job #newjob
#data #dataanalyst #job #newjob
Claim a handpicked Notion library with the 35 best Post Templates from the 7 best LinkedIn Influencers
Claim 35 Post Templates from the 7 best LinkedIn Influencers
Chris French
These are the best posts from Chris French.
2 viral posts with 3,054 likes, 501 comments, and 75 shares.
0 image posts, 0 carousel posts, 0 video posts, 2 text posts.
👉 Go deeper on Chris French's LinkedIn with the ContentIn Chrome extension 👈
Best Posts by Chris French on LinkedIn
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.
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.
