Architecture and Design session
on PowerBI with Microsoft Azure Analysis services
26th & 27th April 2019 | 10:00 am to 06:00 pm
G7CR Technologies India Pvt Ltd
10/4 3rd Floor Mitra Towers Kasturaba Road, Ashok Nagar, Bengaluru, Karnataka 560001
Although many commercial OLAP products are readily available - as stand-alone tools and, increasingly, in close association with relational databases -- OLAP remains a difficult and complex technology to master.
This Two-day instructor-led Work Shop provides delegates a classic, a clear and comprehensive explanation of the concepts and best techniques for deploying OLAP -- no matter what tools you're using. This Session is thoroughly created to offer expanded coverage of logical issues such as Design for Data Marts, dimensional hierarchies, as well as physical issues of data storage, access, and calculation. The practical methods and formulas you'll learn are useful no matter what commercial OLAP tool(s) you use. In addition, we will take a quick preview of Predictive analysis and Data Mining.
Who should attend?
This course is intended for Designers, Managers and Owners of a BI System who needs to get about the business of Analyzing their Information from the heaps of data They Have.
Before attending this course, students must have:
- ✔Basic knowledge of the Microsoft Windows operating system and its core functionality.
- ✔Working knowledge of SQL.
- ✔Working knowledge of relational databases.
- ✔Some experience with database design.
- ✔Familiarity of Data Warehousing Concepts is a Must
Module 1: Appetizers
- •The BI Architecture
- •An Architectural Framework and Approach to BI Implementation
- •Data Marts, Data Warehouse and OLAP
- •The Need for Data Modelling
- •Dimensional Data Modelling
- •Business Cases and Data Modelling Techniques.
- •Thinking Clearly in N Dimensions
Module 2: The Core of BI and OLAP Solutions
- •The OLAP Flavours and its Pro’s and Con’s
- •It’s a Jungle Out There – vendors and Products
- •The Core Of Multidimensional Technology
- •The Internal Structure of a Dimension
- •Hypercubes or Semantic Spaces
- •Analytic Visualization
- •Physical Design of Applications
- •Practical Steps for Designing and Implementing BI Systems
- •Product Language Comparisons
Module 3: Success Guidelines and Best Practices
- •Issues and Resolution Business and Technical
- •Multidimensional Guidelines
- •Toward a Theoretically Grounded Model for BI and Its Connection to the Relational
- •Model and Canonical Logic
- •Codd's 18 Features
- •Best Practices For one of the leading SSAS Products