Name: DP-900T00 Microsoft Azure Data Fundamentals
Price: 595 GBP
Availability: InStock

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Real Estate Development cash flows require greater skill and flexibility from Analysts, and an ability to work with simultaneously with project partners. Value add and opportunistic property investments are complex both in their initial scope and their cash flow projections.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This course will show delegates how to appraise projects in Excel, incorporate and communicate updates as they happen and ultimately understand how to convert an opportunistic property investment into a core asset that can be sold on.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Residual models (profit &amp; site) are demonstrated first to illustrate the main components of any scheme and the traditional methods of evaluation such as profit on cost ratio, rental yield and interest cover. Development cash flows are then constructed in detail looking in particular at phased income as well as fixed, variable and incidental construction costs and their impact on the net cash flow. Additional performance metrics are calculated including geared IRR and return on equity.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Development financing can be trickier than straightforward senior debt investment financing. This is because finance is often required in stages. The brought forward carried forward method demonstrated on the course, is the easiest way to deal with programmed debt drawdown functions and rolled-up interest.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The assessment of project specific risk is arguably much more important in development schemes. Sensitivity analysis and scenario analysis are covered in the final section of the course.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">On this course you will&hellip;</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Learn how to calculate land and profit residuals</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Learn how to structure a full development cash flow, including phased sales, S-curve and straight line cost functions</li><li value="3" fr-original-style="" style="box-sizing: border-box;">You will be taught how to find maximum bidding prices for site development and building refurbishments</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Understanding development financing considerations and learn how to optimise financing</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Analyse financial and project completion risks</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Employ best practice and find solutions to common modelling problems</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who will benefit from this course?</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Developers</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Surveyors</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Real Estate professionals at any level with exposure to real estate financial models on a frequent basis</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Fund managers</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Asset managers</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Land managers</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Planning managers</li><li value="8" fr-original-style="" style="box-sizing: border-box;">Lenders</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Outline</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Day One</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Learn how to build a discounted cash flow, analyse returns and understand the components of development models</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Gross versus Net Yields, calculating Net Development Value (NDV)</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Profit residual, with and without financing</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Site residual, how to calculate profit without knowing your costs.</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Introducing financing to site residual calculations</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Purchase price and acquisition costs</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Phased Sales, marketing and disposal costs</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Modelling construction costs using straight line basis, fixed costs, variable costs, incidental costs and construction fees</li><li value="8" fr-original-style="" style="box-sizing: border-box;">Professional fees</li><li value="9" fr-original-style="" style="box-sizing: border-box;">Income and expenditure project functions</li><li value="10" fr-original-style="" style="box-sizing: border-box;">Logic functions, logic tables and array formulae</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Day Two</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Learn how to build a detailed property development project cash flow, add financing and perform risk analysis on commercial development projects</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Multiple IRRs, competing projects, scoping and linear programming, maximising performance</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Return metrics: Equity profit ratio (EPR), Costs paid out of proceeds (POP), Profit on cost ratio (PCR)</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Alternative site calculation, Net present value (NPV),</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Modelling construction costs using S-curve , variable costs, incidental costs and construction fees</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Switching between scenarios</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Introduction to Development financing, Pari Passu versus Equity First Financing</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Debt scheduling: brought forward and carried forward method</li><li value="8" fr-original-style="" style="box-sizing: border-box;">Consideration of the impact of development finance interest, fees and covenants</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Included in the Course</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">CPD Accredited Certificate &amp; LinkedIn Proficiency Badge</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Course Manual - In-Person Course attendees will receive a Physical Copy, Virtual Course attendees will receive a Virtual Copy and have the option to purchase a Hard Copy at an additional fee</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Course Files</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Post Course Support - Two Months of Questions &amp; Answers, and One year of support is available for an additional fee</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">For more information about the Real Estate Developer such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">E - s.musgrave@bayfieldtraining.com</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">T - 01223 517851</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">W - <a href="https://www.bayfieldtraining.com/" target="_blank" rel="nofollow noopener noreferrer ugc" title="https://www.bayfieldtraining.com/" data-airgap-id="125" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">www.bayfieldtraining.com</a></p>



Real Estate Development cash flows require greater skill and flexibility from Analysts, and an ability to work with simultaneously with project partners. Value add and opportunistic property investments are complex both in their initial scope and their cash flow projections.
This course will show delegates how to appraise projects in Excel, incorporate and communicate updates as they happen and ultimately understand how to convert an opportunistic property investment into a core asset that can be sold on.
Residual models (profit & site) are demonstrated first to illustrate the main components of any scheme and the traditional methods of evaluation such as profit on cost ratio, rental yield and interest cover. Development cash flows are then constructed in detail looking in particular at phased income as well as fixed, variable and incidental construction costs and their impact on the net cash flow. Additional performance metrics are calculated including geared IRR and return on equity.
Development financing can be trickier than straightforward senior debt investment financing. This is because finance is often required in stages. The brought forward carried forward method demonstrated on the course, is the easiest way to deal with programmed debt drawdown functions and rolled-up interest.
The assessment of project specific risk is arguably much more important in development schemes. Sensitivity analysis and scenario analysis are covered in the final section of the course.


On this course you will…
Learn how to calculate land and profit residuals
Learn how to structure a full development cash flow, including phased sales, S-curve and straight line cost functions
You will be taught how to find maximum bidding prices for site development and building refurbishments
Understanding development financing considerations and learn how to optimise financing
Analyse financial and project completion risks
Employ best practice and find solutions to common modelling problems


Who will benefit from this course?
Developers
Surveyors
Real Estate professionals at any level with exposure to real estate financial models on a frequent basis
Fund managers
Asset managers
Land managers
Planning managers
Lenders


Course Outline
Day One
Learn how to build a discounted cash flow, analyse returns and understand the components of development models
Gross versus Net Yields, calculating Net Development Value (NDV)
Profit residual, with and without financing
Site residual, how to calculate profit without knowing your costs.
Introducing financing to site residual calculations
Purchase price and acquisition costs
Phased Sales, marketing and disposal costs
Modelling construction costs using straight line basis, fixed costs, variable costs, incidental costs and construction fees
Professional fees
Income and expenditure project functions
Logic functions, logic tables and array formulae


Day Two
Learn how to build a detailed property development project cash flow, add financing and perform risk analysis on commercial development projects
Multiple IRRs, competing projects, scoping and linear programming, maximising performance
Return metrics: Equity profit ratio (EPR), Costs paid out of proceeds (POP), Profit on cost ratio (PCR)
Alternative site calculation, Net present value (NPV),
Modelling construction costs using S-curve , variable costs, incidental costs and construction fees
Switching between scenarios
Introduction to Development financing, Pari Passu versus Equity First Financing
Debt scheduling: brought forward and carried forward method
Consideration of the impact of development finance interest, fees and covenants


Included in the Course
CPD Accredited Certificate & LinkedIn Proficiency Badge
Course Manual - In-Person Course attendees will receive a Physical Copy, Virtual Course attendees will receive a Virtual Copy and have the option to purchase a Hard Copy at an additional fee
Course Files
Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)
Post Course Support - Two Months of Questions & Answers, and One year of support is available for an additional fee


For more information about the Real Estate Developer such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:
E - s.musgrave@bayfieldtraining.com
T - 01223 517851
W - www.bayfieldtraining.com

Bayfield Training

Financial Modelling & Analysis

Real Estate Finance

Financial Modelling

Microsoft Excel

Financial Risk Management

Professional Development

Continuous Professional Development (CPD)

This course will show delegates how to appraise projects in Excel, incorporate and communicate updates as they happen and ultimately understand how to convert an opportunistic property investment into a core asset that can be sold on.

Real Estate Developer (Development Cash Flow Modelling in Excel)

General Admission

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(35, 35, 51); box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(35, 35, 51);">This course will cover Advanced concepts in DAX, Data Modeling, Power BI architectural design, and more. It is a unique blend of data modeling, data analysis, data presentation, and visualization skills. &nbsp;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(35, 35, 51); box-sizing: border-box;" fr-original-style="color: rgb(35, 35, 51);">This instructor-led course includes:&nbsp;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(35, 35, 51); box-sizing: border-box;" fr-original-style="color: rgb(35, 35, 51);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&bull; &nbsp; &nbsp;2 weeks of self-paced essential learning content that you are to complete before the instructor-led live virtual sessions begin&nbsp;</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(35, 35, 51); box-sizing: border-box;" fr-original-style="color: rgb(35, 35, 51);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&bull; &nbsp; &nbsp;6 instructor-led virtual sessions of 2 hours each. Each Session will have a 15-minute break.&nbsp;</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(35, 35, 51); box-sizing: border-box;" fr-original-style="color: rgb(35, 35, 51);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&bull; &nbsp; &nbsp;Intersession Assignments that you are expected to complete and discuss in your preassigned groups during the session.&nbsp;</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(35, 35, 51); box-sizing: border-box;" fr-original-style="color: rgb(35, 35, 51);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&bull; &nbsp; &nbsp;1 Capstone Project&nbsp;</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(35, 35, 51); box-sizing: border-box;" fr-original-style="color: rgb(35, 35, 51);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&bull; &nbsp; &nbsp;Lifetime access to our LMS where you will have free access to the trainer, other participants, and resources including knowledge videos.&nbsp;</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(35, 35, 51); box-sizing: border-box;" fr-original-style="color: rgb(35, 35, 51);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&bull; &nbsp; &nbsp;Access to our community of life-long learners.&nbsp;</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(35, 35, 51); box-sizing: border-box;" fr-original-style="color: rgb(35, 35, 51);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&bull; &nbsp; &nbsp;Downloadable Certificate you can link to your LinkedIn page&nbsp;</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(35, 35, 51); box-sizing: border-box;" fr-original-style="color: rgb(35, 35, 51);">We look forward to seeing you in Class!!!</span></p>

This course will cover Advanced concepts in DAX, Data Modeling, Power BI architectural design, and more. It is a unique blend of data modeling, data analysis, data presentation, and visualization skills. 
This instructor-led course includes: 
• 2 weeks of self-paced essential learning content that you are to complete before the instructor-led live virtual sessions begin 
• 6 instructor-led virtual sessions of 2 hours each. Each Session will have a 15-minute break. 
• Intersession Assignments that you are expected to complete and discuss in your preassigned groups during the session. 
• 1 Capstone Project 
• Lifetime access to our LMS where you will have free access to the trainer, other participants, and resources including knowledge videos. 
• Access to our community of life-long learners. 
• Downloadable Certificate you can link to your LinkedIn page 
We look forward to seeing you in Class!!!

dbrownconsulting

Business Analytics & Intelligence

Microsoft Power BI

Data Analysis Expressions

Learn advanced concepts in DAX, Data Modeling, Power BI architectural design, and more.

Advanced Reporting & Analytics with Power BI

<div data-id="84fa810" data-element_type="widget" data-widget_type="heading.default" style="color: rgb(51, 51, 51); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(51, 51, 51);"><section data-id="2f89108" data-element_type="section" style="color: rgb(51, 51, 51); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(51, 51, 51);"><div data-id="8492d0b" data-element_type="column" fr-original-style="" style="box-sizing: border-box;"><section data-id="b9a3017" data-element_type="section" fr-original-style="" style="box-sizing: border-box;"><div data-id="7611372" data-element_type="column" fr-original-style="" style="box-sizing: border-box;"><div data-id="84fa810" data-element_type="widget" data-widget_type="heading.default" fr-original-style="" style="box-sizing: border-box;"><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">OVERVIEW</h3></div><div data-id="f4d9ac0" data-element_type="widget" data-widget_type="text-editor.default" style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Prerequisites&mdash;DIAD training and Advanced Data Modeling and Shaping training or equivalent working&nbsp;experience</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This course has been designed specifically for experienced model developers and gives a more advanced treatment of DAX formulas than either DIAD or the PL-300 course. We recommend that attendees have prior experience working with Power BI Desktop to create data models.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">During this course you will&nbsp;review:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Writing DAX formulas.</li><li fr-original-style="" style="box-sizing: border-box;">Defining calculated tables and&nbsp;columns.</li><li fr-original-style="" style="box-sizing: border-box;">Defining measures.</li><li fr-original-style="" style="box-sizing: border-box;">Using DAX iterator functions.</li><li fr-original-style="" style="box-sizing: border-box;">Modifying filter context.</li><li fr-original-style="" style="box-sizing: border-box;">Using DAX time intelligence functions.</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">After completing this training, the attendees should be able to work with Data Analysis Expressions (DAX), perform calculations and define common business calculations for use in reports, address performance and functionality&nbsp;concerns.</p></div><div data-id="3268c88" data-element_type="widget" data-widget_type="heading.default" fr-original-style="" style="box-sizing: border-box;"><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">COURSE BENEFITS:</h3></div><div data-id="7a033b7" data-element_type="widget" data-widget_type="icon-list.default" fr-original-style="" style="box-sizing: border-box;"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><i style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"></i><span style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);">Understand Analytic queries in Power BI</span></li><li fr-original-style="" style="box-sizing: border-box;"><i style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"></i><span style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);">Create calculated tables, calculated columns and measures</span></li><li fr-original-style="" style="box-sizing: border-box;"><i style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"></i><span style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);">Use DAX functions and operators to build DAX formulas</span></li><li fr-original-style="" style="box-sizing: border-box;"><i style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"></i><span style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);">Use DAX iterator functions</span></li><li fr-original-style="" style="box-sizing: border-box;"><i style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"></i><span style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);">Create formulas that manipulate the filter context</span></li><li fr-original-style="" style="box-sizing: border-box;"><i style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"></i><span style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);">Use DAX time intelligence functions</span></li></ul></div><div data-id="402ee41" data-element_type="widget" data-widget_type="heading.default" fr-original-style="" style="box-sizing: border-box;"><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">WHO IS THE COURSE FOR?</h3></div><div data-id="1e62ca4" data-element_type="widget" data-widget_type="text-editor.default" style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Analysts with experience of Power BI wishing to develop more advanced formulas in DAX</li><li fr-original-style="" style="box-sizing: border-box;">Power BI developers who wish to deepen their understanding of the process of calculating formulas so as to make development faster and more reliable</li></ul></div></div></section></div></section><section data-id="a8e6ba7" data-element_type="section" style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);"><div data-id="a4bbb0a" data-element_type="column" fr-original-style="" style="box-sizing: border-box;"><section data-id="4ed22ae" data-element_type="section" fr-original-style="" style="box-sizing: border-box;"><div data-id="16c8bf1" data-element_type="column" fr-original-style="" style="box-sizing: border-box;"><div data-id="326f24d" data-element_type="widget" data-widget_type="menu-anchor.default" fr-original-style="" style="box-sizing: border-box;"></div><div data-id="9bc97d7" data-element_type="widget" data-widget_type="heading.default" fr-original-style="" style="box-sizing: border-box;"><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">LAB OUTLINE</h3></div><div data-id="ce8a9cc" data-element_type="widget" data-widget_type="toggle.default" fr-original-style="" style="box-sizing: border-box;"><div data-tab="1" tabindex="0" fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"><i fr-original-style="" style="box-sizing: border-box;"></i></span>Lab 1 Setup</div><div data-tab="1" style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Connect to data and understand the objectives of the future labs</li></ul></div><div data-tab="2" tabindex="0" fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"><i fr-original-style="" style="box-sizing: border-box;"></i></span>Lab 2 Write DAX Formulas For Power BI</div><div data-tab="2" style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Create a measure</li><li fr-original-style="" style="box-sizing: border-box;">Use variables in the measure definition</li></ul></div><div data-tab="3" tabindex="0" fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"><i fr-original-style="" style="box-sizing: border-box;"></i></span>Lab 3 Add Calculated Table And Columns</div><div data-tab="3" style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Duplicate a table</li><li fr-original-style="" style="box-sizing: border-box;">Create a hierarchy</li><li fr-original-style="" style="box-sizing: border-box;">Create a date table</li><li fr-original-style="" style="box-sizing: border-box;">Add calculated columns</li></ul></div><div data-tab="4" tabindex="0" fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"><i fr-original-style="" style="box-sizing: border-box;"></i></span>Lab 4 Add Measures To Power BI Desktop Models</div><div data-tab="4" style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Add an implicit measure to a report</li><li fr-original-style="" style="box-sizing: border-box;">Add an explicit measure</li><li fr-original-style="" style="box-sizing: border-box;">Add a compound measure</li><li fr-original-style="" style="box-sizing: border-box;">Add a quick measure</li></ul></div><div data-tab="5" tabindex="0" fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"><i fr-original-style="" style="box-sizing: border-box;"></i></span>Lab 5 Use DAX Iterator Functions In A Power BI Desktop Model</div><div data-tab="5" style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Complex summarization</li><li fr-original-style="" style="box-sizing: border-box;">Higher grain summarization</li><li fr-original-style="" style="box-sizing: border-box;">Create ranking measure</li></ul></div><div data-tab="6" tabindex="0" fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"><i fr-original-style="" style="box-sizing: border-box;"></i></span>Lab 6 Modify DAX Filter Context In Power BI Desktop Models</div><div data-tab="6" style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Apply Boolean expression filter</li><li fr-original-style="" style="box-sizing: border-box;">Remove filters: use ALL</li><li fr-original-style="" style="box-sizing: border-box;">Remove filters: use AllSelected</li><li fr-original-style="" style="box-sizing: border-box;">Preserve filters: use KeepFilters</li><li fr-original-style="" style="box-sizing: border-box;">HASONEVALUE</li><li fr-original-style="" style="box-sizing: border-box;">ISINSCOPE</li><li fr-original-style="" style="box-sizing: border-box;">Context transition</li></ul></div><div data-tab="7" tabindex="0" fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"><i fr-original-style="" style="box-sizing: border-box;"></i></span>Lab 7 Use DAX Time Intelligence Functions In Power BI Desktop Models</div><div data-tab="7" style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">TOTALYTD</li><li fr-original-style="" style="box-sizing: border-box;">SAMEPERIODLASTYEAR</li><li fr-original-style="" style="box-sizing: border-box;">Calculate new occurrences</li><li fr-original-style="" style="box-sizing: border-box;">Snapshot calculations</li></ul></div></div></div></section></div></section></div>

OVERVIEW
Prerequisites—DIAD training and Advanced Data Modeling and Shaping training or equivalent working experience
This course has been designed specifically for experienced model developers and gives a more advanced treatment of DAX formulas than either DIAD or the PL-300 course. We recommend that attendees have prior experience working with Power BI Desktop to create data models.
During this course you will review:
Writing DAX formulas.
Defining calculated tables and columns.
Defining measures.
Using DAX iterator functions.
Modifying filter context.
Using DAX time intelligence functions.
After completing this training, the attendees should be able to work with Data Analysis Expressions (DAX), perform calculations and define common business calculations for use in reports, address performance and functionality concerns.
COURSE BENEFITS:
Understand Analytic queries in Power BI
Create calculated tables, calculated columns and measures
Use DAX functions and operators to build DAX formulas
Use DAX iterator functions
Create formulas that manipulate the filter context
Use DAX time intelligence functions
WHO IS THE COURSE FOR?
Analysts with experience of Power BI wishing to develop more advanced formulas in DAX
Power BI developers who wish to deepen their understanding of the process of calculating formulas so as to make development faster and more reliable
LAB OUTLINE
Lab 1 Setup
Connect to data and understand the objectives of the future labs
Lab 2 Write DAX Formulas For Power BI
Create a measure
Use variables in the measure definition
Lab 3 Add Calculated Table And Columns
Duplicate a table
Create a hierarchy
Create a date table
Add calculated columns
Lab 4 Add Measures To Power BI Desktop Models
Add an implicit measure to a report
Add an explicit measure
Add a compound measure
Add a quick measure
Lab 5 Use DAX Iterator Functions In A Power BI Desktop Model
Complex summarization
Higher grain summarization
Create ranking measure
Lab 6 Modify DAX Filter Context In Power BI Desktop Models
Apply Boolean expression filter
Remove filters: use ALL
Remove filters: use AllSelected
Preserve filters: use KeepFilters
HASONEVALUE
ISINSCOPE
Context transition
Lab 7 Use DAX Time Intelligence Functions In Power BI Desktop Models
TOTALYTD
SAMEPERIODLASTYEAR
Calculate new occurrences
Snapshot calculations

Online Productivity Training

DAX In A Day (DAXIAD)

London

<h2>Business Process Modeling: In-House Training</h2>
 <p>This course is part of IIL's Business Analysis Certificate Program (BACP), a program designed to help prepare individuals pass the IIBA® Certification exam to become a Certified Business Analysis Professional (CBAP®). Learn more at www.iil.com/bacp</p>
 <p>A process model is a description of a process in terms of its steps or actions, the data flowing between them and participants in the process, machines, systems, and organizations involved. Modeling is a critical business analysis skill. It applies graphical and text communication techniques to describe the actions, objects, and relationships acted upon in the process and the steps that act upon them. This course teaches the technique of process modeling and ties together the core methods of process, behavior, and data modeling to enable business analysts to fully describe business processes in levels of detail from multiple perspectives.</p><h3>What you will Learn</h3>
 <p>Upon completion, participants will be able to:</p>
 <ul>
 <li>Identify business processes and their components</li>
 <li>Work with UML diagrams</li>
 <li>Use process modeling in business diagramming</li>
 <li>Diagram and model business processes</li>
 </ul><section>
                    <h3>Foundation Concepts</h3> <ul> <li>The role of the business analyst</li> <li>The IIBA® <em>BABOK® </em>Knowledge Areas</li> <li>Business Process Modeling (BPM) and the business analyst</li> <li>A practical approach to business process modeling</li> </ul> <h3>The Context for Modeling Business Processes</h3> <ul> <li>Overview of context for business process modeling</li> <li>Analyzing stakeholder information</li> <li>Modeling best practices</li> <li>Critical inputs for BPM: Business Rules</li> <li>Critical inputs for BPM: Context Diagrams</li> </ul> <h3>Data Models</h3> <ul> <li>Overview of data modeling</li> <li>Entity relationship diagrams</li> <li>Object-oriented approach</li> <li>Class diagrams</li> <li>Other data models</li> </ul> <h3>Process Models - Part I (Non-UML)</h3> <ul> <li>Overview of process modeling</li> <li>Data flow diagrams</li> <li>Workflow diagrams</li> <li>Flowcharts</li> </ul> <h3>Process Models - Part II (UML)</h3> <ul> <li>Overview of UML Process Models</li> <li>UML Activity Diagrams</li> <li>UML Sequence Diagrams</li> </ul> <h3>Usage Models - Part I (Non-UML)</h3> <ul> <li>Overview of usage modeling</li> <li>Prototyping options</li> <li>Static prototyping and storyboards</li> <li>Dynamic prototyping</li> <li>User Interface Design and user stories</li> </ul> <h3>Usage Models - Part II (UML Use Cases)</h3> <ul> <li>Overview of Use Cases</li> <li>Use Case diagrams</li> <li>Use Case descriptions</li> <li>Use Cases and the product life cycle</li> </ul> <h3>Integrating the Models</h3> <ul> <li>Overview of integrating the models</li> <li>General analysis best practices</li> <li>Specific analysis techniques summary</li> <li>Best practices for transition to design</li> </ul> <h3>Summary and Next Steps</h3> <ul> <li>What did we learn and how can we implement this in our work environments?</li> </ul>


                </section>

Business Process Modeling: In-House Training
This course is part of IIL's Business Analysis Certificate Program (BACP), a program designed to help prepare individuals pass the IIBA® Certification exam to become a Certified Business Analysis Professional (CBAP®). Learn more at www.iil.com/bacp
A process model is a description of a process in terms of its steps or actions, the data flowing between them and participants in the process, machines, systems, and organizations involved. Modeling is a critical business analysis skill. It applies graphical and text communication techniques to describe the actions, objects, and relationships acted upon in the process and the steps that act upon them. This course teaches the technique of process modeling and ties together the core methods of process, behavior, and data modeling to enable business analysts to fully describe business processes in levels of detail from multiple perspectives.
What you will Learn
Upon completion, participants will be able to:
Identify business processes and their components
Work with UML diagrams
Use process modeling in business diagramming
Diagram and model business processes
Foundation Concepts
The role of the business analyst
The IIBA® BABOK® Knowledge Areas
Business Process Modeling (BPM) and the business analyst
A practical approach to business process modeling
The Context for Modeling Business Processes
Overview of context for business process modeling
Analyzing stakeholder information
Modeling best practices
Critical inputs for BPM: Business Rules
Critical inputs for BPM: Context Diagrams
Data Models
Overview of data modeling
Entity relationship diagrams
Object-oriented approach
Class diagrams
Other data models
Process Models - Part I (Non-UML)
Overview of process modeling
Data flow diagrams
Workflow diagrams
Flowcharts
Process Models - Part II (UML)
Overview of UML Process Models
UML Activity Diagrams
UML Sequence Diagrams
Usage Models - Part I (Non-UML)
Overview of usage modeling
Prototyping options
Static prototyping and storyboards
Dynamic prototyping
User Interface Design and user stories
Usage Models - Part II (UML Use Cases)
Overview of Use Cases
Use Case diagrams
Use Case descriptions
Use Cases and the product life cycle
Integrating the Models
Overview of integrating the models
General analysis best practices
Specific analysis techniques summary
Best practices for transition to design
Summary and Next Steps
What did we learn and how can we implement this in our work environments?

IIL Europe Ltd

Business Process Model & Notation (BPMN)

Business Process Management (BPM)

Process Modelling

Business Process Modeling

Building Information Modeling

Data Modeling

Business Process Modeling: In-House Training

<h2>Business Process Modeling: Virtual In-House Training</h2>
 <p>This course is part of IIL's Business Analysis Certificate Program (BACP), a program designed to help prepare individuals pass the IIBA® Certification exam to become a Certified Business Analysis Professional (CBAP®). Learn more at www.iil.com/bacp</p>
 <p>A process model is a description of a process in terms of its steps or actions, the data flowing between them and participants in the process, machines, systems, and organizations involved. Modeling is a critical business analysis skill. It applies graphical and text communication techniques to describe the actions, objects, and relationships acted upon in the process and the steps that act upon them. This course teaches the technique of process modeling and ties together the core methods of process, behavior, and data modeling to enable business analysts to fully describe business processes in levels of detail from multiple perspectives.</p><h3>What you will Learn</h3>
 <p>Upon completion, participants will be able to:</p>
 <ul>
 <li>Identify business processes and their components</li>
 <li>Work with UML diagrams</li>
 <li>Use process modeling in business diagramming</li>
 <li>Diagram and model business processes</li>
 </ul><section>
                    <h3>Foundation Concepts</h3> <ul> <li>The role of the business analyst</li> <li>The IIBA® <em>BABOK® </em>Knowledge Areas</li> <li>Business Process Modeling (BPM) and the business analyst</li> <li>A practical approach to business process modeling</li> </ul> <h3>The Context for Modeling Business Processes</h3> <ul> <li>Overview of context for business process modeling</li> <li>Analyzing stakeholder information</li> <li>Modeling best practices</li> <li>Critical inputs for BPM: Business Rules</li> <li>Critical inputs for BPM: Context Diagrams</li> </ul> <h3>Data Models</h3> <ul> <li>Overview of data modeling</li> <li>Entity relationship diagrams</li> <li>Object-oriented approach</li> <li>Class diagrams</li> <li>Other data models</li> </ul> <h3>Process Models - Part I (Non-UML)</h3> <ul> <li>Overview of process modeling</li> <li>Data flow diagrams</li> <li>Workflow diagrams</li> <li>Flowcharts</li> </ul> <h3>Process Models - Part II (UML)</h3> <ul> <li>Overview of UML Process Models</li> <li>UML Activity Diagrams</li> <li>UML Sequence Diagrams</li> </ul> <h3>Usage Models - Part I (Non-UML)</h3> <ul> <li>Overview of usage modeling</li> <li>Prototyping options</li> <li>Static prototyping and storyboards</li> <li>Dynamic prototyping</li> <li>User Interface Design and user stories</li> </ul> <h3>Usage Models - Part II (UML Use Cases)</h3> <ul> <li>Overview of Use Cases</li> <li>Use Case diagrams</li> <li>Use Case descriptions</li> <li>Use Cases and the product life cycle</li> </ul> <h3>Integrating the Models</h3> <ul> <li>Overview of integrating the models</li> <li>General analysis best practices</li> <li>Specific analysis techniques summary</li> <li>Best practices for transition to design</li> </ul> <h3>Summary and Next Steps</h3> <ul> <li>What did we learn and how can we implement this in our work environments?</li> </ul>


                </section>

Business Process Modeling: Virtual In-House Training
This course is part of IIL's Business Analysis Certificate Program (BACP), a program designed to help prepare individuals pass the IIBA® Certification exam to become a Certified Business Analysis Professional (CBAP®). Learn more at www.iil.com/bacp
A process model is a description of a process in terms of its steps or actions, the data flowing between them and participants in the process, machines, systems, and organizations involved. Modeling is a critical business analysis skill. It applies graphical and text communication techniques to describe the actions, objects, and relationships acted upon in the process and the steps that act upon them. This course teaches the technique of process modeling and ties together the core methods of process, behavior, and data modeling to enable business analysts to fully describe business processes in levels of detail from multiple perspectives.
What you will Learn
Upon completion, participants will be able to:
Identify business processes and their components
Work with UML diagrams
Use process modeling in business diagramming
Diagram and model business processes
Foundation Concepts
The role of the business analyst
The IIBA® BABOK® Knowledge Areas
Business Process Modeling (BPM) and the business analyst
A practical approach to business process modeling
The Context for Modeling Business Processes
Overview of context for business process modeling
Analyzing stakeholder information
Modeling best practices
Critical inputs for BPM: Business Rules
Critical inputs for BPM: Context Diagrams
Data Models
Overview of data modeling
Entity relationship diagrams
Object-oriented approach
Class diagrams
Other data models
Process Models - Part I (Non-UML)
Overview of process modeling
Data flow diagrams
Workflow diagrams
Flowcharts
Process Models - Part II (UML)
Overview of UML Process Models
UML Activity Diagrams
UML Sequence Diagrams
Usage Models - Part I (Non-UML)
Overview of usage modeling
Prototyping options
Static prototyping and storyboards
Dynamic prototyping
User Interface Design and user stories
Usage Models - Part II (UML Use Cases)
Overview of Use Cases
Use Case diagrams
Use Case descriptions
Use Cases and the product life cycle
Integrating the Models
Overview of integrating the models
General analysis best practices
Specific analysis techniques summary
Best practices for transition to design
Summary and Next Steps
What did we learn and how can we implement this in our work environments?

Business Process Modeling: Virtual In-House Training

<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p>The Power BI in a Day course is designed for beginners and intermediate users of Power BI.</p>Overview<p>#NAME?</p><p>Students will discover the full capabilities of Power BI in a one-day, hands-on workshop. Please Note: This workshop is primarily self-directed and students will work at their own pace while having access to an instructor for questions.</p></div><div id="course-pills-2"><h3>1 - Accessing &amp; Preparing data</h3> <ul> <li>Data Set</li> <li>Power BI Desktop</li> <li>Power BI Desktop ? Accessing Data</li> <li>Power BI Desktop ? Data Preparation</li> </ul> <h3>2 - Data Modeling and Exploration</h3> <ul> <li>Power BI Desktop ? Data Modeling and Exploration</li> <li>Power BI Desktop ? Data Exploration Continued</li> <li>References</li> </ul> <h3>3 - Data Visualization</h3> <ul> <li>Power BI Desktop</li> <li>Power BI Desktop ? Data Visualization</li> <li>References</li> </ul> <h3>4 - Publishing &amp; Accessing Reports</h3> <ul> <li>Power BI Desktop ? Creating Mobile View</li> <li>Power BI Service</li> <li>Power BI Service ? Publishing Report</li> <li>Power BI Mobile ? Accessing Report on Mobile Device</li> <li>Power BI Service ? Collaboration and Distribution</li> <li>References</li> </ul> <h3>5 - Dashboard and Collaboration</h3> <ul> <li>Power BI Service</li> <li>Building Dashboard</li> <li>References</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Power BI: Dashboard in a Day training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the Power BI: Dashboard in a Day course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Duration
1 Days
6 CPD hours
This course is intended for
The Power BI in a Day course is designed for beginners and intermediate users of Power BI.
Overview
#NAME?
Students will discover the full capabilities of Power BI in a one-day, hands-on workshop. Please Note: This workshop is primarily self-directed and students will work at their own pace while having access to an instructor for questions.
1 - Accessing & Preparing data
Data Set
Power BI Desktop
Power BI Desktop ? Accessing Data
Power BI Desktop ? Data Preparation
2 - Data Modeling and Exploration
Power BI Desktop ? Data Modeling and Exploration
Power BI Desktop ? Data Exploration Continued
References
3 - Data Visualization
Power BI Desktop
Power BI Desktop ? Data Visualization
References
4 - Publishing & Accessing Reports
Power BI Desktop ? Creating Mobile View
Power BI Service
Power BI Service ? Publishing Report
Power BI Mobile ? Accessing Report on Mobile Device
Power BI Service ? Collaboration and Distribution
References
5 - Dashboard and Collaboration
Power BI Service
Building Dashboard
References
Additional course details:
Nexus Humans Power BI: Dashboard in a Day training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. 

This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts.

Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.

While we feel this is the best course for the Power BI: Dashboard in a Day course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.

Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.


Nexus Human

Powerbi

Tableau Desktop Specialist

Microsoft Power Platform

Microsoft BI

Power BI: Dashboard in a Day

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p></p><p>Senior Consultants (both functional and technical) that aspire to be Solution Architects, or current Solution Architects that are new to the role.</p><p></p><p>The Solution Architect is responsible for the successful design, implementation, deployment and adoption of an overall solution. The Solution Architect ensures that the solution meets the customer?s needs now and in the future. In this course, students will learn about decisions a Solution Architect makes during an implementation, covering security, integrations, Power Apps architecture, Power Automate architecture, and more. This course is designed to give you an introduction to the Solution Architect role.<br /></p></div><div id="course-pills-2"><h4>Becoming a Solution Architect/Getting to know your customer</h4><ul><li>Define a Solution Architect</li><li>Role of a Solution Architect on projects</li><li>Project Methodology</li><li>Getting to know your customer</li><li>Group exercise - Getting to know your customer</li></ul><h4>Conceptualizing the design from requirements</h4><ul><li>How to lead the requirement collection effort</li><li>Using fit gap analysis</li><li>Pillars of good architecture</li><li>Blueprinting the solution architecture</li><li>Group exercise - Design from requirements</li><li></li></ul><h4>Project governance and working as a team</h4><ul><li>Solution Architect's role in project governance</li><li>Techniques for keeping a project on track</li><li>Scenarios that could cause a project to fail</li><li>Group exercise - Project governance and working as a team</li><li></li></ul><h4>Power Platform Architecture</h4><ul><li>Key Power Platform architecture components</li><li>Understand how platform design and limits influence solution architectures</li><li>Updates and feature releases</li><li>Understand how to communicate how the platform meets customer needs</li><li></li></ul><h4>Data Modeling</h4><ul><li>Data model influences</li><li>Data model strategy</li><li>Data types</li><li>Data relationships</li><li>Group exercise - Data modeling</li><li></li></ul><h4>Analytics and artificial intelligence</h4><ul><li>Planning and evaluating requirements</li><li>Operational reporting</li><li>Power BI</li><li>Enterprise BI</li><li>Pre-built insights and custom AI</li><li></li></ul><h4>Power Apps Architecture</h4><ul><li>Discuss options for apps and how to choose where to start</li><li>Discuss app composition options</li><li>Using components as part of your app architecture</li><li>Considerations for including Portals as an app in your architecture</li><li>Group exercise - Power Apps Architecture topics</li><li></li></ul><h4>Application Lifecycle Management (ALM)</h4><ul><li>Microsoft vision and Solution Architect's role in ALM</li><li>Environment strategies</li><li>Defning a solution structure for your deliverable</li><li></li></ul><h4>Power Automate Architecture</h4><ul><li>Discuss options for automation and custom logic</li><li>Review considerations for using triggers and common actions</li><li>Explore using Business Process Flows (BPF) to guide users through business processes</li><li>Group Exercise - Evaluate scenarios for Power Automate usage</li><li></li></ul><h4>Security Modeling</h4><ul><li>Solution Architect's role in security modeling</li><li>Discovery and learning your client's environment</li><li>Controlling access to environments and resources</li><li>Controlling access to CDS Data</li><li>Group Exercise - Security Modeling</li><li></li></ul><h4>Integration</h4><ul><li>Solution Architects role in Integrations</li><li>What is an integration and why do we need it</li><li>Platform features that enable integration</li><li>CDS Event Publishing</li><li>Scenarios for group discussion</li><li></li></ul><h4>Dynamics 365 Applications Architecture</h4><ul><li>Solution Architect's role when deploying Dynamics 365 apps</li><li>Architecture Considerations for primary apps</li><li>Group Exercise - App specific working groups evaluate requirements</li><li></li></ul><h4>Power Virtual Agents architecture</h4><ul><li>Introduction</li><li>Chatbot options</li><li>Chatbot concepts</li><li>Best practices</li><li>Integrate chatbots</li><li>Power Virtual Agents in Microsoft Teams</li><li></li></ul><h4>Robotic Process Automation</h4><ul><li>Introduction</li><li>Power Automate Desktop</li><li>Recording and editing tasks</li><li>Running desktop flows</li><li>Process advisor</li><li></li></ul><h4>Testing and Go Live</h4><ul><li>Solution Architect's role with testing and go live</li><li>Planning for testing</li><li>Planning for go live</li><li></li></ul></div>

Duration
3 Days
18 CPD hours
This course is intended for

Senior Consultants (both functional and technical) that aspire to be Solution Architects, or current Solution Architects that are new to the role.

The Solution Architect is responsible for the successful design, implementation, deployment and adoption of an overall solution. The Solution Architect ensures that the solution meets the customer?s needs now and in the future. In this course, students will learn about decisions a Solution Architect makes during an implementation, covering security, integrations, Power Apps architecture, Power Automate architecture, and more. This course is designed to give you an introduction to the Solution Architect role.

Becoming a Solution Architect/Getting to know your customer
Define a Solution Architect
Role of a Solution Architect on projects
Project Methodology
Getting to know your customer
Group exercise - Getting to know your customer
Conceptualizing the design from requirements
How to lead the requirement collection effort
Using fit gap analysis
Pillars of good architecture
Blueprinting the solution architecture
Group exercise - Design from requirements

Project governance and working as a team
Solution Architect's role in project governance
Techniques for keeping a project on track
Scenarios that could cause a project to fail
Group exercise - Project governance and working as a team

Power Platform Architecture
Key Power Platform architecture components
Understand how platform design and limits influence solution architectures
Updates and feature releases
Understand how to communicate how the platform meets customer needs

Data Modeling
Data model influences
Data model strategy
Data types
Data relationships
Group exercise - Data modeling

Analytics and artificial intelligence
Planning and evaluating requirements
Operational reporting
Power BI
Enterprise BI
Pre-built insights and custom AI

Power Apps Architecture
Discuss options for apps and how to choose where to start
Discuss app composition options
Using components as part of your app architecture
Considerations for including Portals as an app in your architecture
Group exercise - Power Apps Architecture topics

Application Lifecycle Management (ALM)
Microsoft vision and Solution Architect's role in ALM
Environment strategies
Defning a solution structure for your deliverable

Power Automate Architecture
Discuss options for automation and custom logic
Review considerations for using triggers and common actions
Explore using Business Process Flows (BPF) to guide users through business processes
Group Exercise - Evaluate scenarios for Power Automate usage

Security Modeling
Solution Architect's role in security modeling
Discovery and learning your client's environment
Controlling access to environments and resources
Controlling access to CDS Data
Group Exercise - Security Modeling

Integration
Solution Architects role in Integrations
What is an integration and why do we need it
Platform features that enable integration
CDS Event Publishing
Scenarios for group discussion

Dynamics 365 Applications Architecture
Solution Architect's role when deploying Dynamics 365 apps
Architecture Considerations for primary apps
Group Exercise - App specific working groups evaluate requirements

Power Virtual Agents architecture
Introduction
Chatbot options
Chatbot concepts
Best practices
Integrate chatbots
Power Virtual Agents in Microsoft Teams

Robotic Process Automation
Introduction
Power Automate Desktop
Recording and editing tasks
Running desktop flows
Process advisor

Testing and Go Live
Solution Architect's role with testing and go live
Planning for testing
Planning for go live


Microsoft Power Apps

Power Apps

Microsoft AZ-700

Microsoft Power Automate

AWS Certified Solutions Architect

PL-600T00 Power Platform Solution Architect

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>The primary audience for this course is people who are moving into a database role, or whose role has expanded to include database technologies. Developers that deliver content from SQL Server databases will also benefit from this material.</p>Overview<p>After completing this course, you will be able to:<br />Describe key database concepts in the context of SQL Server<br />Describe database languages used in SQL Server<br />Describe data modelling techniques<br />Describe normalization and denormalization techniques<br />Describe relationship types and effects in database design<br />Describe the effects of database design on performance<br />Describe commonly used database objects</p><p>This course is provided as an introductory class for anyone getting started with databases. It will be useful to programmers and other IT professionals whose job roles are expanding into database management. Students will learn fundamental database concepts through demonstrations and hands-on labs on a SQL Server instance.<br />This material updates and replaces course Microsoft course 10985 which was previously published under the same title.</p></div><div id="course-pills-2"><h4>Module 1: Introduction to databases</h4><ul><li>Introduction to Relational Databases</li><li>Other Databases and Storage</li><li>Data Analysis</li><li>SQL Server Database Languages</li></ul><h4>Module 2: Data Modeling</h4><ul><li>Data Modelling</li><li>Designing a Database</li><li>Relationship Modeling</li></ul><h4>Module 3: Normalization</h4><ul><li>Fundamentals of Normalization</li><li>Normal Form</li><li>Denormalization</li></ul><h4>Module 4: Relationships</h4><ul><li>Introduction to Relationships</li><li>Planning Referential Integrity</li></ul><h4>Module 5: Performance</h4><ul><li>Indexing</li><li>Query Performance</li><li>Concurrency</li></ul><h4>Module 6: Database Objects</h4><ul><li>Tables</li><li>Views</li><li>Stored Procedures, Triggers and Functions</li></ul></div>

Duration
3 Days
18 CPD hours
This course is intended for
The primary audience for this course is people who are moving into a database role, or whose role has expanded to include database technologies. Developers that deliver content from SQL Server databases will also benefit from this material.
Overview
After completing this course, you will be able to:
Describe key database concepts in the context of SQL Server
Describe database languages used in SQL Server
Describe data modelling techniques
Describe normalization and denormalization techniques
Describe relationship types and effects in database design
Describe the effects of database design on performance
Describe commonly used database objects
This course is provided as an introductory class for anyone getting started with databases. It will be useful to programmers and other IT professionals whose job roles are expanding into database management. Students will learn fundamental database concepts through demonstrations and hands-on labs on a SQL Server instance.
This material updates and replaces course Microsoft course 10985 which was previously published under the same title.
Module 1: Introduction to databases
Introduction to Relational Databases
Other Databases and Storage
Data Analysis
SQL Server Database Languages
Module 2: Data Modeling
Data Modelling
Designing a Database
Relationship Modeling
Module 3: Normalization
Fundamentals of Normalization
Normal Form
Denormalization
Module 4: Relationships
Introduction to Relationships
Planning Referential Integrity
Module 5: Performance
Indexing
Query Performance
Concurrency
Module 6: Database Objects
Tables
Views
Stored Procedures, Triggers and Functions

Microsoft SQL Server

Microsoft SQL

AWS Certified Database

SQL Server

Trainers Course

Database Administration

55315: Introduction to SQL Databases

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>Overview<p>The goal of this course is to enable technical students new to Cassandra to begin working with Cassandra in an optimal manner.  Throughout the course students will learn to:<br />Understand the Big Data needs that C* addresses<br />Be familiar with the operation and structure of C*<br />Be able to install and set up a C* database<br />Use the C* tools, including cqlsh, nodetool, and ccm (Cassandra Cluster Manager)<br />Be familiar with the C* architecture, and how a C* cluster is structured<br />Understand how data is distributed and replicated in a C* cluster<br />Understand core C* data modeling concepts, and use them to create well-structured data models<br />Be familiar with the C* eventual consistency model and use it intelligently<br />Be familiar with consistency mechanisms such as read repair and hinted handoff<br />Understand and use CQL to create tables and query for data<br />Know and use the CQL data types (numerical, textual, uuid, etc.)<br />Be familiar with the various kinds of primary keys available (simple, compound, and composite primary keys)<br />Be familiar with the C* write and read paths<br />Understand C* deletion and compaction</p><p>The Cassandra (C*) database is a massively scalable NoSQL database that provides high availability and fault tolerance, as well as linear scalability when adding new nodes to a cluster. It has many powerful capabilities, such as tunable and eventual consistency, that allow it to meet the needs of modern applications, but also introduce a new paradigm for data modeling that many organizations do not have the expertise to use in the best way.Introduction to Cassandra is a hands-on course designed to teach attendees the basics of how to create good data models with Cassandra.  This technical course has a focus on the practical aspects of working with C*, and introduces essential concepts needed to understand Cassandra, including enough coverage of internal architecture to make good decisions. It is hands-on, with labs that provide experience in core functionality. Students will also explore CQL (Cassandra Query Language), as well as some of the ?anti-patterns? that lead to non-optimal C* data models and be ready to work on production systems involving Cassandra.</p></div><div id="course-pills-2"><h4>Session 1: Cassandra Overview</h4><ul><li>Why We Need Cassandra - Big Data Challenges vs RDBMS</li><li>High level Cassandra Overview</li><li>Cassandra Features</li><li>Optional: Basic Cassandra Installation and Configuration</li></ul><h4>Session 2: Cassandra Architecture and CQL Overview</h4><ul><li>Cassandra Architecture Overview</li><li>Cassandra Clusters and Rings</li><li>Nodes and Virtual Nodes</li><li>Data Replication in Cassandra</li><li>Introduction to CQL</li><li>Defining Tables with a Single Primary Key</li><li>Using cqlsh for Interactive Querying</li><li>Selecting and Inserting/Upserting Data with CQL</li><li>Data Replication and Distribution</li><li>Basic Data Types (including uuid, timeuuid)</li></ul><h4>Session 3: Data Modeling and CQL Core Concepts</h4><ul><li>Defining a Compound Primary Key</li><li>CQL for Compound Primary Keys</li><li>Partition Keys and Data Distribution</li><li>Clustering Columns</li><li>Overview of Internal Data Organization</li><li>Overview of Other Querying Capabilities</li><li>ORDER BY, CLUSTERING ORDER BY, UPDATE , DELETE,  ALLOW FILTERING</li><li>Batch Queries</li><li>Data Modeling Guidelines</li><li>Denormalization</li><li>Data Modeling Workflow</li><li>Data Modeling Principles</li><li>Primary Key Considerations</li><li>Composite Partition Keys</li><li>Defining with CQL</li><li>Data Distribution with Composite Partition Key</li><li>Overview of Internal Data Organization</li></ul><h4>Session 4: Additional CQL Capabilities</h4><ul><li>Indexing</li><li>Primary/Partition Keys and Pagination with token()</li><li>Secondary Indexes and Usage Guidelines</li><li>Cassandra collections</li><li>Collection Structure and Uses</li><li>Defining and Querying Collections (set, list, and map)</li><li>Materialized View</li><li>Overview</li><li>Usage Guidelines</li></ul><h4>Session 5: Data Consistency In Cassandra</h4><ul><li>Overview of Consistency in Cassandra</li><li>CAP Theorem</li><li>Eventual (Tunable) Consistency in C* - ONE, QUORUM, ALL</li><li>Choosing CL ONE</li><li>Choosing CL QUORUM</li><li>Achieving Immediate Consistency</li><li>Overview of Other Consistency Levels</li><li>Supportive Consistency Mechanisms</li><li>Writing / Hinted Handoff</li><li>Read Repair</li><li>Nodetool repair</li></ul><h4>Session 6: Internal Mechanisms</h4><ul><li>Ring Details</li><li>Partitioners</li><li>Gossip Protocol</li><li>Snitches</li><li>Write Path</li><li>Overview / Commit Log</li><li>Memtables and SSTables</li><li>Write Failure</li><li>Unavailable Nodes and Node Failure</li><li>Requirements for Write Operations</li><li>Read Path Overview</li><li>Read Mechanism</li><li>Replication and Caching</li><li>Deletion/Compaction Overview</li><li>Delete Mechanism</li><li>Tombstones and Compaction</li></ul><h4>Session 7: Working with IntelliJ</h4><ul><li>Configuring JDBC Data Source for Cassandra</li><li>Reading Schema Information</li><li>Querying and Editing Tables.</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Introduction to Cassandra  (TTDS6776) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the Introduction to Cassandra  (TTDS6776) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Duration
3 Days
18 CPD hours
Overview
The goal of this course is to enable technical students new to Cassandra to begin working with Cassandra in an optimal manner. Throughout the course students will learn to:
Understand the Big Data needs that C* addresses
Be familiar with the operation and structure of C*
Be able to install and set up a C* database
Use the C* tools, including cqlsh, nodetool, and ccm (Cassandra Cluster Manager)
Be familiar with the C* architecture, and how a C* cluster is structured
Understand how data is distributed and replicated in a C* cluster
Understand core C* data modeling concepts, and use them to create well-structured data models
Be familiar with the C* eventual consistency model and use it intelligently
Be familiar with consistency mechanisms such as read repair and hinted handoff
Understand and use CQL to create tables and query for data
Know and use the CQL data types (numerical, textual, uuid, etc.)
Be familiar with the various kinds of primary keys available (simple, compound, and composite primary keys)
Be familiar with the C* write and read paths
Understand C* deletion and compaction
The Cassandra (C*) database is a massively scalable NoSQL database that provides high availability and fault tolerance, as well as linear scalability when adding new nodes to a cluster. It has many powerful capabilities, such as tunable and eventual consistency, that allow it to meet the needs of modern applications, but also introduce a new paradigm for data modeling that many organizations do not have the expertise to use in the best way.Introduction to Cassandra is a hands-on course designed to teach attendees the basics of how to create good data models with Cassandra. This technical course has a focus on the practical aspects of working with C*, and introduces essential concepts needed to understand Cassandra, including enough coverage of internal architecture to make good decisions. It is hands-on, with labs that provide experience in core functionality. Students will also explore CQL (Cassandra Query Language), as well as some of the ?anti-patterns? that lead to non-optimal C* data models and be ready to work on production systems involving Cassandra.
Session 1: Cassandra Overview
Why We Need Cassandra - Big Data Challenges vs RDBMS
High level Cassandra Overview
Cassandra Features
Optional: Basic Cassandra Installation and Configuration
Session 2: Cassandra Architecture and CQL Overview
Cassandra Architecture Overview
Cassandra Clusters and Rings
Nodes and Virtual Nodes
Data Replication in Cassandra
Introduction to CQL
Defining Tables with a Single Primary Key
Using cqlsh for Interactive Querying
Selecting and Inserting/Upserting Data with CQL
Data Replication and Distribution
Basic Data Types (including uuid, timeuuid)
Session 3: Data Modeling and CQL Core Concepts
Defining a Compound Primary Key
CQL for Compound Primary Keys
Partition Keys and Data Distribution
Clustering Columns
Overview of Internal Data Organization
Overview of Other Querying Capabilities
ORDER BY, CLUSTERING ORDER BY, UPDATE , DELETE, ALLOW FILTERING
Batch Queries
Data Modeling Guidelines
Denormalization
Data Modeling Workflow
Data Modeling Principles
Primary Key Considerations
Composite Partition Keys
Defining with CQL
Data Distribution with Composite Partition Key
Overview of Internal Data Organization
Session 4: Additional CQL Capabilities
Indexing
Primary/Partition Keys and Pagination with token()
Secondary Indexes and Usage Guidelines
Cassandra collections
Collection Structure and Uses
Defining and Querying Collections (set, list, and map)
Materialized View
Overview
Usage Guidelines
Session 5: Data Consistency In Cassandra
Overview of Consistency in Cassandra
CAP Theorem
Eventual (Tunable) Consistency in C* - ONE, QUORUM, ALL
Choosing CL ONE
Choosing CL QUORUM
Achieving Immediate Consistency
Overview of Other Consistency Levels
Supportive Consistency Mechanisms
Writing / Hinted Handoff
Read Repair
Nodetool repair
Session 6: Internal Mechanisms
Ring Details
Partitioners
Gossip Protocol
Snitches
Write Path
Overview / Commit Log
Memtables and SSTables
Write Failure
Unavailable Nodes and Node Failure
Requirements for Write Operations
Read Path Overview
Read Mechanism
Replication and Caching
Deletion/Compaction Overview
Delete Mechanism
Tombstones and Compaction
Session 7: Working with IntelliJ
Configuring JDBC Data Source for Cassandra
Reading Schema Information
Querying and Editing Tables.
Additional course details:
Nexus Humans Introduction to Cassandra (TTDS6776) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. 

This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts.

Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.

While we feel this is the best course for the Introduction to Cassandra (TTDS6776) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.

Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.


Certified Technology Specialist (CTS)

Introduction to Cassandra  (TTDS6776)

<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p></p><p>The audience for this course is individuals who want to learn the fundamentals of database concepts in a cloud environment, get basic skilling in cloud data services, and build their foundational knowledge of cloud data services within Microsoft Azure.</p><p></p>Overview<p>Describe core data concepts Identify considerations for relational data on Azure Describe considerations for working with non-relational data on Azure Describe an analytics workload on Azure</p><p></p><p>In this course, students will gain foundational knowledge of core data concepts and related Microsoft Azure data services. Students will learn about core data concepts such as relational, non-relational, big data, and analytics, and build their foundational knowledge of cloud data services within Microsoft Azure. Students will explore fundamental relational data concepts and relational database services in Azure. They will explore Azure storage for non-relational data and the fundamentals of Azure Cosmos DB. Students will learn about large-scale data warehousing, real-time analytics, and data visualization.</p><p></p></div><div id="course-pills-2"><h3>1 - Explore core data concepts</h3> <ul> <li>Identify data formats</li> <li>Explore file storage</li> <li>Explore databases</li> <li>Explore transactional data processing</li> <li>Explore analytical data processing</li> </ul> <h3>2 - Explore data roles and services</h3> <ul> <li>Explore job roles in the world of data</li> <li>Identify data services</li> </ul> <h3>3 - Explore fundamental relational data concepts</h3> <ul> <li>Understand relational data</li> <li>Understand normalization</li> <li>Explore SQL</li> <li>Describe database objects</li> </ul> <h3>4 - Explore relational database services in Azure</h3> <ul> <li>Describe Azure SQL services and capabilities</li> <li>Describe Azure services for open-source databases</li> </ul> <h3>5 - Explore Azure Storage for non-relational data</h3> <ul> <li>Explore Azure blob storage</li> <li>Explore Azure DataLake Storage Gen2</li> <li>Explore Azure Files</li> <li>Explore Azure Tables</li> </ul> <h3>6 - Explore fundamentals of Azure Cosmos DB</h3> <ul> <li>Describe Azure Cosmos DB</li> <li>Identify Azure Cosmos DB APIs</li> </ul> <h3>7 - Explore fundamentals of large-scale data warehousing</h3> <ul> <li>Describe data warehousing architecture</li> <li>Explore data ingestion pipelines</li> <li>Explore analytical data stores</li> </ul> <h3>8 - Explore fundamentals of real-time analytics</h3> <ul> <li>Understand batch and stream processing</li> <li>Explore common elements of stream processing architecture</li> <li>Explore Azure Stream Analytics</li> <li>Explore Apache Spark on Microsoft Azure</li> </ul> <h3>9 - Explore fundamentals of data visualization</h3> <ul> <li>Describe Power BI tools and workflow</li> <li>Describe core concepts of data modeling</li> <li>Describe considerations for data visualization</li> </ul></div>

Duration
1 Days
6 CPD hours
This course is intended for

The audience for this course is individuals who want to learn the fundamentals of database concepts in a cloud environment, get basic skilling in cloud data services, and build their foundational knowledge of cloud data services within Microsoft Azure.

Overview
Describe core data concepts Identify considerations for relational data on Azure Describe considerations for working with non-relational data on Azure Describe an analytics workload on Azure

In this course, students will gain foundational knowledge of core data concepts and related Microsoft Azure data services. Students will learn about core data concepts such as relational, non-relational, big data, and analytics, and build their foundational knowledge of cloud data services within Microsoft Azure. Students will explore fundamental relational data concepts and relational database services in Azure. They will explore Azure storage for non-relational data and the fundamentals of Azure Cosmos DB. Students will learn about large-scale data warehousing, real-time analytics, and data visualization.

1 - Explore core data concepts
Identify data formats
Explore file storage
Explore databases
Explore transactional data processing
Explore analytical data processing
2 - Explore data roles and services
Explore job roles in the world of data
Identify data services
3 - Explore fundamental relational data concepts
Understand relational data
Understand normalization
Explore SQL
Describe database objects
4 - Explore relational database services in Azure
Describe Azure SQL services and capabilities
Describe Azure services for open-source databases
5 - Explore Azure Storage for non-relational data
Explore Azure blob storage
Explore Azure DataLake Storage Gen2
Explore Azure Files
Explore Azure Tables
6 - Explore fundamentals of Azure Cosmos DB
Describe Azure Cosmos DB
Identify Azure Cosmos DB APIs
7 - Explore fundamentals of large-scale data warehousing
Describe data warehousing architecture
Explore data ingestion pipelines
Explore analytical data stores
8 - Explore fundamentals of real-time analytics
Understand batch and stream processing
Explore common elements of stream processing architecture
Explore Azure Stream Analytics
Explore Apache Spark on Microsoft Azure
9 - Explore fundamentals of data visualization
Describe Power BI tools and workflow
Describe core concepts of data modeling
Describe considerations for data visualization

Educators providing Data Modeling courses in Birmingham delivered Live Online