This is an introductory course for freshers / beginners / non-technical folks who want to take a sneak peek into the working of a Business Intelligence project and understand different career options and associated responsibilities for the same. This course is about how a BI project is executed, what are the different layers of a BI architecture, and which career track one can choose to work on based on your areas of interest in a BI project. This course is not meant to be a exhaustive reference of each and every tool and technology available in the Business Intelligence field.
This is a fully diagram guided course and focused on BI architecture majorly. This course also lists some industry leading tools and technologies from different vendors that fit into different areas of a BI project.
The course has three major sections - BI Project Lifecycle, BI Architecture and BI Career Tracks. The course does not come with any practice tests or do-it-yourself kind of exercises. But if you have a career or technical question related to this course, I would be able to help the students with the same.
This lecture explains the OLTP layer of a BI project.
This lecture explains the Data Integration layer of a BI project.
This lecture explains the MDM and Data Quality layer of a BI project.
This lecture explains the Data Warehouse layer of a BI project.
This lecture explains the Data Mart layer of a BI project.
This lecture explains the OLAP layer of a BI project.
This lecture explains the Reporting layer of a BI project.
This lecture contains links to glossary of Business Intelligence Terminologies reference.
This layer explains different career tracks and corresponding areas and tasks of a BI project that one needs to cover for any given career track.
Discount coupons of my other courses
My name is Siddharth Mehta. I work in the role of a Senior Technology Architect with a multinational IT firm. I have career experience of more than 14 years in the IT industry working with multinational IT companies and Fortune 500 clients.
-|- International experience of working across geographies (US, UK, Singapore) for multi-national clients in Banking, Logistics, Government, Media Entertainment, Products, Life Sciences and other domains
-|- I usually work as a lead architect for a portfolio of applications in web, mobile, BI, Analytics, Data warehousing, Reporting, Collaboration, CMS, NoSQL and other categories.
-|- In my present role, I remain responsible for Arch Design, Tech Stack selection, Infra design, 3rd party products evaluation and procurement, and Performance engineering. My primary specialty is Microsoft SQL Server and Microsoft Business Intelligence. I usually work with MS BI integration with cross technologies like Elasticsearch / Lucene, MongoDB, Sharepoint 2013 and 2010, jQuery based framework like Highcharts and GoJS, jQueryMobile, Bootstrap, iOS xCode framework, and many others.
-|- I have authored more than 200 articles and tutorials collectively for online publications like mssqltips, sqlserverperformance, sqlservercental, techrepublic and others.
-|- I have authored / co-authored as well as reviewed books for print-media publication houses like Manning publication, Packt publication.
-|- I have also authored a whitepaper for MSDN Library titled: Bulk report generation using SSIS and SSRS 2008 R2.
-|- TOGAF 9 Part I & II certified architect
-|- CITA-F certified architect
-|- HCAHD (Hortonworks Hadoop certified)
-|- MCSD.Net, and MCTS in SQL Server maintenance as well as Developing BI apps using SQL Server
-|- Certified Sr. Technology Architect as well as Digital Architect
Master of Science with major in Computer Applications and Information Technology