Become an expert in Data Warehousing and Business Intelligence techniques covering concepts like DW Architecture, Data Modeling, ERwin, ETL fundamentals, Business Reporting and Data Visualisation.
What are the objectives of this course?
At the end of the course the participants should be able to:
1.Understand Data Warehousing and Business Intelligence concepts.
2.Use ERwin r9 for developing the Data Warehouse and Data Marts building with Staging Area.
3.Create Dimensions and Facts tables with Granularity.
4.Use ETL Tool Talend 5.x for loading the data into staging and warehouse/data marts for various Data Migration, Replication and Integration Projects.
5.Use BI Tool Tableau 9.x for building and managing the operational and Analytical reports with dashboards.
Who is it intended for?
The following professionals can go for this course:
1.Data warehousing enthusiasts
4.ETL Developers and BI Developers.
The pre-requisites for this course include basic knowledge of SQL, General Relational Database (Oracle), Microsoft Windows GUI, Basic Unix, Windows Command line.
Training FeaturesWith Mycareercube Online’s e-learning system, certification made simpler! You can take your career to next level.Our e-learning system is proven as the best elearning system available in the market and we gaurantee to make you a certified practicener.
Mycareercube courses includes
- Expert Instructor-Led Training
We use only the industry's finest instructors in the IT industry.Learn from our instructor and interact live at your desired place via virtual learning programs scheduled to run at specific times.
Online Exam Mockup Test
Mycareercube prepares you for live exam by attemping the online mocks. We test you in different ways; first, our learning tool, gives you feedback as to why an answer is correct or incorrect. Next, you’ll receive the questions presented in a randomized, timed format very similar to the live exam. Every time you take the exam, new questions appear. At the end of the test you will be shown, in percentage, what areas of the curriculum you are strong on as well as what areas you’re weak on.
- Navigation and Controls
We provide self-paced training programs are designed in a modular fashion to allow you the flexibility to work with expert level instruction anytime. All courses are arranged in defined sections with navigation controls allowing you to control the pace of your training. Decide when you want to learn at your own pace. 24 x 7. Audio-Video Courses for self-paced evaluation based learning.
What marks this course apart?
All the successful companies have been investing large sums of money in business intelligence and data warehousing tools and technologies. Up-to-date, accurate and integrated information about their supply chain, products and customers are critical for their success. With the advent of Mobile, Social and Cloud platform, today's business intelligence tools have evolved and can be categorized into five areas, including databases, extraction transformation and load (ETL) tools, data quality tools, reporting tools and statistical analysis tools. This course will provide a strong foundation around Data Warehousing and Business Intelligence fundamentals and sophisticated tools like Talend, Tableau and ERwin.