DataFrenchy
DataFrenchy
  • 95
  • 101 760
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
Переглядів: 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!

КОМЕНТАРІ

  • @PaulineHelton-f8i
    @PaulineHelton-f8i 14 днів тому

    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.

  • @LightWarriors4Life
    @LightWarriors4Life 21 день тому

    Simple yet effective, good stuff man 🎸🎉💪🏼

  • @jianweizhao941
    @jianweizhao941 Місяць тому

    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!

  • @Shirtssuckkkk
    @Shirtssuckkkk Місяць тому

    #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)

  • @LightWarriors4Life
    @LightWarriors4Life Місяць тому

    Very informative 💪🏼 😊💫☀️

  • @M_le-n4r
    @M_le-n4r 2 місяці тому

    What platform is this that you use to practice interview questions?

  • @DataFrenchy
    @DataFrenchy 2 місяці тому

    ua-cam.com/users/liveAJMgzV8zu9M?si=VILYTfhstWdV2wwl New live video, come join!

  • @sukanyamukherjee5475
    @sukanyamukherjee5475 2 місяці тому

    does the link works , after vlookup , I am not able to see next , it is going off

  • @DataFrenchy
    @DataFrenchy 2 місяці тому

    Bad weather knocked out my power. Will restart later if power comes back.

  • @michaelnash4200
    @michaelnash4200 2 місяці тому

    More #Truth I built a dashboard a year ago. I'm still the only one in the company that uses it.

  • @michaelnash4200
    @michaelnash4200 2 місяці тому

    #Truth Some jobs are looking for people with Masters and PHDs 🥲

  • @llciii
    @llciii 2 місяці тому

    Motivation for me to know that I’m on the right path.

  • @latishas2482
    @latishas2482 3 місяці тому

    Being able to build the dashboard and take notes as I watched has boosted my confidence in working with and presenting data. Thank you!

  • @nourhanahmedqa2260
    @nourhanahmedqa2260 4 місяці тому

    great job, I'm waiting for more

  • @darakhshannehal1828
    @darakhshannehal1828 4 місяці тому

    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.

    • @DataFrenchy
      @DataFrenchy 4 місяці тому

      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!

    • @darakhshannehal1828
      @darakhshannehal1828 4 місяці тому

      @@DataFrenchy sure, I'll check out that also.

  • @taiwoaina986
    @taiwoaina986 5 місяців тому

    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.

    • @DataFrenchy
      @DataFrenchy 5 місяців тому

      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.

  • @louli5209
    @louli5209 5 місяців тому

    I missed the event! 😶 thanks for sharing !

    • @DataFrenchy
      @DataFrenchy 5 місяців тому

      No problem! I have a ton more planned in the future, just did this to mainly test out some streaming software. Thank you!

  • @alainahohnarth7674
    @alainahohnarth7674 5 місяців тому

    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.

    • @DataFrenchy
      @DataFrenchy 5 місяців тому

      Truly appreciate the feedback! Thank you very much!

    • @alainahohnarth7674
      @alainahohnarth7674 5 місяців тому

      @@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!

    • @DataFrenchy
      @DataFrenchy 5 місяців тому

      @@alainahohnarth7674 appreciate the idea! Will definitely make one soon

  • @rajshethna5035
    @rajshethna5035 5 місяців тому

    This is easy and looks too good with some changes

  • @joel09878
    @joel09878 5 місяців тому

    Helpful series, thanks.

  • @thomers2451
    @thomers2451 6 місяців тому

    lol very good

  • @danielomoregie7603
    @danielomoregie7603 7 місяців тому

    Chris you are the best! Nice one bro.

  • @manhadkhan
    @manhadkhan 7 місяців тому

    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.

  • @unujhjjjjjjjjjjjjj
    @unujhjjjjjjjjjjjjj 7 місяців тому

    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?

  • @shailidalal1880
    @shailidalal1880 7 місяців тому

    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?

  • @Adrian.adrian24
    @Adrian.adrian24 8 місяців тому

    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.

  • @AntonioNunnally
    @AntonioNunnally 8 місяців тому

    Hi Chris, where do you Medicaid information datasets?

  • @user-jq2sv5ws2j
    @user-jq2sv5ws2j 8 місяців тому

    Hello mr French, we meet again. (It’s ur old student)

  • @nadiasharnelle
    @nadiasharnelle 9 місяців тому

    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!

  • @kevinbudgetkitchen551
    @kevinbudgetkitchen551 9 місяців тому

    very good and easy video to follow. thank you

  • @airtel17
    @airtel17 9 місяців тому

    Great

  • @user-du6oo1nz6g
    @user-du6oo1nz6g 10 місяців тому

    I totally didn't know the trick about adding the comma to values in Power BI. Love it!

  • @user-pn3yh2sp1i
    @user-pn3yh2sp1i 10 місяців тому

    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

  • @haarew8336
    @haarew8336 10 місяців тому

    Can you please provide links to the courses you recommend? Thanks.

  • @princemofokeng1389
    @princemofokeng1389 10 місяців тому

    Great video, can you please suggest datasets that I can do for my portfolio project?

  • @IBUDataSimplified
    @IBUDataSimplified 10 місяців тому

    Thanks Frenchy for this nice series and datasets..😊 I made it in power BI 👉ua-cam.com/video/BRYukzkzbbo/v-deo.html

  • @austin316What
    @austin316What 11 місяців тому

    😅😅😅

  • @DataFrenchy
    @DataFrenchy 11 місяців тому

    Link: www.linkedin.com/posts/chris-french-data_ai-has-made-waves-over-the-year-as-data-activity-7117826187384471552-UgFE?

  • @ntran04299
    @ntran04299 11 місяців тому

    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.

  • @user-vh4fc4tu2m
    @user-vh4fc4tu2m 11 місяців тому

    Hey Chris! Loved the video, thank you for showing how a data analyst thinks! This gave me much more confidence!

  • @ericaleverson9430
    @ericaleverson9430 11 місяців тому

    Good job Chris! I use to work for Humana for almost 4 years with mostly the military Tricare health insurance.

  • @wackyartistry
    @wackyartistry 11 місяців тому

    18:35 Unable to add the measure Slicer Measure getting an error "The end of the input was reached."

  • @serial_commenter9454
    @serial_commenter9454 11 місяців тому

    Great video! One question: is it normal for LeetCode to include a test case that isn't covered by the instructions?

  • @corderomason1550
    @corderomason1550 11 місяців тому

    Certifications will not do anything no company in the industry recognizes it or respects it

  • @nikhildoye9671
    @nikhildoye9671 11 місяців тому

    Hi Chris, may I know the actual source of this dataset?

    • @DataFrenchy
      @DataFrenchy 11 місяців тому

      The dataset is linked in the description!