PL-300 Microsoft Power BI Data Analyst Exam Prep

Topic 1 Get started with Microsoft data analytics

• Discover Data Analysis
• Get Started Building with Power BI
• Hand-on Labs

Topic 2 Prepare data for analysis with Power BI

• Get Data in Power BI
• Clean, Transform, and Load Data in Power BI
• Hand-on Labs

Topic 3 Model data with Power BI

• Describe Power BI Desktop models
• Choose a Power BI model framework
• Design a Data Model in Power BI
• Write DAX formulas for Power BI Desktop models
• Add measures to Power BI Desktop models
• Add calculated tables and columns to Power BI Desktop models
• Use DAX time intelligence functions in Power BI Desktop models
• Optimize a model for performance in Power BI
• Enforce Power BI model security
• Hand-on Labs

Topic 4 Build Power BI visuals and reports

• Scope report design requirements
• Design Power BI reports
• Configure Power BI report filters
• Enhance Power BI report designs for the user experience
• Perform analytics in Power BI
• Create paginated reports
• Hand-on Labs

Topic 5 Manage workspaces and datasets in Power BI

• Create and manage workspaces in Power BI
• Manage datasets in Power BI
• Create dashboards in Power BI
• Implement row-level security
• Hand-on Labs

Practice Exam

Promotion Code

Promo or discount cannot be applied to WSQ courses

Prerequisite

The learner must meet the minimum requirement below :

• At least O levels and above education
• Read, write, speak and understand English

The learner must also have basic Python knowledge. If you don't have Python knowledge, please consider the following WSQ courses:

• NICF - Python Fundamental Course for Beginners
  

Mode of Training

Instructor Classroom Training

WSQ Funding Validity Period

15 Aug 2020 - 14 Aug 2024

WSQ Course Fee Funding

Self-Sponsored

• Click here for more info on the funding for self-sponsored.
• Eligible Singapore Citizens can use their SkillsFuture Credit and PSEA funds to offset course fee payable after funding.

Employer-Sponsored

• Click here for more info on the funding for employer-sponsored.
• Absentee Payroll claimable by SMEs: Up to 80%of hourly basic salary capped at $7.50/hr
• Absentee Payroll claimable by Non-SMEs: Up to 80% of hourly basic salary capped at $4.50/hr

WSQ Assessment

• Participants will be assessed through individual assessment
• Passing Criteria – Participants are to answer all questions accurately in the individual written assessment.
• Participants may need to attend additional coaching sessions and re-assessments if they do not pass the required competency standards. 

• 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

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.

Audrey Lin : Audrey Lin is a ACTA certified trainer. She is a Business Development Director at Gill Technologies, an IT Consulting and Managed Services Provider focused at servicing SMEs. I'm responsible for the operations, sales, marketing, accounting, and finance functions of the organization. She have 13 years of experience in helping businesses and schools maximize their Return on Investment on IT through the use of the right technology, improving their business processes and increasing user adoption. My expertise is around Microsoft 365, MS Teams and Power BI. To help organizations improve employee productivity with tools from the MS 365 stack, she have delivered several classroom & online-styled end user training sessions to organizations from various industries - real estate, F&B, oil & gas, healthcare, schools, logistics. I have also created multiple customized & on-demand videos that end users can refer to for a quick review. Being certified as a Microsoft Data Analyst Associate, She is proficient at helping businesses gather business insights from their wide array of data. She have been involved in BI Projects with healthcare firms, logistics companies, FIs, etc., starting from the design phase, right through to the daily management of the BI system. Her area of knowledge in managing security and compliance in MS 365 is significant and ever-growing. She have good understanding of the Zero Trust Principle and uses that to improve the IT security posture of her clients. With the support of her engineering team at Gill Technologies, we use cloud-based management tools from MS 365, namely Intune, Endpoint Manager, Defender, etc. to manage our clients' endpoints.

Peter Cheong: Peter Cheong is a ACTA certified trainer. He specialise In IT related knowlege and conduct IT Training which Include Microsoft Window Server Technology (Wintel) and Linux - Centos/Red Hat. Comptia ,ITIL , Motorola Solution Trunking System and Cisco Networking. He worked in Motorola Solutions Conduct Motorola Astro 25 Trunking System For Police Force Malaysia (RMPnet),Taiwan Navy, Indonesia METRO POLDA (Police Force). After that he Join As IT Group Manager For W-Group which include 17 subsidiaries Companies in Real Estate Developer,Plantation. Building Management Services ,Contruction and also Fiber Opti Service Provider in Sabah,Malaysia.