M\u1ed9t sinh vi\u00ean n\u0103m th\u1ee9 hai vi\u1ebft cho t\u00f4i: \u201cEm h\u1ecdc Qu\u1ea3n l\u00ed h\u1ec7 th\u00f4ng tin v\u00e0 quan t\u00e2m t\u1edbi khu v\u1ef1c trinh s\u00e1t doanh nghi\u1ec7p. Em c\u1ea7m k\u0129 n\u0103ng n\u00e0o v\u00e0 tri\u1ec3n v\u1ecdng vi\u1ec7c l\u00e0m l\u00e0 g\u00ec cho ngh\u1ec1 n\u00e0y? Xin th\u1ea7y gi\u00fap cho.”<\/p>\n
<\/p>\n
\u0110\u00e1p: Ng\u00e0y nay m\u1ecdi c\u00f4ng ti \u0111\u1ec1u t\u1ea1o ra v\u00e0 thu th\u1eadp nhi\u1ec1u d\u1eef li\u1ec7u nh\u01b0 d\u1eef li\u1ec7u b\u00e1n, d\u1eef li\u1ec7u mua, d\u1eef li\u1ec7u l\u1ee3i nhu\u1eadn, d\u1eef li\u1ec7u t\u1ed5n th\u1ea5t, d\u1eef li\u1ec7u kh\u00e1ch h\u00e0ng, d\u1eef li\u1ec7u c\u00f4ng nh\u00e2n, d\u1eef li\u1ec7u n\u0103ng su\u1ea5t, d\u1eef li\u1ec7u v\u1ec1 \u0111\u1ed1i th\u1ee7 c\u1ea1nh tranh, d\u1eef li\u1ec7u th\u1ecb tr\u01b0\u1eddng v.v. T\u1eeb t\u1ea5t c\u1ea3 c\u00e1c ki\u1ec3u d\u1eef li\u1ec7u kh\u00e1c nhau n\u00e0y, ng\u01b0\u1eddi qu\u1ea3n l\u00ed v\u00e0 ng\u01b0\u1eddi ph\u00e2n t\u00edch ph\u1ea3i t\u1ed5 ch\u1ee9c ch\u00fang th\u00e0nh nh\u1eefng th\u00f4ng tin n\u00e0o \u0111\u00f3 \u0111\u1ec3 cung c\u1ea5p cho ng\u01b0\u1eddi \u0111i\u1ec1u h\u00e0nh hay ng\u01b0\u1eddi ch\u1ee7 c\u00f4ng ti l\u00e0m quy\u1ebft \u0111\u1ecbnh. D\u00f9ng nh\u1eefng th\u00f4ng tin n\u00e0y, ng\u01b0\u1eddi \u0111i\u1ec1u h\u00e0nh v\u00e0 ng\u01b0\u1eddi ch\u1ee7 c\u00f4ng ti c\u00f3 th\u1ec3 \u0111o \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 kinh doanh c\u1ee7a c\u00f4ng ti c\u1ee7a h\u1ecd, bi\u1ebft n\u00f3 v\u1eadn h\u00e0nh t\u1ed1t th\u1ebf n\u00e0o, hay l\u1eadp k\u1ebf ho\u1ea1ch cho t\u01b0\u01a1ng lai c\u1ee7a c\u00f4ng ti. Qu\u00e1 tr\u00ecnh thu th\u1eadp, t\u1ed5 ch\u1ee9c, ph\u00e2n t\u00edch v\u00e0 bi\u1ebfn nh\u1eefng d\u1eef li\u1ec7u n\u00e0y th\u00e0nh th\u00f4ng tin d\u00f9ng \u0111\u01b0\u1ee3c \u0111\u01b0\u1ee3c g\u1ecdi l\u00e0 Trinh s\u00e1t doanh nghi\u1ec7p – Business Intelligence (BI).<\/p>\n
Trinh s\u00e1t doanh nghi\u1ec7p l\u00e0 m\u1ed9t trong nh\u1eefng vi\u1ec7c l\u00e0m t\u0103ng tr\u01b0\u1edfng nhanh nh\u1ea5t trong c\u00f4ng nghi\u1ec7p ng\u00e0y nay v\u00e0 nhu c\u1ea7u v\u1ec1 c\u00e1c chuy\u00ean gia n\u00e0y ti\u1ebfp \u00a0t\u1ee5c d\u00e2ng l\u00ean v\u00ec c\u00f3 nhi\u1ec1u nhu c\u1ea7u nh\u01b0ng \u00edt cung c\u1ea5p v\u1ec1 ng\u01b0\u1eddi c\u00f3 k\u0129 n\u0103ng n\u00e0y. V\u1ec1 c\u0103n b\u1ea3n vi\u1ec7c l\u00e0m trong BI bao g\u1ed3m ba ki\u1ec3u: K\u0129 ngh\u1ec7 d\u1eef li\u1ec7u, Nh\u00e0 kho d\u1eef li\u1ec7u v\u00e0 Ph\u00e2n t\u00edch d\u1eef li\u1ec7u.<\/p>\n
Vai tr\u00f2 c\u1ee7a k\u0129 s\u01b0 d\u1eef li\u1ec7u l\u00e0 l\u00e0m vi\u1ec7c c\u00f9ng ph\u1ea7n doanh nghi\u1ec7p c\u1ee7a c\u00f4ng ti \u0111\u1ec3 thu th\u1eadp y\u00eau c\u1ea7u ph\u1ea3i \u0111\u01b0\u1ee3c \u0111\u00e1p \u1ee9ng r\u1ed3i vi\u1ebft \u0111\u1eb7t t\u1ea3 ch\u1ee9c n\u0103ng cho t\u1ed5 k\u0129 thu\u1eadt d\u00f9ng \u0111\u1ec3 thi\u1ebft k\u1ebf v\u00e0 x\u00e2y d\u1ef1ng c\u00e1c gi\u1ea3i ph\u00e1p c\u1ea7n thi\u1ebft. K\u0129 s\u01b0 d\u1eef li\u1ec7u x\u00e1c \u0111\u1ecbnh v\u00e0 t\u1ed5 ch\u1ee9c d\u1eef li\u1ec7u c\u1ea7n \u0111\u01b0\u1ee3c thu th\u1eadp c\u0169ng nh\u01b0 d\u1ea1ng th\u1ee9c c\u1ee7a ch\u00fang.<\/p>\n
Vai tr\u00f2 c\u1ee7a chuy\u00ean vi\u00ean Nh\u00e0 kho d\u1eef li\u1ec7u bao g\u1ed3m trong vi\u1ec7c x\u00e2y d\u1ef1ng, l\u01b0u gi\u1eef, thu th\u1eadp, duy tr\u00ec v\u00e0 qu\u1ea3n l\u00ed c\u00e1c c\u1ea5u tr\u00fac d\u1eef li\u1ec7u v\u00e0 c\u01a1 s\u1edf d\u1eef li\u1ec7u. C\u00f3 hai vai tr\u00f2 con b\u00ean trong nh\u00f3m Nh\u00e0 kho d\u1eef li\u1ec7u: Ki\u1ebfn tr\u00fac s\u01b0 d\u1eef li\u1ec7u, ng\u01b0\u1eddi thi\u1ebft k\u1ebf c\u1ea3 c\u1ea5u tr\u00fac quan h\u1ec7 v\u00e0 \u0111a chi\u1ec1u \u0111\u1ec3 ho\u00e0n th\u00e0nh m\u1ee5c \u0111\u00edch \u0111\u01b0\u1ee3c \u0111\u1eb7t ra trong \u0111\u1eb7c t\u1ea3 k\u0129 thu\u1eadt. Ng\u01b0\u1eddi l\u00e0m m\u00f4 h\u00ecnh d\u1eef li\u1ec7u ph\u00e1t tri\u1ec3n c\u00e1c thu\u1eadt to\u00e1n v\u00e0 m\u00f4 h\u00ecnh \u0111\u1ec3 tr\u00edch d\u1eef li\u1ec7u t\u1eeb c\u00e1c ngu\u1ed3n kh\u00e1c nhau, bi\u1ebfn \u0111\u1ed5i n\u00f3 th\u00e0nh d\u1ea1ng mong mu\u1ed1n, v\u00e0 n\u1ea1p n\u00f3 v\u00e0o trong nh\u00e0 kho d\u1eef li\u1ec7u.<\/p>\n
Vai tr\u00f2 c\u1ee7a ng\u01b0\u1eddi Ph\u00e2n t\u00edch d\u1eef li\u1ec7u l\u00e0 ph\u00e2n t\u00edch, l\u1ef1a ch\u1ecdn v\u00e0 bi\u1ebfn \u0111\u1ed5i d\u1eef li\u1ec7u th\u00e0nh th\u00f4ng tin h\u1eefu d\u1ee5ng cho ph\u00e9p ng\u01b0\u1eddi \u0111i\u1ec1u h\u00e0nh v\u00e0 ng\u01b0\u1eddi ch\u1ee7 c\u00f4ng ti hi\u1ec3u th\u00f4ng tin n\u00e0y v\u00e0 \u0111\u1eb7t m\u1ecdi th\u1ee9 v\u00e0o trong ho\u00e0n c\u1ea3nh. Ng\u01b0\u1eddi ph\u00e2n t\u00edch d\u1eef li\u1ec7u l\u00e0m vi\u1ec7c c\u00f9ng v\u1edbi nh\u1eefng ng\u01b0\u1eddi ph\u00e2n t\u00edch kh\u00e1c v\u00e0 chuy\u00ean gia mi\u1ec1n \u0111\u1ec3 t\u1ea1o ra b\u1ea3ng \u0111i\u1ec1u khi\u1ec3n, th\u1ebb \u0111i\u1ec3m v\u00e0 b\u00e1o c\u00e1o t\u1eeb nh\u00e0 kho d\u1eef li\u1ec7u.<\/p>\n
Ng\u00e0y nay ph\u1ea7n l\u1edbn c\u00e1c h\u1ec7 th\u1ed1ng BI \u0111ang d\u00f9ng c\u00e1c s\u1ea3n ph\u1ea9m ph\u1ea7n m\u1ec1m t\u1eeb c\u00e1c c\u00f4ng ti nh\u01b0 Oracle, SAP, IBM v\u00e0 Microsoft. V\u1edbi ngh\u1ec1 trong Trinh s\u00e1t doanh nghi\u1ec7p, b\u1ea1n s\u1ebd c\u1ea7n \u00edt nh\u1ea5t l\u00e0 b\u1eb1ng c\u1eed nh\u00e2n trong khoa h\u1ecdc m\u00e1y t\u00ednh, k\u0129 ngh\u1ec7 ph\u1ea7n m\u1ec1m hay qu\u1ea3n l\u00ed h\u1ec7 th\u00f4ng tin. K\u0129 s\u01b0 d\u1eef li\u1ec7u ph\u1ea3i c\u00f3 tri th\u1ee9c v\u1ec1 c\u00e1ch khu v\u1ef1c doanh nghi\u1ec7p l\u00e0m vi\u1ec7c v\u00e0 c\u00f3 k\u0129 n\u0103ng v\u1eefng trong qui tr\u00ecnh k\u0129 ngh\u1ec7 y\u00eau c\u1ea7u. Chuy\u00ean vi\u00ean Nh\u00e0 kho d\u1eef li\u1ec7u ph\u1ea3i c\u00f3 s\u1ef1 th\u00e0nh th\u1ea1o trong SQL v\u00e0 c\u00f4ng ngh\u1ec7 c\u01a1 s\u1edf d\u1eef li\u1ec7u quan h\u1ec7 c\u0169ng nh\u01b0 c\u00f4ng ngh\u1ec7 c\u01a1 s\u1edf d\u1eef li\u1ec7u \u0111a chi\u1ec1u. H\u1ecd c\u0169ng ph\u1ea3i c\u00f3 tri th\u1ee9c v\u1ec1 c\u00e1c th\u1ee7 t\u1ee5c m\u00f4 h\u00ecnh ho\u00e1 d\u1eef li\u1ec7u v\u00e0 k\u1ebf to\u00e1n t\u00e0i ch\u00ednh v\u00e0 c\u00e1c nguy\u00ean l\u00ed thi\u1ebft k\u1ebf nh\u00e0 kho d\u1eef li\u1ec7u, c\u00e1c th\u1ed1ng k\u1ebf v\u00e0 c\u00e1c chu\u1ea9n. Chuy\u00ean vi\u00ean ph\u00e2n t\u00edch d\u1eef li\u1ec7u ph\u1ea3i c\u00f3 tri th\u1ee9c v\u1ec1 hi\u1ec3u bi\u1ebft ph\u00e2n t\u00edch d\u1eef li\u1ec7u v\u00e0 c\u00e1c k\u0129 thu\u1eadt b\u00e1o c\u00e1o. H\u1ecd ph\u1ea3i hi\u1ec3u c\u00e1c gi\u1ea3i ph\u00e1p b\u00e0n \u0111i\u1ec1u khi\u1ec3n trinh s\u00e1t doanh nghi\u1ec7p, c\u00f3 kinh nghi\u1ec7m ph\u00e1t tri\u1ec3n c\u00e1c \u0110\u1ed1i t\u01b0\u1ee3ng doanh nghi\u1ec7p v\u00e0 c\u00e1c b\u00e1o c\u00e1o doanh nghi\u1ec7p vi\u1ebft ra. B\u00ean c\u1ea1nh c\u00e1c k\u0129 n\u0103ng k\u0129 thu\u1eadt h\u1ecd ph\u1ea3i c\u00f3 k\u0129 n\u0103ng trao \u0111\u1ed5i n\u00f3i v\u00e0 vi\u1ebft gi\u1ecfi, k\u1ec3 c\u1ea3 tr\u00ecnh b\u00e0y. Ph\u1ea7n l\u1edbn m\u1ecdi ng\u01b0\u1eddi l\u00e0m vi\u1ec7c trong BI \u0111\u1ec1u xu\u1ea5t th\u00e2n t\u1eeb ch\u01b0\u01a1ng tr\u00ecnh Qu\u1ea3n l\u00ed h\u1ec7 th\u00f4ng tin nh\u01b0ng m\u1ed9t s\u1ed1 ng\u01b0\u1eddi c\u0169ng t\u1edbi t\u1eeb khoa h\u1ecdc m\u00e1y t\u00ednh v\u00e0 k\u0129 ngh\u1ec7 ph\u1ea7n m\u1ec1m.<\/p>\n
<\/p>\n
—English version—<\/p>\n
<\/p>\n
Business Intelligence Careers<\/p>\n
A second year student wrote to me: \u201cI study Information System Management and interest in business intelligence area. What skills do I need and what is the job prospect for this career? Please help.”<\/p>\n
<\/p>\n
Answer: Today every company produces and collects a lot of data such as sales data, purchases data, revenues data, profits data, lost data, customer\u2019s data, workers data, productivity data, competitor\u2019s data, market data etc. From all these different types of data, managers and analysts must organize them into certain information to provide to the executives or company owners to make decisions. Using these information, executives and company owners can measure the business results of their company, knowing how well it operates, or plan for the future of the company. The process of collect, organize, analyze and turn these data into usable information is called Business Intelligence (BI).<\/p>\n
Business Intelligence is one of the fastest growing jobs in the industry today and demand for these specialists continues to rise as there is more demand but fewer supplies of people who have this skills. Basically jobs in BI consist of three types: Data Engineering, Data warehouse and Data analytics.<\/p>\n
The role of Data engineer is to work with the business part of the company to gather the requirements that must be met then write functional specifications for the technical team uses to design and construct necessary solutions. Data engineer define and organize the data to be collected as well their formats.<\/p>\n
The role of Data warehouse specialists is involved in building, storing, collecting, maintaining and managing data structures and databases. There are two sub-roles within the Data warehouse group: Data architects who design both relational and multidimensional structures to accomplish the goals set out in the technical specification. Data modelers develop algorithms and models to extract data from different sources, transform it into the desired format, and load it into the data warehouse.<\/p>\n
The role of Data Analytics is to analyze, select and transform the data into useful information that allow executives and company owners to understand this information and put everything into context. Data analytics work with other analysts and domain experts to create dashboards, scorecards and reports from the data warehouse.<\/p>\n
Today most BI systems are using software products from companies such as Oracle, SAP, IBM and Microsoft. For a career in Business Intelligence, you will need at least a Bachelor\u2019s degree in computer science, software engineering or information system management. Data engineer must have knowledge of how the business sectors work and have strong skills in requirements engineering process. Data Warehouse specialist must have proficiency in SQL and relational database technology, as well as multidimensional database technology. They must also have knowledge of data modeling and financial accounting procedures and data warehousing design principals, statistics and standards. Data Analytics specialist must have knowledge of an understanding of data analysis and reporting techniques. They must understand business intelligence dashboard solutions, experience developing Business Objects and written business reports. Beside technical skills they must have strong oral and written communication skills, including presentation. Most people who work in BI come from Information System Management program but some also come from computer science and software engineering.<\/p>\n","protected":false},"excerpt":{"rendered":"
M\u1ed9t sinh vi\u00ean n\u0103m th\u1ee9 hai vi\u1ebft cho t\u00f4i: \u201cEm h\u1ecdc Qu\u1ea3n l\u00ed h\u1ec7 th\u00f4ng tin v\u00e0 quan t\u00e2m t\u1edbi khu v\u1ef1c trinh s\u00e1t doanh … <\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-4558","post","type-post","status-publish","format-standard","hentry","category-quan-li-he-thong-tin"],"_links":{"self":[{"href":"https:\/\/science-technology.vn\/index.php?rest_route=\/wp\/v2\/posts\/4558","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/science-technology.vn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/science-technology.vn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/science-technology.vn\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/science-technology.vn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4558"}],"version-history":[{"count":1,"href":"https:\/\/science-technology.vn\/index.php?rest_route=\/wp\/v2\/posts\/4558\/revisions"}],"predecessor-version":[{"id":4559,"href":"https:\/\/science-technology.vn\/index.php?rest_route=\/wp\/v2\/posts\/4558\/revisions\/4559"}],"wp:attachment":[{"href":"https:\/\/science-technology.vn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4558"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/science-technology.vn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4558"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/science-technology.vn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4558"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}