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