Course Details: Data warehousing overview Basics of Data Warehousing What is OLTP and OLAP? Difference between OLTP and OLAP Advantages of OLAP What is Data Marts and ODS? Dimensional Modeling Overview Introduction to Dimensional Modeling What are Facts and Dimensions? Star schema and Snowflake schema Introduction to Business Intelligence What is Business Intelligence Where BI tools are Used Why the Oracle Business Intelligence Advantages Architecture, Components Clients - Answers, Delivers, Dashboards and Web administration, Servers- Oracle BI server, Presentation, Scheduler server Server Architecture Repository Basics What is Meta data? Creating a Repository using BI Administration Tool Physical, Business Model and Mapping, and presentation layers Properties of repository objects Building Physical Layer of a Repository Objects of Physical Layer DSN for a data sources Build physical layer Building business Model mapping layer Objects of BMM layer Building Business model (creating logical tables, columns, joins) Creating simple measures Building presentation layer Objects of presentation layer Properties of the presentation layer Build presentation layer Testing and validating Repository Checking repository consistency Checking Global Consistency Inspecting Oracle Answers inspecting SQL Inspecting log files(Nqquery.log,NQSserver.log) Adding multiple sources to dimension De-normalizing tables structures in database design Adding multiple sources to existing logical tables source Adding second table sources Adding calculations to fact Calculation measures on the basis of physical and logical columns Using Calculation wizard Creating dimensional hierarchies and level based measures Creating dimensional hierarchies Use level based measures Create Rank and Share measures Using aggregation Importing Aggregated Tables into Repository Modeling aggregate tables to speed processing Using variables Presentation Variables Repository variables Session variables Initialization Blocks Multiuser Environment (MUD) Overview on Multiuser Environment (MUD) How to create projects in MUD Checkout and checkin of projects Modeling time series data Types of SCDS Using of time series functions Modeling extension tables Purposes of extension tables Modeling extension tables for fact and dimensions Oracle BI Security Security at object and data level Creating users and User groups Assigning permissions to users Setting Query limits and timing restrictions Authenticating using an external database Cache management Purge cache and event handling tables Making the table cacheable Setting of cache in NQSCONFIG.INI file Working with Oracle BI Answers Building Busines Requests usiing Answers Adding filters to Business requests Adding Column Filter Prompts in Answers Views and charts in requests Creating Oracle Intelligence Dashboards Creating dashboard pages using report requests Creating dashboard prompts Configuring guided navigation links Adding content to dashboard Conditional links and conditional section Administering OBI Presentation Catalog Using catalog management to maintain web catalog Creating catalog groups, issuing privileges etc
SBR Trainings offers wide range of courses belonging to business, IT, students, developers, data and working professionals, freshers etc; We regulate training about your expected courses and help you to advance your career. SBR come up with numerous courses and offer training throughout the world like France, United states, China, India, Singapore, Germany, Australia, Canada etc; by using interface like webex and GoToMeeting.
SBR trainers assist in developing Real time experience of the required course and also improving interview skills, knowledge, communication, content of the course, innovative project ideas, future scope etc,. This makes our students are becoming future experts and working as professionals in top rated companies.
SBRTrainings offers wide range of courses belonging to business, IT, students, developers, data and working professionals, freshers etc; We regulate training about your expected courses and help you to advance your career. SBR come up with numerous courses and offer training throughout the world like France, United states, China, India, Singapore, Germany, Australia, Canada etc; by using interface like webex and GoToMeeting.
SBR trainers assist in developing Real time experience of the required course and also improving interview skills, knowledge, communication, content of the course, innovative project ideas, future scope etc,. This makes our students are becoming future experts and working as professionals in top rated companies.
1. The classes can be attended to at any place and any time as per your choice Use your laptop, desktop, Android and iOS App to learn on the go 2. Choose from a number of batches as per your convenience If you got something urgent to do, reschedule your batch for a later time if you want fast rack also arrange 1:1 3. Live screen sharing, step-by-step live demonstrations and live Q&A led by real time industry experts. If you are busy so not joined class it means Missed a class? Not an issue. We record the classes and send to your email id 4. Share your learning objectives and get oriented with our web and mobile platform. Talk to your personal learning manager to clarify your doubts 5. We have pre-populated your learning platform with previous class recordings and presentations. 6. We have in-house expert Teaching Assistants to resolve all your queries. Reach out to us by raising a ticket from your learning platform. sbrtrainings provides life time learning assistance. 7. Have a problem? Our Support Ninjas Are There to Help You 24 X 7