![DataFrenchy](/img/default-banner.jpg)
- 95
- 101 760
DataFrenchy
United States
Приєднався 27 бер 2023
Hi! I'm Chris French, a Senior Analyst at Spring Health!
Tips and advice for aspiring analysts!
Feel free to follow my socials: linktr.ee/chrisfrench_data
Tips and advice for aspiring analysts!
Feel free to follow my socials: linktr.ee/chrisfrench_data
How to Create Donut Chart KPIs in Excel
In this video, we will be creating a Donut Chart with a Dynamic KPI.
In 6 minutes, we will be using aspects like Pivot Tables, Text Boxes, and Data Visualizations in Excel.
I hope you enjoy this video!
Dataset: github.com/chrisfrenchjr/SQLQueries/blob/main/Donut%20KPI%20(UA-cam).xlsx
Socials: beacons.ai/datafrenchy
#exceltips #exceltricks
In 6 minutes, we will be using aspects like Pivot Tables, Text Boxes, and Data Visualizations in Excel.
I hope you enjoy this video!
Dataset: github.com/chrisfrenchjr/SQLQueries/blob/main/Donut%20KPI%20(UA-cam).xlsx
Socials: beacons.ai/datafrenchy
#exceltips #exceltricks
Переглядів: 333
Відео
Marketing Data Analysis using EQUALS
Переглядів 19510 місяців тому
Marketing Data Analysis using EQUALS
Excel for Data Analysts I Excel Function Series - Aggregate Functions
Переглядів 93010 місяців тому
Excel for Data Analysts I Excel Function Series - Aggregate Functions
LeetCode SQL Interview Question: 1148. Article Views I
Переглядів 11211 місяців тому
LeetCode SQL Interview Question: 1148. Article Views I
LeetCode SQL Interview Question: 1527. Patients with a Condition
Переглядів 9411 місяців тому
LeetCode SQL Interview Question: 1527. Patients with a Condition
Microsoft Power BI Project Tutorial for Beginners | Healthcare Data Analytics
Переглядів 1,9 тис.11 місяців тому
Microsoft Power BI Project Tutorial for Beginners | Healthcare Data Analytics
LeetCode SQL Interview Question: 584. Find Customer Referee
Переглядів 10911 місяців тому
LeetCode SQL Interview Question: 584. Find Customer Referee
LeetCode SQL Interview Question: 183. Customers Who Never Order
Переглядів 9911 місяців тому
LeetCode SQL Interview Question: 183. Customers Who Never Order
DataFrenchy Podcast Episode 1: My Journey into Data
Переглядів 25411 місяців тому
DataFrenchy Podcast Episode 1: My Journey into Data
LeetCode SQL Interview Question: 511. Game Play Analysis I
Переглядів 16011 місяців тому
LeetCode SQL Interview Question: 511. Game Play Analysis I
Beginner Tableau Project in 30 Minutes!
Переглядів 60111 місяців тому
Beginner Tableau Project in 30 Minutes!
LeetCode SQL Interview Question: 577. Employee Bonus
Переглядів 12411 місяців тому
LeetCode SQL Interview Question: 577. Employee Bonus
LeetCode SQL Interview Question: 175. Combine Two Tables
Переглядів 25411 місяців тому
LeetCode SQL Interview Question: 175. Combine Two Tables
5 Ways to Become a Data Analyst with NO Experience
Переглядів 2,8 тис.11 місяців тому
5 Ways to Become a Data Analyst with NO Experience
Google Data Analytics Certificate - Should You Take It?
Переглядів 68811 місяців тому
Google Data Analytics Certificate - Should You Take It?
Use this SECRET to Find Data Analyst Jobs on LinkedIn
Переглядів 2,5 тис.11 місяців тому
Use this SECRET to Find Data Analyst Jobs on LinkedIn
Use LinkedIn to Land your Data Analyst Job
Переглядів 23211 місяців тому
Use LinkedIn to Land your Data Analyst Job
Data Visualization in Tableau I Sports Store Sales Analytics Project (3/3) I Excel SQL Tableau
Переглядів 1 тис.11 місяців тому
Data Visualization in Tableau I Sports Store Sales Analytics Project (3/3) I Excel SQL Tableau
Data Exploration in SQL I Sports Store Sales Analytics Project (2/3) I Excel SQL Tableau
Переглядів 1,8 тис.11 місяців тому
Data Exploration in SQL I Sports Store Sales Analytics Project (2/3) I Excel SQL Tableau
Data Cleaning in Excel I Sports Store Sales Analytics Project (1/3) I Excel SQL Tableau
Переглядів 2,1 тис.Рік тому
Data Cleaning in Excel I Sports Store Sales Analytics Project (1/3) I Excel SQL Tableau
Create an AWESOME Dashboard for your Portfolio!
Переглядів 1,3 тис.Рік тому
Create an AWESOME Dashboard for your Portfolio!
Tableau Beginner Project in Under 45 Minutes!
Переглядів 5 тис.Рік тому
Tableau Beginner Project in Under 45 Minutes!
This was an amazing tutorial. I've recently been tasked by the admins where I work to help gather specific metrics for implementing a new service line company wide and this will come in super handy. I have managed to come up with what they need but it requires alot of manual entry, this should cut my reporting time down by so much. Seriously, I can't thank you enough.
Simple yet effective, good stuff man 🎸🎉💪🏼
Hi Chris, your video is quite helpful! Also, where can I get the dataset? I'd like to practice myself to improve my Tableau skillset. Thank you!
#6: change a previous job title to analyst "When I went to start my job search in data analytics, I wasn’t having much success. Once I changed my role from manager to analyst, all of a sudden, responses started coming in." - Chris French, LinkedIn, 7-17-2024 (Basically, take what this dude says with a grain of salt when it comes to "how to break into data". The dude is great with excel and has had great success with his career. But he don't know nothin about breaking into data without relevant experience, per his own words)
Very informative 💪🏼 😊💫☀️
What platform is this that you use to practice interview questions?
LeetCode!
ua-cam.com/users/liveAJMgzV8zu9M?si=VILYTfhstWdV2wwl New live video, come join!
does the link works , after vlookup , I am not able to see next , it is going off
Bad weather knocked out my power. Will restart later if power comes back.
More #Truth I built a dashboard a year ago. I'm still the only one in the company that uses it.
#Truth Some jobs are looking for people with Masters and PHDs 🥲
Motivation for me to know that I’m on the right path.
Being able to build the dashboard and take notes as I watched has boosted my confidence in working with and presenting data. Thank you!
great job, I'm waiting for more
This is a great resource! I learnt a lot. Although I hope the video quality can be better. Waiting for more such resources. Thank you.
Thank you! And yes, improvements were made to the video quality for future videos. If you look at my recent video, the Budgeting Dashboard in Excel, you’ll see what my future videos will look like!
@@DataFrenchy sure, I'll check out that also.
My slicer wouldn’t show after I added this excel sheet to my google drive. I checked on my phone just to confirm this. Can you help out with that? Thank you for all that you do.
Hey! That can happen sometimes. A few options: could add a border to it, or export it as a PDF. If there’s still issues with it, feel free to contact me at datafrenchy@gmail.com with your file.
I missed the event! 😶 thanks for sharing !
No problem! I have a ton more planned in the future, just did this to mainly test out some streaming software. Thank you!
This is such a great, practical resource! Your walkthrough was so helpful. Thanks so much for continuing to put out free data resources like this.
Truly appreciate the feedback! Thank you very much!
@@DataFrenchy Would be really helpful to see a guided video on using PowerQuery for data cleaning and joining tables (if you have the time). Thanks again for putting out such high quality content, Chris!
@@alainahohnarth7674 appreciate the idea! Will definitely make one soon
This is easy and looks too good with some changes
Thank you!
Helpful series, thanks.
lol very good
Chris you are the best! Nice one bro.
for that green label appearing on the 12:33, you can use =value(cell number) to remove that and then copy and paste as values.
Hi Chris, how do we make use of this analysis done by SQL for data visualization or in real job? Are we just looking at end numbers? Do we just use previous cleaned data from Excel directly in Tableau? Basically what is the purpose of this step if at the end we will be using Tableau to answer these questions anyway?
Chris, I have a question about the practical use of these SQL queries in real jobs. Are they kind of what you show in the video or is the complexity usually higher?
Hey Chris, glad to see you open your UA-cam channel! I Can tell you from experience that the last route is very effective. I’ve done this twice, where I get any position at the company and work my way up. You get to build great relationships along the way and all you have to do is show that you’re a great employee and bring value.
Hi Chris, where do you Medicaid information datasets?
Hello mr French, we meet again. (It’s ur old student)
You wouldn't happen to have another location to dl the dataset from? Github says "(Sorry about that, but we can’t show files that are this big right now.)". Thanks in advance!
very good and easy video to follow. thank you
Great
I totally didn't know the trick about adding the comma to values in Power BI. Love it!
Hi Chris! Looks like a really useful tool for people who are confident with spreadsheets but only planning on exploring SQL. Is EQUALS already available or you got access to it due to partnership, so it's still being developed? And can you use all the formulas & functions similar to EXCEL ones? Thanks in advance
Can you please provide links to the courses you recommend? Thanks.
Great video, can you please suggest datasets that I can do for my portfolio project?
Thanks Frenchy for this nice series and datasets..😊 I made it in power BI 👉ua-cam.com/video/BRYukzkzbbo/v-deo.html
😅😅😅
Link: www.linkedin.com/posts/chris-french-data_ai-has-made-waves-over-the-year-as-data-activity-7117826187384471552-UgFE?
really practical and reasonable advice, none of that “take this bootcamp and get a job in 3 months” bull. I look forward to learning about the data space on your channel more! I think you’re my top 3 channels (data janitor, shashank kalanithi) on realistic path to get into this space.
Hey Chris! Loved the video, thank you for showing how a data analyst thinks! This gave me much more confidence!
Good job Chris! I use to work for Humana for almost 4 years with mostly the military Tricare health insurance.
18:35 Unable to add the measure Slicer Measure getting an error "The end of the input was reached."
Great video! One question: is it normal for LeetCode to include a test case that isn't covered by the instructions?
Certifications will not do anything no company in the industry recognizes it or respects it
Hi Chris, may I know the actual source of this dataset?
The dataset is linked in the description!