Analyzing And Visualizing Data With Power BI

GENERAL CONTENT TUITION FEE TRAINERS PHOTOS

Who are entirely suitable for the training course?

Excel & Power BI are two tools that are indispensable with who working with data and statistics. It’s released by Microsoft Corporation. This course is designed to provide practical knowledge from overview to advance, to help students be acquainted with these tools and apply them to their work.

This course is suitable for:

Departmental Staff: to know how to use tools (MS Excel, Power BI) to view and design self-service reports.
Management Team: to know how to view reports on devices (Power BI); how to find business insights and hidden meanings of reports/data.
Business Analyst: to know how to use technology to analyze business data for business insights and design story-driven reports.
Students, workers: to need to learn and improve your knowledge.
People who have a passion for Microsoft’s products.

This course is designed for several topics, each topic will have requirements and appropriate objects separately. Please consider before choosing.

If you have any question, please feel free to contact us via: (84) 909 310 768 | 0903 746 294 or email: info@bacs.vn | bac.trainingba@gmail.com.

TOPIC 1: Microsoft Power BI Basic

Prerequisites:

Must be familiar with working with data in Excel.
Work email to sign up for Microsoft Power BI service.
Must have a PC/ laptop to practice.

Audiences:

Users who using Power BI to create a self-service report
Data Analyst, Finance and Accounting Staff, Marketing Professionals, Business Managers and all those involved with reporting
Business users, C-Level users who want to view/exploring report on mobile devices
Business Intelligence developers
Report creators.

TOPIC 2: Microsoft Power BI Advance

Prerequisites:

Must know the basics of working with data in Excel
Must complete course 1 OR have Power BI basic knowledge
Work email to sign up for the free Microsoft Power BI service
Must have PC/laptop to practice
Must have basic knowledge of SQL, relational database or Excel pivot.

Audiences:

Complete Power BI basic topic or already have Power BI basic
BI developers who work with modeling data
Power BI users
Analysis users
Data Analyst, Finance and Accounting Staff, Marketing Professionals, Business Managers and all those involved with reporting.

TOPIC 3: DAX and M Query

Prerequisites:

Work email to sign up for the free Microsoft Power BI service
Must have a PC/ laptop to practice
Must have strong knowledge of BI, relational database, cube.

Audiences:

Users who work with Data Cleansing or Data Transformation
Power BI Desktop user
Analysis Services Users
Power BI Users
Excels Power Pivot Users
Those that need to model data using SSAS, Power BI or Power Pivot
Data Analyst, Finance and Accounting Staff, Marketing Professionals, Business Managers and all those involved with reporting
This course is NOT for you if you are already comfortable working with basic and intermediate level DAX.

tham-gia-khoa-hoc-ba

Why should I take the course?

Microsoft is one of the Leading Technology Corporations, specializing in providing modern Technology Solutions which we are using today. The most famous are Microsoft Office suite and Windows operating system. They are also pioneering in providing technology solutions in-process data statistics in Business. Typically, that is a release of the Power BI tool - a suite of business data mining tools, helping to provide visual and intelligent information for decision-making in the organization.

For people who usually work with data and report, certainly that you cannot help knowing about Microsoft PowerPoint. A tool can systematize contents to help users can create visual and lively presentations and reports.

Combining with PowerPoint tool is Microsoft Excel tool, which can help users manage their data effectively. Excel has been becoming an indispensable application in the operation of every single business in Viet Nam. Almost all activities related to data always use Excel tool. Using Excel can help complete work faster 30 times than working manually. The people who are fluent in Excel may get career advancement higher by 60 percentage than normal.

How’s about Power BI?

With the strong development of Enterprises today, the demand for data aggregation and process really needs more than ever. If using Power BI tool, your business performance will be a hundred times better than just using Excel. With small data, you can process on Excel. However, if it's big data, multi-source, processing on Excel will be very difficult. Therefore, this Power BI tool will help us handle that huge block data, giving us a visual view from that, helping user finding out the opportunities and valuable information for business.

However, the coordinated use of that tool effectively to serve the work is not everyone knows and not a simple thing. With an increasing demand for using Powerpoint, Excel and Power BI in individual user communities as well as businesses, but there is no complete training course about this area. Therefore, BAC and experts have coordinated to design this course.

What do you get after the course?

Be equipped with knowledge from basic to advance, understand terms, concepts and usage of Excel and Power BI tool of Microsoft.
Understanding usage of Excel, Power BI in Data Analysis and applying them in real work.
Ability to use tool which has been trained to analyse data and take over the related work at the enterprise.

How are courses designed?

Excel & Power BI course is co-developed by BAC and the experts for 4 weeks with contents based on practical requirements of businesses. The course is divided into 3 topics, and sorted from basic to advance. Each topic will mention an area of knowledge related to Excel & Power BI, helping students master related knowledge and can apply knowledge into work in the most effective way.

The topics are independent, meaning the students can choose to enroll in certain topics without any requirement to register for the full course. However, with advanced topics, in order to enroll, students must be equipped with the basic knowledge required. Students can join into basic courses or students already have real experience in work and self-equipping required knowledge.

During the learning process, students will practice in parallel to learn theoretically. At the end of each topic, trainers and students will review the knowledge of each topic and resolve the problems of students together.

The topics will be trained in the course "Power BI":

Topic 1: Microsoft Power BI Basic
Topic 2: Microsoft Power BI Advance
Topic 3: DAX and M Query

Class Information

Place: 6th Floor, Thien Phuoc 01 Building, 244 Cong Quynh Street, Pham Ngu Lao, District 1, HCMC.
Teaching Language: Vietnamese
Materials: English
Issued Materials: Hard-copy (NO Soft copy), BAC/IIBA Practical Templates

Student Requirements

Join the course at the right place, on time and right schedule.
Comply with class rules.
Spirit of cooperation, working in group with members of the class and trainers.

Contact detail

Điện thoại tư vấn If you have any question, please feel free to contact us via:
Phone: (84) 909 310 768 or (84) 903 746 294
Email: info@bacs.vn | bac.trainingba@gmail.com

Contents of this course include:

Topic 1: Microsoft Power BI Basic
Topic 2: Microsoft Power BI Advance
Topic 3: DAX and M Query

Specific content:

Session 1-2-3-4

Topic Microsoft Power BI Basic

1. Introduction

Introduction to MS Power BI
Introduction components of MS Power BI: Visualizations, Datasets, Reports, Dashboards, Tiles
Introducing MS Power BI common workflow
Hand-on lab: Signing up for Power BI, Exploring report/dashboard on Power BI online

2. Microsoft Power BI Service

Introducing the Power BI online service
Creating and exploring reports using Power BI service
Creating and exploring dashboard using Power BI service
Exploring data with Q&A
Mobile applications
Sharing and collaborating
Exporting report/dashboard.
Hand-on lab:
- Create the first report with Power BI service
- Create the first dashboard with Power BI service
- View report/dashboard on mobile devices
- Sharing report/dashboard within an organization
- Export report/dashboard

3. Microsoft Power BI Desktop

Introducing Power BI Desktop
Connecting to data sources in Power BI Desktop
Cleaning and transform data in Power BI Desktop
Relationships in Power BI Desktop
Designing reports
Publishing to Power BI Service.
Hand-on lab:
- Download Power BI Desktop
- Using Power BI Desktop to connect to data source
- Cleaning data
- Create a report in Power BI Desktop
- Publish report to Power BI Service

Session 5:

4. Power BI with Excel

Introduction using Power BI Data with Excel
Setting up Power BI Data to work with Excel
Creating Measures for Excel Analysis
Configuring refresh schedule to keep report/dashboard data up-to-date
Hand-on Lab:
- Loading data from Excel to Power BI desktop
- Create some sample measures
- Create reports using measures

5. Graphs and Visualizations

Intro to Visualization Section
Column Graphs
Stacked and 100% Graphs
Graph Options
Trend Analysis Graphs
Additional Graphs
Scatterplots
Bubble plots
Ribbon Chart
Hand-on lab

6. Interactive Dashboards

Creating Interactive Dashboards
Interactive Dashboard Section
Publishing Dashboards
Pinning and Q & A
Sharing Dashboards
Power BI on Mobile
Themes

7. Summary

Session 6-7-8:

Topic Microsoft Power BI Advance

1. Cleaning and transform data

Cleaning data using Edit Queries in Power BI
Transforming data
Combining data from multiple tables
Hands-on lab: Cleaning and transforming data in Power BI desktop

2. Modeling data with Power BI

Introduction to modeling data
Manage relationships in datasets
Create calculated columns
Optimizing data models
Create calculated measures
Create calculated tables
Explore your time-based data
Hands-on lab:
- Import data from source to Power BI desktop
- Create relationships
- Create calculated columns, calculated measures, calculated tables
- Optimize data model.

3. Manage Roles in Power BI

Introducing Row-level security (RLS) in Power BI
Define roles and rule in Power BI Desktop
Verifying roles rule in Power BI Desktop.
Hand-on lab:
- Define roles and rule in Power BI desktop
- Public report to Power BI service
- Verifying role & rules.

4. Manage Groups in Power BI

Introducing Group in Power BI
Create and manage Group
Sharing between group members
Demo

5. Introducing Content Pack

Build content pack
Use content pack
Update content pack
Demo

6. Summary

Session 9-10

Topic DAX and M Query

Part 1: DAX

Introduction to DAX
DAX calculation types: Calculated columns, Calculated measures
DAX functions:
- Aggregation functions
- Counting functions
- Logical functions
- Information functions
- Text functions
- Date functions
Using variables in DAX expressions
Table relationships and DAX
DAX tables and filtering
Time Intelligence functions
- Introduction to Time Intelligence
- Creating a Date table
- YTD Calculations
- Formatting Dates
- Date Master Tables

Part 2: M QUERY

Importing data
- Introduce Power Query data sources
- Import data from Excel file
- Combining data from multiple sources
Transforming data
- Using Query Editor to transform data
- Manage queries
- Query setting steps
- Transformation techniques:
  - Pivoting/Unpivoting Columns transformation
  - Split Columns transformation
  - Filtering Data
  - Sorting data
Combining data
- Appending tables
- Merging tables
Managing query
- Refresh schedule
- Sharing query
Power query formulas and functions
- Power Query formula
- Condition logic in Power query
- Using parameters in Power query
- Create custom function
Time Intelligence
- Formatting Dates
- Date Master Tables
- Hand-on lab
Topic Summary

FULL TUITION FEE: 9,900,000 VND

The tuition fee includes materials and certification.
Materials are included notebook or/and pen.
Tuition fee IS EXEMPT from value added tax (VAT).

DISCOUNT POLICY

10% discount on tuition fee if the students register for the course and payment is received ten days in advance.

PAYMENT

Students can choose 1 of the following payment methods:

Payment in cash

BAC TRAINING AND CONSULTANCY JOINT STOCK COMPANY

Headquarters: 6th Floor, 244 Cong Quynh Street, Pham Ngu Lao Ward, District 1, HCMC.
Branch: 11th Floor, 39B Truong Son Street, Ward 4, Tan Binh District, HCMC.
Email: info@bacs.vn or bac.trainingba@gmail.com
Hotline: (84) 909 310 768 | (84) 903 746 294

Payment by cards

BAC accepts new payment method: Convenient payment using mPOS device:

Payment by swiping ATM and international cards directly at the BAC office.
Payment by Internet Banking / Mobile Banking / Electronic Wallet (E-Wallet) / QR-code.
Easy payments from anywhere with the payment link.
Payment by credit card, installment with 0% interest.

Fee: card fees MUST BE PAID by the customer when paying by card. The consultant will estimate the card fee according to the fee schedule given by mPOS and provide a concrete estimate for the student to consider before paying. For additional details on how to incorporate the mPOS payment solution, please visit this link.

Payment by Transfer

Account 1: Tien Phong Bank
- Account number: 01236879001
- Account name: CTY CO PHAN DAO TAO VA TU VAN BAC
- Tân Bình Branch

NOTES:

Students shall complete the payment in advance, and not later than the opening session. BAC does not accept any payment after the opening day.
Exceptions: In cases of faulty payment process or students have committed to pay tuition fee after the opening day, BAC will accept as exceptions.

OTHER PROVISIONS

Reserve registered courses

After register and pay the tuition fee for the course, if students can not join the course, they should have an official notification to BAC before the opening session. In this case, students will be reserved tuition and join the next course or switch to another BAC course in suitable requirements.

Opening Schedule Changes

In case of course could not start on schedule, BAC will send an email to inform the student of the expected opening day.
If the new opening schedule is suitable for students' needs, BAC will reserve tuition fee. Students will continue to participate in the course.
If the new opening schedule does not meet students' needs, BAC will refund the tuition fee.

Refund Policy

Tuition fees ARE NOT REFUNDED.
In case of our student cannot join the new class schedule due to a change from BAC in terms of changing the course opening schedule, that student will be refunded the tuition by BAC according to the following process:
- Students can receive a refund by transfer or in cash.
- After the two sides have officially confirmed the cancellation of the course, the entire tuition will be refunded to students by BAC within a maximum of 3 working days.
- Students must return the receipt of tuition to BAC to complete the refund procedure.

Any information or support related to payment - PLEASE CONTACT US VIA:

Hotline: 0903 746 294 or Email: phungtran@bacs.vn.

Bui Huynh Thuy Mai

Ms. Bui Huynh Thuy Mai graduated in Computer Science at the Ho Chi Minh City University of Science (Viet Nam National University Ho Chi Minh City). With more than 10 years of experience working in the field of database programming and more than 7 years in developing BI applications such as MS BI, Cognos BI suite, Pentaho BI, ZAP BI. Currently, she is working as Data/BI Specialist at Datatyk Ho Chi Minh – a startup specializing in providing supporting service and development data analysis solutions. Besides, she has experience working with Machine Learning and she is a Full-Stack Microsoft BI (MSQL, MSIS, MSAS, MSRA and PerformancePoint) and Share-Point 2013...

To Ngoc Van

Ms. To Ngoc Van graduated in Computer Science at Hong Bang University (October 2002). With more than 10 years of experience on ETL, Warehouse, BI; 10 years of experience on database as Analyst and Designer, DBA, T-SQL/ PL/SQL developer (SQL Server and Oracle, MySQL). Besides that, she also has experience in programming, analysis and design database.

Ho Ngoc Phi

Although his chronological age is very young, he has experienced in many positions as a lecturer, assistant director and data processing analyst. He is an expert in Excel. He teaches informatics (Word, Excel, PowerPoint) for teachers of English school systems such as LEECAM, NGOAI NGU THAN DONG, ANH NGU KHONG GIAN and ANH NGU THUONG DINH. He is a regular teacher about VBA and EXCEL of giaiphapexcel.com and Nguon Luc Quoc Te. He usually open Excel’s class, teach Excel for big companies such as Canon, Unicons, Viet Nhat, Cocacola, Viettel, VinaPhone, Vsip1, OI-ABJC, Lotus, Akzonobel, Kumho, Phu Nong and some other small businesses. Writing VBA applications on Excel, etc.

Nguyen Minh Ngoc

Mr.Ngoc is a procurement professional, having 09 years of work in total, comprising of years working for Holcim Vietnam and Malaya Vietnam Glass Limited in different areas from customer service to commercial environment. Having in-depth knowledge of customer service, procurement, purchasing, inventory and warehouse activities, blended with strong ERP experience (SAP, EXACT GLOBE), analysis in Excel visual basic programming (VBA), high sense of responsibility, discipline & integrity. Ngoc is very experienced in translating the Business strategy into operational/execution plans and is the 'connector' to bring cross-functional teams together to constantly deliver the business targets...

Students are awarded certification after completing the course

One of the practical hours of the course

Nguyen Thi Mai Binh

Business Analyst

For an outsider like me, the topics on "techniques" of BA are very important. Examples include using diagrams to model the requirement, write User Story / Use case, etc.

At the course of Fundamental Business Analysis, I met Mr. Loc, a very enthusiastic and caring person. In addition to sharing practical experiences in class, he also takes the time to advise, support, and comment on my CV. Besides, the Center and Phung also support sending CVs, connecting students to the network of quality partner companies, which helps students like themselves find the most suitable job. Thanks, BAC.
View detail +
Pham Que

Business Analyst

The BAC Product Design course has provided me with a lot of useful knowledge and background. The lecturers are very enthusiastic, infusing us with a flame of passion and enthusiasm in the industry. At the same time, share the necessary knowledge and skills in lectures in a more understandable way. The number of students is not too much, so the quality of teaching is excellent. Instructors correct the exercises 1-1, so the lesson will be more in-depth.
View detail +
Nguyen Van Long

Specialist in accounting mode & Professional solution of Finance and Accounting in IT application - Vietnam Electricity (EVN)

I participated in Fundamental Business Analysis at BAC. At this place, the training material provides a lot of useful content and is easy to understand. The lecturers are very enthusiastic additionally the content of the curriculum, they also share many practical experiences, questions of the students are answered right in the classroom, and with illustrations from real projects. After all, Thanks to BAC and Teacher Thai Son.
View detail +