Topics

POWER BI FOR DATA ANALYSIS

• Introduction to Power BI Desktop
• Power BI Desktop Installation
• Connecting Data Sources (Excel, CSV, Web, SQL)
• Data Transformation Basics
• Power Query Editor
• Filtering
• Sorting
• Removing Duplicates
• Merging Queries
• Appending Queries
• Column Splitting
• Data Formatting
• Creating Custom Columns
• Relationships Between Tables
• Primary Keys
• Foreign Keys
• Star Schema
• Snowflake Schema
• Creating Data Models
• Calculated Columns
• Measures
• Introduction to DAX
• DAX Functions
• Time Intelligence Functions
• Building Dashboards
• Charts
• Maps
• Tables
• Slicers
• Conditional Formatting
• Filters
• Drill Throughs
• Custom Visuals from Marketplace
• Sales Data Analysis
• Financial KPIs
• HR & Employee Data Insights
• HR Analytics Dashboard
• Sales Dashboard Creation

DATABASE MANAGEMENT USING MYSQL

• Introduction to Database
• MS Access
• MySQL
• Data Types
• Constraints
• Primary Key
• Foreign Key
• Creating Tables
• Changing Tables
• Updating Tables
• Inserting Data into Tables
• Updating Records
• Deleting Records
• Selecting Records Using WHERE Clause
• Comparison & Logical Operators
• Wildcard Searching Using LIKE Operator
• Aggregate Functions (SUM, AVG, MIN, MAX, COUNT)
• GROUP BY Clause
• HAVING Clause
• Subqueries
• Table Joins
• INNER JOIN
• OUTER JOIN
• LEFT JOIN
• RIGHT JOIN
• UNION
• String Functions
• SUBSTR
• LEN
• UPPER
• LOWER
• CONCAT

BUSINESS CONCEPTS

• Report Making
• Understanding MIS Fundamentals
• MIS � Manage and Analyse Business Data