Companies Home Search Profile

Professional Dashboards in Excel and Tableau

Focused View

365 Careers

2:31:57

20 View
  • 001 What Does the Course Cover.mp4
    03:25
  • 002 Why Learn Data Visualization.mp4
    06:08
  • 003 How to Choose the Right Visualization - Popular Approaches and Frameworks.mp4
    06:58
  • 004 Choosing the Colors for Your Visualization.mp4
    08:56
  • 005 Choosing the Right Data Visualization Color Palette.html
  • 001 Dashboard in Excel - Introduction to the Task.mp4
    03:36
  • 002 Dashboard in Excel - Getting to Know the Data Set.mp4
    03:35
  • 003 Dashboard in Excel - Creating the Design for the Excel Dashboard.mp4
    06:44
  • 004 Dashboard in Excel - How to Create a Drop-down List in Excel.mp4
    04:50
  • 005 Dashboard in Excel How to Use the Developer Tab and Make Radio Buttons in Excel.mp4
    02:46
  • 006 Dashboard in Excel - Including Additional Columns to the Excel Spreadsheet.mp4
    05:43
  • 007 Dashboard in Excel Introduction to Pivot Tables.mp4
    03:20
  • 008 Dashboard in Excel - Tables Creating Time Filter References in Excel.mp4
    06:16
  • 009 Dashboard in Excel - Tables Adding Month, Year and Selected Dates Fields in Ex.mp4
    04:13
  • 010 Dashboard in Excel Tables - How to calculate Net Sales.mp4
    06:46
  • 011 Dashboard in Excel Tables - How to Calculate Gross Profit Margins and Distribu.mp4
    03:15
  • 012 Dashboard in Excel - Tables Volume by Size.mp4
    04:54
  • 013 Dashboard in Excel - Tables Volume by Client Type Homework.html
  • 014 Dashboard in Excel Charts - Making a Bar and Line Combo Graph.mp4
    06:30
  • 015 Dashboard in Excel - Charts Making a Clustered Bar Graph I.mp4
    05:19
  • 016 Dashboard in Excel - Charts Making Clustered Bar Graph II.mp4
    04:02
  • 017 Dashboard in Excel Adding KPIs and a Slicer to the Dashboard.mp4
    03:27
  • 018 Dashboard in Excel - Adding a Custom Design to the Dashboard.mp4
    02:26
  • 019 Dashboard in Excel - Customizing the Appearance of the Slicer.mp4
    04:01
  • 020 Dashboard in Excel - Interpretation.mp4
    04:56
  • external-links.txt
  • 001 Dashboard in Tableau - Introduction to the Task.mp4
    02:33
  • 002 Dashboard in Tableau - Examining the Data and Preparing the Sheets for the Table.mp4
    03:29
  • 003 Dashboard in Tableau - Creating a Bar and Line Combo Graph.mp4
    05:11
  • 004 Dashboard in Tableau - Horizontal Bars Graph I.mp4
    02:18
  • 005 Dashboard in Tableau - Horizontal Bars Graph II.mp4
    01:46
  • 006 Dashboard in Tableau - Introducing KPIs to the Tableau Dashboard.mp4
    03:06
  • 007 Dashboard in Tableau - How to make a Dashboard in Tableau and Add a Brand Filter.mp4
    03:59
  • 008 Dashboard in Tableau - How to incorporate a Date Filter into the Dashboard.mp4
    06:13
  • 009 Dashboard in Tableau - Introducing a Custom Design to the Tableau Dashboard.mp4
    07:34
  • 010 Dashboard in Tableau - How to Interpret the Dashboard.mp4
    03:42
  • 011 Completing 100%.html
  • external-links.txt
  • Description


    Complete Dashboards: Excel, Tableau, Pivot Tables, Slicers, Filters, Design, Templates

    What You'll Learn?


    • Techniques for choosing an appropriate visualization based on your data
    • Approaches for selecting the best colors scheme for a professional presentation
    • How to build stunning interactive dashboard reports
    • Methods to use real-world data sets to solve a business problem from the FMCG sector
    • How to master Excel Pivot Tables and the Developer tab
    • Ways to create custom based time Filters in Tableau
    • Skills to style and format a presentation-worthy dashboard
    • How to successfully interpret the results from a report in Excel and Tableau

    Who is this for?


  • People interested in enhancing their data viz skillset
  • Anyone who wants to gain a valuable skill
  • The course is also ideal for beginners, as it starts from the fundamentals and gradually builds up your skills
  • What You Need to Know?


  • You have Excel installed on your computer (we’ll guide you through installing Tableau)
  • You have some experience with writing basic formulas in Excel and are comfortable with the spreadsheet environment
  • You are motivated and eager to enhance your data visualization skills
  • More details


    Description

    What you’ll learn in this course?

    Professional Dashboards in Excel and Tableau will teach you how to create visually compelling reports with both Excel and Tableau!

    Whether you prefer working with Excel or Tableau, this course will enable you to create beautiful reports from scratch!

    Dynamic and meaningful visual reports have now become the focus of most business interactions. With dashboards, you can gain crucial insights from the company’s data and present information to investors or clients. That makes building a compelling dashboard a highly demanded skill which can make or break your chances of securing a place in the strategic team of your company. So, if you are looking for ways to improve your data visualization proficiency and boost your career prospects, look no further!

    Professional Dashboards in Excel and Tableau will show you not only how to create reports, but also how to style them to perfection and interpret them with ease. You’ll also have access to the elegant color template we work with during the lessons, so you can apply it to your future reports for a professional and cohesive look. In addition, we’ll help you with advice on how to create your own dashing templates using the best free online platforms out there.

    Here’s what you will find in this unique course:

    · Introduction into the main principles of data visualization

    We discuss topics such as color theory, how to choose the right visualization based on your data, and showcase a few online platforms that can aid you on your data visualization journey.

    · The entire process of making a dashboard in Excel

    Starting from the very beginning, we’ll show you techniques that you can successfully apply to every Excel report. We work on real-world data and create a report based on data from a real firm, operating in the fast-moving consumer goods sector.

    · Creating a dashboard in Tableau

    Again, our data comes from the real-world FMCG industry. In the process of crafting the components, we’ll get familiar with a wide range of techniques for building charts and other elements available in Tableau.

    But it doesn’t end there!

    You’ll also learn how to add custom time filters on both Excel and Tableau. Creating a time filter in Excel is a technical task, but with a well thought through idea and a neatly planned execution, everything is possible. This type of filter can then be applied to any report featuring time series data. So, you can transfer this knowledge to all future reports you’re in charge of.

    In Tableau, we’ll see various software options for customizing and styling filters. There are numerous possibilities to design and style filters in Tableau, and integrating it into a dashboard is easy and intuitive. Even if you’ve never worked with the software before, you’ll quickly become the master of creating dazzling charts and reports.

    Who is this course for:

    People who want to level up their career with data visualization skills

    Anyone who wants to improve their Excel and Tableau skills

    Anyone interested in dynamic visualization techniques

    People who are looking for a career in business intelligence or analytics


    Who this course is for:

    • People interested in enhancing their data viz skillset
    • Anyone who wants to gain a valuable skill
    • The course is also ideal for beginners, as it starts from the fundamentals and gradually builds up your skills

    User Reviews
    Rating
    0
    0
    0
    0
    0
    average 0
    Total votes0
    Focused display
    Category
    365 Careers is the #1 best-selling provider of business, finance, and data science courses on Udemy. The company’s courses have been taken by more than 2,000,000 students in 210 countries. People working at world-class firms like Apple, PayPal, and Citibank have completed 365 Careers trainings.    Currently, 365 focuses on the following topics on Udemy:    1) Finance – Finance fundamentals, Financial modeling in Excel, Valuation, Accounting, Capital budgeting, Financial statement analysis (FSA), Investment banking (IB), Leveraged buyout (LBO), Financial planning and analysis (FP&A), Corporate budgeting, applying Python for Finance, Tesla valuation case study, CFA, ACCA, and CPA2) Data science – Statistics, Mathematics, Probability, SQL, Python programming, Python for Finance, Business Intelligence, R, Machine Learning, TensorFlow, Tableau, the integration of SQL and Tableau, the integration of SQL, Python, Tableau, Power BI, Credit Risk Modeling, and Credit Analytics, Data literacy, Product Management, Pandas, Numpy, Python Programming, Data Strategy3) Entrepreneurship – Business Strategy, Management and HR Management, Marketing, Decision Making, Negotiation, and Persuasion, Tesla's Strategy and Marketing4) Office productivity – Microsoft Excel, PowerPoint, Microsoft Word, and Microsoft Outlook5) Blockchain for BusinessAll of our courses are:   - Pre-scripted   - Hands-on    - Laser-focused   - Engaging   - Real-life tested    By choosing 365 Careers, you make sure you will learn from proven experts, who have a passion for teaching, and can take you from beginner to pro in the shortest possible amount of time.   If you want to become a financial analyst, a data scientist, a business analyst, a data analyst, a business intelligence analyst, a business executive, a finance manager, an FP&A analyst, an investment banker, or an entrepreneur365 Careers’ courses are the perfect place to start.
    Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.
    • language english
    • Training sessions 33
    • duration 2:31:57
    • English subtitles has
    • Release Date 2024/02/14