Training Course Fees
The full course fees for this training is S$1,200, before any Government funding.
For Singaporean/PR above 21 years, Training Grants are available.
For Foreigners, no government grants are available.
Grant Information
WSQ funding from SkillsFuture Singapore (SSG) is available to Singaporeans/PRs above 21.
(Both Individuals & Company Sponsored ).
Individual Singaporeans, 25 years & above can also use their SkillsFuture Credits for this training at Intellisoft.
Companies sending Locals & Foreign staff for training can availย SFEC Funding.ย
Use it to improve the skills of your entire department!
NTUC Members canย utilize UTAP Funds to offset 50%ย of the remaining fees*.
Contact us for more information on How to apply for this SkillsFuture Grant.
Call +65-6252-5033 for Details or WhatsApp Now at +65-9066-9991
up to 70% Grant
$840 Funding by SSG-
Singaporeans Above 40 Years
-
Individuals
-
SME Companies
-
Individuals Can Use SkillsFuture
-
UTAP Funding*
up to 50% Grant
$600 Funding by SSG-
Below 40 Years
-
Individuals
-
SG / PR / MNC Companies
-
SkillsFuture (Singaporeans only)
-
UTAP Funding*
Highly Trusted & Quality WSQ Course in Singapore at Intellisoft
Course Overview
Unlock the full potential of Power BI with our Advanced Power BI course!
Dive deep into
- Advanced DAX measures,
- Exploreย sophisticated use cases for Power Query, and
- Masterย data visualization using advanced settings.
Learn toย implement row-level security, keep your data models optimized, and import custom visuals.
Enhance your reports withย Python or R visuals, and leverageย new KPI cards,ย Gauges, and more toย create Stellar Dashboards for your management.
Thisย comprehensive two-day Advanced Power BI course in Singaporeย is designed for those who already know the basics of Power BI and are ready to elevate their skills to the next level.
Learn From Power BI Experts
Led by Power BI Guruย Vinai Prakash,ย with overย 35 years of experience in data analysis and business intelligence,ย this courseย promises hands-on, practical learning to empower you with advanced skills.
Course Outline
ADVANCED POWER BI COURSE OUTLINE
Section 1: Data analytics With Power BI
Understanding data analytics
Explore Roles in data Analysis
Key Tasks for a data analyst
Introduction to Power BI Desktop Advanced Features
Components of Power BI
Understanding Power BI Services
Section 2: Design a data model in Power BI
Get data from files & folders
Get data from relational data sources
Get data from a NoSQL database
Get data from online services
Select a storage mode
Get data from Azure Analysis Services
Fix performance issues
Resolve data import errors
Understanding Constraints & Performance issues
Understand data types mismatch issues
Resolving data quality errors
Section 3: Data Cleansing With Power BI
Shape the initial data
Simplify the data structure
Evaluate and change column data types
Combine multiple tables into a single table
Profile data in Power BI
Use Advanced Editor to modify M code
Section 4: Creating Advanced DAX measures in Power BI
Using the Calculate function
Understanding Filter Context
Using IF, SWITCH, FIND
Using VALUES, HASONEVALUE, SELECTEDVALUE, and CONCATENATEX
Using ALL, ALLEXCEPT, ALLSELECTED, KEEPFILTERS
Creating Virtual Tables
Create semi-additive measures
Advanced Date Comparisons With Same Period Last Year, Year To Date, Month to date totals,
Using Date Functions like DATEADD, FIRSTDATE, LASTDATE, NEXTYEAR
Writing Custom Time Intelligence Functions
Using RELATED & RELATEDTABLE functions in Power BI
Section 5: Performance Optimization in Power BI
Performance optimization Considerations
Review performance of Measures, Relationships, and visuals
Using variables to improve performance & Troubleshooting
Reduce cardinality in the Data Model
Optimize DirectQuery models with table level storage
Create and manage aggregations
Section 6: Working with Power BI visuals
Introduction to Advanced Power BI visualizations
Add visualization items to reports
Choose an effective visualization
Format and configure visualizations
Import a custom visual into Power BI
Add an R or PYTHON visual in a report
Section 7: Create a data-driven story with Power BI reports
Introduction to create a data-driven story with Power BI reports
Design a report layout
Add buttons, bookmarks, and selections
Design report navigation
Use advanced interactions and drill through
Configure conditional formatting
Apply slicing, filtering, and sorting
Publish and export reports
Comment on reports
Fine Tune report performance
Optimize reports for mobile use
Section 8: Create dashboards in Power BI
Introduction to dashboards
Configure data alerts
Explore data by asking questions
Add a dashboard theme
Pin a live report page to a dashboard
Configure a real-time dashboard
Configure data classification
Explore mobile view & Auto Mobile Layouts
Topc 9: Perform analytics in Power BI
Introduction to analytics
Explore statistical summary
Identify outliers with Power BI visuals
Group and bin data for analysis
Apply clustering techniques
Conduct time series analysis
Use the Analyze feature
Use advanced analytics custom visuals
Review Quick insights
Apply AI Insights
Section 10: Work with AI visuals in Power BI
Introduction to working with AI visuals
Use the Q&A visual
Find important factors with the Key influencers visual
Use the Decomposition Tree visual to break down a measure
Section 11: Create and manage workspaces in Power BI
Distribute a report or dashboard
Monitor usage and performance
Recommend a development life cycle strategy
Troubleshoot data by viewing its lineage
Configure data protection
Section 12: Secure Access With Row-Level Security
Configure row-level security with the static method
Configure row-level security with the dynamic method
Section 13: Manage datasets in Power BI
Create dynamic reports with parameters
Create what-if parameters
Use a Power BI gateway to connect to on-premises data sources
Configure a dataset scheduled refresh
Configure incremental refresh settings
Manage and promote datasets
Troubleshoot service connectivity
Target Audience
This course is perfect for:
- Business analysts and data professionals who have a basic understanding of Power BI.
- Professionals looking to enhance their data visualization and analysis skills.
- Individuals seeking to implement advanced Power BI features in their work.
- Anyone interested in taking their Power BI knowledge to an intermediate or advanced level.
Pre-Requisites
- Basic knowledge of Power BI, including data import and basic DAX measures.
- You should know the basics of Power Query, how to create DAX measures, and how to design simple dashboards in Power BI
- Familiarity with creating basic reports and dashboards in Power BI.
Grant Information
WSQ:ย To claim WSQ Funding for this Advanced Data Analytics & Visualization with Power BI course, participants must be either individual Singaporeans/PRs, OR Company Sponsored Singaporeans/PRs.ย You can get up to 50% to 70% WSQ Grant.
SkillsFuture for Advanced Microsoft Power BI Training: Individual Singaporeans aged 25 and above can use their SkillsFuture Credits to offset the unfunded portion to learn how to use Power BI for data analytics and visualization.ย Only Skills Future Credit (Opening Credit) and One-off SkillsFuture Credit Top-Up can be used for this course.
SkillsFuture Credit (Mid-Career) CANNOT be used for this course.
UTAP Funding:ย NTUC Members can utilize UTAP to offset 50% of the remaining fees*.
Call us at +65 6250-3575 or email toย training@intellisoft.com.sgย for any questions or toย register for the upcoming class of Advanced Data Analytics & Visualization with Power BI with SkillsFuture or WSQ funding.
Do You Have Any Questions
on Course Fee, WSQ Grant or Funding?
Ask Us. We’ll be happy to assist you.
Upcoming Course Dates
Training Schedule |
---|
How To Register
Register for Advanced Power BI Training Course in Singapore at Intellisoft
- Visit Our Website: Go toย Intellisoft Training.
- Find the Course: Navigate to the โAdvanced Power BIโ course page.
- Fill Out the Form: Complete theย registration formย with your details & Submit the form
This hands-on, practical course will be taught byย Power BI Guru Vinai Prakash, who has over 35 years of experience in data analysis and business intelligence.
Donโt miss this opportunity to learn from the best and transform your data analysis capabilities!
TESTIMONIALS FROM OUR ADVANCED POWER BI COURSE ATTENDEES
โThe Advanced Power BI course exceeded my expectations. Vinaiโs expertise and practical approach made complex concepts easy to understand. I feel much more confident in my ability to create impactful reports and dashboards now.โย โย Sarah Lim, Data Analyst, Vodafone
โTaking this course was a game-changer for my career. The hands-on exercises and real-world examples provided invaluable insights. Vinai is an outstanding instructor who truly cares about his studentsโ success.โ
โย John Tan, Director, Business Innovation
Why Choose Us?
ACTA Certified Trainers
Authorized Training Organization
WSQ
Certifications
Fully Set Up
Training Room
20+ Years
Experience in Education
Practical, Hands-on
Training
25,000+
Certified Students
32+
Courses
Useful & Handy
Student Guide
Contact Us
We are located at Fortune Centre, 190 Middle Road, #10-08 Singapore 188979
Click here for For Directionsย
Telephone: 6252-5033ย ย WhatsApp: 9066-9991
Email: info@trainingint.com
Highly Trusted & Quality WSQ Course in Singapore at Intellisoft
Course Overview
Unlock the full potential of Power BI with our Advanced Power BI course!
Dive deep into
- Advanced DAX measures,
- Exploreย sophisticated use cases for Power Query, and
- Masterย data visualization using advanced settings.
Learn toย implement row-level security, keep your data models optimized, and import custom visuals.
Enhance your reports withย Python or R visuals, and leverageย new KPI cards,ย Gauges, and more toย create Stellar Dashboards for your management.
Thisย comprehensive two-day Advanced Power BI course in Singaporeย is designed for those who already know the basics of Power BI and are ready to elevate their skills to the next level.
Learn From Power BI Experts
Led by Power BI Guruย Vinai Prakash,ย with overย 35 years of experience in data analysis and business intelligence,ย this courseย promises hands-on, practical learning to empower you with advanced skills.
Course Outline
ADVANCED POWER BI COURSE OUTLINE
Section 1: Data analytics With Power BI
Understanding data analytics
Explore Roles in data Analysis
Key Tasks for a data analyst
Introduction to Power BI Desktop Advanced Features
Components of Power BI
Understanding Power BI Services
Section 2: Design a data model in Power BI
Get data from files & folders
Get data from relational data sources
Get data from a NoSQL database
Get data from online services
Select a storage mode
Get data from Azure Analysis Services
Fix performance issues
Resolve data import errors
Understanding Constraints & Performance issues
Understand data types mismatch issues
Resolving data quality errors
Section 3: Data Cleansing With Power BI
Shape the initial data
Simplify the data structure
Evaluate and change column data types
Combine multiple tables into a single table
Profile data in Power BI
Use Advanced Editor to modify M code
Section 4: Creating Advanced DAX measures in Power BI
Using the Calculate function
Understanding Filter Context
Using IF, SWITCH, FIND
Using VALUES, HASONEVALUE, SELECTEDVALUE, and CONCATENATEX
Using ALL, ALLEXCEPT, ALLSELECTED, KEEPFILTERS
Creating Virtual Tables
Create semi-additive measures
Advanced Date Comparisons With Same Period Last Year, Year To Date, Month to date totals,
Using Date Functions like DATEADD, FIRSTDATE, LASTDATE, NEXTYEAR
Writing Custom Time Intelligence Functions
Using RELATED & RELATEDTABLE functions in Power BI
Section 5: Performance Optimization in Power BI
Performance optimization Considerations
Review performance of Measures, Relationships, and visuals
Using variables to improve performance & Troubleshooting
Reduce cardinality in the Data Model
Optimize DirectQuery models with table level storage
Create and manage aggregations
Section 6: Working with Power BI visuals
Introduction to Advanced Power BI visualizations
Add visualization items to reports
Choose an effective visualization
Format and configure visualizations
Import a custom visual into Power BI
Add an R or PYTHON visual in a report
Section 7: Create a data-driven story with Power BI reports
Introduction to create a data-driven story with Power BI reports
Design a report layout
Add buttons, bookmarks, and selections
Design report navigation
Use advanced interactions and drill through
Configure conditional formatting
Apply slicing, filtering, and sorting
Publish and export reports
Comment on reports
Fine Tune report performance
Optimize reports for mobile use
Section 8: Create dashboards in Power BI
Introduction to dashboards
Configure data alerts
Explore data by asking questions
Add a dashboard theme
Pin a live report page to a dashboard
Configure a real-time dashboard
Configure data classification
Explore mobile view & Auto Mobile Layouts
Topc 9: Perform analytics in Power BI
Introduction to analytics
Explore statistical summary
Identify outliers with Power BI visuals
Group and bin data for analysis
Apply clustering techniques
Conduct time series analysis
Use the Analyze feature
Use advanced analytics custom visuals
Review Quick insights
Apply AI Insights
Section 10: Work with AI visuals in Power BI
Introduction to working with AI visuals
Use the Q&A visual
Find important factors with the Key influencers visual
Use the Decomposition Tree visual to break down a measure
Section 11: Create and manage workspaces in Power BI
Distribute a report or dashboard
Monitor usage and performance
Recommend a development life cycle strategy
Troubleshoot data by viewing its lineage
Configure data protection
Section 12: Secure Access With Row-Level Security
Configure row-level security with the static method
Configure row-level security with the dynamic method
Section 13: Manage datasets in Power BI
Create dynamic reports with parameters
Create what-if parameters
Use a Power BI gateway to connect to on-premises data sources
Configure a dataset scheduled refresh
Configure incremental refresh settings
Manage and promote datasets
Troubleshoot service connectivity
Target Audience
This course is perfect for:
- Business analysts and data professionals who have a basic understanding of Power BI.
- Professionals looking to enhance their data visualization and analysis skills.
- Individuals seeking to implement advanced Power BI features in their work.
- Anyone interested in taking their Power BI knowledge to an intermediate or advanced level.
Pre-Requisites
- Basic knowledge of Power BI, including data import and basic DAX measures.
- You should know the basics of Power Query, how to create DAX measures, and how to design simple dashboards in Power BI
- Familiarity with creating basic reports and dashboards in Power BI.
Grant Information
WSQ:ย To claim WSQ Funding for this Advanced Data Analytics & Visualization with Power BI course, participants must be either individual Singaporeans/PRs, OR Company Sponsored Singaporeans/PRs.ย You can get up to 50% to 70% WSQ Grant.
SkillsFuture for Advanced Microsoft Power BI Training: Individual Singaporeans aged 25 and above can use their SkillsFuture Credits to offset the unfunded portion to learn how to use Power BI for data analytics and visualization.ย Only Skills Future Credit (Opening Credit) and One-off SkillsFuture Credit Top-Up can be used for this course.
SkillsFuture Credit (Mid-Career) CANNOT be used for this course.
UTAP Funding:ย NTUC Members can utilize UTAP to offset 50% of the remaining fees*.
Call us at +65 6250-3575 or email toย training@intellisoft.com.sgย for any questions or toย register for the upcoming class of Advanced Data Analytics & Visualization with Power BI with SkillsFuture or WSQ funding.
Do You Have Any Questions
on Course Fee, WSQ Grant or Funding?
Ask Us. We’ll be happy to assist you.
Register
Register for Advanced Power BI Training Course in Singapore at Intellisoft
- Visit Our Website: Go toย Intellisoft Training.
- Find the Course: Navigate to the โAdvanced Power BIโ course page.
- Fill Out the Form: Complete theย registration formย with your details & Submit the form
This hands-on, practical course will be taught byย Power BI Guru Vinai Prakash, who has over 35 years of experience in data analysis and business intelligence.
Donโt miss this opportunity to learn from the best and transform your data analysis capabilities!
TESTIMONIALS FROM OUR ADVANCED POWER BI COURSE ATTENDEES
โThe Advanced Power BI course exceeded my expectations. Vinaiโs expertise and practical approach made complex concepts easy to understand. I feel much more confident in my ability to create impactful reports and dashboards now.โย โย Sarah Lim, Data Analyst, Vodafone
โTaking this course was a game-changer for my career. The hands-on exercises and real-world examples provided invaluable insights. Vinai is an outstanding instructor who truly cares about his studentsโ success.โ
โย John Tan, Director, Business Innovation
Why Choose Us?
ACTA Certified Trainers
Authorized Training Organization
WSQ
Certifications
Fully Set Up
Training Room
20+ Years
Experience in Education
Practical, Hands-on
Training
25,000+
Certified Students
32+
Courses
Useful & Handy
Student Guide
Contact Us
We are located at Fortune Centre, 190 Middle Road, #10-08 Singapore 188979
Click here for For Directionsย
Telephone: 6252-5033ย ย WhatsApp: 9066-9991
Email: info@trainingint.com