monsoonsim thailand - monsoonsim th - monsoonsim x ......monsoonsim x data analytics 1 note: the...
TRANSCRIPT
MonsoonSIM x Data Analytics
1
Note:
The note from myself to all the Certified Trainer of MonsoonSIM in Thailand. MonsoonSIM is only one of the supporting tools ads
very first step to synchronize the Data vs Action in Business Processes and will be leverage as business descriptive, diagnostic,
predictive and prescriptive.
To utilize the supporting tools as powerful tool to start the 21st century world-requirement skill which be called ‘Data Analytics’.
CT are need to integrate Art and Science together. And make sure that we didn’t deliver the memory of pattern for interpretation of
data, but we do need to lets data to be a part of learning the cause and effect, and link with many theories in business and
management, and let’s the Learner to notice the pattern themselves. Due to the limitation in MonsoonSIM which able to provide the
fundamental understanding. CT will be the one who extend the learner vision, the study case of Business in reality, will be given the
sampling in each business/industry to learner. By the way, the business which vey dynamic; not only have one purposing; to lets the
learner to test and try multi-dimension of data by themselves will extend their experiential and become ‘Business Data Analyzer’ The
interpretation of data without the knowledge of social sciences will have no value like what we trying to step into Digital
Transformation., as same context of Data-lization also.
The data analytics is widening area. Technically Business Data Analytics are alike Combination of Art and Sciences. In this cases,
• Art is understanding what business Needs (Market& Customer, Process to fulfil the market’s demand with limitation of
resources to supply by business achievement which vary on many perspectives, factors, limitation which I have called
‘Dynamic Dimension of Art’ this part is very significant as same as level of Data Model which can describe what going on,
why it is significant, when, where and who we should applied or not applied that action.
• In the other hands, we are talking to Data which become more proof-able and we had call them as Data-science to make
them systematically (Colleting, Storing, Cleansing, Transforming, Enriching & Interpretation) which will be categorized in
many way in Many area like; IT infrastructure to provide colleting, Storing; in the world of Software which will try to enrich
the data to be come widen answer as pattern of data or specific answer in certain business questions.
When Art combine with Science it like 200 years ago, when the academic try to systematize the art and social school to become
‘Science’ by putting the law. Unfortunately, we have unfruitful result as Silo Learning and became Silo practical as normal like today
business. The sense of using cross data department;(Multi-Dimensional) are hardly to form “Entrepreneurial skills” by traditional
learning and teaching style. Please do not lets this happened again in our era.
In the Science perspective, we may need to found the sampling of the action , statistical and denoted them as data pattern. But
somehow when Data need to used to evaluate qualitative or hardly-human interact with situation. The data pattern seems to have
various model. That why as CT, do not start with model to remember. We should start with test and trial, error and achieve. Start
with ask more not tell them more.
Paramintara Yaoyuenyong
April 2020
Pottery Soldier picture from b2bnn.com
“ กลยุทธท์างธุรกจิในยุค Disruptiveเกดิจากกระบวนการทางธุรกจิทีม่ี
ประสทิธภิาพ ผสานเขา้กบั การใชข้อ้มูล
ทีม่ ีพลานุภาพ และพืน้ฐานของกระบวน
ท่าทีด่ ีเร ิม่ตน้ที ่MonsoonSIM ”
Facebook: MonsoonSIMTHMonsoonsimthailand.com
ปรมนิทร ์เยาวย์นืยง2
MSIM x Data Analyticsembrace the Business + Data Analytics = Data Driven Business
3
Paramintara YaoyuenyongMonsoonSIM TH Certified [email protected] April 2020
Note:▪ MSIM is business simulation platform which provide fundamental experience and knowledge to Business, Management, ERP & Business Processes and Basic Data Analytics which link to Business
▪ MSIM is not ERP Program but initially build to learn ERP and Business Processes
▪ MSIM has their own Business Intelligent but still need to integrate with 3rd Party BI; like Tableau, Power BI, Google Data Studio.
▪ the data set in MSIM can export as manual by download as CSV from any graph, some report are need to transform the data before use and Live Access, which will send data to SQL
▪ most of Data in MSIM already in Unpivot type to use with 3rd party BI.
▪ MSIM is developing in area of Data Analytics. We are open for idea and comment form our Certified Trainer.
4
Updated in March 2020
What MonsoonSIM & Data Analytics synchronize for
5
Data Analytics
Business
Data
Analytics
Harmonizing the working
between Businessman
& Data Engineer
Understanding about
what business need/
Business terminology
Where data happened in
the business processes and
Able to understand when
Query business data
Data Visualization will help
on business analytics and
Decision making
To build the Data Driven
Business concept which is
21st Century of Entrepreneurship
Relationship between data
& business activities to
make report/dashboard
6
Data Driven Business Value Chain and Revenue ModelBy Lasse Berntzenhttps://www.researchgate.net/figure/Data-Driven-Business-Value-Chain-and-Revenue-Model_fig2_319114871
7
https://www.intergen.co.nz/blog/Priyanka-Roy/dates/2017/8/The-data-driven-world/
The Data Driven World
Strategic
GOAL
ORGANIZATION
BUSINESS PROCESSES
INFRASTRUCTURE
Relationship between Data VS Business (A)
Paramintara Yaoyuenyong (2019)
Internal FactorsExternal Factors
DATABASE
(Store/Clean/Structure)
TOOLS
(Collection)
ERP
(Evaluate/Control/Drive/SPRINT)
ERP and BI
(Measurement/Utilize/Optimize/Forecast)
PROJECT MANAGEMENT
(Tracking)
BUSINESS PLAN
MARKETING PLAN
SALES PLAN
PROCUTION PLAN
FINANCIAL PLAN
HR PLAN
COLLABORATIVE
EXECUTION PLAN
IN EACH BU
DATA and
IT INFRASTRUCTURE
(Server & Storage,
Network & Security,
Client and Sensor)
ALINE
DATA
8
Data Analytics Maturity Description
By Dr. Thanachart Ritbumrung
BADS, SGSS, NIDA
9
10
Business Analytics Maturity
Descriptive Analytics
What happened?
Univariate Analysis
Diagnostic Analytics
Why it happened?
Multivariate and Multidimensional
Predictive Analytics
What might happen?
Data mining and Machine learning
Prescriptive Analytics
What should
we do?
Optimization
Descriptive / Diagnostic
ActivityData &
Information Decision
CauseData &
Information Result
11
Predictive / Prescriptive
ResultsResults
ResultsResults
TIMING / SAMPLING
ENVIRONMENT (CAUSEs/RESULTs)
ResultsResults
ResultsResults
Predictive&
Prescriptive
12
MonsoonSIM MaturityParamintara Y. (April 2020)
13
Basic Business & Management Concepts
Integrated Workflow& Decision Making on multiple KPIs
Strategic Thinking & Collaborative Business Processes
Strategic Business Management & Data Driven Business
Business Analytics & MonsoonSIM Maturity
Descriptive Analytics
What happened?
Univariate Analysis
Diagnostic Analytics
Why it
happened?
Multivariate and Multidimensional
Predictive Analytics
What might happen?
Data mining and Machine learning
Prescriptive Analytics
What should
we do?
Optimization
This slide originally from workshop which MSIM conducted with Data Café Thailand and converted to add MSIM’s Experienced in by Paramintara Y. April 2020
Da
ta A
na
lyti
cs
wo
rld
Mo
nso
on
SIM
wo
rld Basic Business &
Management Concepts
Integrated Workflow& Decision Making on
multiple KPIs
Strategic Thinking & Collaborative Business
Processes
Strategic Business Management & Data
Driven BusinessIn Ordinary University class skilled In MonsoonSIM Basic Class skilled In MonsoonSIM Intermediate Class skilled
• Able to work as designed KPI in their job role as officer
• Able to learn and be expertise in their job territory
• Able collaborate their work with others
• Able to solve multi-dimensional problems with various optional
• Able to utilize internal Data to solve problem
• Able to find the solutions by keep others KPIs and driven business as Team Leader
• Able to protect, prevent and solving the Business Risks
• Able to utilize external data to support and becomes strategic business decision making
• Able to optimize existing Business Plan/Processes to generate better outcomes
• Able to build new Business Plan as new sources of incomes
Bu
sin
ess
wo
rld
To study and Learn To Work as professional To manage Risks and collaborate all
function as organization strategicTo build the new business plan/opportunity
To optimize for better outcomes
14
Data Analytics Learning with MSIM
15
Business Fundamental / Understanding
Business Experienced by MonsoonSIM
- Business Processes/Concepts
- Action in Business to Data
- Basic Business Decision (Business Information)
- Introduction to ERP; Enterprise Resources Panning
- Basic Business Plan
Basic to Advance Business Strategies
Business Decision Making with Integrated KPI from many Business Units to Business Plan
- MSIM Dashboard- MSIM Business
Intelligent
- Resources& Risk Management
- Utilization and Lean Management
Data Visualization
Visualize business Data to make better understanding in Business Problem and make better decision
- send out business game data to use with 3rd party BI; Tableau, Power BI or G-Data Studio with CSV or Live Access
- Integrated with Business perspective
Data Driven Business (Business Strategy by using Data)
Able to use Business Data to create Business Strategies
- Able to investigate business problem and find the root causes and having better solutions
- Able to use the Data to drive business to run smooth and create methodology match to business plan
- Build adaptive business plan
Key success & Roadmap to learn Business Data Analytic by MonsoonSIMParamintara Y. April 2020
16
Stage 1:
Understanding Relationship between
Data and Business Action as Information
as Data Principles (Professional Officer)
Stage 2:
Understanding Business KPIs, Risks, Business Processes
and Data flow crossing operation and
understand as Data Pattern
(Head of Department)
Stage 3:Use MonsoonSIM’ s BI; Business Intelligent to
Understand as Diagnosis for
fundamental and closed business
environment with MSIM Live Access
as Data Principles (Entrepreneurial
Manager)
Stage 4:
Transform Data Pattern and Business Scenario
from MSIM to Data Visualization for
further study as Data Principles (Business Junior Management)
Stage 5:Business Used Case for
study build SEM; Strategic Enterprise
Management ( C - Level )
Stage 6:using Big/Live Data +
Experiential Data to extend
as Data Driven Business by Predictive +
Prescriptive Analytics
( Board and Higher Managemnent )
Descriptive Analytics Diagnosis Analytics Predictive Analytics Prescriptive Analytics
Fundamental Business Concept
17
Profitability
(Gain income)
Manageability
(Cost Controlling)
Highest Profit
Business Processes
Management &
Business Data Analytics
Continuity to keep good status
ACT
Relationship between Data VS Business (B)
BUYING
GOODS
SKU
CUTOMERS
DATE
TIME
COLLECT
CLEAN
STRUCTURE
ANANLYZE
BEHAVIOR
TREND
POPULAR TYPE
QUANTITY
PROCUREto SELL
CHECKDOPLANCHECK
SUPPLYEVALUATEDEMAND
PROCESSERP/BI/ETCPOSInformation’s User: Product Manager, Marketing, Procure, Production, EtcSales & Accounting & IT IT App & Data Analyst 18
Measurement (Data Proven Business)
19
MonsoonSIM xData Analytics
20
Note: for 3rd Party BI
21
There are many 3rd Party BI Tools in
market with different support for
education and free using period. BTW,
if your student can leverage their skill
by merging experience with Data and
understand how the data tells or
describe the actioned and what will
data tells them about. Would be great.
My experience (MAR 2019): For Business and other student who are not keen on CODING. Tableau quite good but
limited free usage time, unless your can have academic version. Power BI Desktop seems to be good tools for free
usage. BTW any tools which student can learn more would be great. And Free description in YouTube are widely
founded. For student which understand coding, Google Cloud BI is an good Optional tool.
3 fundamental steps to learn Data Analytics x MonsoonSIMfrom Data Processing to Data Visualization
22
•Let’s learner gain basic Business Knowledge and Leverage to each maturity level
•Pull the Data in the MSIM to use with BI Software
MSIM Experienced and Export Data
•Cleaning
•Transforming to readable format
•Single source of truth
• Do need the Business’s knowledge (Basic → Advance)
•Creating data model to be used
Data Preparation & Data Modeling •Coding and Formula
•Design the Dashboard; graphical representation of information and data
• Interpretation
Data Visualization
MSIM Experienced and Export Data
23
Business Concepts/Practice
Business Size/
Processes/
Complexity
Number & Size
of Data/
Transactions
Type:
• Each virtual company
data (Users Level)
• Comparison of every
virtual data (CT Level)
Manually Export
• Raw Data
• Transactional list in
each department
• MSIM Report
• etc
Live Access to SQL
• 4-5 sets of data
(Sales, inventory,
marketing and
procurement)
The key success of Business Data Analyticsthis is key of interpretation of Business Data Analytics, always weakness of data analyzer
Understand changes of data
to Business decision criteria
Understanding Data and Business Result
in Each Business Processes (Continuity in Process and Supply
chain to Data
Understand Business Activity
and Data; Relationship of Data & Action
Understanding Business
24
Peacock tail style
(Big picture)
Onion style
(In depth)Paramintara Y.
How to export data from MonsoonSIM
25
EXPORTING DATA
Where data was kept in MSIM?Recommended, When you download, may need to rename the file with date and type of data
The data in MonsoonSIM will able to group as 2 groups
26
A) Data in some department B) Data as report (info) from User Report/BI
• There are data in each business department related to their
job roles/KPIs
• These Data need to be Cleaned and Transformed before use
• Mostly need to ‘Search’ to the date that you need those data
• Example
• Accounting/Finance will able to see P&L, Balance
Sheet and Trail Balance based on the date you ae need
• Marketing Report, will based on which date that you
have purchase the report.
• Forecast will able to load forecasting in the game
which show market demand
• In report/BI menu will have daily record of Inventory, Retails
Sales, Whole Sales, Operating Expenses, Cash on Hand,
Procurement and Marketing Expenses (All of these data is
unpivot data type)
• The other option is Export Game KPI
Extending CasesCT who teach about Data Analytics may need to extend the learner vision about Data Analytics
▪ In normal SME, not many company implement ERP systems in. Mostly will start with functional software like Accounting, Inventory, Sell separately and they can not link to each one automatically. Mostly may need to combine them with many technique.
▪ The data in each software will have different style/pattern when they has been stored in ‘Database’
▪ Master Data and type of data like Date, some Record will different based on limitation and condition of each software.
▪ when they would like to bring data from different record in different file type and style. Mostly me need to transform them as one Table; (Data Preparation to make then single source of truth)
▪ After that Data Modeling will be incurred (If needed)
27
Data Access Allowance
▪ As USERs in Each virtual company will run their business and the game system will record those transaction and become Raw Data, Data, and Report in the game. The learner will able to export these data in many format; Some need to do data preparation process (In Raw Data level), Some data is ready as Unpivot type to apply with 3rd party BI
▪ As Certified Trainer, CT able to Export KPI, Data in Observer. But the data will be Comparison Data from Virtual Company in That’s Game code. This can be manual download or Live Data Access. BTW, (April 2020) the limitation will applicable to Live Game not Club Game.
28
Data Access AllowanceManually Download & Live Access
29
All graph format → csv
These Data need to be prepared before use
FIN PMN MKT
These Data need to be Cleaned/Transform
Data in each department → CSV
Export Game KPI → CSV
Cost&
Price
These Data already in Unpivot type
FIN HR
Stock
Value
Market
ShareSales
PRD
Utilizati
on
Transaction Report → CSVThese Data already in Unpivot type
Cash on Hand, Inventory, Marketing
Expense, OPEX, Procurement, Retails
Sales, Wholesales Sales
Each Virtual Company Data
Learner Access CERTTIFIED TRAINER ACCESS
All virtual Data in Same Game Coder
An Option to export business data from MonsoonSIM (CT)
30
Update V.8
Export Data
Export DATA as CSV
Data Analytics Live Access
CT ONLY
CT: KPI Export to CSV
31
Update V.8
CT ONLY
CT Export Game KPI are comparison
between every group in each data
CT can Export Game KPI as below
guidance., in each file able to
contain 20 sets of data.
I do recommend to download and
rename the file name.
Export data from any graph in MSIMApplicable to all graph in MSIM (CT and Learner)
32
Update V.8
All the graph will have 3bar menu in right top corner, you can click at this menu and choose download
CSV, download and save as, RENAME the file, reformat the data ‘de-normalize, unpivot data’ before use
Learner; Export KPI
33
Update V.8
Learner will only export their virtual company KPI Data, but for CT will be comparison between every group
in each data
For Learner, They can Export Game KPI as below guidance., in each file able to contain 20 sets of data.
I do recommend to download and rename the file name.
34
Learner; Export DataUpdate V.8
New interface in data pull out and BI
35
Update V.8
BI; Business IntelligentThe information in each type which able to download as csv to use with 3rd Party BI
Able to filter the data by date (Starting – Ending)
And can copy, download as excel or CSV
Export Data to CSV file type
36
1
2
EXPORT to CSV
37
Student able to download some data for more analysis
With 3rd Party BI software like Power BI, Tableau by
using this function
Data Analytics Live Access
38
Recommended to
take a look
Note:
Since MSIM version 7.x (FEB 2019). The users able to pull the data in MonsoonSIM Game to use with 3rd party BI
software like Tableau, Power BI, Google Data Studio and etc.
In these software, the step of learning Data Analytics quite the same page, only some feature, terminology, menu
name and Dashboard quite different.
In the sample of this supporting presentation will be based on Power BI. BTW, CT able to use these platform or
others like QlikView, R, Python match you your designed curriculum and learner’s experiences.
The writer is not expertise in any Data Analytics area., If some content has mistake and mislead, I am do apologize.
And pleas do help to update this together in out CT community.
Data Analytics Live Access Step
39
Update V.8
CT Activate the Live Access
Feature
CT given related info
Learner put required info to 3rd
Party BI
Learner prepare the dashboard for
their purpose
Once the game has been played,
Data will automatically send out to IP Address
via SQL Connector
IP Address, Databased number,
Username, and Password
40
CT: Data Analytics Live AccessUpdate V.8
CT will need to activate Live Data Access and set assessment to Learner
CT will able to allow to send out the data to 3rd Party BI which
support import data from SQL
After click Live Data User Access, Game will show an IP
Address, Databased number, Username, and Password
CT need to share these information to Learner
Once you have allowed access, these access will longer for 2
weeks
41
CT: Data Analytics Live AccessUpdate V.8
Data will be 2 different sets;
Trainer Data Set
will be comparison data of all virtual company
Data will be 2 different sets;
TEAM Data Set
will be each virtual company data Set
CT will need to activate Live Data Access and set assessment to Learner
42
CT: Data Analytics Live AccessUpdate V.8
Download SQL Connector https://www.monsoonsimthailand.com/download1.html
To send out the data set as Live., The Learner need to prepare
▪ 3rd Party BI like; Microsoft Power BI (Desktop), Tableau etc
▪ Download SQL Connector to become agent to send out Dataset to those
BI Software
Live Access with MS Power BI
43
Update V.8
1. Get Data and choose My SQL Database
Live Access with MS Power BI
44
Update V.8
2. Fill in IP Address as Server, 5 digit of game code as Database
Server = IP Address
Database = Game Code
45
Live Access with MS Power BIUpdate V.8
2. Fill in IP Address as Server, 5 digit of game code as Database
46
Live Access with MS Power BIUpdate V.8
3. Data will be pulled into Power BI, after that
Check this boxes to choose
The data set to Power BI
After this process, will be
▪ Prepare data which Power BI able to
read (Unpivot Data/DE normalize data)
▪ Choose appropriate output (Graph
format), add Attribute, adjust the value
of Dashboard as Power BI can do
Guide from MonsoonSIM about Live Access
47
Update V.8
https://www.monsoonsimthailand.com/uploads/3/1/3/8
/31385775/monsoonsim_google_data_studio_workshop.
The guide by Mr.Sidhata Gunawan
MonsoonSIM Indonesia
Extending Knowledge about Data
48
Type of data
Action/DataIT Infrastructure
Type of Data Store/ Data Management
SW1 ACC
SW2 Sales
SW3 LGS
Reporting (Dashboard) & Data Services for
Business (Planning, Decision making, Execution)
Data Processing Application Level, Data Modeling
to suite the purpose
49
X
After this we will using Power BI as 3rd party BI to demo how to use data in MonsoonSIM to Visualize and learn more.
The reason to choose this platform, cause of Desktop version is permanently free no expiry within certain time. and
Related tools like Excel will work with Power BI. And the methodology in these file, will use Power BI technique.
BTW, For other platform, mostly the process quite the same. CT and Learner able to choose the platform you are keen on
Steps after exporting the data from MonsoonSIM
50
1) Try to understand Data in activity, result layer from MonsoonSIM which will you export first. To Make sure that
you will ready to put/in lay/sync when many data has been scrummed together.
2) Set the Goals why you need to put these data to understand, describe, predict or prescribe them. Technically
can be call “Business Problems that you want to solve, to learn to prevent the risk, to utilize and to optimize
your administrate quality.
3) Export and rename the file name that learner understand. By putting into One folder to easier to ‘GET DATA’
4) Recheck the Data format and make sure that the data is ready to be used in Power BI as Processed Data;
Unpivot format, Correct Type of Data etc.. (This part can use Excel or using Query Data in Power BI)
5) Get Data into Power BI Processed and modelled (Note step 3 and 4 can be traditional way or use feature in
each software to processed data)
6) Visualize and Convey Data in appropriate format
Single Source
of Truthor other
platform
Data Preparation & Data ModelData preparation and Data Model is one of the key of Data Analytics Process., The data need to be in the format that can interpret or readable by Business Intelligent Software.
Normally Data Preparation and Data model has cover;
▪ Cleansing
▪ Transforming
▪ Adjust type of data
▪ Modeling
In MonsoonSIM, some type of data need to be Cleaned, Transformed, Adjust to correct type of data. This is an opportunity to learn this step. BTW most of data already in readable format (Unpivot data) which easier to visualize them.
51
Sample of Data in MonsoonSIM after exporting
Most of exporting data in MonsoonSIM since version 8.x (Feb 2020) already in ‘Unpivot form’ which can be read in most of data analytics software. BTW, Learner need to recheck for data readiness to be used for next step
52
TIPs: Edit Data in Excel may help you to prepare data fasterOnce you have download data in CSV or excel format., If learner have an experience to clean, transform, change type or format or etc. may help you to prepare data faster. BTW, Edit Queries in Power BI also have this ability. You can choose to use excel or power queries base on your way.
What we can prepare data in Excel; ▪ Convert spread sheet to be Table Data by select all and Press CTRL+L or CTRL+T
▪ Change Table name, Column name
▪ Entering some Data which no have or create new column and put the related formula in
▪ Change data format / Data type
▪ Remove empty row
▪ Fill in the data in blank field
▪ Etc.
53
TIPS: Convert file in Excel to be Dynamic Table format
54
• Open CSV file in Excel, Choose the Data Range and Press CTRL+L
• The table will be format as data Table; I had called “Dynamic Table Format”
• Note: This process is not compulsory.
(1a) How to ‘Get Data’ in Power BI
55
or
Basic Power BI; Understanding interfaceLearner can study more from many YouTube and Website for any 3rd Party BI as you are need to use.
56
Report View;
to build dashboard
Data View;
to manage/process
the data
Model View;
to model the data,
Relationship of data
Fields,
Data and element
which you Get Data to
Power BI; Data Base
Can be single
database or multiple
data base
Visualization,
Many type of graph to be used
in Dashboard and Axis of
Data. Must select data to be
visualize properly., if not the
dashboard will not show
Filter,
to filter data to show
as dashboard
(2a) Processing data by using ‘Edit Queries’
57
To be noted that, Power BI has feature which called ‘Edit Queries’ to prepare and processed the data
to be ready to use. BTW, for those who can use Excel, You can also prepare the data in Excel instead of
using this feature
Choose Data View;
You will see the table of
date which you have loaded
into Power BI
Choose Edit Queries,
to manage your data to be
ready for next step
Note: The following sample after this section will only cover the data which come from MonsoonSIM to prepare data to be used for Visualize step.
Some problem, may happen after you processed and cancel the previous action in Power BI., some error will happen.
BTW, they are more problems regarding to data base will you import into any BI software. For example▪ different style of locale which different in each software or
keyed in data; DD-MM-YYYY or MM-DD-YY, etc.
▪ Like Year in Buddhism year and Christianity year
▪ Data format like Entering name of Province; กทม., ก.ท.ม., กรงุเทพฯ, กรงุเทพมหานคร or Mobile number patter etc
▪ When have many data source, the column name will vary like ต าบล หรอื แขวง, เขต หรอื อ าเภอ
▪ Have special alphabet
58
Problems which always found in Data preparation; Type of Data
59
Some data will not be proper type of data,
STEP: Data View >> Edit Queries >> Choose Table Top Role >> Right Click >> Change Data Type
Problems which always found in Data preparation; Remove Top roles
60
If the Top roles didn’t be Colum name., You are need to remove the top roles
STEP: Data View >> Edit Queries >> Remove Role >> Remove top Role >> Put Number of row to be removed
Problems which always found in Data preparation; Empty Value in table cellPower BI will not work properly if the data filed has blank. The exported data from MonsoonSIM will only have data when transaction has been performed. For example, the data of selling., will only be recorded when the sales has completed. Like a first few days in Retail which the procurement goods not ready, will have no record in that day. = empty sales record in those day.
61
Note for Edit Queries➢ Make sure that data is ready in format, value type etc. Before go to next step.
➢ The 1st row of data, column name is very important in next step; Data modeling
➢ If you can make “one single truth of source” will help. If not, at least column name which related as reference data source must be the same
➢ each users can use different technique base on practice, try and error correction. As long as you can prepare data with many technique and structure and able to ‘empower data’, any technique will be acceptable.
62
(3a) Modeling the data (Sync the relevant data from multiple sources)
63
Normally, Power BI will be modelling
the data if all the sources has same
Column name. When you click on
model view.
For example, You will see 5 sources of
data which have connect line to like
relevant data. For this case is “Day as
time series”
If the data in different didn’t link
automatically, you will need to do
manual link hem together.
Once the data is ready, modeling has
proper link. You can go for next step
to data visualization.
Data Visualization
Concept: Easier way to understand Set of Data in Graph / Visual format
64
https://en.wikipedia.org/wiki/Data_visualization
Sample of CSV Data and use with Power BI by Dr.Thanachart Ritbumrung, NIDA
65
Basic questions about bring data to visualizeThis step need to be clarified before any step. There are like communication theory. You may need to
‘5WXH’ for all the question will you need to lets data tells you about and way to answer to make
everyone understand in Data Visualization.
•List set of business questions that need to be communicate for specific purpose
5WXH
•Export, process data, model them
•Choose the related data to be visualized
Prepare Data •Specific type of communication; comparison, composition, relationship, Distribution
•Using graph and format to be visualized
Communicate purpose
•Make sure that your target audience will understand your dashboard
•Live/Static in which channel which device
Visualize them
Sample of 5WXH over Data Visualization
66
Who
Why
What
When
Where
How
5WXH in Data Visualization
• To understand what
business questions will
they need for decision
• How the data important
to their decision and
action
• To able to select the data
to be processed and able
to describe, diagnose,
predict, prevent• How accurate in time dimension
effect to decision
• Realtime Analyze or Scheduled
Analyze
• How often which data should be
retrieved
• Where to get/find data from
Business department/ Business
Process
• Which database was kept in the
system
• How to get permission to access
the database
• What format / layout to
be used to visualize
• What technique to
process and model the
data
Sample 5WXH over Data Visualization
67
High Level Management
Mid level Management
Head of Department
Operation Staff
For important &
Strategic decision making
To mange to meet Business Goals with progress
Maintain quality of work with lowest cost & highly outcome
Able to take responsibility in job roles and leverage skills
In some industry may need REAL TIME Data
Often update Data
Depends on cycle of measurement which vary
from industry
Base in level of roles/Business cycle
Who Why & What WhenRelationship of integrated
factors which effect to business
Composition & Comparison for strategic planning
Distribution type in operation dashboard
Individual / department KPI
What & How
Trend and Indicator
Composition & Comparison for strategic planning
Distribution type in operation dashboard
Indicator and Details
Layout
Visualizing Tips:
68
• Choose type of graph/dashboard match to audience’s need
• Cleary Visualize and layout, understand by 5-7 seconds
▪Indicator
▪Trends
▪Details
• Prepare slicer or filter of data which can provide relationship of
various factors to Business answer
Let's start to bring data to be visuality
69
Report View;
to build
dashboard
The Data
source
which
already
loaded,
cleaned,
transformed
and
modelled Choose the visualization
style match to your
objective
Each one will have
different data to be used
and plot for graph
Filter it tools to help to
limit the range of data to
be showed in dashboard
Choose the proper visualization style match to your objectives
Link to learn more:
▪https://softcrylic.com/blogs/data-visualization-with-powerbi/
▪https://docs.microsoft.com/th-th/power-bi/visuals/power-bi-visualization-types-for-reports-and-q-and-a
▪https://www.9experttraining.com/articles/visualization-%E0%B9%83%E0%B8%99-power-bi-desktop
70
Chart Suggestion
71
Content in Dashboard (Data Visualization)
▪ Comparison
72
▪ Distribution ▪ Composition
▪ Relationship
References
73
Data Base
database is an organized collection of data
74
https://en.wikipedia.org/wiki/Database
Data Warehousing
75
https://en.wikipedia.org/wiki/Data_warehouse
76
https://emap.wordpress.com/2016/02/26/geospatialdata-science/