Business Intelligence

DBMS
8 Lessons
- Understanding Relational Model
  Start
- Relation & Tuple
  Start
- Business Entity / Object Attributes
  Start
- ER Modeling
  Start
- Degree Of Relationship
  Start
- Cardinality & Keys
  Start
- DBMS Vs RDBMS
  Start
- Normalization
  Start
ANSI SQL
10 Lessons
- Introduction to SQL
  Start
- DDL Commands
  Start
- DML Commands
  Start
- DCL Commands
  Start
- DQL Commands
  Start
- SQL Functions
  Start
- SQL Constraints
  Start
- Joins
  Start
- Sub Queries
  Start
- Sequence
  Start
PL-SQL
7 Lessons
- Introduction to PL-SQL
  Start
- PL-SQL Variables
  Start
- Control Structures
  Start
- Cursors
  Start
- Stored Procedures & Functions
  Start
- Packages
  Start
- Triggers
  Start
MS-Excel
17 Lessons
- Introduction to MS-Excel
  Start
- Formula & Function
  Start
- Creating formula using operators
  Start
- Auto Sum
  Start
- Common formulas
  Start
- Date Functions
  Start
- Text Functions
  Start
- Formula referencing
  Start
- Relative and absolute referencing
  Start
- Auto fill and custom list
  Start
- Sorting
  Start
- VLOOKUP & HLOOKUP
  Start
- Array Formulas
  Start
- Data validation rules
  Start
- Pivot table & report
  Start
- Pivot charts
  Start
- Macros & VBA
  Start
Python Programming
19 Lessons
- Introduction to python programming
  Start
- Introduction to python programming
  Start
- Variables & data types
  Start
- List & list comprehension
  Start
- Tuple
  Start
- Set
  Start
- Dictionary
  Start
- Operators
  Start
- Control flow structures
  Start
- Loop control structures
  Start
- Functions & modules
  Start
- Lambda, Filter, Map, Reduce
  Start
- Object oriented programming
  Start
- Abstraction
  Start
- Inheritance
  Start
- Polymorphism
  Start
- Exception handling
  Start
- File handling
  Start
- Regular expressions
  Start
Business Intelligence & Power BI
34 Lessons
- Introduction to business intelligence
  Start
- The need for business intelligence
  Start
- Architecture & flow of Power BI
  Start
- Components & building blocks
  Start
- Installation
  Start
- Connecting to different data sources
  Start
- Query editor in Power BI
  Start
- Cleaning of data
  Start
- Query duplicate, query reference
  Start
- Combining data
  Start
- Pivoting, spliting columns
  Start
- Modeling with power BI
  Start
- Views in Power BI desktop
  Start
- Star & Snowflake schemas
  Start
- Data Analysis Expressions (DAX)
  Start
- M Query Vs DAX Query
  Start
- DAX data types & operators
  Start
- DAX measures & calculations
  Start
- Row and filter context
  Start
- Aggregate functions
  Start
- Calculate DAX
  Start
- IF & switch in DAX
  Start
- Data Visualization
  Start
- Charts in power BI
  Start
- Matrixes and tables
  Start
- Map Visualization
  Start
- Power BI dashboards
  Start
- Dashboard with interactivity (Slicers & filters)
  Start
- Smart Narrative
  Start
- Decomposition Tree
  Start
- Power BI mobile
  Start
- Direct Connectivity
  Start
- Data gateways
  Start
- Direct query, live connection
  Start
Softskills
10 Lessons
- Introduction to softskills
  Start
- SWOT Analysis
  Start
- Communication skills
  Start
- Group Discussion
  Start
- Goal Setting
  Start
- Resume Writing
  Start
- Interview Skills
  Start
- Time Management
  Start
- Presentation skills
  Start
- Mock Interviews
  Start

Data Analyst & Power BI

Course Summary

Course Curriculum

DBMS

ANSI SQL

PL-SQL

MS-Excel

Python Programming

Business Intelligence & Power BI

Softskills

Pradeep

John Smith

Highly Recommended Course. Easy to Understand, Informative, Very Well Organized. The Course is Full of Practical and Valuable for Anyone who wants to Enhance their Skills. Really Enjoyed it. Thank you!!

Course Pricing