• Text to Columns
• Concatenate
• The Concatenate Function
• The Right Function with Concatenation
• Absolute Cell References
• Data Validation
• Time and Date Calculations
• Conditional Formatting
• Exploring Styles and Clearing Formatting
•  Using Conditional Formatting to Hide Cells
• Using the IF Function
• Changing the "Value if false" Condition to Text
• Pivot Tables
• Creating a Pivot Table
• Specifying PivotTable Data
• Changing a PivotTables Calculation
• Filtering and Sorting a PivotTable
• Creating a PivotChart
• Grouping Items
• Updating a PivotTable
• Formatting a PivotTable
• Using Slicers
• Charts
• Creating a Simple Chart
• Charting Non-Adjacent Cells
• Creating a Chart Using the Chart Wizard
• Modifying Charts
• Moving an Embedded Chart
• Sizing an Embedded Chart
• Changing the Chart Type
• Chart Types
• Changing the Way Data is Displayed

Advance Excel

• Date Formats
• Conditional Formatting
• Sorting
• Filtering
• Lookup Functions
• Pivoting

Statistics:

• Correlation
• Linear Regression
• Non Linear Regression
• Predictive time series forecasting
• K means clustering
• P value
• Find outlier
• Neural Network
• Error Measure

POWER BI

Structured Query Language (SQL)

SQL is a domain-specific language used in programming and designed for managing data held in a relational database management system, or for stream processing in a relational data stream management system.

• SQL commands  
• DDL DML commands
• Create
• Alter
• Drop
• Delete
• Select queries
• Where clause 
• Order by
• Group by
• Joins
• Sub queries

Module 1: Introduction to Power BI

• Get Started with Power BI
• Overview: Power BI concepts
• Sign up for Power BI
• Overview: Power BI data sources
• Connect to a SaaS solution
• Upload a local CSV file
• Connect to Excel data that can be refreshed
• Connect to a sample
• Create a Report with Visualizations
• Explore the Power BI portal

Module 2: Viz and Tiles

• Overview: Visualizations
• Using visualizations
• Create a new report
• Create and arrange visualizations
• Format a visualization
• Create chart visualizations
• Use text, map, and gauge visualizations and save a report
• Use a slicer to filter visualizations
• Sort, copy, and paste visualizations
• Download and use a custom visual from the gallery

Module 3: Reports and Dashboards

• Modify and Print a Report
• Rename and delete report pages
• Add a filter to a page or report
• Set visualization interactions
• Print a report page
• Send a report to PowerPoint
• Create a Dashboard
• Create and manage dashboards
• Pina report tile to a dashboard
• Pin a live report page to a dashboard
• Pin a tile from another dashboard
• Pin an Excel element to a dashboard
• Manage pinned elements in Excel
• Add a tile to a dashboard
• Build a dashboard with Quick Insights
• Set a Featured (default) dashboard
• Ask Questions about Your Data
• Ask a question with Power BI Q&A
• Tweak your dataset for Q&A
• Enable Cortana for Power BI

Module 4: Publishing Workbooks and Workspace

• Share Data with Colleagues and Others
• Publish a report to the web
• Manage published reports
• Share a dashboard
• Create an app workspace and add users
• Use an app workspace
• Publish an app
• Create a QR code to share a tile
• Embed a report in SharePoint Online

Module 5: Other Power BI Components and Table Relationship

• Use Power BI Mobile Apps
• Get Power BI for mobile
• View reports and dashboards in the iPad app
• Use workspaces in the mobile app
• Sharing from Power BI Mobile
• Use Power BI Desktop
• Install and launch Power BI Desktop
• Get data
• Reduce data
• Transform data
• Relate tables
• Get Power BI Desktop data with the Power BI service
• Export a report from Power BI service to Desktop

Module 6: DAX functions

• New Dax functions
• Date and time functions
• Time intelligence functions
• Filter functions
• Information functions
• Logical functions
• Math & trig functions
• Parent and child functions
• Text functions

OR 

TABLEAU 

Tableue Introduction

•  Tableue Architecture
•  The Tableue Interface
•  Distributing and Publishing

Tableue Pre Builder

•  The Input Step
•  The Cleaning Step
•  Group and Replace
•  The Profile Pane
•  The Pivot Step
•  The Aggregate Step
•  The Join Step
•  The Union Step

Connecting to Data

•  Getting Started with Data
•  Managing Metadata
•  Saving and Publishing Data Sources
•  Data Prep with Text and Excel Files
•  Join Types with Union
•  Cross-database Joins
•  Data Blending
•  Connecting to PDFs

Visual Analytics

•  Getting Started with Visual Analytics
•  Drill Down and Hierarchies
•  Sorting
•  Grouping
•  Creating Sets
•  Set Actions
•  Ways to Filter
•  Using the Filter Shelf
•  Interactive Filters
•  Parameters
•  Formatting
•  Basic Tooltips & Viz in Tooltip
•  Trend Lines
•  Reference Lines
•  Forecasting
•  Clustering

Dashboards and Stories

•  Getting Started with Dashboards and Stories
•  Building a Dashboard
•  Dashboard Objects
•  Dashboard Formatting
•  Dashboard Interactivity Using Actions
•  Dashboard Extensions
•  Story Point

Mapping

•  Getting Started with Mapping
•  Maps in Tableau
•  Editing Unrecognized Locations
•  Spatial Files
•  The Density Mark Type (Heat maps
•  Expanding Tableau's Mapping Capabilities
•  Custom Geocoding
•  Polygon Maps
•  Mapbox Integration

Calculations

•  Getting Started with Calculations
•  Calculation Syntax
•  Introduction to LOD Expressions
•  Intro to Table Calculations
•  Modifying Table Calculations
•  Aggregate Calculations
•  Date Calculations
•  Logic Calculations
•  String Calculations
•  Number Calculations
• Type Calculations
•  Conceptual Topics with LOD Expressions
•  Aggregation and Replication with LOD Expressions
•  Nested LOD Expressions
•  How to Integrate R and Tableau
•  Using R within Tableau

Why Tableue is doing it

•  Understanding Pill Types
•  Measure Names and Measure Values
•  Aggregation, Granularity, and Ratio Calculations
•  When to Blend and When to Join
•  One-to-many relationships
•  Joins inflating the number of rows
•  Filtering for Top Across Panes

How to

•  Using a Parameter to Change Fields
•  Finding the Second Purchase Date with LOD Expressions
•  Cleaning Data by Bulk Re-aliasing
•  Bollinger Bands
•  Bump Charts
•  Control Charts
•  Funnel Charts
•  Step and Jump Lines
•  Pareto Charts
•  Waterfall Charts

Module 1: Introduction to Data Analytics

• Introduction to Data Analytics
• What is Data? Types of Data
• Data Analytics vs Data Science vs Business Intelligence
• Types of Analytics:
  • Descriptive Analytics
  • Diagnostic Analytics
  • Predictive Analytics
  • Prescriptive Analytics
• Data Analytics Lifecycle
• Industry Applications of Data Analytics
• Introduction to Data-Driven Decision Making

Module 2: Microsoft Excel for Data Analytics

• Excel Fundamentals
• Data Formatting and Data Cleaning
• Sorting and Filtering
• Conditional Formatting
• Data Validation
• Excel Formulas and Functions
  • IF, SUMIF, COUNTIF
  • VLOOKUP, XLOOKUP
  • INDEX and MATCH
  • Text and Date Functions
• Pivot Tables and Pivot Charts
• Advanced Excel Dashboards
• Power Query in Excel
• Statistical Analysis using Excel

Module 3: SQL for Data Analytics

• Introduction to Databases
• RDBMS Fundamentals
• SQL Installation and Environment Setup
• SELECT, WHERE, ORDER BY
• GROUP BY and HAVING
• Aggregate Functions
• Joins:
  • INNER JOIN
  • LEFT JOIN
  • RIGHT JOIN
  • FULL JOIN
• Subqueries
• Common Table Expressions (CTEs)
• CASE Statements
• Window Functions
• Views
• Data Manipulation Language (DML)
• Data Definition Language (DDL)
• Query Optimization Basics
• SQL Business Case Studies

Module 4: Python Programming for Data Analytics

• Python Fundamentals
• Variables, Data Types and Operators
• Conditional Statements and Loops
• Functions
• Lists, 
• Tuples, 
• Sets and Dictionaries
• File Handling
• Exception Handling
• Introduction to Jupyter Notebook
• Python Libraries for Data Analytics

NumPy

• Arrays and Array Operations
• Mathematical Functions
• Statistical Operations
• Data Manipulation

Pandas

• Series and DataFrames
• Data Import and Export
• Data Cleaning
• Handling Missing Values
• Data Transformation
• Filtering and Grouping
• Merging and Joining DataFrames
• Exploratory Data Analysis (EDA)

Module 5: Statistics for Data Analytics

• Introduction to Statistics
• Descriptive Statistics
• Mean, Median and Mode
• Variance and Standard Deviation
• Probability
• Probability Distributions
• Normal Distribution
• Sampling Techniques
• Correlation and Covariance
• Hypothesis Testing
• Z-Test and T-Test
• Chi-Square Test
• ANOVA
• Statistical Interpretation using Python

Module 6: Data Visualization

Blog - Power BI - Microsoft - Blocos de construção do Power BI

Superstore Analytics Dashboard using Tableau (Data Series 7.0 dibimbing.id)

Ten Must-Know Seaborn Plots. For anyone who wants to ace… | by Sneha Bajaj | Medium

8

• Principles of Data Visualization
• Chart Selection and Design
• Bar Charts, Line Charts and Pie Charts
• Histograms and Box Plots
• Scatter Plots
• Heatmaps
• Matplotlib
• Seaborn
• Plotly
• Interactive Visualizations
• Storytelling with Data