- What is Visualization?
- What is BI?
- Why we need BI
- What is Power BI?
- Power BI Architecture
- Installation of Power BI
- Components of Power BI
- Types of Data Loading
- Import Mode
- Direct Query Mode
- Import vs Direct Query Mode
- Composite Models
- Most Commonly Used Data Sources
- Excel
- Text / CSV
- MS Access
- Web Link
- SQL Server /Oracle
- SSAS (Analysis Service)
- SharePoint List / Online / Folder
- Folder
- Other Data Sources
- TRANSFORMS
- Remove Columns
- First Row Header
- Duplicate Columns
- Split Columns
- Remove Duplicate
- Replace Value
- Change Data Type
- Group BY
- Pivot and Unpivot
- Formatting data
- Add Custom Columns
- Invoke Function
- Append Queries
- Merge Queries
- Combine Files(Folder)
- Parameters
- Other Query Features
- Introduction to Data Modeling
- Deployment Cycle
- Data Model Engine
- 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
- Overview
- Best Practice
- 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
- Data Trends
- Categorical and Trends Data Together (Combo)
- Geographical Data and Maps Filters
- Report Level
- Page Level
- Visual Level
- Bidirectional filters
- Synonyms
- Custom Colors, Color Picker
- What is Power BI SERVICE?
- Licensing (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
- Setting up APP workspace
- Subscription and Alerts
- Analyze Excel Integration
- Usage Metrics Report
- Quick Insights
- Data Security (RLS)
- Export and Embed Option
- Refreshing Data Overview
- Installing the Data Gateway
- Enterprise vs Personal Gateway
- Scheduling the Data Refresh
- Power BI Admin Role
- Power BI Updates
- Installing SQL Server with Tabular Mode
- Installing Visual Studio
- Installing SSDT
- Creating a new Tabular Model
- Data Modelling in SSAS Tabular
- Deploy the Model
- Processing Tabular Model
- Schedule Processing (SQL Server Agent & SSIS)
- Power BI Desktop vs SSAS Tabular
- 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 (ROW & FILTER Contexts)
- Aggregated Functions (SUM,MIN,MAX,AVG,COUNT)
- Relate Functions (RELATED & RELATED TABLE)
- Iterative Functions (SUMX, AVGX, COUNTX)
- Variables (VAR)
- Logical functions (IF, SWITCH)
- Table Functions (ALL, ALLEXCEPT,VALUES,FILTER,CALCUILATETABLE) o FORMAT FUNCTION, FIND, SEARCH, SUBSTITUE, VALUE, CALCULATE,UNION,ROW,ADDCOLUMNS,SUMMARIZE
- Handling Blanks (ISBLANK,NOTISBLANK)
- Rank Functions (RANKX)
- Date Functions(DATEADD,DATEDIFF,TODAY Required Date Formats)
- Calendar Functions (CALENDAR, CALENDAT AUTO)
- Time Intelligence functions (TOTALMTD, TOTALQTD, TOTALYTD, PARALLELPERIOD, SAMEPERIODLASTYEAR, PARALLELPERIOD, RUNING TOTAL)
- SEMI ADDITIVE (OPENING BALANCE, CLOSING BALANCE, LAST DATE, FIRST DATE, LASTNONBLANK, FIRSTNONBLANK)
- Dynamic Measures, Dynamic Filters & Dynamic chart Axis
- After the completion you will have 3 real time projects to practice
- To hands on and explore Power BI Service options and features of real time