Data Analytics Course (Advance)
1. Business Analytics With Basic + Advance Excel
- Formatting a Spreadsheet
- EditingFeatures
- Working with Charts
- Simple DatabaseOperations
- Data Validations
- Sorting and Filtering Data
- More Functions
- Formatting
- Formulas and Functions
- Working with Charts
- Working with Functions
- Working with Large
- Worksheets Working with Templates
- Working with Reports
- WhatIf Analysis Charts
2. Microsoft Power BI Training Course
Understanding the Power BI EcoSystem
- Describe the Power BI EcoSystem
- Define Power BI and its Relationship with MS EXcel
- Discuss the Power BI Suite of Products
- Describe how the Power BI Products Integrate
- Explain theTypical Analytics Process Flow
Apply Data Presentation Skills Using Power Query
- Differentiate between the Various Data Sources
- Connect Power BI to a Data Source
- Clean & Transform data to Ensure Data Quality
- Load the Data to the Power BI Data Model
Create and Format Reports using the Power BI Desktop
- Describe the Use of Page Backgrounds and Templates
- Create visualizations to Display the Data
- Apply Drill through and Down
- Create and Manage Slicers with the Use of Filters
- Explore Visual Interactions
Create and Format Visualizations using the Power BI Service
- Build Additional reports in the Power BI Service
- Compile and Configure Reports into a Dashbord
- Construct a Power BI Mobile Dashbord
- Add Quick Insight Results a Report
- Implement and use Q&A Visual
Create Basic DAX Expressions to Enhance the Power BI Data Mode
- Define DAX Formulas and Their Applications
- Discuss DAX Best Practices Explain Syntax Rules
- Create Basic Calculated Columns and Measures
- Discuss Row and Filter Context
- Apply Common DAX Expressions Such as Filter, Sum, etc
- Discuss Time Intelligence Functions
3. Python
- Basics of Python
- Data Types in python
- Program Flow Controlpython
- Functionsdeclaration in python
- Modules and Packages in python
- Date and time in python
- Random library in python
- Strings and Dictionary Manipulations in python
- File handling in python
- Oops with python Regular Expression in python
- Exception handling in python
- Database Interaction using python
- Multithreading in python
- GUI design using tkinter
- Web scrapping in python
4. SQL
- Guaranteeing uniqueness with primary key constraints
- Enforcing integrity with foreign key constraints
- Imposing business rules with check constraints
- Guaranteeing uniqueness with primary key constraints
- Enforcing integrity with foreign key constraints
- Imposing business rules with check constraints
- Adding table rows with INSERT
- Changing row content with UPDATE
- Removing rows with
- Controlling transactions with COMMIT and ROLLBACK DELETE
- Retrieving data with SELECT
- Specifying column expressions
- Sorting the result with ORDER BY
- Testing for equality or inequality
- Applying wildcard characters
- Stacking results with UNION
- Identifying matching rows with INTERSECT rows
- Utilizing EXCEPT to find nonmatching
- Conditional formatting with the CASE expression
- Utilizing the CASE expression to simulate IF tests
- Dealing with NULL values
- Summarizing data using SUM, AVG and COUNT
- Finding the highest/lowest values with MAX and MIN
- Defining the summary level with GROUP BY
- Applying filter conditions with HAVING
- Placing subqueries in the column list
- Creating complex expressions containing subqueries
- Handling subqueries that return no rows
- Subqueries in the FROM clause
5. Tableau
Field Types and Visual Ces
- Scenario
- Objectives
- Application Terminology and Definitions
- Data Source Page
- Tableau Workspace
- Files and Folders
- Getting Started with Tableau
- View Terminology and Definitions
- View Sections Data Terminology and Definitions
- Data Types
- Data Roles: Dimension vs. Measure
- Data Roles: Continuous vs. Discrete Changing Data Roles •
- Visual Cues for Fields in the Data Pane Visual Cues for Fields in the Rows or Column Shelves
Data Connection in Tableau Interface
- Data Connections in the Tableau
- Connecting to Tableau Data Server
- Types of Joins & When to Use Joining
- Enabling Right Outer Join
- Right Outer Join and Custom SQL Enabled
- Data Blending in Tableau Differences BetweenJoining and Blending
- Writing Custom SQL
- Prepare your Data for Analysis
Organizing and Simplifying Data
- Organizing and Simplifying Data Objectives
- Filtering Data Applying a Filter to a View
- Filtering on Dimensions Functions Aggregating Measures
- Filtering on Measures & Dates
- Quick Filters
- Sorting of Data
- Types of Sorting Creating Combined Fields
- Creating Groups and Defining Aliases What is a Group
- Defining an Alias Working with Sets and Combined Sets Sets
- Combined Sets Working with Groups and Sets
- Drill to Other Levels in a Hierarchy Grand Totals and Subtotals
- Adding Totals
- How to Define Aggregations
Formatting and Annotations
- Custom Geocoding
- Click Interaction Adding Title to View Click Interaction2 Adding Captions to View
- Using Titles Captions and Tooltips Adding Tooltips to Views
Special Field Types
- Date Hierarchies
- Drilling in the Time Hierarchy
- Pivoting Date Parts on Shelves
- Differentiate Between Discrete and Continuous Dates
- Working with Discrete and Continuous dates
- Creating and Using Custom Dates Fiscal Year
- Define a Date Field on a Fiscal Year Relative Date Filters