Name: Power BI for Data-driven Decision Makers
Price: 395 GBP
Availability: InStock

Redhill

<h3><b>DNS training course description</b></h3>
      <p>This three-day hands on DNS training course studies both the UNIX BIND and the Microsoft (MS DNS) implementations. The course starts with the big picture of how DNS works, then client configuration. Primary and secondary servers are then configured, progressing to DDNS, subdomains and security issues. Hands on sessions follow all sections ensuring that troubleshooting techniques are used throughout the course. Students choose whether to use Windows or UNIX for the hands on sessions. </p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
        <li>Describe the architecture of DNS.</li>
              <li>Explain how DNS works.</li>
              <li>Install, configure, maintain and troubleshoot DNS</li>
                  </ul>
       
        <h5>
        <b>DNS training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Technical staff wanting to learn DNS including:<br />
        Network personnel<br />
         System administrators.</p>
              
							<li><b>Prerequisites:</b></li>
							
              <p> UNIX Fundamentals (or Windows knowledge).
								<br /> TCP/IP foundation for engineers.</p>
              
							<li><b>Duration</b></li>
							
              <p>3 days
						</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>DNS training course contents</b></h3>
      <ul>
				<li>What is DNS?</li><p>
Hostnames, Name resolution, host files, host file
					problems, What is DNS? The DNS namespace,
TLDs, gTLDs, registering domains, Nameservers,
how DNS works. <br /><span>Hands on</span> Testing DNS servers
on the Internet.
</p><li>DNS clients</li><p>
Ways to use DNS, dynamic and static
configuration, multiple nameservers, domain name,
searchlist, resolution issues, testing the
configuration. <br /><span>Hands on</span> Client configuration.
</p><li>DNS server software</li><p>
Implementations, Microsoft, BIND, daemons and
services, installation, starting and stopping servers.
<br /><span>Hands on</span> Setting up a DNS server.
</p><li>DNS zone files</li><p>
What is a zone, Zone file overview, Forward zones,
Reverse zones, Resource records, A records, PTR,
CNAME, Root hints, local zone file. BIND and
Microsoft configuration. <br /><span>Hands on</span> Server
configuration files.
</p><li>NS and applications</li><p>
MX records, Mail server load balancing, SPF, SRV
records, VoIP and SRV, Microsoft and SRV,
NAPTR. <br /><span>Hands on</span> Testing records with dig and
nslookup.
</p><li>DNS slaves and other servers</li><p>
DNS server types, Server resilience, Slaves, Zone
transfers, SOA records, Serial numbers,
recommendations, polling based zone transfers,
NOTIFY, AD integration, DNS caching, Negative
caching, TTL, Caching only servers. <br /><span>Hands on</span>
Masters, slaves and zone transfers.
</p><li>The DNS protocol</li><p>
The DNS stack, DNS port numbers, DNS queries,
The DNS header, header section format, question
format, other section format. <br /><span>Hands on</span>
Troubleshooting DNS with Wireshark.
</p><li>Dynamic DNS</li><p>
DHCP, DDNS, IXFR, WINS integration. <br /><span>Hands on</span>
Dynamic DNS.
</p><li>Subdomains</li><p>
Root servers, root server selection, Authority,
delegation, NS records, subdomain with and
without delegation, reverse delegation. <br /><span>Hands on</span>
Delegation, setting up a subdomain server.
</p><li>DNS security</li><p>
Restricting queries, DNS and firewalls, Split DNS,
forwarders, internal root servers, the use of proxy
servers, DNSSEC, TSIG. <br /><span>Hands on</span> Hardening a
DNS server.
</p><li>DNS and IPv6</li><p>
What is IPv6, IPv6 addressing, IPv6 DNS issues,
AAAA, IPv6 reverse delegation.
</p><li>Troubleshooting DNS</li><p>
Problem solving, DNS troubleshooting, Zone file
checking, Some common errors, Log files, tools,
nslookup, dig, host, DNS design, performance,
load balancing. <br /><span>Hands on</span> Putting it all together.
</p><li>Summary</li><p>
Useful books, Internet sites, RFCs.
</p><li>Appendix: ENUM</li><p>
What is ENUM, How ENUM works, NAPTR. 
</p>
      </ul>

DNS training course description
This three-day hands on DNS training course studies both the UNIX BIND and the Microsoft (MS DNS) implementations. The course starts with the big picture of how DNS works, then client configuration. Primary and secondary servers are then configured, progressing to DDNS, subdomains and security issues. Hands on sessions follow all sections ensuring that troubleshooting techniques are used throughout the course. Students choose whether to use Windows or UNIX for the hands on sessions. 
What will you learn
Describe the architecture of DNS.
Explain how DNS works.
Install, configure, maintain and troubleshoot DNS
DNS training course details
Who will benefit:
Technical staff wanting to learn DNS including:
 Network personnel
 System administrators.
Prerequisites:
 UNIX Fundamentals (or Windows knowledge). 
 TCP/IP foundation for engineers.
Duration
3 days 
DNS training course contents
What is DNS?

Hostnames, Name resolution, host files, host file problems, What is DNS? The DNS namespace,
TLDs, gTLDs, registering domains, Nameservers,
how DNS works. 
Hands on Testing DNS servers
on the Internet.

DNS clients

Ways to use DNS, dynamic and static
configuration, multiple nameservers, domain name,
searchlist, resolution issues, testing the
configuration. 
Hands on Client configuration.

DNS server software

Implementations, Microsoft, BIND, daemons and
services, installation, starting and stopping servers.

Hands on Setting up a DNS server.

DNS zone files

What is a zone, Zone file overview, Forward zones,
Reverse zones, Resource records, A records, PTR,
CNAME, Root hints, local zone file. BIND and
Microsoft configuration. 
Hands on Server
configuration files.

NS and applications

MX records, Mail server load balancing, SPF, SRV
records, VoIP and SRV, Microsoft and SRV,
NAPTR. 
Hands on Testing records with dig and
nslookup.

DNS slaves and other servers

DNS server types, Server resilience, Slaves, Zone
transfers, SOA records, Serial numbers,
recommendations, polling based zone transfers,
NOTIFY, AD integration, DNS caching, Negative
caching, TTL, Caching only servers. 
Hands on
Masters, slaves and zone transfers.

The DNS protocol

The DNS stack, DNS port numbers, DNS queries,
The DNS header, header section format, question
format, other section format. 
Hands on
Troubleshooting DNS with Wireshark.

Dynamic DNS

DHCP, DDNS, IXFR, WINS integration. 
Hands on
Dynamic DNS.

Subdomains

Root servers, root server selection, Authority,
delegation, NS records, subdomain with and
without delegation, reverse delegation. 
Hands on
Delegation, setting up a subdomain server.

DNS security

Restricting queries, DNS and firewalls, Split DNS,
forwarders, internal root servers, the use of proxy
servers, DNSSEC, TSIG. 
Hands on Hardening a
DNS server.

DNS and IPv6

What is IPv6, IPv6 addressing, IPv6 DNS issues,
AAAA, IPv6 reverse delegation.

Troubleshooting DNS

Problem solving, DNS troubleshooting, Zone file
checking, Some common errors, Log files, tools,
nslookup, dig, host, DNS design, performance,
load balancing. 
Hands on Putting it all together.

Summary

Useful books, Internet sites, RFCs.

Appendix: ENUM

What is ENUM, How ENUM works, NAPTR. 

Systems & Network Training

Network & Security

Network Engineer

Definitive DNS for engineers

General Admission

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p></p><p>The audience for this course are data professionals and business intelligence professionals who want to learn how to accurately perform data analysis using Power BI. This course is also targeted toward those individuals who develop reports that visualize data from the data platform technologies that exist on both in the cloud and on-premises.</p><p></p><p></p><p>This course covers the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will show how to access and process data from a range of data sources including both relational and non-relational sources. Finally, this course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution.</p><p></p>Prerequisites<p></p><li>Understanding core data concepts.</li>  <li>Knowledge of working with relational data in the cloud.</li>  <li>Knowledge of working with non-relational data in the cloud.</li>   <li>Knowledge of data analysis and visualization concepts.</li>   <li>DP-900T00 Microsoft Azure Data Fundamentals is recommended<p></p></li></div><div id="course-pills-2"><h3>1 - Discover data analysis</h3> <ul> <li>Overview of data analysis</li> <li>Roles in data</li> <li>Tasks of a data analyst</li> </ul> <h3>2 - Get started building with Power BI</h3> <ul> <li>Use Power BI</li> <li>Building blocks of Power BI</li> <li>Tour and use the Power BI service</li> </ul> <h3>3 - Get data in Power BI</h3> <ul> <li>Get data from files</li> <li>Get data from relational data sources</li> <li>Create dynamic reports with parameters</li> <li>Get data from a NoSQL database</li> <li>Get data from online services</li> <li>Select a storage mode</li> <li>Get data from Azure Analysis Services</li> <li>Fix performance issues</li> <li>Resolve data import errors</li> </ul> <h3>4 - Clean, transform, and load data in Power BI</h3> <ul> <li>Shape the initial data</li> <li>Simplify the data structure</li> <li>Evaluate and change column data types</li> <li>Combine multiple tables into a single table</li> <li>Profile data in Power BI</li> <li>Use Advanced Editor to modify M code</li> </ul> <h3>5 - Design a semantic model in Power BI</h3> <ul> <li>Work with tables</li> <li>Create a date table</li> <li>Work with dimensions</li> <li>Define data granularity</li> <li>Work with relationships and cardinality</li> <li>Resolve modeling challenges</li> </ul> <h3>6 - Add measures to Power BI Desktop models</h3> <ul> <li>Create simple measures</li> <li>Create compound measures</li> <li>Create quick measures</li> <li>Compare calculated columns with measures</li> </ul> <h3>7 - Add calculated tables and columns to Power BI Desktop models</h3> <ul> <li>Create calculated columns</li> <li>Learn about row context</li> <li>Choose a technique to add a column</li> </ul> <h3>8 - Use DAX time intelligence functions in Power BI Desktop models</h3> <ul> <li>Use DAX time intelligence functions</li> <li>Additional time intelligence calculations</li> </ul> <h3>9 - Optimize a model for performance in Power BI</h3> <ul> <li>Review performance of measures, relationships, and visuals</li> <li>Use variables to improve performance and troubleshooting</li> <li>Reduce cardinality</li> <li>Optimize DirectQuery models with table level storage</li> <li>Create and manage aggregations</li> </ul> <h3>10 - Design Power BI reports</h3> <ul> <li>Design the analytical report layout</li> <li>Design visually appealing reports</li> <li>Report objects</li> <li>Select report visuals</li> <li>Select report visuals to suit the report layout</li> <li>Format and configure visualizations</li> <li>Work with key performance indicators</li> </ul> <h3>11 - Configure Power BI report filters</h3> <ul> <li>Apply filters to the report structure</li> <li>Apply filters with slicers</li> <li>Design reports with advanced filtering techniques</li> <li>Consumption-time filtering</li> <li>Select report filter techniques</li> <li>Case study - Configure report filters based on feedback</li> </ul> <h3>12 - Enhance Power BI report designs for the user experience</h3> <ul> <li>Design reports to show details</li> <li>Design reports to highlight values</li> <li>Design reports that behave like apps</li> <li>Work with bookmarks</li> <li>Design reports for navigation</li> <li>Work with visual headers</li> <li>Design reports with built-in assistance</li> <li>Tune report performance</li> <li>Optimize reports for mobile use</li> </ul> <h3>13 - Perform analytics in Power BI</h3> <ul> <li>Explore statistical summary</li> <li>Identify outliers with Power BI visuals</li> <li>Group and bin data for analysis</li> <li>Apply clustering techniques</li> <li>Conduct time series analysis</li> <li>Use the Analyze feature</li> <li>Create what-if parameters</li> <li>Use specialized visuals</li> </ul> <h3>14 - Create and manage workspaces in Power BI</h3> <ul> <li>Distribute a report or dashboard</li> <li>Monitor usage and performance</li> <li>Recommend a development life cycle strategy</li> <li>Troubleshoot data by viewing its lineage</li> <li>Configure data protection</li> </ul> <h3>15 - Manage semantic models in Power BI</h3> <ul> <li>Use a Power BI gateway to connect to on-premises data sources</li> <li>Configure a semantic model scheduled refresh</li> <li>Configure incremental refresh settings</li> <li>Manage and promote semantic models</li> <li>Troubleshoot service connectivity</li> <li>Boost performance with query caching (Premium)</li> </ul> <h3>16 - Create dashboards in Power BI</h3> <ul> <li>Configure data alerts</li> <li>Explore data by asking questions</li> <li>Review Quick insights</li> <li>Add a dashboard theme</li> <li>Pin a live report page to a dashboard</li> <li>Configure a real-time dashboard</li> <li>Set mobile view</li> </ul> <h3>17 - Implement row-level security</h3> <ul> <li>Configure row-level security with the static method</li> <li>Configure row-level security with the dynamic method</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans PL-300T00: Microsoft Power BI Data Analyst 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 PL-300T00: Microsoft Power BI Data Analyst 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
This course is intended for

The audience for this course are data professionals and business intelligence professionals who want to learn how to accurately perform data analysis using Power BI. This course is also targeted toward those individuals who develop reports that visualize data from the data platform technologies that exist on both in the cloud and on-premises.


This course covers the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will show how to access and process data from a range of data sources including both relational and non-relational sources. Finally, this course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution.

Prerequisites

Understanding core data concepts.
Knowledge of working with relational data in the cloud.
Knowledge of working with non-relational data in the cloud.
Knowledge of data analysis and visualization concepts.
DP-900T00 Microsoft Azure Data Fundamentals is recommended
1 - Discover data analysis
Overview of data analysis
Roles in data
Tasks of a data analyst
2 - Get started building with Power BI
Use Power BI
Building blocks of Power BI
Tour and use the Power BI service
3 - Get data in Power BI
Get data from files
Get data from relational data sources
Create dynamic reports with parameters
Get data from a NoSQL database
Get data from online services
Select a storage mode
Get data from Azure Analysis Services
Fix performance issues
Resolve data import errors
4 - Clean, transform, and load data in Power BI
Shape the initial data
Simplify the data structure
Evaluate and change column data types
Combine multiple tables into a single table
Profile data in Power BI
Use Advanced Editor to modify M code
5 - Design a semantic model in Power BI
Work with tables
Create a date table
Work with dimensions
Define data granularity
Work with relationships and cardinality
Resolve modeling challenges
6 - Add measures to Power BI Desktop models
Create simple measures
Create compound measures
Create quick measures
Compare calculated columns with measures
7 - Add calculated tables and columns to Power BI Desktop models
Create calculated columns
Learn about row context
Choose a technique to add a column
8 - Use DAX time intelligence functions in Power BI Desktop models
Use DAX time intelligence functions
Additional time intelligence calculations
9 - Optimize a model for performance in Power BI
Review performance of measures, relationships, and visuals
Use variables to improve performance and troubleshooting
Reduce cardinality
Optimize DirectQuery models with table level storage
Create and manage aggregations
10 - Design Power BI reports
Design the analytical report layout
Design visually appealing reports
Report objects
Select report visuals
Select report visuals to suit the report layout
Format and configure visualizations
Work with key performance indicators
11 - Configure Power BI report filters
Apply filters to the report structure
Apply filters with slicers
Design reports with advanced filtering techniques
Consumption-time filtering
Select report filter techniques
Case study - Configure report filters based on feedback
12 - Enhance Power BI report designs for the user experience
Design reports to show details
Design reports to highlight values
Design reports that behave like apps
Work with bookmarks
Design reports for navigation
Work with visual headers
Design reports with built-in assistance
Tune report performance
Optimize reports for mobile use
13 - Perform analytics in Power BI
Explore statistical summary
Identify outliers with Power BI visuals
Group and bin data for analysis
Apply clustering techniques
Conduct time series analysis
Use the Analyze feature
Create what-if parameters
Use specialized visuals
14 - Create and manage workspaces in Power BI
Distribute a report or dashboard
Monitor usage and performance
Recommend a development life cycle strategy
Troubleshoot data by viewing its lineage
Configure data protection
15 - Manage semantic models in Power BI
Use a Power BI gateway to connect to on-premises data sources
Configure a semantic model scheduled refresh
Configure incremental refresh settings
Manage and promote semantic models
Troubleshoot service connectivity
Boost performance with query caching (Premium)
16 - Create dashboards in Power BI
Configure data alerts
Explore data by asking questions
Review Quick insights
Add a dashboard theme
Pin a live report page to a dashboard
Configure a real-time dashboard
Set mobile view
17 - Implement row-level security
Configure row-level security with the static method
Configure row-level security with the dynamic method
Additional course details:
Nexus Humans PL-300T00: Microsoft Power BI Data Analyst 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 PL-300T00: Microsoft Power BI Data Analyst 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

Business Analytics & Intelligence

Microsoft Power BI

Microsoft Power Platform

Microsoft BI

Data Analyst

PL-300T00 Microsoft Power BI Data Analyst

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>This course is intended for information workers and data science professionals who seek to use database reporting and analysis tools such as Microsoft SQL Server Reporting Services, Excel, Power BI, R, SAS and other business intelligence tools, and wish to use TSQL queries to efficiently retrieve data sets from Microsoft SQL Server relational databases for use with these tools.</p>Overview<p>After completing this course, students will be able to: - Identify independent and dependent variables and measurement levels in their own analytical work scenarios. - Identify variables of interest in relational database tables. - Choose a data aggregation level and data set design appropriate for the intended analysis and tool. - Use TSQL SELECT queries to produce ready-to-use data sets for analysis in tools such as PowerBI, SQL Server Reporting Services, Excel, R, SAS, SPSS, and others. - Create stored procedures, views, and functions to modularize data retrieval code.</p><p>This course is about writing TSQL queries for the purpose of database reporting, analysis, and business intelligence.</p></div><div id="course-pills-2"><h3>1 - INTRODUCTION TO TSQL FOR BUSINESS INTELLIGENCE</h3> <ul> <li>Two Approaches to SQL Programming</li> <li>TSQL Data Retrieval in an Analytics / Business Intelligence Environment</li> <li>The Database Engine</li> <li>SQL Server Management Studio and the CarDeal Sample Database</li> <li>Identifying Variables in Tables</li> <li>SQL is a Declarative Language</li> <li>Introduction to the SELECT Query</li> <li>Lab 1: Introduction to TSQL for Business Intelligence</li> </ul> <h3>2 - TURNING TABLE COLUMNS INTO VARIABLES FOR ANALYSIS: SELECT LIST EXPRESSIONS, WHERE, AND ORDER BY</h3> <ul> <li>Turning Columns into Variables for Analysis</li> <li>Column Expressions, Data Types, and Built-in Functions</li> <li>Column aliases</li> <li>Data type conversions</li> <li>Built-in Scalar Functions</li> <li>Table Aliases</li> <li>The WHERE clause</li> <li>ORDER BY</li> <li>Lab 1: Write queries</li> </ul> <h3>3 - COMBINING COLUMNS FROM MULTIPLE TABLES INTO A SINGLE DATASET: THE JOIN OPERATORS</h3> <ul> <li>Primary Keys, Foreign Keys, and Joins</li> <li>Understanding Joins, Part 1: CROSS JOIN and the Full Cartesian Product</li> <li>Understanding Joins, Part 2: The INNER JOIN</li> <li>Understanding Joins, Part 3: The OUTER JOINS</li> <li>Understanding Joins, Part 4: Joining more than two tables</li> <li>Understanding Joins, Part 5: Combining INNER and OUTER JOINs</li> <li>Combining JOIN Operations with WHERE and ORDER BY</li> <li>Lab 1: Write SELECT queries</li> </ul> <h3>4 - CREATING AN APPROPRIATE AGGREGATION LEVEL USING GROUP BY</h3> <ul> <li>Identifying required aggregation level and granularity</li> <li>Aggregate Functions</li> <li>GROUP BY</li> <li>HAVING</li> <li>Order of operations in SELECT queries</li> <li>Lab 1: Write queries</li> </ul> <h3>5 - SUBQUERIES, DERIVED TABLES AND COMMON TABLE EXPRESSIONS</h3> <ul> <li>Non-correlated and correlated subqueries</li> <li>Derived tables</li> <li>Common table expressions</li> <li>Lab 1: Write queries</li> </ul> <h3>6 - ENCAPSULATING DATA RETRIEVAL LOGIC</h3> <ul> <li>Views</li> <li>Table-valued functions</li> <li>Stored procedures</li> <li>Creating objects for read-access users</li> <li>Creating database accounts for analytical client tools</li> <li>Lab 1: Encapsulating Data Retrieval Logic</li> </ul> <h3>7 - GETTING YOUR DATASET TO THE CLIENT</h3> <ul> <li>Connecting to SQL Server and Submitting Queries from Client Tools</li> <li>Connecting and running SELECT queries from:</li> <li>Excel</li> <li>PowerBI</li> <li>RStudio</li> <li>Exporting datasets to files using</li> <li>Results pane from SSMS</li> <li>The bcp utility</li> <li>The Import/Export Wizard</li> <li>Lab 1: Getting Your Dataset to the Client</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans 55232 Writing Analytical Queries for Business Intelligence 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 55232 Writing Analytical Queries for Business Intelligence 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
This course is intended for
This course is intended for information workers and data science professionals who seek to use database reporting and analysis tools such as Microsoft SQL Server Reporting Services, Excel, Power BI, R, SAS and other business intelligence tools, and wish to use TSQL queries to efficiently retrieve data sets from Microsoft SQL Server relational databases for use with these tools.
Overview
After completing this course, students will be able to: - Identify independent and dependent variables and measurement levels in their own analytical work scenarios. - Identify variables of interest in relational database tables. - Choose a data aggregation level and data set design appropriate for the intended analysis and tool. - Use TSQL SELECT queries to produce ready-to-use data sets for analysis in tools such as PowerBI, SQL Server Reporting Services, Excel, R, SAS, SPSS, and others. - Create stored procedures, views, and functions to modularize data retrieval code.
This course is about writing TSQL queries for the purpose of database reporting, analysis, and business intelligence.
1 - INTRODUCTION TO TSQL FOR BUSINESS INTELLIGENCE
Two Approaches to SQL Programming
TSQL Data Retrieval in an Analytics / Business Intelligence Environment
The Database Engine
SQL Server Management Studio and the CarDeal Sample Database
Identifying Variables in Tables
SQL is a Declarative Language
Introduction to the SELECT Query
Lab 1: Introduction to TSQL for Business Intelligence
2 - TURNING TABLE COLUMNS INTO VARIABLES FOR ANALYSIS: SELECT LIST EXPRESSIONS, WHERE, AND ORDER BY
Turning Columns into Variables for Analysis
Column Expressions, Data Types, and Built-in Functions
Column aliases
Data type conversions
Built-in Scalar Functions
Table Aliases
The WHERE clause
ORDER BY
Lab 1: Write queries
3 - COMBINING COLUMNS FROM MULTIPLE TABLES INTO A SINGLE DATASET: THE JOIN OPERATORS
Primary Keys, Foreign Keys, and Joins
Understanding Joins, Part 1: CROSS JOIN and the Full Cartesian Product
Understanding Joins, Part 2: The INNER JOIN
Understanding Joins, Part 3: The OUTER JOINS
Understanding Joins, Part 4: Joining more than two tables
Understanding Joins, Part 5: Combining INNER and OUTER JOINs
Combining JOIN Operations with WHERE and ORDER BY
Lab 1: Write SELECT queries
4 - CREATING AN APPROPRIATE AGGREGATION LEVEL USING GROUP BY
Identifying required aggregation level and granularity
Aggregate Functions
GROUP BY
HAVING
Order of operations in SELECT queries
Lab 1: Write queries
5 - SUBQUERIES, DERIVED TABLES AND COMMON TABLE EXPRESSIONS
Non-correlated and correlated subqueries
Derived tables
Common table expressions
Lab 1: Write queries
6 - ENCAPSULATING DATA RETRIEVAL LOGIC
Views
Table-valued functions
Stored procedures
Creating objects for read-access users
Creating database accounts for analytical client tools
Lab 1: Encapsulating Data Retrieval Logic
7 - GETTING YOUR DATASET TO THE CLIENT
Connecting to SQL Server and Submitting Queries from Client Tools
Connecting and running SELECT queries from:
Excel
PowerBI
RStudio
Exporting datasets to files using
Results pane from SSMS
The bcp utility
The Import/Export Wizard
Lab 1: Getting Your Dataset to the Client
Additional course details:
Nexus Humans 55232 Writing Analytical Queries for Business Intelligence 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 55232 Writing Analytical Queries for Business Intelligence 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.


Oracle Business Intelligence

Business Intelligence (BI)

Analytical Skills

Business Data Analysis

55232 Writing Analytical Queries for Business Intelligence

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p>The primary audience for this course are persons who are new to reporting with MicrosoftÂ© SQL ServerÂ© Report Builder and SSRS, persons who are transitioning from another reporting software application, and persons who are existing Report Builder and SSRS report authors.</p>Overview<p>Navigate the Report Builder Environment. - Create table reports. - Format reports. - Create basic and complex expressions. - Group report data. - Create matrix reports. - Sort and filter data. - Summarize data with charts. - Print and export reports.</p><p>In this course, students will continue their learning on the foundations of report writing with MicrosoftÂ© SQL ServerÂ© Report Builder and SSRS.</p>Prerequisites<p>?Familiarity with Windows.   ?Creating and navigating folders.   ?Opening programs.    ?Manipulating windows.   ?Copying and pasting objects.   ?Formatting text.   ?Saving files.</p></div><div id="course-pills-2"><h3>1 - Exploring the Report Builder Environment</h3> <ul> <li>Introducing the Report Builder Environment</li> <li>Working with Existing Reports</li> <li>Lab 1: Exploring the Report Builder Application</li> </ul> <h3>2 - Adding Data to Table Reports</h3> <ul> <li>Create Report Data Sources</li> <li>Create Report Datasets</li> <li>Work with the Tablix Data Region</li> <li>Create a Table Report</li> <li>Lab 1: Creating Table Reports</li> </ul> <h3>3 - Formatting Data and Creating Expressions in Reports</h3> <ul> <li>Formatting Reports</li> <li>Sorting and Filtering Report Data</li> <li>Adding Data to a Dataset</li> <li>Creating Simple Expressions</li> <li>Creating Complex Expressions</li> <li>Lab 1: Formatting Reports</li> </ul> <h3>4 - Grouping Report Data</h3> <ul> <li>Group Data in Reports</li> <li>Group Data Using an Expression</li> <li>Creating Subgroups and Group Aggregates</li> <li>Lab 1: Creating Reports with Groups and Aggregates</li> </ul> <h3>5 - Matrix Reports</h3> <ul> <li>Creating and Modifying Matrix Data Regions</li> <li>Creating and Modifying Column Groups</li> <li>Lab 1: Creating Matrix Reports</li> </ul> <h3>6 - Charts</h3> <ul> <li>Create and Modify Chart Wizard Reports</li> <li>Add Charts to Existing Reports</li> <li>Modify Charts in Reports</li> <li>Lab 1: Creating Charts and Chart Reports</li> </ul> <h3>7 - Printing and Exporting Reports</h3> <ul> <li>Print Features and Print Options</li> <li>Export Reports</li> <li>Lab 1: Printing and Exporting Reports</li> </ul></div>

Duration
2 Days
12 CPD hours
This course is intended for
The primary audience for this course are persons who are new to reporting with MicrosoftÂ© SQL ServerÂ© Report Builder and SSRS, persons who are transitioning from another reporting software application, and persons who are existing Report Builder and SSRS report authors.
Overview
Navigate the Report Builder Environment. - Create table reports. - Format reports. - Create basic and complex expressions. - Group report data. - Create matrix reports. - Sort and filter data. - Summarize data with charts. - Print and export reports.
In this course, students will continue their learning on the foundations of report writing with MicrosoftÂ© SQL ServerÂ© Report Builder and SSRS.
Prerequisites
?Familiarity with Windows. ?Creating and navigating folders. ?Opening programs. ?Manipulating windows. ?Copying and pasting objects. ?Formatting text. ?Saving files.
1 - Exploring the Report Builder Environment
Introducing the Report Builder Environment
Working with Existing Reports
Lab 1: Exploring the Report Builder Application
2 - Adding Data to Table Reports
Create Report Data Sources
Create Report Datasets
Work with the Tablix Data Region
Create a Table Report
Lab 1: Creating Table Reports
3 - Formatting Data and Creating Expressions in Reports
Formatting Reports
Sorting and Filtering Report Data
Adding Data to a Dataset
Creating Simple Expressions
Creating Complex Expressions
Lab 1: Formatting Reports
4 - Grouping Report Data
Group Data in Reports
Group Data Using an Expression
Creating Subgroups and Group Aggregates
Lab 1: Creating Reports with Groups and Aggregates
5 - Matrix Reports
Creating and Modifying Matrix Data Regions
Creating and Modifying Column Groups
Lab 1: Creating Matrix Reports
6 - Charts
Create and Modify Chart Wizard Reports
Add Charts to Existing Reports
Modify Charts in Reports
Lab 1: Creating Charts and Chart Reports
7 - Printing and Exporting Reports
Print Features and Print Options
Export Reports
Lab 1: Printing and Exporting Reports

SSRS

Report Writing

Manager Training

Trainers Course

Business Writing

55123 Writing Reports with Report Builder and SSRS Level 1

London

<h2>Business Intelligence: In-House Training</h2>
 <p>Business Intelligence (BI) refers to a set of technology-based techniques, applications, and practices used to aggregate, analyze, and present business data. BI practices provide historical and current views of vast amounts of data and generate predictions for business operations. The purpose of Business Intelligence is the support of better business decision making. This course provides an overview of the technology and application of BI and how it can be used to improve corporate performance.</p><h3>What you will Learn</h3>
 <p>You will learn how to:</p>
 <ul>
 <li>Specify a data warehouse schema</li>
 <li>Identify the data and visualization to be used for data mining and Business Intelligence</li>
 <li>Design a Business Intelligence user interface</li>
 </ul><section>
                    <h3>Getting Started</h3> <ul> <li>Introductions</li> <li>Agenda</li> <li>Expectations</li> </ul> <h3>Foundation Concepts</h3> <ul> <li>The challenge of decision making</li> <li>What is Business Intelligence?</li> <li>The Business Intelligence value proposition</li> <li>Business Intelligence taxonomy</li> <li>Business Intelligence management issues</li> </ul> <h3>Sources of Business Intelligence</h3> <ul> <li>Data warehousing</li> <li>Data and information</li> <li>Information architecture</li> <li>Defining the data warehouse and its relationships</li> <li>Facts and dimensions</li> <li>Modeling, meta-modeling, and schemas</li> <li>Alternate architectures</li> <li>Building the data warehouse</li> <li>Extracting</li> <li>Transforming</li> <li>Loading</li> <li>Setting up the data and relationships</li> <li>Dimensions and the Fact Table</li> <li>Implementing many-to-many relationships in data warehouse</li> <li>Data marts</li> </ul> <h3>Online Analytical Processing (OLAP)</h3> <ul> <li>What is OLAP?</li> <li>OLAP and OLTP</li> <li>OLAP functionality</li> <li>Multi-dimensions</li> <li>Thinking in more than two dimensions</li> <li>What are the possibilities?</li> <li>OLAP architecture</li> <li>Cubism</li> <li>Tools</li> <li>OLAP variations - MOLAP, ROLAP, HOLAP</li> <li>BI using SOA</li> <li>Applications of Business Intelligence</li> <li>Applying BI through OLAP</li> <li>Enterprise Resource Planning and CRM</li> <li>Business Intelligence and financial information</li> </ul> <h3>Business Intelligence User Interfaces and Presentations</h3> <ul> <li>Data access</li> <li>Push-pull data access</li> <li>Types of decision support systems</li> <li>Designing the front end</li> <li>Presentation formats</li> <li>Dashboards</li> <li>Types of dashboards</li> <li>Common dashboard features</li> <li>Briefing books and scorecards</li> <li>Querying and Reporting</li> <li>Reporting emphasis</li> <li>Retrofitting</li> <li>Talking back</li> <li>Key Performance Indicators</li> <li>Report Definition and Visualization</li> <li>Typical reporting environment</li> <li>Forms of visualization</li> <li>Unconstrained views</li> <li>Data mining</li> <li>What is in the mine?</li> <li>Applications for data mining</li> <li>Data mining architecture</li> <li>Cross Industry Standard Process for Data Mining (CISP-DM)</li> <li>Data mining techniques</li> <li>Validation</li> </ul> <h3>The Business Intelligence User Experience</h3> <ul> <li>The business analyst role</li> <li>Business analysis and data analysis</li> <li>Five-step approach</li> <li>Cultural impact</li> <li>Identifying questions</li> <li>Gathering information</li> <li>Understand the goals</li> <li>The strategic Business Intelligence cycle</li> <li>Focus of Business Intelligence</li> <li>Design for the user</li> <li>Iterate the access</li> <li>Iterative solution development process</li> <li>Review and validation questions</li> <li>Basic approaches</li> <li>Building ad-hoc queries</li> <li>Building on-demand self-service reports</li> <li>Closed loop Business Intelligence</li> <li>Coming attractions - future of Business Intelligence</li> <li>Best practices in Business Intelligence</li> </ul>


                </section>

Business Intelligence: In-House Training
Business Intelligence (BI) refers to a set of technology-based techniques, applications, and practices used to aggregate, analyze, and present business data. BI practices provide historical and current views of vast amounts of data and generate predictions for business operations. The purpose of Business Intelligence is the support of better business decision making. This course provides an overview of the technology and application of BI and how it can be used to improve corporate performance.
What you will Learn
You will learn how to:
Specify a data warehouse schema
Identify the data and visualization to be used for data mining and Business Intelligence
Design a Business Intelligence user interface
Getting Started
Introductions
Agenda
Expectations
Foundation Concepts
The challenge of decision making
What is Business Intelligence?
The Business Intelligence value proposition
Business Intelligence taxonomy
Business Intelligence management issues
Sources of Business Intelligence
Data warehousing
Data and information
Information architecture
Defining the data warehouse and its relationships
Facts and dimensions
Modeling, meta-modeling, and schemas
Alternate architectures
Building the data warehouse
Extracting
Transforming
Loading
Setting up the data and relationships
Dimensions and the Fact Table
Implementing many-to-many relationships in data warehouse
Data marts
Online Analytical Processing (OLAP)
What is OLAP?
OLAP and OLTP
OLAP functionality
Multi-dimensions
Thinking in more than two dimensions
What are the possibilities?
OLAP architecture
Cubism
Tools
OLAP variations - MOLAP, ROLAP, HOLAP
BI using SOA
Applications of Business Intelligence
Applying BI through OLAP
Enterprise Resource Planning and CRM
Business Intelligence and financial information
Business Intelligence User Interfaces and Presentations
Data access
Push-pull data access
Types of decision support systems
Designing the front end
Presentation formats
Dashboards
Types of dashboards
Common dashboard features
Briefing books and scorecards
Querying and Reporting
Reporting emphasis
Retrofitting
Talking back
Key Performance Indicators
Report Definition and Visualization
Typical reporting environment
Forms of visualization
Unconstrained views
Data mining
What is in the mine?
Applications for data mining
Data mining architecture
Cross Industry Standard Process for Data Mining (CISP-DM)
Data mining techniques
Validation
The Business Intelligence User Experience
The business analyst role
Business analysis and data analysis
Five-step approach
Cultural impact
Identifying questions
Gathering information
Understand the goals
The strategic Business Intelligence cycle
Focus of Business Intelligence
Design for the user
Iterate the access
Iterative solution development process
Review and validation questions
Basic approaches
Building ad-hoc queries
Building on-demand self-service reports
Closed loop Business Intelligence
Coming attractions - future of Business Intelligence
Best practices in Business Intelligence

IIL Europe Ltd

Business Information Technology

Business Intelligence: In-House Training

<h2>Business Intelligence: Virtual In-House Training</h2>
 <p>Business Intelligence (BI) refers to a set of technology-based techniques, applications, and practices used to aggregate, analyze, and present business data. BI practices provide historical and current views of vast amounts of data and generate predictions for business operations. The purpose of Business Intelligence is the support of better business decision making. This course provides an overview of the technology and application of BI and how it can be used to improve corporate performance.</p><h3>What you will Learn</h3>
 <p>You will learn how to:</p>
 <ul>
 <li>Specify a data warehouse schema</li>
 <li>Identify the data and visualization to be used for data mining and Business Intelligence</li>
 <li>Design a Business Intelligence user interface</li>
 </ul><section>
                    <h3>Getting Started</h3> <ul> <li>Introductions</li> <li>Agenda</li> <li>Expectations</li> </ul> <h3>Foundation Concepts</h3> <ul> <li>The challenge of decision making</li> <li>What is Business Intelligence?</li> <li>The Business Intelligence value proposition</li> <li>Business Intelligence taxonomy</li> <li>Business Intelligence management issues</li> </ul> <h3>Sources of Business Intelligence</h3> <ul> <li>Data warehousing</li> <li>Data and information</li> <li>Information architecture</li> <li>Defining the data warehouse and its relationships</li> <li>Facts and dimensions</li> <li>Modeling, meta-modeling, and schemas</li> <li>Alternate architectures</li> <li>Building the data warehouse</li> <li>Extracting</li> <li>Transforming</li> <li>Loading</li> <li>Setting up the data and relationships</li> <li>Dimensions and the Fact Table</li> <li>Implementing many-to-many relationships in data warehouse</li> <li>Data marts</li> </ul> <h3>Online Analytical Processing (OLAP)</h3> <ul> <li>What is OLAP?</li> <li>OLAP and OLTP</li> <li>OLAP functionality</li> <li>Multi-dimensions</li> <li>Thinking in more than two dimensions</li> <li>What are the possibilities?</li> <li>OLAP architecture</li> <li>Cubism</li> <li>Tools</li> <li>OLAP variations - MOLAP, ROLAP, HOLAP</li> <li>BI using SOA</li> <li>Applications of Business Intelligence</li> <li>Applying BI through OLAP</li> <li>Enterprise Resource Planning and CRM</li> <li>Business Intelligence and financial information</li> </ul> <h3>Business Intelligence User Interfaces and Presentations</h3> <ul> <li>Data access</li> <li>Push-pull data access</li> <li>Types of decision support systems</li> <li>Designing the front end</li> <li>Presentation formats</li> <li>Dashboards</li> <li>Types of dashboards</li> <li>Common dashboard features</li> <li>Briefing books and scorecards</li> <li>Querying and Reporting</li> <li>Reporting emphasis</li> <li>Retrofitting</li> <li>Talking back</li> <li>Key Performance Indicators</li> <li>Report Definition and Visualization</li> <li>Typical reporting environment</li> <li>Forms of visualization</li> <li>Unconstrained views</li> <li>Data mining</li> <li>What is in the mine?</li> <li>Applications for data mining</li> <li>Data mining architecture</li> <li>Cross Industry Standard Process for Data Mining (CISP-DM)</li> <li>Data mining techniques</li> <li>Validation</li> </ul> <h3>The Business Intelligence User Experience</h3> <ul> <li>The business analyst role</li> <li>Business analysis and data analysis</li> <li>Five-step approach</li> <li>Cultural impact</li> <li>Identifying questions</li> <li>Gathering information</li> <li>Understand the goals</li> <li>The strategic Business Intelligence cycle</li> <li>Focus of Business Intelligence</li> <li>Design for the user</li> <li>Iterate the access</li> <li>Iterative solution development process</li> <li>Review and validation questions</li> <li>Basic approaches</li> <li>Building ad-hoc queries</li> <li>Building on-demand self-service reports</li> <li>Closed loop Business Intelligence</li> <li>Coming attractions - future of Business Intelligence</li> <li>Best practices in Business Intelligence</li> </ul>


                </section>

Business Intelligence: Virtual In-House Training
Business Intelligence (BI) refers to a set of technology-based techniques, applications, and practices used to aggregate, analyze, and present business data. BI practices provide historical and current views of vast amounts of data and generate predictions for business operations. The purpose of Business Intelligence is the support of better business decision making. This course provides an overview of the technology and application of BI and how it can be used to improve corporate performance.
What you will Learn
You will learn how to:
Specify a data warehouse schema
Identify the data and visualization to be used for data mining and Business Intelligence
Design a Business Intelligence user interface
Getting Started
Introductions
Agenda
Expectations
Foundation Concepts
The challenge of decision making
What is Business Intelligence?
The Business Intelligence value proposition
Business Intelligence taxonomy
Business Intelligence management issues
Sources of Business Intelligence
Data warehousing
Data and information
Information architecture
Defining the data warehouse and its relationships
Facts and dimensions
Modeling, meta-modeling, and schemas
Alternate architectures
Building the data warehouse
Extracting
Transforming
Loading
Setting up the data and relationships
Dimensions and the Fact Table
Implementing many-to-many relationships in data warehouse
Data marts
Online Analytical Processing (OLAP)
What is OLAP?
OLAP and OLTP
OLAP functionality
Multi-dimensions
Thinking in more than two dimensions
What are the possibilities?
OLAP architecture
Cubism
Tools
OLAP variations - MOLAP, ROLAP, HOLAP
BI using SOA
Applications of Business Intelligence
Applying BI through OLAP
Enterprise Resource Planning and CRM
Business Intelligence and financial information
Business Intelligence User Interfaces and Presentations
Data access
Push-pull data access
Types of decision support systems
Designing the front end
Presentation formats
Dashboards
Types of dashboards
Common dashboard features
Briefing books and scorecards
Querying and Reporting
Reporting emphasis
Retrofitting
Talking back
Key Performance Indicators
Report Definition and Visualization
Typical reporting environment
Forms of visualization
Unconstrained views
Data mining
What is in the mine?
Applications for data mining
Data mining architecture
Cross Industry Standard Process for Data Mining (CISP-DM)
Data mining techniques
Validation
The Business Intelligence User Experience
The business analyst role
Business analysis and data analysis
Five-step approach
Cultural impact
Identifying questions
Gathering information
Understand the goals
The strategic Business Intelligence cycle
Focus of Business Intelligence
Design for the user
Iterate the access
Iterative solution development process
Review and validation questions
Basic approaches
Building ad-hoc queries
Building on-demand self-service reports
Closed loop Business Intelligence
Coming attractions - future of Business Intelligence
Best practices in Business Intelligence

Business Intelligence: Virtual In-House Training

<p>This course will allow you to explore the potential of self-service business intelligence using Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, to create Visualizations, and publish Reports to different platforms<br />.</p> <p><strong>Course Objectives</strong></p> <p>At the end of this course you will be able to:</p> <ul> <li>Connect to data from different sources.</li><li>Use the Query Editor</li><li>Perform Power BI desktop data Shaping and Transformation.</li><li>Create Power BI desktop Modelling.</li><li>Create Power BI desktop Visualizations and Reports.</li></ul> <p>' 1 year email support service</p> <p>Take a closer look at the <strong>consistent excellent feedback from our growing corporate clients</strong> visiting our site <em><strong>ms-officetraining co uk</strong></em></p> <p>With more than 20 years experience, we deliver courses on all levels of the Desktop version of <strong>Microsoft Office and Office 365</strong>; ranging from Beginner, Intermediate, Advanced to the VBA level and Business Intelligence.</p> <p>Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering<strong> public, one to one, tailored and bespoke course</strong></p> <p><strong><strong>Tailored training courses:</strong></strong></p> <p>in in company training, you can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs.</p> <p>Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in.</p><p><strong>Introduction to Power BI</strong></p> <ul> <li>Power BI Jargon explained</li><li>A quick look at Power BI Desktop</li><li>A quick look at the Power BI service</li><li>Helpful resources</li></ul> <p><strong>Power BI and Excel</strong></p> <ul> <li>Introduction to using Excel data in Power BI</li><li>Upload Excel data to Power BI</li><li>Import Power View and Power Pivot to Power BI</li></ul> <p><strong>Getting started with Power BI Desktop</strong></p> <ul> <li>Overview of Power BI Desktop</li><li>Accessing Help and Helpful resources</li><li>Connect to data sources in Power BI Desktop</li></ul> <p><strong>Shaping and Transforming Data with Query Editor</strong></p> <ul> <li>Introduction to the Query Editor</li><li>Data Sources Power BI Desktop can Connect to</li><li>Introduction to Steps and M code</li><li>Combining Data Using Merge and Append Queries</li><li>Data Type Properties</li><li>Working with Delimiters</li><li>Clean and transform your data with the Query Editor</li><li>Text Specific Transformation Tools</li><li>Number Specific Transformation Tools</li><li>Date Specific Transformation Tools</li><li>Split and Merge columns</li><li>Creating an Index Column</li><li>Adding Conditional Columns</li><li>Columns From Examples</li><li>Grouping and Aggregating data</li><li>Pivoting and Unpivoting</li><li>Using filters</li></ul> <p><strong>Modeling the data</strong></p> <ul> <li>Introduction to modeling your data</li><li>How to manage your data relationships</li><li>Create calculated columns</li><li>Optimizing data models</li><li>Create calculated measures</li><li>Show Values As and Quick Measures</li><li>Create calculated tables</li><li>Explore your time-based data</li><li>Introduction to DAX</li><li>DAX calculation types</li><li>DAX functions</li></ul> <p><strong>Visualizations</strong></p> <ul> <li>Introduction to visuals in Power BI</li><li>Create and customize simple visualizations</li><li>Modify colors in charts and visuals</li><li>Shapes, text boxes, and images</li><li>Page layout and formatting</li><li>Group interactions among visualizations</li><li>Visual hierarchies and drill-down</li><li>Using custom visualizations</li><li>Create a KPI Visualization</li><li>Geo-Data and Maps</li></ul> <p><strong>Reports, Publishing and Sharing</strong></p> <ul> <li>Introduction to the Power BI service</li><li>Quick insights in Power BI</li><li>Create and configure a dashboard</li><li>Ask questions of your data with natural language</li><li>Create custom Q&amp;A suggestions</li><li>Share dashboards with your organization</li><li>Introduction to content packs, security, and groups</li><li>Publish Power BI Desktop reports</li><li>Print and export dashboards and reports</li><li>Create groups in Power BI</li><li>Use content packs</li><li>Update content packs</li><li>Publish to web</li></ul><h2>
        
            Who is this course for?
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                             <p>This course facilitates you with knowledge on the potential for Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, and to create Visualizations, and publish Reports to different platforms.</p> 
                        </div><h2>
        
            Requirements
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                             <p>Before attending this course, delegates should have:<br />- A general knowledge of database concepts (fields, records and relationships)<br />- Familiarity with Excel.</p> 
                        </div><h2>
        
            Career path
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                             <p>Business Intelligence<br /><br />Data Analysis<br /><br />ETL &amp; Data Warehousing</p> 
                        </div>

This course will allow you to explore the potential of self-service business intelligence using Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, to create Visualizations, and publish Reports to different platforms
.
Course Objectives
At the end of this course you will be able to:
Connect to data from different sources.
Use the Query Editor
Perform Power BI desktop data Shaping and Transformation.
Create Power BI desktop Modelling.
Create Power BI desktop Visualizations and Reports.
' 1 year email support service
Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk
With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level and Business Intelligence.
Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke course
Tailored training courses:
in in company training, you can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs.
Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in.
Introduction to Power BI
Power BI Jargon explained
A quick look at Power BI Desktop
A quick look at the Power BI service
Helpful resources
Power BI and Excel
Introduction to using Excel data in Power BI
Upload Excel data to Power BI
Import Power View and Power Pivot to Power BI
Getting started with Power BI Desktop
Overview of Power BI Desktop
Accessing Help and Helpful resources
Connect to data sources in Power BI Desktop
Shaping and Transforming Data with Query Editor
Introduction to the Query Editor
Data Sources Power BI Desktop can Connect to
Introduction to Steps and M code
Combining Data Using Merge and Append Queries
Data Type Properties
Working with Delimiters
Clean and transform your data with the Query Editor
Text Specific Transformation Tools
Number Specific Transformation Tools
Date Specific Transformation Tools
Split and Merge columns
Creating an Index Column
Adding Conditional Columns
Columns From Examples
Grouping and Aggregating data
Pivoting and Unpivoting
Using filters
Modeling the data
Introduction to modeling your data
How to manage your data relationships
Create calculated columns
Optimizing data models
Create calculated measures
Show Values As and Quick Measures
Create calculated tables
Explore your time-based data
Introduction to DAX
DAX calculation types
DAX functions
Visualizations
Introduction to visuals in Power BI
Create and customize simple visualizations
Modify colors in charts and visuals
Shapes, text boxes, and images
Page layout and formatting
Group interactions among visualizations
Visual hierarchies and drill-down
Using custom visualizations
Create a KPI Visualization
Geo-Data and Maps
Reports, Publishing and Sharing
Introduction to the Power BI service
Quick insights in Power BI
Create and configure a dashboard
Ask questions of your data with natural language
Create custom Q&A suggestions
Share dashboards with your organization
Introduction to content packs, security, and groups
Publish Power BI Desktop reports
Print and export dashboards and reports
Create groups in Power BI
Use content packs
Update content packs
Publish to web
 Who is this course for? Who is this course for? 
This course facilitates you with knowledge on the potential for Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, and to create Visualizations, and publish Reports to different platforms.
 Requirements Requirements 
Before attending this course, delegates should have:
- A general knowledge of database concepts (fields, records and relationships)
- Familiarity with Excel.
 Career path Career path 
Business Intelligence

Data Analysis

ETL & Data Warehousing

Microsoft Office Training

Microsoft Power Apps

Microsoft Power BI Desktop (live online classes)

<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.


Tableau Desktop Specialist

Power BI: Dashboard in a Day

<p>This course will allow you to explore the potential of self-service business intelligence using Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and  data Modelling, to create Visualizations, and publish Reports to different platforms<br />.</p> <p><strong>Course Objectives</strong></p> <p>At the end of this course you will be able to:</p> <ul> <li>Connect to data from different sources.</li><li>Use the Query Editor</li><li>Perform Power BI desktop data Shaping and Transformation.</li><li>Create Power BI desktop Modelling.</li><li>Create Power BI desktop Visualizations and Reports.</li></ul> <p>' 1 year email support service</p> <p>Take a closer look at the <strong>consistent excellent feedback from our growing corporate clients</strong> visiting our site <em><strong>ms-officetraining co uk</strong></em></p> <p>With more than 20 years experience, we deliver courses on all levels of the Desktop version of <strong>Microsoft Office and Office 365</strong>; ranging from Beginner, Intermediate, Advanced to the VBA level and Business Intelligence.</p> <p>Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering<strong> public, one to one, tailored and bespoke courses.</strong></p> <ul> <li><strong>Our competitive rates <strong>start from £550.00 per day of training</strong></strong></li></ul> <p><strong><strong>Tailored training courses:</strong></strong></p> <p>You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs.</p> <p>Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in.</p><p><strong>Introduction to Power BI</strong></p> <ul> <li>Power BI Jargon explained</li><li>A quick look at Power BI Desktop</li><li>A quick look at the Power BI service</li><li>Helpful resources</li></ul> <p><strong>Power BI and Excel</strong></p> <ul> <li>Introduction to using Excel data in Power BI</li><li>Upload Excel data to Power BI</li><li>Import Power View and Power Pivot to Power BI</li></ul> <p><strong>Getting started with Power BI Desktop</strong></p> <ul> <li>Overview of Power BI Desktop</li><li>Accessing Help and Helpful resources</li><li>Connect to data sources in Power BI Desktop</li></ul> <p><strong>Shaping and Transforming Data with Query Editor</strong></p> <ul> <li>Introduction to the Query Editor</li><li>Data Sources Power BI Desktop can Connect to</li><li>Introduction to Steps and M code</li><li>Combining Data Using Merge and Append Queries</li><li>Data Type Properties</li><li>Working with Delimiters</li><li>Clean and transform your data with the Query Editor</li><li>Text Specific Transformation Tools</li><li>Number Specific Transformation Tools</li><li>Date Specific Transformation Tools</li><li>Split and Merge columns</li><li>Creating an Index Column</li><li>Adding Conditional Columns</li><li>Columns From Examples</li><li>Grouping and Aggregating data</li><li>Pivoting and Unpivoting</li><li>Using filters</li></ul> <p><strong>Modeling the data</strong></p> <ul> <li>Introduction to modeling your data</li><li>How to manage your data relationships</li><li>Create calculated columns</li><li>Optimizing data models</li><li>Create calculated measures</li><li>Show Values As and Quick Measures</li><li>Create calculated tables</li><li>Explore your time-based data</li><li>Introduction to DAX</li><li>DAX calculation types</li><li>DAX functions</li></ul> <p><strong>Visualizations</strong></p> <ul> <li>Introduction to visuals in Power BI</li><li>Create and customize simple visualizations</li><li>Modify colors in charts and visuals</li><li>Shapes, text boxes, and images</li><li>Page layout and formatting</li><li>Group interactions among visualizations</li><li>Visual hierarchies and drill-down</li><li>Using custom visualizations</li><li>Create a KPI Visualization</li><li>Geo-Data and Maps</li></ul> <p><strong>Reports, Publishing and Sharing</strong></p> <ul> <li>Introduction to the Power BI service</li><li>Quick insights in Power BI</li><li>Create and configure a dashboard</li><li>Ask questions of your data with natural language</li><li>Create custom Q&amp;A suggestions</li><li>Share dashboards with your organization</li><li>Introduction to content packs, security, and groups</li><li>Publish Power BI Desktop reports</li><li>Print and export dashboards and reports</li><li>Create groups in Power BI</li><li>Use content packs</li><li>Update content packs</li><li>Publish to web</li></ul><h2>
        
            Who is this course for?
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                             <p>This course facilitates you with knowledge on the potential for Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, and to create  Visualizations, and publish Reports to different platforms.</p> 
                        </div><h2>
        
            Requirements
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                             <p>Before attending this course, delegates should have:<br />- A general knowledge of database concepts (fields, records and relationships)<br />- Familiarity with Excel.</p> 
                        </div><h2>
        
            Career path
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                             <p>Business Intelligence<br /><br />Data Analysis<br /><br />ETL &amp; Data Warehousing</p> 
                        </div>

This course will allow you to explore the potential of self-service business intelligence using Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, to create Visualizations, and publish Reports to different platforms
.
Course Objectives
At the end of this course you will be able to:
Connect to data from different sources.
Use the Query Editor
Perform Power BI desktop data Shaping and Transformation.
Create Power BI desktop Modelling.
Create Power BI desktop Visualizations and Reports.
' 1 year email support service
Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk
With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level and Business Intelligence.
Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses.
Our competitive rates start from £550.00 per day of training
Tailored training courses:
You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs.
Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in.
Introduction to Power BI
Power BI Jargon explained
A quick look at Power BI Desktop
A quick look at the Power BI service
Helpful resources
Power BI and Excel
Introduction to using Excel data in Power BI
Upload Excel data to Power BI
Import Power View and Power Pivot to Power BI
Getting started with Power BI Desktop
Overview of Power BI Desktop
Accessing Help and Helpful resources
Connect to data sources in Power BI Desktop
Shaping and Transforming Data with Query Editor
Introduction to the Query Editor
Data Sources Power BI Desktop can Connect to
Introduction to Steps and M code
Combining Data Using Merge and Append Queries
Data Type Properties
Working with Delimiters
Clean and transform your data with the Query Editor
Text Specific Transformation Tools
Number Specific Transformation Tools
Date Specific Transformation Tools
Split and Merge columns
Creating an Index Column
Adding Conditional Columns
Columns From Examples
Grouping and Aggregating data
Pivoting and Unpivoting
Using filters
Modeling the data
Introduction to modeling your data
How to manage your data relationships
Create calculated columns
Optimizing data models
Create calculated measures
Show Values As and Quick Measures
Create calculated tables
Explore your time-based data
Introduction to DAX
DAX calculation types
DAX functions
Visualizations
Introduction to visuals in Power BI
Create and customize simple visualizations
Modify colors in charts and visuals
Shapes, text boxes, and images
Page layout and formatting
Group interactions among visualizations
Visual hierarchies and drill-down
Using custom visualizations
Create a KPI Visualization
Geo-Data and Maps
Reports, Publishing and Sharing
Introduction to the Power BI service
Quick insights in Power BI
Create and configure a dashboard
Ask questions of your data with natural language
Create custom Q&A suggestions
Share dashboards with your organization
Introduction to content packs, security, and groups
Publish Power BI Desktop reports
Print and export dashboards and reports
Create groups in Power BI
Use content packs
Update content packs
Publish to web
 Who is this course for? Who is this course for? 
This course facilitates you with knowledge on the potential for Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, and to create Visualizations, and publish Reports to different platforms.
 Requirements Requirements 
Before attending this course, delegates should have:
- A general knowledge of database concepts (fields, records and relationships)
- Familiarity with Excel.
 Career path Career path 
Business Intelligence

Data Analysis

ETL & Data Warehousing

Microsoft Power BI Desktop In-company (now with live online classes)

<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p>This course is designed for professionals in a variety of job roles who receive Power BI data visualizations and reports from data analysts or from data visualization engineers. These data report recipients want to use the features and capabilities of Power BI to fully explore the visualizations and initial analyses provided to them in reports, perform additional analysis to ask next-level questions of the data, and to customize and create new visualizations and dashboards in order to share new insights and create compelling reports.</p>Overview<p>Explore Power BI reports.  Analyze data to get answers and insights.  Sort and group data for analysis and reporting.  Filter visualizations.  Prepare reports.  Troubleshoot, collaborate, and share reports.</p><p>As data acquisition, access, analysis, and reporting are interwoven with our businesses and lives, more and more data is collected about business and personal activities. This abundance of data and the computing power to analyze it has increased the use of data analysis and data visualization across a broad range of job roles. Decision makers of all types, including managers and executives, must interact with, interpret, and develop reports based on data and analysis provided to them. Microsoft Power BI software is designed for data analysis and the creation of visualizations. Data analysts prepare data, perform initial analysis, and create visualizations that are then passed to business data decision makers. These decision makers can use Power BI's tools to explore the data, perform further analysis to find new insights, make decisions, and create customized reports to share their findings.</p>Prerequisites<p>To ensure your success in this course, you have experience managing data with Microsoft Excel or Google Sheets</p></div><div id="course-pills-2"><h3>1. Exploring Power BI Reports</h3><ul> <li>Topic A: Data Analysis Workflow with Power BI</li>  <li>Topic B: Explore Reports in the Power BI Service</li>  <li>Topic C: Edit Reports</li></ul>    <h3>2. Analyzing Data to Get Answers and Insights</h3><ul> <li>Topic A: Configure Data Visualizations</li>  <li>Topic B: Ask New Questions by Changing Aggregation</li>  <li>Topic C: Find Answers with Calculations</li></ul>    <h3>3.  Sorting and Grouping Data for Analysis and Reporting</h3><ul> <li>Topic A: Sort Data</li>  <li>Topic B: Group Data</li></ul>   <h3>4.  Filtering Visualizations</h3><ul> <li>Topic A: Filter Data to Refine Analysis</li>  <li>Topic B: Create Slicers for Reports</li></ul>    <h3>5.  Preparing Reports</h3><ul> <li>Topic A: Format and Annotate Reports</li>  <li>Topic B: Emphasize Data in Reports</li></ul>    <h3>6.  Troubleshooting, Sharing, and Collaborating</h3><ul> <li>Topic A: Troubleshoot Data Issues</li>  <li>Topic B: Collaborate in Power BI</li>  <li>Topic C: Collaborate with Non-Power BI Users</li></ul></div>

Duration
1 Days
6 CPD hours
This course is intended for
This course is designed for professionals in a variety of job roles who receive Power BI data visualizations and reports from data analysts or from data visualization engineers. These data report recipients want to use the features and capabilities of Power BI to fully explore the visualizations and initial analyses provided to them in reports, perform additional analysis to ask next-level questions of the data, and to customize and create new visualizations and dashboards in order to share new insights and create compelling reports.
Overview
Explore Power BI reports. Analyze data to get answers and insights. Sort and group data for analysis and reporting. Filter visualizations. Prepare reports. Troubleshoot, collaborate, and share reports.
As data acquisition, access, analysis, and reporting are interwoven with our businesses and lives, more and more data is collected about business and personal activities. This abundance of data and the computing power to analyze it has increased the use of data analysis and data visualization across a broad range of job roles. Decision makers of all types, including managers and executives, must interact with, interpret, and develop reports based on data and analysis provided to them. Microsoft Power BI software is designed for data analysis and the creation of visualizations. Data analysts prepare data, perform initial analysis, and create visualizations that are then passed to business data decision makers. These decision makers can use Power BI's tools to explore the data, perform further analysis to find new insights, make decisions, and create customized reports to share their findings.
Prerequisites
To ensure your success in this course, you have experience managing data with Microsoft Excel or Google Sheets
1. Exploring Power BI Reports
Topic A: Data Analysis Workflow with Power BI
Topic B: Explore Reports in the Power BI Service
Topic C: Edit Reports
2. Analyzing Data to Get Answers and Insights
Topic A: Configure Data Visualizations
Topic B: Ask New Questions by Changing Aggregation
Topic C: Find Answers with Calculations
3. Sorting and Grouping Data for Analysis and Reporting
Topic A: Sort Data
Topic B: Group Data
4. Filtering Visualizations
Topic A: Filter Data to Refine Analysis
Topic B: Create Slicers for Reports
5. Preparing Reports
Topic A: Format and Annotate Reports
Topic B: Emphasize Data in Reports
6. Troubleshooting, Sharing, and Collaborating
Topic A: Troubleshoot Data Issues
Topic B: Collaborate in Power BI
Topic C: Collaborate with Non-Power BI Users

Educators providing Microsoft BI courses in Bristol delivered Online