DATE: 28 & 29 SEPTEMBER 2021 (TUESDAY & WEDNESDAY) 9.00 AM- 5.00 PM
VENUE: ZOOM APPS (CONNECT WITH US SAFELY FROM YOUR OFFICE OR HOME)
Power BI is not a new name in the BI market, components of Power BI has been in the market through diﬀerent time periods. Some components such As Power BI Desktop is such new that released as general availability at 24th of July. On the other hand Power Pivot released at 2010 for the first time. Microsoft team worked through long period of time to build a big umbrella called Power BI, this big umbrella is not just a visualization tool such as Tableau, it is not just a self-service data analysis tool such as PivotTable and PivotChart in Excel, it is not just a cloud based tool for data analysis. Power BI is combination of all of those, and it is much more.
With Power BI you can connect to many data sources (wide range of data sources supported, and more data sources add to the list every month). You can mash up the data as you want with a very powerful data mash up engine. You can model the data, build your star schema, or add measures and calculated columns with an In-Memory super fast engine.
You can visualize data with great range of data visualization elements and customize it to tell the story behind the data.
You can publish your dashboard and visualization tool in cloud and share it to those who you want. You can work with On-premises as well as Azure/cloud based data sources.
Power BI is a cloud based data analysis, which can be used for reporting and data analysis from wide range of data source.
Power BI is simple and user friendly enough that business analysts and power users can work with it and get benefits of it.
Power BI made of 6 main components, these components released in the market separately, and they can be used even individually. Components of Power BI are:
Data mash up and transformation tool.
In-memory tabular data modelling tool
Data visualization tool
3D Geo-spatial data visualization tool
Natural language question and answering engine.
|Power BI Desktop:
A powerful companion development tool for Power BI
In this training, participants will gain the following:
- Navigate between diﬀerent Power BI tools and their functionality
- Build informative dashboards
- Work confidently with and create a variety of visualisations
- Work with quick measures
- Create, edit and format interactive visuals
- Create multiple levels of filters
- Create and use custom slices
- Reduce time , with Power BI, from 1 hour to 1 min or less
WHO SHOULD ATTEND?
Senior Level, administrative staﬀ including Senior Sales & Marketing Executive, Finance staﬀ, Senior Account Executive, Personal Assistant, senior IT staﬀ, purchase executive, operation staﬀ, retail staﬀ who job description require them to not only enter data but to analyze data into Excel. Those who play a supportive role in decision making process will find this course useful.
EFFECTIVE TRAINING METHODS
The training is purpose driven. Our hands-on exercise will help you to understand the importance of Excel using practical case study. You will love those case studies.
Unconventional Training Tool
- Case studies from a Malaysia e-commerce internet company and multi branched retail chains
- Online Course
Presentation & Interactive discussions via zoom apps
KENT LAU CHEE YONG has over 11 years of training experience for Malaysian’ corporate and MNC focusing on improving productivity using Excel. He have helped over 4000 Malaysian to master Excel in the past 11 years, moving forward, his goals to help 10,000 Malaysian to master Power BI in next 3 years.
He is not only capable to conduct training effectively but also developing Excel-based tool for corporate using Excel Macro/VBA. Just by writing a few lines of VBA code, he helped an audit executive to reduce his work from 3 days to few minutes. In another case, he wrote another VBA codes to help a business analyst to reduce her monthly reporting task from half day to few minutes. He has helped many admin executive, quality control executive, HR executive, finance executive, audit executive, sales executive, marketing executive, business analyst to reduce their time to analyze and produce report. He has the privilege to train following companies:
DHL Malaysia, Ambank Malaysia, DKSH, Unilever Malaysia, Shell Malaysia, TNB, SGS, AstraZeneca, Clarion, Air Products, LB Aluminum Berhad, Siemens, Tele-Paper, Dunlop, TARC, FMM and more (over 400 companies in past 11 years and still counting)