How to become ASP.NET Developer dot net video tutorials download kudvenkat videos Subscribe Kudvenkat Blog follow pragimtech on facebook follow pragimtech on twitter follow pragimtech on google plus
Home C# ASP.NET MVC GridView JavaScript Placements Contact Feedback Subscribe Careers Support us
Contact Details Phone:
+91 99456 99393
+91 80958 31888
WhatsApp:
+91 99001 13931
Email:
pragim@pragimtech.com
pragim@gmail.com
Address:
Outer Ring Road
Opposite Innovative Multiplex
3rd Floor
Above Unilet Showroom
Beside Nandas Hyderabadi Biryani
Marathahalli, Bangalore 37

Course Contents Oracle Apps Advanced Pricing
Oracle Apps ASCP Functional
Oracle Apps SCM Functional
DOT NET | MVC
Sharepoint
MSBI
Siebel CRM
Informatica (9.1)
Informatica Data Quality (9.5.1)
Java J2EE
EMC SAN
Testing Tools
Selenium Testing
HADOOP
TIBCO
Tableau
Oracle DBA
Oracle PL/SQL
Oracle OFSAA
Oracle OBIEE
QlikView
IBM MQ Admin
Android
Salesforce
Devops
UI Development with AngularJS and Angular 2/4

Interview Questions Dot Net Video Tutorials
C#
C# Programs
ASP.NET
WCF
SQL Server
MVC
HR
PRAGIM Technologies: MSBI Course Contents
Introduction to MS - BI:
  • What is MS-BI
  • BI/DWH life cycle
  • ETL and OLAP Tools
  • Features of MS-BI
Introduction to SSIS:
  • Package
  • Tasks
  • SSIS installation
  • SSIS Architecture
  • SSIS Wizard
  • Control Flow Tasks
  • Data Flow Task
  • Variables and Expressions
  • Errors and Debugging SSIS
  • Data viewers
  • Deployment
  • Manually Executing SSIS Package
  • Scheduling SSIS Package
  • Importing and Exporting Packages
  • Monitoring and Optimizing Packages
Introduction to SQL Server Reporting Services:
  • Reporting Services Architecture
  • Reporting Services Terminology
Creating Reports:
  • Deconstructing Reporting Services
  • Shared Data Sources
  • Creating Reports from Scratch
Calculations and Formatting:
  • Creating Expressions
  • Using the Global Collection
Grouping and Sorting:
  • Creating Groups and Calculating Totals and Percentages
  • Interactive Sorting, Creating Drill-Down Reports
Report Parameters
  • Creating Report Parameters
  • Creating Drop-Down Parameters
  • Multi-Valued Parameters
  • Debugging Parameter Issues
Creating Matrix Reports and Charts:
  • Creating a Basic Matrix Report
  • Matrix Subtotals
  • Creating a Basic Chart
  • Exploring the Charting Possibilities
Reporting Services Security:
  • Two Parts to Reporting Services Security
  • Securing Access to Reports
  • Data Source Security
OLAP Modeling:
  • Modeling source schemas—stars and snowflakes
  • Understanding dimensional modeling— Dimensions (Type 1, 2, or 3) or rapidly changing
  • Understanding fact (measures) and cube modeling
Intermediate SSAS:
  • KPIs
  • Perspectives
  • Translations – cube metadata and currency localization
  • Actions – regular, drill-through and reporting
Advanced SSAS:
  • Using multiple fact tables
  • Modeling intermediate fact tables
  • Modeling M:M dimensions, Fact (degenerate) dimensions, Role-playing dimensions, write back dimensions
  • Modeling changing dimensions – Dimension Intelligence w/ Wizard
  • Using the Add Business Intelligence Wizards – write-back, semi-additive measures, time intelligence, account intelligence
Cube Storage and Aggregation:
  • Storage topics – basic aggregations, MOLAP
  • Advanced Storage Design – MOLAP, ROLAP, HOLAP
  • Partitions – relational and Analysis Services partitions
  • Customizing Aggregation Design - Processing Design
  • Rapidly changing dimensions / ROLAP dimensions
  • Welcome to the Real Time – Proactive Caching
  • Cube processing options
Beginning MDX:
  • Basic syntax
  • Using the MDX query editor in SQL Server Management Studio
  • Most-used Functions & Common tasks
  • New MDX functions
Disclaimer - Terms of use - Contact Us