Course Content
Data Analysts in Power BI
Learning Path.
- Basics of SQL and No-SQL
- Normalization
- Integrity and Constraints
- Data Manipulation
- Joins and Subqueries
- SQL Functions
- Indexing and Views
- Basics of Excel
- String,Number,Date Functions
- Financial Functions
- IF, COUNTIF, SUMIF
- Pivot Table & Lookups
- Goal Seek & WhatIF
- Range & Data Validation
- Charts/li>
- Statistics Forumlas in Excel
- Introduction of Macros
- Basics of Python
- Data Type & Variables
- Control Statement
- NUMPY & PANDAS
- Data Cleansing & Data Wrangling
- Statistics using Python
- Charts & Graphs
- Introduction of Business Intelligence
- Introduction of Data Analysis
- Introduction of Power BI
- Data Modeling & M-Language
- Filters & Slicers
- Formatting Visual Componenet
- Cards & Drill Through
- Tables & Matrics
- Graphs
- Preparing Dashboard
- Preparing Reports
- DAX- Query
- Power BI- Services & Workspace
- Sharing and Publishing Reports
- Preparing Visuals using Python Scripts
- Role Based Security