Data Analytics

Statistics:

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

TABLEAU  OR  POWER BI

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

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

1: Introduction To Python

• Installation and Working with Python
• Understanding Python variables
• Python basic Operators
• Understanding python blocks

2: Python Data Types

• Declaring and using Numeric data types: int, float, complex
• Using string data type and string operations
• Defining list and list slicing
• Use of Tuple, Set, Dictionary data type

3: Python Program Flow Control

• Conditional blocks using if, else and elif
• Simple for loops in python
• For loop using ranges, string, list and dictionaries
• Use of while loops in python
• Loop manipulation using pass, continue, break and else
• Programming using Python conditional and loops block

4: Python Functions, Modules and Packages

• Organizing python codes using functions
• Organizing python projects into modules
• Importing own module as well as external modules
• Understanding Packages
• Powerful Lamda function in python
• Programming using functions, modules and external packages

5: Python String, List and Dictionary Manipulations

• Building blocks of python programs
• Understanding string in build methods
• List manipulation using in build methods
• Dictionary manipulation
• Programming using string, list and dictionary in build function

6: Python File Operation

• Reading config files in python
• Writing log files in python
• Understanding read functions, read(), readline() and readlines()
• Understanding write functions, write() and writelines()
• Manipulating file pointer using seek
• Programming using file operations

7: Python Object Oriented Programming – Oops

• Concept of class, object and instances
• Constructor, class attributes and destructors
• Real time use of class in live projects
• Inheritance, overlapping and overloading operators
• Adding and retrieving dynamic attributes of classes
• Programming using Oops support

8: Python Exception Handling

• try….except…else
• try-finally clause
• Avoiding code break using exception handling
• Safe guarding file operation using exception handling
• Handling and helping developer with error code
• Programming using Exception handling