Data Warehousing and BI Analytics
Today’s businesses are investing significantly in capabilities to harness the massive amounts of data that fuel Business Intelligence (BI). Working knowledge of Data Warehouses and BI Analytics tools are a crucial skill for Data Engineers, Data Warehousing Specialists and BI Analysts, making who are amongst, the most valued resources for organizations.
This course prepares you with the skills and hands-on experience to design, implement and maintain enterprise data warehouse systems and business intelligence tools. You’ll gain extensive knowledge on various data repositories including data marts, data lakes and data reservoirs, explore data warehousing system architectures, deepen on data cubes and data organization using related tables. And analyze data using business intelligence like Cognos Analytics, including its reporting and dashboard features, and interactive visualization capabilities.
This course provides hands-on experience with practice labs and a real-world inspired project that can be added to your portfolio and will demonstrate your proficiency in working with data warehouses. Skills you will gain include building data warehouses, Star/Snowflake schemas, CUBEs, ROLLUPs, Materialized Views/MQTs, reports and dashboards.
This course assumes prior SQL and relational database experience.
What you'll learn
- Describe the architecture, features, and benefits of data warehouses, data marts, and data lakes and identify popular data warehouse system vendors.
- Design and populate a data warehouse, and model and query data using SQL to build CUBEs, ROLLUPs, and Materialized Views.
- Analyze warehouse data using popular Business Intelligence (BI) tools such as Cognos Analytics to create reports and dashboards.
- Demonstrate loading data into a data warehouse, writing aggregation queries, creating materialized query tables, and building an analytics dashboard.
Get a Reminder
Rating | Not enough ratings |
---|---|
Length | 6 weeks |
Effort | 6 weeks, 2–3 hours per week |
Starts | On Demand (Start anytime) |
Cost | $99 |
From | IBM via edX |
Instructors | Rav Ahuja, Ramesh Sannareddy |
Download Videos | On all desktop and mobile devices |
Language | English |
Subjects | Programming |
Tags | Computer Science |
Get a Reminder
Similar Courses
Careers
An overview of related careers and their average salaries in the US. Bars indicate income percentile.
Business Intelligence Implementer $68k
Business Intelligence Generalist $68k
Business Intelligence Researcher $84k
Business Intelligence Contractor $86k
Advisor Business Intelligence $94k
Business Intelligence and Investigations $97k
Associate Business Intelligence $104k
Business Intelligence Architect 3 $109k
Business Intelligence Advisor $109k
Developer, Business Intelligence $121k
Business Intelligence Strategist $122k
IT Business Intelligence Developer $149k
Write a review
Your opinion matters. Tell us what you think.
Please login to leave a review
Rating | Not enough ratings |
---|---|
Length | 6 weeks |
Effort | 6 weeks, 2–3 hours per week |
Starts | On Demand (Start anytime) |
Cost | $99 |
From | IBM via edX |
Instructors | Rav Ahuja, Ramesh Sannareddy |
Download Videos | On all desktop and mobile devices |
Language | English |
Subjects | Programming |
Tags | Computer Science |
Similar Courses
Sorted by relevance
Like this course?
Here's what to do next:
- Save this course for later
- Get more details from the course provider
- Enroll in this course