Course Code: tableaupowerbi
Duration: 28 hours
Prerequisites:

There are no specific requirements needed to attend this course.
Basic Understanding of Visualization and data row and column

Overview:

In this course delegates will be able to learn both visualization tool i.e. Tableau Desktop and Power BI and also will be able to distinguish between the two;
It is intended for anyone who is looking to work with data and is designed to help you use the main functions in Tableau and Power BI Tool.

During the course you will be able to:

  • Distinguish Between Tableau and Power BI
  • Connect to your data from different sources.
  • Edit and save a data source.
  • Understand Tableau and BI terminology.
  • Use the Tableau and Power BI interface / paradigm to effectively create powerful visualizations.
  • Create basic calculations including basic arithmetic calculations, custom aggregations and ratios, date math, and quick table calculations in tableau; And  DAX calculations in Power BI
  • Represent your data using the following visualization types in both Power BI as well as in Tableau:
    • Cross tabs
    • Geographic maps
    • Heat maps
    • Tree maps
    • Pie charts and bar charts
    • Dual axis and combined charts with different mark types
    • Highlight Tables
    • Scatter Plots
  • Build dashboards to share visualizations in Tableau and Power BI on different devices.
Course Outline:
  • Introduction to Power BI & Tableau and their Architecture
    • Difference between Power BI & Tableau
      • History
      • Cost
      • Performance
      • User Interface
      • Data Sources
  • Working with Data in both
  • Devices Supported by both
  • Connecting to different Data Sources in Tableau
  • Data Sources in Power BI
    • On-premises and online data sources
    • Data transformations + M language
    • Direct connections to selected sources (SQL Server, OLAP)
  • Design data model in Power BI
    • Single and multi-directional data filtering
    • Understanding DAX
      • Functions
      • Calculations
      • Working with the time dimensions (including fiscal periods, comparing periods, YTD)
      • Functions for naturalizing a parent-child hierarchy
      • Filter functions
      • DAX Templates
  • Simplifying and sorting your data in Tableau
  • Filtering, grouping and exclusion in Tabeau & Power BI
  • Organizing your data in Tableau & Power BI
  • Interactive Data Analysis in Tableau & Power BI
  • Calculations, Statistics and Parameters in Tableau
  • Table calculations
  • Advanced Geo Techniques: Mapping data geographically
  • Viewing specific values
  • Formatting Views, Customizing your Visualization: Custom charts
  • Building various charts visualization
  • Highlighting data with reference lines
  • Telling a Data Story with Dashboard and reports
  • Users and Data Access management – Row Level Security
  • Q & A mechanism
  • Visualization on various devices

**Green Text highlighting Tableau and blue highlighting Power BI