1. What is MSPBI & Scope
2. Learn the common work flow in Power BI
3. Building blocks of Power BI and its relations
4. Quick demo how to create a businessdashboard in MSPBI
5. MSPBI components
1. Get data in shape for use with Power BI
2. Combining two or more data sets (sourcedata) for reporting
3. Tackling messy data in MS Power BI
4. Clean & Transform data
1. Create and customize visualization
2. Use combination charts
3. Create and format slicers
4. Map visualizations
5. Visualizations utilization
6. Use tables and matrixes
7. Long live bubbles
8. Scatter charts in action
9. Advanced funnel and waterfall charts
10. Drive fast dashboard insights with gaugesand numbers
11. Color your visualization world with colors
12. Shapes and scales
13. Adding personal touch
14. Logo etc. to reports and dashboards
15. Display and present your dashboard in away you want with summarize data
16. Control how your report elements overlapwith each other
17. Learn to drill into hierarchies
18. Manage how levels are shared (Z-order inreports)
19. How to use R visuals in MSPBI
1. Quick insights in Power BI Service
2. Create and configure a dashboard
3. Share dashboard with your organization
4. Display and edit visuals- tiles
5. Full screen
6. Get more space on your dashboard
7. Install and configure a personal gateway
8. Excel and MSPBI
9. Import and excel table into Power BI
10. Import excel files with data models andpower view sheets
11. Connect One Drive for business to MSPBI
12. Excel data in Power BI summary
Application
Setting up Data Models with DAX
1. DAX for creating tables and columns
2. Rows vs. query vs. filter context
3. Procedure to be followedDAX for calculated tables and columns
4. Creating a date table
5. Calculated column for costs
6. Data cleaning with DAX
7. Connecting data from different tables
8. Methods to create DAX measures
9. Advantages of explicit measures V2
10. DAX and measures
11. Using variables
12. Basic statistical measures
13. Quick measures
1. Filtering and counting with DAX
2. Understanding different filter functions
3. Using different filters with DAX
4. Filter ALL the data
5. Calculating with a filter
6. Analyzing across dimensional tables
7. Iterating functions
8. DIY iterating functions
9. Iterating functions in Power BI
10. Practice with iterating functions
11. More iterating functions
12. Use of RANKX()
1. Logical functions
2. Interpreting SWITCH()
3. Logical functions in Power BI
4. IF() for formatting tables
5. Exploring SWITCH()
6. Grouping
7. Row-level security
8. Applying row-level security
9. Managed roles in Power BI
10. Creating an email list
11. Implementing RLS
1. Table manipulation functions
2. Summary of SUMMARIZE()
3. Table manipulations using DAX
4. SUMMARIZE() the facts
5. ADDCOLUMNS()? No problem!
6. Time intelligence functions
7. Time intelligence functions output
8. Time intelligence in Power BI
9. Use of TOTALYTD()
10. Use of SAMEPERIODLASTYEAR()
1. Getting Started with Tableau
2. Overview of Tableau
3. Tableau Architecture
1. Managing Metadata
2. Managing Extracts
3. Data Sources
4. Cross-Database Joins
5. Data Aggregation And Data Ports
6. Tableau Charts
7. Bar Charts and Stacked Bars Data Blending
8. Tree Maps and Scatter Plots
9. Individual Axes
10. Blended Axes
11. Dual Axes
12. Combinational Chart
1. Drill Down
2. Hierarchies
3. Sorting
4. Filtering
5. Grouping
6. Trend
7. Reference Lines
8. Forecasting
9. Clustering
10. Analysis with Cubes
11. MDX
1. Connecting Tableau to Data File
2. Navigating Tableau
3. Calculated Fields
4. Adding
5. Colors
6. Labels
7. Formatting
1. Data Extracts and Time Series
2. Understanding Granularity, Aggregationand Level of Details
3. Default Location in Maps
4. Custom Geo Coding
5. Symbol Map and Filled Map
1. Into Section
2. Joining Data In Tableau
3. Working With Maps
4. Hierarchies
5. Scatter Plot
6. Applying Filters in Different Sheets
7. Creating 1st Dashboard
8. Creating 2nd Dashboard
1. Duplicate Values
2. Multiple Fields
3. Data Blending
4. Dual Axis Chart
5. Building Calculated Fields
1. Downloading Dataset and Connection
2. Mapping
3. Building Table Calculation For Gender
4. Bins and Distributions for Age
5. Tree Map Chart
1. Advanced Dashboard
1. Storyline and Storytelling
1. Data Format
2. Data Interpreter
3. Multiple Columns And Pivot
4. Metadata Grid
5. Advanced Data Preparation
20 hrs.* (Regular/Weekend)
Duration : 20 hrs.* (Regular/Weekend)
Eligibility : 12th+ Having basic knowledge of Computer