- Customizing tabs, options in excel
- Name managers
- Data validation: Options in data validation for list, whole numbers, dates
- Using name manager for data validation
- Sorting
- Custom sorting
- Subtotals
- Sorting left to right
- Advanced sorting with multiple options
- Advanced filter options
- Sorting and filtering with color options
- Pivot tables
- Short cuts to create pivot tables
- Changing row and column labels
- Custom format tables and default tables
- Changing number formats
- Value field settings and summarizing values by 11 different options
- Value field settings and showing values as different options
- Grouping of continuous fields
- Pivot charts, compared regular charts
- Slicers, Slicer settings, advanced slicer
- Calculated fields in pivot tables
- Vlookup and Hlookup
- Syntax for Vlookup
- What-if there are errors
- Vlookup with data validation
- Approximation for Vlookup
- Using column function for dynamic column numbers
- Using Choose function to select a table for Vlookup
- Using Match function to identify column number
- Locking cells for absolute and relative cells
- Formulae
- Auto sum functions
- Logical functions
- Text functions
- Date and Time functions
- Lookup and reference functions
- Information functions
- Charts
- Column charts
- Line charts
- Pie charts, Pie in pie and Bar of pie, Donut
- Stacker bar and clustered bar charts
- Area
- Scatter charts
- Radar charts
- Tree maps
- Histogram
- Waterfall
- Funnel
- Combo
- Conditional formatting
- Duplicate values
- Alternate rows
- Multiple criteria
- Negative numbers
- Gantt charts and Formula
- Advanced topics
- What-if analysis
- Text to columns
- Flash fill
- Remove duplicates, Consolidate
- Grouping, ungrouping and sub-totals
- Freezing and unfreezing panes
Part time, Online
45 Days
Quick facts
particular | details | ||
---|---|---|---|
Medium of instructions
English
|
Mode of learning
Self study, Virtual Classroom
+1 more
|
Mode of Delivery
Video and Text Based
|
Frequency of Classes
Weekdays, Weekends
|
Course and certificate fees
certificate availability
Yes
certificate providing authority
Digital Lync
The syllabus
Excel
Introduction to Excel
Power BI Introduction
Intro
- Connecting to database, basic transformation
- Managing queries, splitting columns
- Modifying data types
- Dates
- Re-ordering columns, conditional columns
- Connecting to folders
- Merge queries
- Query dependency
- Transform data
- Enter data
- Query parameter
Data Modeling in Power BI
- Data modeling
- Data relationships
- Calculated columns
- Quick measures
- Optimize models
- Calculated measures
- Hierarchies
- Calculated tables
- Time intelligence
- Insert new data tables
- Include/Exclude
- Grouping and Binning
Visualizations in Power BI
- Create and format visualizations
- Hierarchical axis and concatenating
- Filters
- Combo charts
- Forecasting
- Clustering data
- Slicers
- Data behind visualization
- Date slicers
- Maps, ESRI maps
- Tables and matrixes
- Table style
- Scatter charts
- Waterfall and funnel charts
- Gauge, cards and KPIs
- Coloring charts
- Shapes, grid lines, page settings
- Duplicates, categories with no data
- Aligning, hierarchies
Charts in Power BI
- Combo charts
- Custom visual store
- Date slicer
- Waterfall and funnel charts
- Grouping and binning
- Map visualizations
- Report measures
- Tables and matrices
- Turn off visual headers
- Persistent filters
- Sync slicers
- Buttons
- Custom date tables
- Default summarization
- Measure filtering
Excel Data and Collaboration in Power BI
- Upload an excel table
- Excel data with BI content
- Pinning excel tables
- Analyze in excel
- Workspaces
Power BI Service
- Overview of dashboards
- Publish from Power BI
- Get insights
- Pinning on dashboards, dashboard tiles, display options
- Adding widgets
- Navigating content
- Filter the list in navigating pane
- Dashboard settings
- Sharing, print and export dashboards
- Focus mode
- Export to csv or excel or ppt
- Notifications, alerts
- Subscriptions
- Publishing
SQL
- Intro
- Syntax
- Select
- Distinct
- Where
- And Or Not
- Order By
- Insert into
- Null values
- Update
- Delete
- Top
- Min and Max
- Count, Avg, sum
- Like
- Wildcards
- In
- Between
- Alias
- Joins
- Inner
- Left
- Right
- Full
- Self
- Union
- Group By
- Having
- Exists
- Create table
- Drop table
- Alter table
- Not null
- Unique
- Primary key
- Default
- Views
- Operators