Understand the fundamentals of healthy dieting (calories, protein, carbs, fat, vitamins & minerals)
Create a diet that is perfect for your needs and lifestyle
Learn when, what and how much you should eat for optimal body composition
Build more muscle by optimizing your meal plan
Lose fat faster by optimizing your meal plan
Improve immunity and energy levels with the right vitamins and minerals
Course Content
Welcome! Course Introduction
Introduction to Data Ware housing
02:30
Business Intelligence
What is Business Intelligence and Visual Intelligence?
Data Entry Techniques in Excel
07:15
How to Make Your Spreadsheets Look Professional
12:30
Excel Formulas for Beginners
05:16
Tableau Introduction
• Why Tableau
• History of Tableau
• Characteristics of Tableau
• Tableau versions.
• Differences between different versions of tableau.
• What is Vizql
• Use of Vizql in Tableau.
• Tableau Architecture and components.
Inserting a Line Break with Alt + Enter
14:05
Create Easily Printable Excel Documents
11:20
Tableau Components
• What is Tableau Desktop, Server
• What is Tableau Reader
• What is Tableau Online
• What is Tableau Public?
Discounting Cash Flows in Microsoft Excel
22:05
Calculating Internal Rate of Return (IRR) in Excel
07:45
Date Functions in Excel
09:12
Tableau Extensions
• Types of Extensions
• When to use Tableau Extensions
• Differences between Twb and. Twbx extensions
An Introduction to the Case Study
15:35
The Project’s Cash Flow Calculation
12:33
View Sections
• What is Dashboard, when to use Dashboard and Ways to use Dashboard
• What is work book and when to use Workbook
• What is work sheet and when to use worksheets
• What is stories their usage
• Ways to use Workbook, Dashboard, Worksheet, Stories
• Types of Data Connections in Tableau
• Connect to Live Data connection
• Connect to Extract Data connection in Tableau
• Creation of Extract file in Tableau
Data Joins in Tableau
• What is Join
• Types of Joins
• When to use Joining
• Rules to perform the Joins in tableau.
• What is Custom SQL.
• Custom SQL Enabled Custom SQL.
• Writing
• Data Refresh
Data Blending in Tableau
• What is Data Blending
• Types of Data Blending
• When to use Data Blending
• Rules to perform the Joins in tableau
• Join vs. Data Blending
Graphs/Charts/Bars
• Line Graphs
• Single Line graphs
• Dual Line Graphs
• Blended Axis
• Difference between Dual axis and Blended axis
• Horizontal Bar Charts
• Vertical Bar charts
• Side-Side by bar charts
• Stacked Bar charts
• Pie Charts
• Gantt Charts
Maps
• What are Tree Maps
• Heat Maps
• Tree map implementation
• Filed Maps
• What is Geo-Coding and implementation
• Importing External Custom Geo coding
Filters and Types
• What are Filters
• Filters on Dimensions
• What is Wild Card
• Filters on Measures
• Context Filters
• Global Filters
• Quick Filters
• Defining Filters at Source
• Defining Filters at Custom SQL
Creating and Using Parameters
• What is Parameter
• Creating Parameter
• Exploring Parameter Controls
• Work with the parameter
• Click interaction working with parameter
• Parameters and use with real time examples
• Dynamically Show and Hide Sheets with Parameter
Groups and Sets
• What is Group
• When to use Group
• Editing Existing Group
• Limitation of groups
• What is Set
• When to Use Sets
• Types of Sets
Calculated Fields
• What is Tableau Calculation
• When to use INDEX (), RANK (), LAST (), FIRST () Functions
• RUNNING_SUM Calculations
• WINDOW_SUM Calculations
• String Calculations
• Boolean Calculations
• DATE Calculations.
Trend Analysis
• What is Trend Analysis
• Logarithmic Model
• Exponential Model
• Linear Model
• Polynomial Model
Fore Casting and Reference Lines
• What is Fore Casting and implementation
• What is Reference Line
• Lines
• Bands
• Distributions
• Box Plot
Annotations
• Mark Annotation
• Point Annotation
• Area Annotation
Aggregation and Disaggregation
• What is Aggregation
• When to use Aggregation
• What is Disaggregation
• When to use Disaggregation.
Page-shelf or Automated Maps
• What is Page Shelf?
• When to use Page Shelf
• Page Shelf Customized Controls
Drop Lines
• What is Drop Lines
• When to use Drop Lines?
• What is summary Card?
• When to Use summary Card in Tableau?
Actions in Tableau
• What are Actions & When to use Actions
• Types of Actions in tableau
• How to Trigger the Action
Hierarchy in Tableau
• What is a Hierarchy?
• Relation between Drill downs, Roll ups and Hierarchies.
• What are Automatic Hierarchies?
• How to create Custom Hierarchy in Tableau?
• Removing Hierarchy
Tableau Advanced Charts – User defined Charts (IMP)
• Water Fall charts
• Donut charts
• Funnel Charts
• Lollipops charts
• Whisker plots.
• Scatter plot
Case Study
• Resume Preparation
• Mock Interviews
• Advanced Tableau 10 New Features.
• Reporting Migration Process and Check list in Real-Time.
