Data Analysis & Visualization with Power BI

Data Analysis & Visualization with Power BI

Tanggal
16-18 Oktober 2024

Waktu
09.00-16.00 wib

Tempat
Swiss-Belhotel Pondok Indah
Jl. Metro Pondok Indah Sector 2 Block SA
Pondok Indah, Jakarta Selatan

Outline Training

1. Introduction to Power BI Desktop
2. Data Preparation
3. Data Modeling
4. Data Analysis Expressions (DAX)
5. Data Visualization
6. Artificial Intelligence with Power BI
7. Data Analysis

Note:

1. Contact us for details of syllabus & investment fee
2. Please bring your own Laptop with Microsoft Excel minimal 2019 installed.

Investasi
IDR 8.5 Juta/ Peserta

What is Power BI?
Power BI is a suite of business analytics tools, which includes both desktop (Power BI Desktop) and web-based (Power BI Service) applications, which:

1. Deliver insights throughout your organization
2. Connect to hundreds of data sources
3. Simplify data prep and drive ad hoc analysis
4. Produce beautiful reports, then publish them on the web and across mobile devices
5. Scale across the enterprise, with security and governance built-in

Power BI is the industry leader among BI platforms.

Note: For more detailed information, please visit powerbi.microsoft.com.

Power BI Training Road Map

• Part 1: Power BI Desktop
• Part 2: Power BI Service
• Part 3: Advanced Dax
• Part 4: PL-3000 Exam Prep

Part 1 Power BI Desktop
What You Learn in This Course
By the end of this 3-day Data Analysis with Power BI course, participants will be able to use Power BI Desktop to:

Prepare Data:

• Use Power Query editor to connect to source data; clean, shape, and transform tables; edit, merge and append queries; load data, etc.

Model Data:

• Build relational data models, create table relationships, understand cardinality, explore filter flow, etc.
• Use DAX functions, add calculated columns and measures, write DAX formulas for business metrics, etc.

Visualize Data:

• Use various types of charts and visuals, customize formats, edit interactions, apply filters, slicers, drill-through, bookmarks, etc.

Analyse Data:

• Use Power BI analytical capabilities, including AI visuals, i.e. Q & A, smart narrative, key influencer, forecast, decomposition tree, anomaly detection, etc., to analyse data and gain actionable insights.

Workshop Leader
Michael Shane
Data analysts can extract invaluable business insights and information from business transactional data with Business Intelligence by analyzing monthly behaviors, trends, and outliers, if any, of sales volumes, prices, and costs, etc., in their smallest granularity for the past several years. Top management can leverage them – when modeling their Strategic Plan and Annual Budget – to challenge, adjust, defend and justify business strategy and reasonableness of projection assumptions used in the financial model to make more informed and data-driven business decisions.

Michael is a passionate and robust proponent of Synergy of Business Intelligence and Financial Modeling. To promote this synergy using Microsoft Power BI and Microsoft Excel, he currently provides such synergy services and Power BI training to finance professionals in corporations. He hopes that businesses in Indonesia will commonly practice such synergy as it helps top management to make better business decisions that will lead to better profitability and healthier cash flows.

In his previous employment with Deloitte Indonesia, he assisted the firm’s top management in developing and implementing the firm’s internal self-service business intelligence and analytics using Microsoft Power BI for generating business insights which are indispensable for more accurate planning, budgeting, and forecasting as well as for aligning and fine-tuning business strategies and making more informed and data-driven business decisions.

He developed and regularly maintained Business Intelligence reports and dashboards using Microsoft Power BI for Deloitte’s Clients & Industry team.

As part of Deloitte’s Audit Analytics team, he also performed audit analytics using Qlik Sense to support Deloitte Audit teams.

In the earlier part of his employment, he assisted in a cloud-based accounting application project organized and led by Deloitte Audit Advisory Services team.

He was also part of Deloitte Indonesia’s training team and assisted in delivering the following monthly training:

1. Firm-wide internal training and public training on Business Intelligence using Microsoft Power BI, covering data transformation, data modeling, data analysis with DAX, and data visualization.
2. Public training on Financial Modelling using Microsoft Excel, covering Financial Modeling standards, Financial Modeling fundamentals, Financial Modeling for Planning & Budgeting, and Sensitivity & Scenario Analysis.

Michael holds a master’s degree in information systems management from BINUS University and is a Microsoft Certified Power BI Data Analyst.