Home / Technology & AI / Data Analytics with Power BI
Data Analytics with Power BI
Turning data into real-time business insights
Level of course:
Intermediate
Delivery:
In-Person Learning
Duration:
/ 2 days
Upcoming Course Schedule:
25-26 Nov 2024
20-21 Jan 2025
21-22 April 2025
Course Overview
Analyze data with precision, uncovering valuable insights for informed decision-making.
Power BI is a business analytics service by Microsoft. It aims to provide interactive visualizations and business intelligence capabilities with an interface simple enough for end users to create their own reports and dashboards.
This course provides participants with the knowledge and skills to work with and analyze data and work with business cases using Microsoft Power BI. This course will allow participants to use Power BI Desktop to connect to various data sources, shape the data, and use data models to create reports. Through this Power BI course, participants can learn that Power BI Desktop centralizes, simplifies, and streamlines what can otherwise be a scattered, disconnected, and arduous process of designing and creating business intelligence repositories and reports.
At the end of the course participants will be able to…
Who is this course for?
Anyone who wants to create professional dashboards and reports for their organization as well as to analyze data and derive insights.
Key Takeaways
Course Pre-requisites :
No prior PowerBI experience is require. Having of some basic knowledge of Excel charts and graphs would be an added advantage for you.
Topics
Here's what you get to
learn in this course
Topic 1
- Fundamentals of KPIs and their respective visual format
- What differentiates a good visualization from a bad one?
- Basic technical terminologies to get started with Power BI
- Different kinds of charts in Power BI
Topic 2
- Connect different data sources
- Understand data statistically and visually
- Understanding Power Query Editor for data transformation and cleaning
- Working with multiple data files
- Understanding Data Normalization
- Understanding Facts and Dimension tables
- Create relationships among queries
- Making “dirty data” fit for analysis
Topic 3
- Convert data types
- Create hierarchies in data to drill down
- Create groups
- Create basic visualizations
- Formatting visualization
- Apply in-built filters to a chart as slicers/ radio buttons/drop-down menu
- Understanding Focus Mode
- Adding interactivity in visuals for advanced presentation
Topic 1
- Create Slicer
- Understanding and using the visualization pane for filtering
- Creating Visual Field filters
- Creating Top N Filters
- Adding page-level filters
- Understanding Filter Interaction in Reports
- Create Map Based Visualizations
- Create Gauge and TreeMap Visualizations
- Importing Custom Visualizations
- Create multiple report pages
- Understanding Drill through capabilities and cross-filtering on reports
Topic 2
- Create a report
- Machine Learning features in Power BI
- Build a narrative in your report
- Customizing reports with shapes, images, text, backgrounds etc.
- Insight generation using Natural Language Processing in Power BI
Topic 3
- Understanding Power BI Service (Participants will be provided with a business account)
- Publishing reports to Power BI Service
- Accessing and sharing reports
- Storytelling using Power BI service
Instructor
Know your course instructor
Pranav Dubey
Pranav is an accomplished academic and corporate trainer in the field of data science, business Intelligence, and automation. Passionate about technology, he has been involved in developing digital solutions for analytics, operations, and AI.As an advocate of equal educational opportunities for all, Pranav has taught and mentored over 100k college students from 23+ countries on various skills through his social venture, The Sparks Foundation. As a corporate trainer, he has taken 1500+ hours of on-site and virtual training sessions & workshops in APAC region since 2019.
Download BrochureFunding and Subsidy
* Participant need to meet the attendance and assessment requirements to be eligible for the funding.
For Singapore Citizens & PR (below 40yrs old) |
For Singapore Citizens (40yrs old and above) |
|
---|---|---|
Course Fees | S$1000 | S$1000 |
Funding Support | S$500 | S$700 |
Total Fee payable | S$500 | S$300 |
Assessments
As part of the requirement for SkillsFuture Singapore, there will be an assessment conducted at the end of the course.
Participants are required to attain a minimum of 75% attendance and pass the assessment to receive a digital Certificate of Completion issued by Impress Training along with a WSQ Statement of Attainment.
SkillsFuture Credit
Eligible Singapore Citizens may use their SkillsFuture Credit balance to offset respective course fees. This is only applicable to Self-sponsored Individuals.
The Course is very useful. Trainer was engaging and I learned a lot.
Lee Ser Hiang
Senior Manager, CPF Board
The course was very interesting and Trainer was engaging and helpful.
Cheryl Foo
Manager, Supreme Court
Very engaging Trainer and knowledgeable in this field, Training was well-structured and many useful tips shared.
Abigail Lee
Marketing Executive, ST Telemedia Global Data Centres Pte Ltd
Well designed course and had great takeaways and backed by research.
Nigel Goh
Manager, Sembcorp Industries
Mind-blowing professional training course that helped my team with techniques to structure/plan a good presentations before diving into it.
Valerie Lee
Head, Corporate Development, Sembcorp Industries Ltd
I never knew PowerPoint has so much to offer. Thank you for alerting me to its possibilities.
Seah Boon Kiat
Deputy Manager, Temasek Polytechnic
Amazing instructor that never fails to wow and amuse me with his powerpoint creations. I enjoyed the course a lot. Keep it up!
Miko Chong
Product Innovator, NCS Pte Ltd
One of the most useful courses I've attended. Many hands-on practices. Great!
Samantha Wu
Manager, Civil Aviation Authority of Singapore
Great content delivered with great energy. Lots of learnings and insights.
Rakesh Patni
Research Director, IDC Asia Pacific
This course is a MUST for any professionals who does presentations, whatever the frequency maybe. Overall lots of knowledge gained & this would be very relevant and beneficial to my career.
Rubegan Soundarajan
Plant Manager, ST Engineering Innosparks Pte Ltd
The Trainer has done an impressive job in delivery a concept and impactful course on producing and presenting business presentations. He is entertaining and delivered the course very effectively.
Roderick Leong
Manager, Nxera SG Pte Ltd
Interesting Course - Animation are more effective than we thought. Passionate Trainer!
Ong Lay Khoon
Vice President, Sembcorp Energy Markets Pte Ltd
The course is amazing. Trainer is great, has lots of knowledge and very engaging.
Alberto Resco Perez
Senior Director, Software Engineering, Singtel
Trainer is very engaging and approachable, along with excellent delivery of course content.
Cedric Ang
Associates - Investments, Fraser Hospitality
Every Minute well-spent! On a more important note, definitely seeing myself applying the learning into my daily work.
Megan Niu
Lead, Sembcorp Industries Ltd
Fun learning session, a lot of insights sharing during the training.
Song Peilin
Senior Finance Manager, Mapletree Investments