Data Analytics Course (Beginners)
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