- What is BI?
- Why we need BI
- What is Power BI?
- Installation of Power BI
- Components of Power BI Desktop
- Types of Data Loading
- Import Mode
- Direct Query Mode
- Import vs Direct Query Mode
- Composite Models
- Most Commonly Used Data Sources
- Excel
- Text / CSV
- SQL Server /Oracle
- SSAS (Analysis Service)
- SharePoint List / Online / Folder
- Folder
- Other Data Sources
- Remove Columns
- First Row Header
- Duplicate Columns
- Split Columns
- Remove Duplicate
- Replace Value
- Change Data Type
- Group BY
- Formatting data
- Add Custom Columns
- Invoke Function
- Append Queries
- Merge Queries
- Combine Files(Folder)
- Parameter
- Introduction to Data Modeling
- What is Data Model
- Relationships in Power BI - One to One, One to Many, Many to Many
- Tables and Relationship
- Grouping / Binning
- Drill Through Reports
- What IF Parameter
- Bidirectional filters
- Visualization types
- Custom visuals
- Creating power BI Visuals
- Bar Chart and Line Chart
- Combining charts
- Adding slicers for filters
- Tabular data /Matrix
- Cards / Multi Cards
- Categorical data
- Categorical and Trends Data Together (Combo)
- Geographical Data and Maps
- Filters
- Bidirectional filters
- What is Power BI SERVICE?
- Free Vs Pro Vs Premium
- App workspace
- What is Report Server
- Power BI Q&A
- Bookmarks
- Deploying/Publishing Power BI Report
- Creating and sharing dashboard
- Mobile Power BI Overview
- Designing the reports and Dashboard for Mobile
- Interacting with Mobile Power BI App
- Introduction to DAX
- Calculated Columns
- Calculated Tables
- Calculated Measures
- Calculated Columns vs Measures
- Evaluation Contexts
- Aggregated Functions
- Relate Functions
- Iterative Functions
- Variables
- Logical functions
- Table Functions
- Handling Blanks
- Rank Functions
- Date Functions
- Calendar Functions
- Time Intelligence functions
- SEMI ADDITIVE
- Download and Install Tableau
- Load Data from Excel
- User Interface of Tableau
- Dimensions vs. Measures
- Application of Discrete and Continuous Fields
- Bar Chart
- Stacked Bar Chart
- Line Chart
- Scatter Plot
- Dual-Axis Charts
- Combined-Axis Charts
- Funnel Chart
- Cross Tabs
- Highlight Tables
- Maps
- Measure Names and Measure Values
- Filters in Tableau
- Filters in Tableau
- Dimension Filter
- Date Filter
- Measure Filter
- Visual filter
- Interactive Filter
- Data Source Filter
- Context Filter
- Dashboards in Tableau
- Dashboard
- Working with Layout
- Objects in Dashboard
- Making Dashboards Interactive
- Story
- Level of Details
- Introduction to Level of Detail (LODs)
- Fixed LOD
- Include LOD
- Exclude LOD