Diploma In Data Warehousing Abaseen Institute of Medical & Modern Sciences

Course details

Module1 (Diploma In Data Warehousing)

  • Introduction to Data Warehousing
  • Identifying data warehouse components
  • Analyzing failed installations
  • Top-down vs. bottom-up approach
  • Selecting the appropriate technique for your environment
  • Establishing Dimensional Modeling
  • Modeling the business process
  • Relating business processes to dimensions with a Bus Matrix
  • Reviewing denormalization techniques to optimize database read performance
  • Identifying the advantages of star schema over snowflake schemas
  • Differentiating between normalized and renormalized system design
  • Enabling drill-up and drill-down reporting through the use of hierarchies
  • Building fact tables
  • Setting the grain of your fact tables to maintain a balance between flexibility and performance
  • Identifying primary keys and foreign keys
  • Tailoring business analysts' needs through the use of summary tables
  • Creating dimensions
  • Resolving date dimension issues
  • Exploring connections between separate events with conformed dimensions
  • Increasing model flexibility through the use of role-playing dimensions
  • Substituting surrogate keys for natural keys
  • Building the Data Warehouse
  • Architecting the physical database
  • Mapping the logical data model to the physical data model
  • Evaluating hardware considerations
  • Choosing a method of data storage
  • Indexing and materialized views for performance
  • Ensuring data quality
  • Profiling source data
  • Configuring the database for change data capture
  • Refreshing the data warehouse

Module2 (Diploma In Data Warehousing)

  • Extracting data from multiple sources
  • Connecting to different data sources
  • Databases
  • Spreadsheets
  • Text files
  • Transforming data during migration
  • Cleansing and scrubbing data
  • Mapping data elements and data types
  • Conforming dimensions and facts
  • Loading data into a data warehouse
  • Employing a staging database
  • Automating incremental data loading
  • Verifying success for data integrity
  • Leveraging BI for Data Analysis
  • Identifying levels in the BI stack
  • Demonstrating SharePoint as a deployment platform
  • Utilizing Excel as a client tool for data analysis
  • Querying data from the OLAP server
  • Exploring business intelligence tools
  • Multidimensional cubes
  • Slicing and dicing your data
  • Surfacing Key Performance Indicators (KPIs) to evaluate the health of your organization
  • Deploying a Complete Data Warehouse Solution
  • Taking advantage of industry-standard data-mining techniques
  • Identifying data-mining methodologies
  • Choosing the right data-mining tasks based on organizational needs
  • Planning for the future
  • Big Data and the impact on traditional data warehousing
  • Supplementing the traditional data warehouse to handle unstructured data
  • Dealing with large data sets via Hadoop

About Abaseen Institute of Medical & Modern Sciences

AIMMS (Abaseen Institute of Medical & Modern Sciences) is the only ISO Certified, &  the biggest educational network of its kind in the country and spread throughout all provinces. It is to further clarify that AIMMS is affiliated institute with Trade Testing Board, Board of Technical Education KPK, Skill Development Council Punjab, Board of Technical Education,  and other national and international bodies of education like United Kingdom Association of Professionals(UKAP), American Learning Center Virginia of USA and  especially for international students, and is working as a registerd firm.  AIMMS does not issue its own certification, but it helps the prospective students issue various diplomas/certificates and awards with the collaboration of these affiliated bodies.

AIMMS, the only home of learning where your dream to get 1 & 2 year professional diploma of International standard, has become easier now. The ocean of learning & motivation, pioneer in Distance Learning, Assignment, Home Based Study and Experience Based education, and the only ISO certified and Govt recognized organization of its kind in the region, engaged in providing education under unique style at your door step and shape your skills into productive excellence. 

The launch of Abaseen Institute of Medical and Modern Science (AIMMS) is a hall-mark event in the educational history of Pakistan. In collaboration with well-reputed organizations of the country and abroad, and the liberal support of professionals, AIMMS is taking big strides on the way to unprecedented progress. It has brought in vogue education at your door steps through various strategies which includes Distance Learning Program (DLP), FAST Track Education System (FTES) and Experience based education program known as RPL. This will have tremendous impact on the socio-economic growth of the country.

AIMMS provides competency based, Skill-oriented  certification, Diplomas, Certified Professional Management (CPM) and  experienced professionals in the field of research, management, health, technical, vocational and computer related technologies to help the under privileged segments of the society. To bring prosperity through skill is the sole motto of AIMMS. For all technical and practical courses, previous experience is required, otherwise, we can arrange periodic workshop for the students if the required number of students get enrolled.

See all Abaseen Institute of Medical & Modern Sciences courses

IT, Computing and Technology Related Questions

Contact information not available.

Are you from Abaseen Institute of Medical & Modern Sciences ? Claim your course!
Courses you can instantly connect with... SPSS Appxone Training Center

Is this the right course for you?

Rate our content

Didn't find what you were looking for ?