Advanced Power BI for Business Analytics

Topic 1: Setup Data Model

• Power query
• Data modeling
• Relationships

Topic 2 Working with Power BI DAX Language

• DAX functions
• DAX formula 

Topic 3 Measures and Calculated Columns 

• Add calculated columns 
• Create measures

Topic 4: Creating Interactive Dashboard

• Create dynamics dashboard
• Create interactive maps

SSG Training Grant

Funding Period 25 Aug 2018 - 23 Aug 2023

SSG TG is $30 per pax. Net fee after SSG TG is $502.86. Absentee Payroll is not eligible.

Prerequisite

This course is for beginner. No prior knowledge on programming is required.:

Software Requirement

• Download and install Power BI Desktop https://powerbi.microsoft.com/en-us/desktop/
  
• Power BI requires Window 10 and above

• Data Analyst
• Business Intelligence Specialist
• Business Analyst
• Data Visualization Specialist
• Financial Analyst
• Marketing Analyst
• Reporting Specialist
• Operations Analyst
• Sales Operations Manager
• IT Manager (with reporting focus)
• Product Manager (data-driven products)
• Supply Chain Analyst
• Project Manager (with data reporting needs)
• HR Analytics Specialist
• CRM Administrator

Wayne Lim: Wayne Lim is a ACTA trainer. An Agile practitioner and Scrum Master, part of a start-up in the Maritime sector, and involved in family’s’ food and beverage business. Wayne graduated from RMIT University with a bachelor’s in construction management. Having 11 years in project management experience in the construction and marine sectors. Lectured in tertiary institutions in topics like management, marketing, engineering, mathematics, and customer service. His current interest includes R and Python programming languages, DevOps, and Agile methodologies.

Ken Hiong: Ken Hiong is a ACTA certified trainer. Ken has over 20 years of work experience in the healthcare and pharmaceutical industry, having assumed various functional and managerial roles in sales, marketing, business development, finance, business analysis and planning. With an interest and experience in scripting, Ken has worked on projects using HTML, CSS, PHP, MySQL, WordPress, MS Office, VBA, Power BI, etc. Notably, Ken is a proven expert Excel user at work who has made efficient many work processes, improved data analysis and enhanced the quality of business planning and reporting for organizations.

Ken graduated with a Pharmacy degree, holds a Master of Business Administration from the National University of Singapore and a Master of Applied Finance from the University of Adelaide. An ardent advocate of lifelong learning, Ken is ACTA trained and seeks to continually upgrade his IT skills through various channels of learning and Microsoft certifications. With MS Office Master qualification, Ken looks forward to assisting individuals and corporations improve their computer skills, productivity and business outcomes.

Sanjiv Venkatram: Sanjiv i is an ACTA certified experienced leader with a proven track record in business / finance consulting and in developing i) business intelligence (BI) solutions ii) data analytics/analysis solutions and iii) IOT lead BI solutions. Sanjiv's goal through Prudentia Consulting, is to promote the simple joy and excitement of actively using the Microsoft Platform. He believes that the agility afforded by the Microsoft platform helps businesses get time back for deeper business thinking and to spend more time with their end customers

Sanjiv has rich experiences in diverse/complex high-tech businesses, turn around environments and strategic transformations. His functional expertise is in sales analytics, financial planning and analysis, engineering and program management. He has worked across discrete manufacturing, professional services and higher education verticals. He also has a working knowledge of equities portfolio management within the financial services domain.Sanjiv is the CEO of Prudentia Consulting, an organization committed to promoting the active usage of the Microsoft Platform. Prior to this, he has worked at Microsoft (US & APAC: 9.2 years), Cognizant Tech Solutions (3.3 years), Yazaki North America (8 years) and until recently at Oracle. Here are a few of his BI/analytics projects driven at scale: Built APAC wide BI dashboard using the Power BI umbrella tool set (Power BI online, Power BI desktop and Power Pivot) and a KPI lake (SQL DB), Helped develop key KPIs – identified key KPIs and helped land this in the DB, Developed a budget audit tool that captured budget inputs from a host of countries across the globe, Developed a business unit P&L reporting tool (functional architecture) in Business Objects for the world-wide financial planning and analysis team.

Dr. Alvin Ang: Dr. Alvin Ang is a ACTA certified trainer. Dr. Alvin Ang did his Ph.D., Masters and Bachelors from NTU, Singapore. Previously he was a Principal Consultant (Data Science) as well as an Assistant Professor. He was also 8 years SUSS adjunct lecturer. His focus and interest is in the area of real world data science. Though an operational researcher by study, his passion for practical applications outweigh his academic background. He owns a startup externally.