fbpx

Tech On Fire

Data Analysis by Business Intelligence for SME

Master Power BI for a data-driven marketing strategy

By 2025, the amount of newly created data worldwide will exceed 160ZB which is ten times that of 2016!

Why Data-driven?

With the rapid development of the Internet, Big Data has become the buzzword. It is often mentioned in IT, finance, retail, and government services, putting a spotlight on digital marketing and e-commerce. The rise of search engines and social media has also led to an increase of data available, making it easier to collect consumer information. Many large companies will consolidate the data as a database to make it more efficient to understand consumer preferences and adjust market strategies.

Regardless of company size, as long as an enterprise can extract appropriate data and analyze them, they can transform the data into information with commercial value, reduce costs and investment risks, improve the efficiency of decision-making, and even understand competitors’ strategies. Making data-driven business decisions is the key to success.

Pain Points We Solved

Even when it is easier to collect data, how can businesses sieve through the large amount of data and select the most critical data for analysis and prediction? Some SMEs can only rely on the traditional marketing model and make speculations based on experience and market sense. However, the lack of systematic data analysis makes it easy to ignore market changes and increase investment risks.

As a solution, business intelligence emerged. Through the integration of business information through data analysis tools, data is transformed into easy-to-understand visual reports. With the addition of data mining and data forecasting technologies, companies can come up with faster and more cost-effective solutions and make profitable business decisions based on the content.

Programme Highlights

This course is tailored for SMEs. The instructor will teach learners professional knowledge and skills in business intelligence, data management and analysis.  By learning and applying Power BI in business, learners can integrate and visualize data more efficiently, thereby reviewing past business results and predicting future market trends.

Power BI is a free tool developed by Microsoft as part of Office 365. In recent years, it has become the most popular self-serviced business intelligence tool for enterprises. Because its operating interface is simple and easy to learn and use, and there is no need for programming, it is different from the traditional BI where professional IT department or data analyst are required to operate them. This free and self-serviced BI truly makes data analysis “popular”, allowing SMEs to apply big data analysis technology to their daily business.

Tech on Fire Testimonial

Technology Applied

Students can instantly apply the latest social media marketing knowledge to real life work

Technical skills unlock :

  • Business Intelligence
  • E-commerce
  • Digital transformation
  • Data management
  • Data Analysis using Power BI
  • Digital Social Media
  • Data mining and visualization
  • Digital record-keeping

Curriculum

Module 1: Introduction to Power BI

Learning hours: 1 lesson, 3 hours in total

This module will first introduce the basic concepts of big data analysis to the learners. The instructor will explain the basic knowledge of business intelligence and the skills to operate the Power BI software.

• What is Business intelligence?
• Basic concepts of big data, analytics and applications
• Common methodology and terminology
• Overview and considerations for self-service BI
• Becoming a data-driven company
• Introduction to Power BI Desktop: Report, Data & Model
• Power BI in action (case sharing)

After taking this module, learners will be able to understand how data-driven thinking can improve corporate decision-making efficiency.

Module 2: Data integration and transformation

Learning hours: 1 lessons, 3 hours in total
 
This module will teach learners to use the dashboard function of Power BI to collect and integrate data from different data sources, and transform the data with the Power Query Editor.
 
Module content:
• Using Power BI dashboard
• Connecting to different data sources – File, Database, Online Services and more
• Power Query Editor overview
• Data preparation
• Data types
• Data shaping and combining
• Data trimming and cleaning
• Data integration to Power BI
• In-class exercise: Transform data using datasets provided by the instructor
 
There is an in-class exercise for this module and learners will have an opportunity to practice data transformation with guidance.

Module 3: Data Analysis Strategies

Learning hours: 1 lessons, 3 hours in total
 
This module will cover the principles and methods of data analysis, teach learners to build more insightful data models, use data analysis algorithms (DAX), and analyze related data through BI to make business predictions and decisions.
 
Module content:
• Introduction to Data Analysis
• Analysis with BI – Descriptive, Diagnostic, Predictive &Prescriptive
• Data modelling
• Data Analysis Expression(DAX)  basics
• Data relationship
• Calculation and measure
• Data model optimization
• What-if analysis: making projections
• Monitoring, exploration and decision making
• In-class exercise: data-modelling and analysing sample data provided by instructor
 
There is an in-class exercise for this module and the instructor will provide sample data for learners to use in BI data analysis.

Module 4: From Data to Visualisation

Learning hours: 1 lesson, 3 hours in total
 
In this module, learners will learn to visualize data and organize them into a user-friendly and shareable chart.  The instructor will also introduce the mobile version and the upgraded version of Power BI so that learners can master the higher-level technologies and functions.
 
Module content:
• Customize dashboard design
• Create visuals, power automate visuals
• Create, collaborate and share report
• Power BI Report Builder and Server
• Use of Power BI mobile app
• Power BI Desktop monthly updates and new features
• Power BI Pro or Premium Per User (PPU) licence
• Data protection
• In-class exercise: Creating visuals with sample data
 
After completing this module, learners can create dashboards and tables by themselves to for cost-effective data analysis.

Learning Outcome

Build your own Dashboard

Build your own Dashboard
Learners can use the Power BI dashboard for data visualization and promptly analyse key data.

Strengthen data analysis on Excel

Learners can make use of Excel data, assign relationships and make data-driven business decisions.

“A few months ago, I joined a new company where the boss wanted to conduct data analysis using business intelligence to replace the traditional marketing model. However, the company is a small enterprise and employees have no experience in using relevant analysis software.  After one round of data collection, they chose to enrol in this course.

This course allowed us to understand the changes in marketing models in recent years, and that the use of data to promote online marketing has gradually become the mainstream. Compared with the traditional methods of relying on annual marketing charts, business intelligence makes planning more flexible and enables quicker adjustments to market strategies. The Power BI software has a simple operation interface and is easier for beginners. Even if you have not taken statistics and IT related courses in the past, you can still use it with ease.  It also saves time from converting data to charts on excel. Now I can perform data-oriented analytical thinking, observe the development patterns of different industries and apply the skills to daily operations.”

Johnny Lam
In-house Marketer

Our Instructors

Our instructors have been working in the IT industry for years with a wealth of teaching experience. They compile the program curriculum and customize the scope and content of the program to cater for different corporate needs, target to technologically upskill corporate staff and improve operation efficiency in a short time. In addition to newest information technology sharing, instructors will also study real life cases with students.

Social Media Marketing Bootcamp

Creamy Lam

Instructor
Ex-JobsDB

A real-life case of an online pet shop: Data-oriented reform in marketing for enhanced insights!

This online pet shop has been in business for two years. In the past, it has been advertising on social media to attract new customers. However, the results have been mediocre, and the business revenue was not stable. For long-term business development, the shop owner decided to enrol in this course, hoping to learn the application of data, and seek a change in the business model.

After completing this course, the store owner learned about consumption patterns and habits through Power BI analysis, and discovered the cause of the high customer churn rate in the past.  They immediately adjusted the marketing strategy to improve the customer shopping experience.  In addition, they learned to use reports to analyze customer traffic, improve webpage layout according to visitors’ browsing preferences, place products with higher click-through rates on the homepage, and analyze related data between the products. In two months, sales have risen by 25%, and there has been steady growth ever since, expanding the scale of online stores.

Information at a glance

Course NameData Analysis by Business Intelligence for SME
Course CodeBI
Course Duration12 hours
Learning ModeFace to Face / Online
Class Size10
Medium of InstructionCantonese with English Terms
FundingThis course has been approved by RTTP scheme for up to 2/3 subsidy

Frequently Asked Questions

Can the Power BI software be used on mobile phones?

Yes, it can be installed on IOS, Android, Windows 10 mobile and tablet computers, so you can view business data anytime, anywhere.

What is the relationship between Power BI and Excel?

Power BI Desktop is developed on the basis of Excel, and integrates the latter’s Power Query, Power Pivot, Power View, and Power Map plug-ins, which can be  originated from different data sources.

What industries are Power BI suitable for?

Power BI is actually suitable for people from all walks of life. Its biggest advantage lies in its easy-to-use operation, allowing users who lack technical background to master data analysis and visualization functions.