- Data Visualization
- History of Data Visualization
- Benefits of Data Visualization
- What is Power BI?
- Why are we learning Power BI?
- Components of Power BI
- Power BI Architecture
- Power BI pricing structure
- Home
- Simpliv Learning
- Courses
- Microsoft Power Business Intelligence Bootcamp
Online
25 Hours
Important Dates:
20 May, 2024
Course Commencement Date
Quick facts
particular | details | ||
---|---|---|---|
Medium of instructions
English
|
Mode of learning
Self study, Virtual Classroom
|
Mode of Delivery
Video and Text Based
|
Frequency of Classes
Weekdays
|
Course and certificate fees
certificate availability
Yes
certificate providing authority
Simpliv Learning
The syllabus
Introduction to Data Visualization & Power BI
Power BI Desktop
- Introduction to Power BI Desktop
- Installation of Power BI Desktop
- Views in Power BI Desktop
- Overview of Power Query Editor
Connect data from multiple sources
- Connect Excel & CSV files
- Connect Folder containing multiples Excel & CSV files
- Connect tables from Websites / SharePoint
- Understanding different data types
- Manually detecting data types
- Best practices in column naming conventions
- Creating Column Headers
- Modelling Data
- Managing Data Relationships
Data Cleaning
- Removing duplicates, null values & errors
- Filtering blank rows & columns
- Filtering unwanted rows & columns
- Importance of Applied Steps section in Power Query Editor
- Replacing data from the tables
- Data profiling for data quality check
- Splitting columns
Data Transformation
- Append Queries / Files
- Merge Queries / Files
- Merging columns
- Move columns & sorting of data
- Pivot & Unpivot of data
- Duplicate & Reference tables
- Closing & Applying changes in Power Query Editor
- Difference between Refresh Preview & Refresh All
- Issues in refreshing data
Data Analysis Expressions (DAX)
- Overview of DAX
- Why DAX is important to learn?
- Data types in DAX
- Introduction to DAX functions
- Measures in DAX
- Calculated Columns in DAX
- Field Parameters (new feature)
- Date & Time functions
- Time Intelligence functions
Data Visualization
- Introduction to visuals in Power BI
- Various charts in Power BI
- New Format Pane (new feature)
- Canvas Zoom (new feature)
- Chart formatting & customization
- Adjusting Page layout
- Creating Hierarchies
- Drill up & Drill down
- Page navigations
- Customizing Tooltips
- Slicers
- Sync slicers
- Bookmarks
- Filters
- Tables & Matrix
- Conditional formatting
- Advanced Charts
- Custom Visuals
Power BI Service
- Overview of Power BI Service
- Importance of Power BI Service
- What is Workspace?
- Creating Workspace
- Power BI Report vs Dashboard
- Creating Power BI Dashboard
- Publish Power BI Report to Power BI Service
- Quick Insights
- Power BI Q&A
- Ask questions about our data using NQL
- Power BI Embedded
- Row Level Security (RLS)
- Paginated Report
- What is Data Gateway?
- Standard vs Personal Gateway
- Installation & configuration of Data Gateway
- Scheduled Refresh
Articles
Popular Articles
Latest Articles
Trending Courses
Popular Courses
Popular Platforms
Learn more about the Courses
Providers
Providers
View all coursesders">
View all courseView all coursess
Providers
Providers
Collaborators
Medium of Instructions
Mode of Learning
Mode of Study
Mode of Delivery
Certificate Providing Authority
Thank You!
The Brochure has been downloaded and sent to your registered email ID successfully.
Download Brochure
Thank You!
Brochure has been downloaded.
Sign In/Sign Up
We endeavor to keep you informed and help you choose the right Career path. Sign in and access our resources on Exams, Study Material, Counseling, Colleges etc.