LEARNFAST CMS

Course Name

CRM Qualification Value

Netsuite Product

Course Level

None Beginner Intermediate Advanced

Show Page Title

Yes, Show the page title No, Hide the page title

Header Block

Information Block Contact Form Block

Background Fill

Yes No

Publish

Learning Methods

Instructor-Led Classes Mentored Learning Distance Learning

Instructor-Led Classes

Online learning

Title

Title Background color

Block Colour

Dashboard Image

Category

External link

Accreditation

Promo

Accredited by
Credit Details

Full Time Fee Part Time Fee Online Cost Cost Terms

Registration Fee Laptop Cost Laptop Registration Fees

Core Spec Med Spec High Spec

Laptop Terms

Terms

Installments

2M 3M 6M 9M 12M 18M 24M Early Bird Discount 10%

Page Title

Price Description

Payment Terms

Overview

<p aria-level="1" paraeid="{810a7292-7b1f-48c8-b417-86ffc4b7e44a}{135}" paraid="334772353" role="heading"><span style="font-family:segoe ui;"><span style="font-size:14px;">Welcome to the <strong>Analyzing Data with Microsoft Power BI</strong> course. </span></span></p>

<p paraeid="{810a7292-7b1f-48c8-b417-86ffc4b7e44a}{159}" paraid="1508506118"><span style="font-family:segoe ui;"><span style="font-size:14px;">This four-day course will discuss the various methods and best practices that are in line with business and technical requirements for <strong>modeling, visualizing, and analyzing data with Power BI.</strong> The course will also show how to <strong>access and process</strong> data from a <strong>range of data sources</strong> including both relational and non-relational data. This course will also explore how to implement proper security standards and policies across the Power BI spectrum including datasets and groups.  </span></span></p>

<p paraeid="{810a7292-7b1f-48c8-b417-86ffc4b7e44a}{197}" paraid="475616491"><span style="font-family:segoe ui;"><span style="font-size:14px;">The course will also discuss how to manage and deploy <strong>reports and dashboards</strong> for sharing and content distribution. Finally, this course will show how to <strong>build paginated reports</strong> within the Power BI service and publish them to a workspace for inclusion within Power BI. </span></span></p>

<p paraeid="{810a7292-7b1f-48c8-b417-86ffc4b7e44a}{215}" paraid="724548523"><span style="font-family:segoe ui;"><span style="font-size:14px;"><strong>Job role: </strong>Developer </span></span></p>

<p paraeid="{810a7292-7b1f-48c8-b417-86ffc4b7e44a}{225}" paraid="1807799375"><span style="font-family:segoe ui;"><span style="font-size:14px;"></span></span><span style="font-size:18px;"><span style="font-family:segoe ui;"><strong>Features & Benefits</strong></span></span></p>

<ul>
	<li><span style="font-size:14px;"><span style="font-family:segoe ui;"><span style="font-size:14px;"><span style="font-family:segoe ui;"><span style="font-size:14px;"><span style="font-family:segoe ui;"></span></span><span style="font-family:segoe ui;"><span style="font-size:14px;">This is an authorised <strong>Microsoft Official Course (MOC)</strong>, a preparation course for <a href="https://docs.microsoft.com/en-us/learn/certifications/exams/da-100" rel="noreferrer noopener" target="_blank">Exam DA-100: Analyzing Data with Microsoft Power BI.</a> </span></span></span></span></span></span></li>
</ul>

<ul>
	<li><span style="font-size:14px;"><span style="font-family:segoe ui;">Learners will gain confidence to take other <strong>role-based courses</strong> and <strong>certifications. </strong></span></span></li>
	<li><span style="font-size:14px;"><span style="font-family:segoe ui;"><span style="font-size:14px;"><span style="font-family:segoe ui;">An <strong>additional fee</strong> is payable for exam vouchers. </span></span></span></span></li>
	<li><span style="font-size:14px;"><span style="font-family:segoe ui;">Take full advantage of our new <strong>Hybrid Learning</strong> by attending <strong>on campus</strong> or <strong>virtually.</strong> Have all your classes ready to be <strong>downloaded</strong> and <strong>watched</strong>, anytime, anywhere. <a href="https://learnfast.co.za/pgs-153-hybrid-learning.html">(Read More)</a></span></span></li>
</ul>

<ul>
	<li><span style="font-size:14px;"><span style="font-family:segoe ui;"><span style="font-size:14px;"><span style="font-family:segoe ui;">Attendees will learn practical skills which can be applied in the work environment.  </span></span></span></span></li>
</ul>

Duration

Career Options

Financing Options

Admission Requirements

<p paraeid="{e4e70cdf-bd38-4382-a064-40c443521d15}{24}" paraid="171346482"><span style="font-size:14px;"><span style="font-family:segoe ui;">Successful Data Analysts start this role with experience of working with data in the cloud. </span></span></p>

<p paraeid="{e4e70cdf-bd38-4382-a064-40c443521d15}{34}" paraid="1767917977"><span style="font-size:14px;"><span style="font-family:segoe ui;">Specifically: </span></span></p>

<ul>
	<li paraeid="{e4e70cdf-bd38-4382-a064-40c443521d15}{40}" paraid="770989461">
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Understanding core data concepts. </span></span></div>
	</li>
	<li paraeid="{e4e70cdf-bd38-4382-a064-40c443521d15}{47}" paraid="313974603">
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Knowledge of working with relational data in the cloud. </span></span></div>
	</li>
	<li paraeid="{e4e70cdf-bd38-4382-a064-40c443521d15}{54}" paraid="211878563">
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Knowledge of working with non-relational data in the cloud. </span></span></div>
	</li>
	<li paraeid="{e4e70cdf-bd38-4382-a064-40c443521d15}{61}" paraid="401528869">
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Knowledge of data analysis and visualization concepts. </span></span></div>
	</li>
</ul>

<p paraeid="{e4e70cdf-bd38-4382-a064-40c443521d15}{68}" paraid="1088867935"><span style="font-size:14px;"><span style="font-family:segoe ui;">You can gain the prerequisites and a better understanding of working with data in Azure by completing Microsoft Azure Data Fundamentals before taking this course. </span></span></p>

<ul>
	<li paraeid="{e4e70cdf-bd38-4382-a064-40c443521d15}{82}" paraid="1218792819"><span style="font-size:14px;"><span style="font-family:segoe ui;">You can gain the prerequisites and a better understanding of working with data in Azure by completing <a href="https://learnfast.co.za/tcp-2_30_615-microsoft-azure-data-fundamentals-dp-900t00-a-.html" rel="noreferrer noopener" target="_blank">Microsoft Azure Data Fundamentals</a> before taking this course. </span></span></li>
</ul>

Important Notes

<ul>
	<li paraeid="{b3cb6e25-b51e-49d0-8cac-ca1093935ea6}{117}" paraid="804321541">
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Learners to arrive at the training venue from 08:00 in preparation for 08:30 starting time </span></span></div>
	</li>
	<li paraeid="{b3cb6e25-b51e-49d0-8cac-ca1093935ea6}{140}" paraid="1182152953">
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Bookings are only confirmed upon receipt of the proof of payment or an official company purchase order. </span></span></div>
	</li>
	<li paraeid="{b3cb6e25-b51e-49d0-8cac-ca1093935ea6}{147}" paraid="1081372771">
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">For full day, on campus courses, Learnfast will supply you with a computer to use for training (if applicable),& tea/coffee and a full lunch. Catering is not included for On-Site training and laptops are available for hire at an additional cost if required. </span></span></div>
	</li>
	<li paraeid="{b3cb6e25-b51e-49d0-8cac-ca1093935ea6}{178}" paraid="1309175345">
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Cancellation or rescheduling requests must be in writing and reach us via email at least 5-10 working days prior to the course commencement date. Full course fees will be retained for no shows. </span></span></div>
	</li>
	<li paraeid="{b3cb6e25-b51e-49d0-8cac-ca1093935ea6}{185}" paraid="880286382">
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Virtual learners are required to have a stable internet connection & a working headset available for sound purposes.  </span></span></div>
	</li>
	<li paraeid="{b3cb6e25-b51e-49d0-8cac-ca1093935ea6}{192}" paraid="2124695199">
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Learners who use their own laptops are fully responsible to ensure that administration rights, software installations, etc. are working sufficiently prior to training. </span></span></div>
	</li>
	<li paraeid="{b3cb6e25-b51e-49d0-8cac-ca1093935ea6}{207}" paraid="2134258061">
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Learnfast reserves the right to cancel or postpone dates if we require to do so and undertake to inform clients in writing and telephonically of these changes. </span></span></div>
	</li>
	<li paraeid="{b3cb6e25-b51e-49d0-8cac-ca1093935ea6}{216}" paraid="1561849529">
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Learnfast is not responsible for costs associated with cancellation of classes such as flight and accommodation for clients. </span></span></div>
	</li>
</ul>

CourseOutline

<div><span style="font-size:14px;"><span style="font-family:segoe ui;"><strong>Module 1: Get Started with Microsoft Data Analytics </strong></span></span></div>

<div><span style="font-size:14px;"><span style="font-family:segoe ui;">This module explores the different roles in the data space, outlines the important roles and responsibilities of a Data Analysts, and then explores the landscape of the Power BI portfolio.</span></span></div>

<ul>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Data Analytics and Microsoft</span></span></div>
	</li>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Getting Started with Power BI</span></span></div>
	</li>
</ul>

<hr />
<div><span style="font-size:14px;"><span style="font-family:segoe ui;"><strong>Module 2: Prepare Data in Power BI </strong></span></span></div>

<div><span style="font-size:14px;"><span style="font-family:segoe ui;">This module explores identifying and retrieving data from various data sources. You will also learn the options for connectivity and data storage, and understand the difference and performance implications of connecting directly to data vs. importing it.</span></span></div>

<ul>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Get data from various data sources</span></span></div>
	</li>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Optimize performance</span></span></div>
	</li>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Resolve data errors</span></span></div>
	</li>
</ul>

<hr />
<div><span style="font-size:14px;"><span style="font-family:segoe ui;"><strong>Module 3: Clean, Transform, and Load Data in Power BI </strong></span></span></div>

<div><span style="font-size:14px;"><span style="font-family:segoe ui;">This module teaches you the process of profiling and understanding the condition of the data. They will learn how to identify anomalies, look at the size and shape of their data, and perform the proper data cleaning and transforming steps to prepare the data for loading into the model.</span></span></div>

<ul>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Data shaping</span></span></div>
	</li>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Enhance the data structure</span></span></div>
	</li>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Data Profiling</span></span></div>
	</li>
</ul>

<hr />
<div><span style="font-size:14px;"><span style="font-family:segoe ui;"><strong>Module 4:  Design a Data Model in Power BI </strong></span></span></div>

<div><span style="font-size:14px;"><span style="font-family:segoe ui;">This module teaches the fundamental concepts of designing and developing a data model for proper performance and scalability. This module will also help you understand and tackle many of the common data modeling issues, including relationships, security, and performance.</span></span></div>

<ul>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Introduction to data modeling</span></span></div>
	</li>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Working with tables</span></span></div>
	</li>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Dimensions and Hierarchies</span></span></div>
	</li>
</ul>

<hr />
<div><span style="font-size:14px;"><span style="font-family:segoe ui;"><strong>Module 5: Create Measures using DAX in Power BI </strong></span></span></div>

<div><span style="font-size:14px;"><span style="font-family:segoe ui;">This module introduces you to the world of DAX and its true power for enhancing a model. You will learn about aggregations and the concepts of Measures, calculated columns and tables, and Time Intelligence functions to solve calculation and data analysis problems.</span></span></div>

<ul>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Introduction to DAX</span></span></div>
	</li>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">DAX context</span></span></div>
	</li>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Advanced DAX</span></span></div>
	</li>
</ul>

<hr />
<div><span style="font-size:14px;"><span style="font-family:segoe ui;"><strong>Module 6: Optimize Model Performance </strong></span></span></div>

<div><span style="font-size:14px;"><span style="font-family:segoe ui;">In this module you are introduced to steps, processes, concepts, and data modeling best practices necessary to optimize a data model for enterprise-level performance.</span></span></div>

<ul>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Optimze the model for performance</span></span></div>
	</li>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Optimize DirectQuery Models</span></span></div>
	</li>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Create and manage Aggregations</span></span></div>
	</li>
</ul>

<hr />
<div><span style="font-size:14px;"><span style="font-family:segoe ui;"><strong>Module 7: Create Reports </strong></span></span></div>

<div><span style="font-size:14px;"><span style="font-family:segoe ui;">This module introduces you to the fundamental concepts and principles of designing and building a report, including selecting the correct visuals, designing a page layout, and applying basic but critical functionality. The important topic of designing for accessibility is also covered.</span></span></div>

<ul>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Design a report</span></span></div>
	</li>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Enhance the report</span></span></div>
	</li>
</ul>

<hr />
<div><span style="font-size:14px;"><span style="font-family:segoe ui;"><strong>Module 8: Create Dashboards </strong></span></span></div>

<div><span style="font-size:14px;"><span style="font-family:segoe ui;">In this module you will learn how to tell a compelling story through the use of dashboards and the different navigation tools available to provide navigation. You will be introduced to features and functionality and how to enhance dashboards for usability and insights.</span></span></div>

<ul>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Create a Dashboard</span></span></div>
	</li>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Real-time Dashboards</span></span></div>
	</li>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Enhance a Dashboard</span></span></div>
	</li>
</ul>

<hr />
<div><span style="font-size:14px;"><span style="font-family:segoe ui;"><strong>Module 9: Create Paginated Reports in Power BI </strong></span></span></div>

<div><span style="font-size:14px;"><span style="font-family:segoe ui;">This module will teach you about paginated reports, including what they are how they fit into Power BI. You will then learn how to build and publish a report.</span></span></div>

<ul>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Paginated report overview</span></span></div>
	</li>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Create Paginated reports</span></span></div>
	</li>
</ul>

<hr />
<div><span style="font-size:14px;"><span style="font-family:segoe ui;"><strong>Module 10: Perform Advanced Analytics   </strong></span></span></div>

<div><span style="font-size:14px;"><span style="font-family:segoe ui;">This module helps you apply additional features to enhance the report for analytical insights in the data, equipping you with the steps to use the report for actual data analysis. You will also perform advanced analytics using AI visuals on the report for even deeper and meaningful data insights.</span></span></div>

<ul>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Advanced Analytics</span></span></div>
	</li>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Data Insights through AI visuals</span></span></div>
	</li>
</ul>

<hr />
<div><span style="font-size:14px;"><span style="font-family:segoe ui;"><strong>Module 11: Create and Manage Workspaces </strong></span></span></div>

<div><span style="font-size:14px;"><span style="font-family:segoe ui;">This module will introduce you to Workspaces, including how to create and manage them. You will also learn how to share content, including reports and dashboards, and then learn how to distribute an App.</span></span></div>

<ul>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Creating Workspaces</span></span></div>
	</li>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Sharing and Managing Assets</span></span></div>
	</li>
</ul>

<hr />
<div><span style="font-size:14px;"><span style="font-family:segoe ui;"><strong>Module 12: Manage Datasets in Power BI </strong></span></span></div>

<div><span style="font-size:14px;"><span style="font-family:segoe ui;">In this module you will learn the concepts of managing Power BI assets, including datasets and workspaces. You will also publish datasets to the Power BI service, then refresh and secure them.</span></span></div>

<ul>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Parameters</span></span></div>
	</li>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Datasets</span></span></div>
	</li>
</ul>

<hr />
<div><span style="font-size:14px;"><span style="font-family:segoe ui;"><strong>Module 13: Row-level security </strong></span></span></div>

<div><span style="font-size:14px;"><span style="font-family:segoe ui;">This module teaches you the steps for implementing and configuring security in Power BI to secure Power BI assets.</span></span></div>

<ul>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Security in Power BI</span></span></div>
	</li>
</ul>

Available Exams and Certifications

<p paraeid="{df67382e-03a3-446c-af75-dc57750ca767}{110}" paraid="413941652"><span style="font-size:14px;"><span style="font-family:segoe ui;">On completion the learner will earn:   </span></span></p>

<ul>
	<li paraeid="{df67382e-03a3-446c-af75-dc57750ca767}{126}" paraid="725911956"><span style="font-size:14px;"><span style="font-family:segoe ui;"><strong>Certificate of Completion </strong>from <strong>Microsoft </strong></span></span></li>
	<li paraeid="{df67382e-03a3-446c-af75-dc57750ca767}{137}" paraid="253507786"><span style="font-size:14px;"><span style="font-family:segoe ui;"><strong><a href="https://docs.microsoft.com/en-us/learn/certifications/exams/da-100" rel="noreferrer noopener" target="_blank"><span style="color:#FFFFFF;"><span style="background-color:#FFFFFF;">Microsoft Certified: Analyzing Data with Microsoft Power BI</span></span></a></strong> upon successful pass of the certification exam. </span></span></li>
</ul>

<p paraeid="{df67382e-03a3-446c-af75-dc57750ca767}{157}" paraid="1283062853"><em><span style="font-size:14px;"><span style="font-family:segoe ui;">Note: All certificates are electronically issued.  </span></span></em></p>

Articulation Options

Outcomes

<p paraeid="{df67382e-03a3-446c-af75-dc57750ca767}{183}" paraid="506398719"><span style="font-size:14px;"><span style="font-family:segoe ui;">Upon completion of this course, learners will have acquired these skills </span></span></p>

<ul>
	<li paraeid="{df67382e-03a3-446c-af75-dc57750ca767}{200}" paraid="1677259532">
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Ingest, clean, and transform data </span></span></div>
	</li>
	<li paraeid="{df67382e-03a3-446c-af75-dc57750ca767}{207}" paraid="1620110546">
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Model data for performance and scalability </span></span></div>
	</li>
	<li paraeid="{df67382e-03a3-446c-af75-dc57750ca767}{214}" paraid="853159897">
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Design and create reports for data analysis </span></span></div>
	</li>
	<li paraeid="{df67382e-03a3-446c-af75-dc57750ca767}{221}" paraid="2003459958">
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Apply and perform advanced report analytics </span></span></div>
	</li>
	<li paraeid="{df67382e-03a3-446c-af75-dc57750ca767}{228}" paraid="1188897941">
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Manage and share report assets </span></span></div>
	</li>
	<li paraeid="{df67382e-03a3-446c-af75-dc57750ca767}{235}" paraid="751912337">
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Create paginated reports in Power BI </span></span></div>
	</li>
</ul>

Who Should Attend

Learning Methods & Delivery

Study Kit

Assessment

Career Video

Hardware Requirements

PDF Link URL

Header

Form Email

LEARNFAST CMS

Course Info

Control Panel