Practice Lab 70-467: Designing Business Intelligence Solutions with Microsoft SQL Server
duration: 7 hours |
access duration: 180 days |
Details
Through this LiveLab, focussed on Microsoft exam 70-467: Designing Business Intelligence Solutions with Microsoft SQL Server, you will receive hands-on experience regarding creating business intelligence solutions. By performing tasks in a real SQL Server environment, you will improve your practical knowledge and skills on the various exam subjects.
You will perform practical exercices with regards to partition switching, high availability and disaster recovery, SSAS, MDX & DMX queries. and far more.
Result
After completing this lab you have practical experience regarding creating business intelligence solutions.
Note: As of January 31, 2021, this certification will expire. If
you would like advice on which training to take then, please
contact our support team.
Prerequisites
No specific knowledge is required. It is a plus when you have
completed the training course: Designing Business Intelligence
Solutions with Microsoft SQL Server (exam 70-467).
Target audience
Business Analyst
Content
Practice Lab 70-467: Designing Business Intelligence Solutions with Microsoft SQL Server
Plan and Manage Reporting Services Configuration
- Introduction
- Create a Native Mode Report Server Database
- Create a Reporting Services Service Application using SharePoint Central Administration
- Summary
Configure HTTP Access to Analysis Services on IIS
- Introduction
- Configuring HTTP Access to Analysis Services on IIS
- Summary
Understanding Performance of Named Queries in Data Source View
- Introduction
- Creating a Named Query
- Analysing Performance of Named Query
- Summary
Design and Create MDX Calculations
- Introduction
- Creating Query-Scoped Calculated Members in MDX Statement
- Creating Session-Scoped Calculated Member in MDX Statement
- Summary
Creating Automated Backup of SQL Server
- Introduction
- Creating Automated Backup
- Summary
Deploy SSIS Solutions
- Introduction
- Creating Integration Services Catalog
- Creating an SSIS Package with Parameters and Values
- Adding a Configuration to SSIS Package
- Deploying SSIS Projects with Project Deployment Model
- Using Package Configurations in SSIS
- Executing SSIS Package Using SQL Server Agent
- Summary
Many to Many Multidimensional Database (SSAS)
- Introduction
- Create Many to Many Multidimensional Database in SSAS
- Summary
Implement Appropriate Indexing Strategy on Fact Tables
- Introduction
- Implementing Clustered Index on Fact Table
- Implementing Non- Clustered Index
- Summary
Design Cube Architecture
- Introduction
- Creating a Data Source View in SSAS
- Creating Measures, Measure Groups and Aggregate Functions
- Using Drillthrough Action
- Define an Index for the View
- Summary
Design Package Configurations for SSIS Packages
- Introduction
- Adding Configurations to SSIS Packages
- Summary
Creation of Multiple Partitions to improve Query and Load Performance
- Introduction
- Creating Multiple Partitions to Improve Query Performance
- Creating Multiple Partitions to Improve Load Performance
- Summary
Parallel Bulk Loading Using Partition Switching
- Introduction
- Partioning Tables
- Summary
Proactive Caching in SQL Server Analysis Services (SSAS)
- Introduction
- Implementing Proactive Caching in SSAS
- Summary
ETL in SSIS and Processing in Analysis Services
- Introduction
- Creating a Simple ETL Package
- Developing and Processing an OLAP Cube
- Summary
Dynamic Dimension Security in SSAS
- Introduction
- Set up Role Based Dynamic Dimension Security
- Summary
Aggregations in SSAS
- Introduction
- Creating Group of Aggregations
- Summary
Design BI Reporting Solution Architecture
- Introduction
- Create Drillthrough Reports in SSRS
- Adding a Subreport
- Rendering a Report on a Web Page
- Create a Data Alert in Data Alert Designer
- Create a Reporting Services Subscription to Deliver a Report to a SharePoint Library
- Summary
Partitions and Storage Modes in SSAS
- Introduction
- Creating Partitions
- Configuring Storage Modes in SSAS
- Summary
Design Roles for Calculated Measures
- Introduction
- Set up Security to Calculated Members through Roles
- Summary
Configure Logging for ETL Package
- Introduction
- Creating a Simple ETL Package
- Adding and Configuring Logging for an ETL package
- Summary
Design the Data Warehouse
- Introduction
- Building an Enterprise Data Warehouse Model Using Snowflake Schema
- Adding a Data Lineage for a Dimension Table
- Working with Fact Tables
- Adding Data Lineage for a Fact Table
- Working with Column Store Index
- Partitioning the Fact Table
- Implement an Incremental Data Load
- Summary
Manage Excel Services and Reporting for SharePoint
- Introduction
- Add a Reporting Services Report to Your Power Pivot Workbook
- Deploy PowerPivot Workbook to SharePoint Using BIDS
- Demonstrate How to Schedule Data Refresh for PowerPivot Workbook Published to a SharePoint Library
- Deploy a PowerView Report to a SharePoint Library
- Summary
Analyzing Performance Consequences of MDX and DMX Queries
- Introduction
- Analyzing Performance Consequences of MDX
- Analyzing Performance Consequences of DMX
- Summary
High Availability and Disaster Recovery
- Introduction
- Backing up and Restoration of an SSAS Database
- Backing up and Restoration of SSRS Database
- Backing up and Restoration of SSIS Database
- Summary
Designing a Reporting Services Dataset
- Introduction
- Configuring an OLE DB Source to Use Parameterized Queries and Map a Query Parameter to a Variable
- Creating an SSRS Report on an SSAS OLAP Cube
- Creating a DAX-Based Dataset to retrieve tabular
- Creating SSRS reports using Stored Procedures with Parameters
- Summary
Configure Kerberos Constrained Delegation for Analysis Services
- Introduction
- Configuring Analysis Services for Kerberos Constrained Delegation
- Summary
Course options
We offer several optional training products to enhance your learning experience. If you are planning to use our training course in preperation for an official exam then whe highly recommend using these optional training products to ensure an optimal learning experience. Sometimes there is only a practice exam or/and practice lab available.
Optional practice exam (trial exam)
To supplement this training course you may add a special practice exam. This practice exam comprises a number of trial exams which are very similar to the real exam, both in terms of form and content. This is the ultimate way to test whether you are ready for the exam.
Optional practice lab
To supplement this training course you may add a special practice lab. You perform the tasks on real hardware and/or software applicable to your Lab. The labs are fully hosted in our cloud. The only thing you need to use our practice labs is a web browser. In the LiveLab environment you will find exercises which you can start immediately. The lab enviromentconsist of complete networks containing for example, clients, servers,etc. This is the ultimate way to gain extensive hands-on experience.
Sign In
WHY_ICTTRAININGEN
Betaal in termijnen
| Cursusnaam | |
| Looptijd | |
| Rentebedrag financiering | |
| Totaal bedrag | |
| Maandbedrag |
Gespreid betalen met Spraypay
Met de betaaloptie SprayPay kun je jouw bestelling van € 250,- tot € 3.500,- veilig en gespreid betalen in gelijke termijnen van 12, 18, 24 of 36 maanden. Je hebt op die manier een minimale financiële belasting en je kunt eenvoudig de termijnbetalingen opnemen in jouw vaste lasten.
Hoe werkt het kopen op afbetaling? De beoordeling van de kredietaanvraag vindt online plaats. Binnen enkele seconden weet je of je in aanmerking komt voor een krediet. Is de aanvraag akkoord dan kun je meteen genieten van je aankoop.
Let op: deze betaalmetode is aleen beschikbaar voor particulieren! Bekijk voor je aankoop ook de SprayPay voorwaarden.
Via ons opleidingsconcept bespaar je tot 80% op trainingen
Start met leren wanneer je wilt. Je bepaalt zelf het gewenste tempo
Spar met medecursisten en profileer je als autoriteit in je vakgebied.
Ontvang na succesvolle afronding van je cursus het officiële certificaat van deelname van Icttrainingen.nl
Krijg inzicht in uitgebreide voortgangsinformatie van jezelf of je medewerkers
Kennis opdoen met interactieve e-learning en uitgebreide praktijkopdrachten door gecertificeerde docenten
Orderproces
Once we have processed your order and payment, we will give you access to your courses. If you still have any questions about our ordering process, please refer to the button below.
read more about the order process
Een zakelijk account aanmaken
Wanneer u besteld namens uw bedrijf doet u er goed aan om aan zakelijk account bij ons aan te maken. Tijdens het registratieproces kunt u hiervoor kiezen. U heeft vervolgens de mogelijkheden om de bedrijfsgegevens in te voeren, een referentie en een afwijkend factuuradres toe te voegen.
Betaalmogelijkheden
U heeft bij ons diverse betaalmogelijkheden. Bij alle betaalopties ontvangt u sowieso een factuur na de bestelling. Gaat uw werkgever betalen, dan kiest u voor betaling per factuur.
Cursisten aanmaken
Als u een zakelijk account heeft aangemaakt dan heeft u de optie om cursisten/medewerkers aan te maken onder uw account. Als u dus meerdere trainingen koopt, kunt u cursisten aanmaken en deze vervolgens uitdelen aan uw collega’s. De cursisten krijgen een e-mail met inloggegevens wanneer zij worden aangemaakt en wanneer zij een training hebben gekregen.
Voortgangsinformatie
Met een zakelijk account bent u automatisch beheerder van uw organisatie en kunt u naast cursisten ook managers aanmaken. Beheerders en managers kunnen tevens voortgang inzien van alle cursisten binnen uw organisatie.
What is included?
| Certificate of participation | No |
| Monitor Progress | Yes |
| Examination possible | Yes |
| Mobile ready | Yes |
| Sharing knowledge | Unlimited access to our IT professionals community |
| Study advice | Our consultants are here for you to advice about your study career and options |
| Study materials | Certified teachers with in depth knowledge about the subject. |
| Service | World's best service |
Platform
Na bestelling van je training krijg je toegang tot ons innovatieve leerplatform. Hier vind je al je gekochte (of gevolgde) trainingen, kan je eventueel cursisten aanmaken en krijg je toegang tot uitgebreide voortgangsinformatie.
FAQ
Niet gevonden wat je zocht? Bekijk alle vragen of neem contact op.