Agile Scrum Workflow

Scrum is one of the Agile framework:

1 User story and refinement:

Input from executives, team, stakeholders, customers

2 Product Backlog:

Ranked list of what is required: features, stories

3 Sprint Planning Meeting:

Team selects starting at stop as much as it can commit to deliver by end of sprint

4 Sprint Backlog: Task breakout

5 Stand-up meeting: daily discussion between team members

6 Sprint end date and team deliverable do not change

7 Sprint review, finished work and sprint retrospective

If you are interested in or have any problems with Agile or Business Intelligence, feel free to contact me.

Or you can connect with me through my LinkedIn.

Why Communication is So Important In IT Industry?

Many people have an impression on IT developers: Coding all the time.

Actually, it is a stereotype. In IT Industry, developers spend more time on communication rather than computers.

So, if you want to become an IT professional, you need to be good at communication.

Even you more enjoy coding.

Think about how much time you will spend on interacting with others?

  1. Check the email box…
  2. Agile Scrum Meeting…
  3. Communicate with colleagues about the needs…

How we can improve our communication?

1 Don’t judge or criticize

People are good at putting themselves in the centre. Everyone think himself/herself is the most important.

It is wrong and we can’t belittle others.

We should respect them firstly and then others will accept our opinion.

2 Think what others need

The key in communication is not think our own interests, like what I need and what I want.

Instead, we should consider what others need and what they want.

Why they want this function?…

Why this part makes them feel bored?…

3 Avoid fighting

As IT developers, sometimes we are easy to think others will accept the logical thinking.

Actually, most people are sensitive and follow their feelings.

From a book (How to Win Friends and Influence People) written by Dale Carnegie, the only way to solve the fighting is to avoid it.

If you never think about how to communicate with others, this is the right time!

Improve the ability of soft skills, and you will find it is valuable for your life.

People will like you and value you back.

From my BI journey, I learn more about soft skills, English at work and tech chit chats.If you are interested in or have any problems with BI, feel free to contact me .

Or you can connect with me through my LinkedIn.

Some Cheat Sheets about Business Intelligence

There are several parts of my Business Intelligence journey.

So I write this blog for recording some cheat sheets.


Firstly, some tools need to be installed on the laptop.

All of them are Microsoft softwares, so I prepare a surface laptop 2.

  1. SQL Server 2016 Developer Edition: Seclect the features we need to install, such as SQL Server Integration Services(SSIS), SQL Server Analysis Services(SSAS) and SQL Server Reporting Services(SSRS).
  2. SQL Server Management Studio(SSMS)
  3. SQL Server Data Tools(SSDT)
  4. Report Builder

What is Business Intelligence(BI)?

I have mentioned it in the previous blog. It is to transform raw data into meaningful information for analysis.

BI Process:

  1. Import data from different data sources
  2. Produce reports or graghs through SSIS, SSAS and SSRS
  3. Make business decisions

Some terms:

ETL: Extraction, Transformation and Loading

OLTP: Online Transaction Processing

Cube: Multi-dimensional data structure built using dimensions and facts, using MDX (Multi dimensional expression) language

SQL and Relational Database: which I have mentioned them in the previous blog

Primary Key: A single attribute or an unique id in a Relational Database

Foreign Key: A set of attributes that references a candidate key in a Relational Database

Some differences:

Traditional Normalized Database VS Data Warehouse: Formal one has no duplicate data but latter one has duplicate data for efficiency.

Null VS Blank(where clause): For null, the clause is where xxxxx is null; For blank, the clause is where xxxxx is ”

Delete VS truncate: truncate table xxxxx ->no rollback&faster; delete from xxxxx -> rollback

SQL Language:

Learning sources:

  2. SQL Server tutorial for beginner

Some common commands:

One table:




Two tables:

Inner Join

Other Joins, e.g., LEFT OUTER JOIN


If you are interested in or have any problems with Business Intellgence, feel free to contact me .

Or you can connect with me through my LinkedIn.

What is the Difference between Business Analysis, Data Analysis and Data Science?

The terms and job titles in the data field are extraordinarily large, such as business analysis, data analysis, data science, etc.

They often stun everyone, so this article we will talk about all of them, especially the differences.

Business Analysis VS Data Analysis

Generally, data analysis means that using data to analyse a XXX problem. The pipeline includes data collecting, data warehousing, data cleaning, data visualisation, etc.

As we can see, there is a blank in the sentence.

Actually, data analysis can be applied to different areas, and that is also the meaning of ‘XXX’ .

It can be academic or commercial.

If ‘XXX’ is commercial, then data analysis will equal to business analysis. In other words, the business analysis is an application of data analysis.

There is a main difference between data analysis and business analysis, which is the data sources.

The data source of data analysis positions is often based on the company websites, Apps, ERP system, etc.

And those job descriptions will require candidates master SQL, Python or R.

However, the data collected from those platforms often exists several problems, mainly the data quality, such as some missing data or data noise.

Those are caused by weak IT infrastructures and ‘econnoisseurs’ who want to register more user accounts.

However, the data sources of business analysis positions not just include those internal data collected by companies but also include a large amount of external sources. For example:

  1. Industry studies
  2. Qualitative interviews
  3. Quantitative interviews
  4. Internal data

Business Analysis VS Data Science

Because of Alpha Go, Artificial Intelligence is well-known to everyone.

However, the successful area of AI is not related to data analysis.

They focus on the computer vision and natural language processing, and their industrial applications are mainly in security and supply chain.

However, the usage of algorithms in commercial industry is limited because some departments in the company are hard to be represented by data and algorithm models.

This causes that algorithm can only solve the specific problems.

  1. Firstly, algorithm is related to users directly. The famous example is risk control. Because the factors contributing to the user credits are easy to be built by an algorithm model, commonly logistic regression.
  2. Secondly, forecasting algorithms. Business Intelligence is highly required to do forecasting.
  3. Thirdly, dimensionality reduction algorithms. It is often to reduce dimensions so it is easy to evaluate a problem, such as new products.


In summary, algorithms are useful in business intelligence, however, it cannot replace it.

Business Intelligence is an application in commercial problems and algorithm models are tools to solve specific problems.

If you are interested in or have any problems with Business Intellgence, feel free to contact me .

Or you can connect with me through my LinkedIn.

Why Do People Think Enter X Challenge Innovation Competition is a Good Idea?

Except some IT competitions, I also enter X Challenge Innovation Competition in university.

X Challenge is a competition that gives every AUT student the opportunity and guidance to develop an idea for a business, cause or project. 

Each student can experience how to launch and run a business, which starts from an innovative idea. 

It consists of two stages: The Idea and The Accelerator.

You can enter either one or both, as an individual or as a team. When entering as a team at least one member must be a current AUT student.

I enter The Idea.

Next is my milestones for X Challenge:

01/04/2019: Gather my team.

Choosing a partner who matches the marketing and business ability that I lack will shape the future of the business more than any other.

In this stage, I choose Mia Lu.

She is a marketing and multi-media specialist who holds a double major in Marketing and Economics, with 4+ years of experience in digital marketing and communications. Except the marketing professional ability, design is also her passion and speciality, i.e., graphic design and UX design.

More important, she is an amazing women with high execution and communication skills.

07/04/2019: Decide what we want to build. Brainstorming something the world needs and all the members agreed on the idea.

Finally, our idea is Named Entity Recognition as a Service.

Here is the rationale of our idea. This tool can prevent privacy information leakage for individual Online Social Networks users.

It mainly involves in Deep Learning and Natural Language Processing techniques.

17/04/2019: Demonstrate that people want your product and figure out how to scale. We celebrate once 300 people who are not our friends and family tell us that using our product was useful.

25/04/2019: Submit the Google form to AUT. The form consists of one-page idea, including the problem we solve, our product advantages, markets and customers, direct or indirect competitors and team member description.

01/05/2019: Our team is chosen as a winner of The Idea.

My feelings:

Through the innovation competition, I realise how to change a technical idea to a business product.

And I realise how to act as a leader, especially collaborating with other team member.

Team support is the key to success!

If you are interested in or have any problems with business plan or competitions, feel free to contact me .

Or you can connect with me through my LinkedIn.