Most popular
Tableau Server Administration (TTDTAB005)
What you'll learn
User interactions with Tableau Server
Tableau Server components
Single-server installation
Content administration
Authorization and permissions
Users, groups, and sites
Data sources and extracts
Schedules, tasks, and subscriptions
Monitoring server status
Command-line utilities and REST API
Upgrading a single-server installation to a new version
Modifying the authentication method
Developing with Spark for Big Data (TTSK7505)
What you'll learn
The essentials of Spark architecture and applications
How to execute Spark Programs
How to create and manipulate both RDDs (Resilient Distributed Datasets) and UDFs (Unified Data Frames)
How to persist and restore data frames
Essential NOSQL access
How to integrate machine learning into Spark applications
How to use Spark Streaming and Kafka to create streaming applications
Next Level Power BI (TTDPB02)
What you'll learn
Identify and retrieve data from data sources and understand the different connection methods.
Optimize query performance
Profile and examine the data and apply data shape transformations
Develop a scalable and performance data model
Enhance the data model with DAX using measures, calculated columns and tables
Use variables and aggregations to optimize model performance
Design and create reports and dashboards
Select and add appropriate visualizations
Create paginated reports
Perform Advanced Analytics
Create and manage workspaces
Manage datasets and dataset refresh
Apply row-level security
Intermediate
55164-A: Quick Powerful Graphics with Power View, PowerPivot, Power Query, Power Map and Power BI
$1,590.00
55164-A: Quick Powerful Graphics with Power View, PowerPivot, Power Query, Power Map and Power BI
What you'll learn
Navigate the Power View interface.
Utilize Power View reports.
Work with tables.
Understand aggregations.
Utilize matrix.
Configure drill through.
Use cards as a visualization.
Apply filters.
Create charts.
Utilize tiles.
Add slicers to reports.
Utilize themes.
Navigate the PowerPivot interface.
Examine and configure relationships.
Configure calculated columns are calculated fields.
Create PivotTables.
Understand and utilize DAX.
Work with hierarchies.
Manage perspectives.
Navigate the Power Query interface.
Merge datasets.
Manage modifications.
Perform data cleaning.
Navigate the Power Map interface.
Use Bing maps.
Examine map data.
Configure tours, scenes, and layers.
Add time to a presentation.
Navigate the Power BI interface.
Utilize data sources.
Understand querying with natural language.
Successfully log into their virtual machine.
Have a full understanding of what the course intends to cover.
Apache Spark for Data Scientists
What you'll learn
The essentials of Spark architecture and applications
How to execute Spark Programs
How to create and manipulate both RDDs (Resilient Distributed Datasets) and UDFs (Unified Data Frames)
How to integrate machine learning into Spark applications
How to use Spark Streaming
Introduction to Power BI (TTDPB01)
What you'll learn
Perform Power BI desktop data transformation.
Describe Power BI desktop modelling.
Create a Power BI desktop visualization.
Implement the Power BI service.
Describe how to connect to Excel data.
Shape and Combine Data
Describe how to collaborate with Power BI data.
Connect directly to data stores.
Time Permitting: Explore the Power BI developer API.
Time Permitting: Describe the Power BI mobile app
Intermediate
55049-A: PowerPivot, Power View and SharePoint 2013 Business Intelligence Center for Analysts
$1,195.00
55049-A: PowerPivot, Power View and SharePoint 2013 Business Intelligence Center for Analysts
What you'll learn
Successfully log into their virtual machine.
Use PowerPivot 2013 in Excel.
Work with DAX.
Create Power View visualizations.
Understand data models.
Save to SharePoint.
Surface on SharePoint.
Work with the SharePoint Business Intelligence Center.
Create dedicated apps in SharePoint for PowerPivot and Power View.
Use PowerPivot within Excel to import a table from SQL Server.
Use PowerPivot within Excel to import a table from SQL Server Analysis Services.
Hide columns they don’t want reflected in the resulting PivotTable.
View the relationships existing within the imported tables from SQL Server and then import an additional table and configure a relationship between it and the existing.
Create a PivotTable within an existing worksheet.
Navigate and successfully use Power View.
Create a table.
Create a chart.
Save and share their work.
Create a BI semantic model.
Explore the options and settings available within the new SharePoint 2013 Central Administration and Excel Services.
Access and review the Secure Store.
Create a new web application and business intelligence site while exploring the features of both.
Create custom apps to store visualizations and/or workbooks in SharePoint 2013 Business Intelligence Center.
Enterprise Scala with Spark
What you'll learn
Essential Scala programming, leveraging your existing OO development experience
How to write essential Spark programs and perform exploratory data analysis in Scala and the Spark shell
Work with Spark Core
Work with NoSQL
How to write programs for Spark Streaming in Scala
55232-A: Writing Analytical Queries for Business Intelligence
What you'll learn
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.
Describe the purpose of analytical queries
Describe the function of TSQL data retrieval in an analytics/business intelligence environment
Describe the primary functions of the database engine
Discuss TSQL as a declarative language
Identify variables of interest in database tables
Write basic SELECT queries
Implement column expressions in SELECT queries
Implement column and table aliases
Describe data types and Implement data type conversions
Implement built-in functions
Use WHERE and ORDER BY clauses in SELECT queries
Discuss and describe the conceptual flow of JOIN operations
Implement INNER and OUTER JOIN operations on two or more tables
Describe the order of operations of SELECT clauses
Combine JOIN operations with WHERE and ORDER BY
Describe the row granularity of result sets
Discuss and implement aggregate functions to achieve required row granularity
Use GROUP BY to calculate aggregate values for groups
Use HAVING to filter records in the result set by aggregate value
Combine GROUP BY and HAVING with WHERE and ORDER BY
Describe and discuss the rationale of creating intermediate results sets within SELECT queries
Implement non-correlated and correlated subqueries
Implement derived tables
Implement Common Table Expressions
Create intermediate to advanced TSQL queries to retrieve result sets for analysis
Identify scenarios in which views, table-valued functions, and stored procedures simply data retrieval
Compare and contrast views, table-valued functions, and stored procedures
Create views, table-valued functions, and stored procedures
Describe the security requirement for creating database objects
Implement views, table-valued functions, and stored procedures for users with read-only access to source data
Describe the properties of database connection strings
Run queries from, and return results to, Excel, PowerBI, and RStudio
Export query results to external text files using the SSMS results pane, the bcp utility, and the Import/Export Wizard
Splunk Boot Camp
What you'll learn
Splunk essentials
Indexing in Splunk
Splunk architecture and components
Query and search your data
How to create dashboards and visualizations
How to apply alerts
Trending
Tableau Server Administration (TTDTAB005)
What you'll learn
User interactions with Tableau Server
Tableau Server components
Single-server installation
Content administration
Authorization and permissions
Users, groups, and sites
Data sources and extracts
Schedules, tasks, and subscriptions
Monitoring server status
Command-line utilities and REST API
Upgrading a single-server installation to a new version
Modifying the authentication method
Developing with Spark for Big Data (TTSK7505)
What you'll learn
The essentials of Spark architecture and applications
How to execute Spark Programs
How to create and manipulate both RDDs (Resilient Distributed Datasets) and UDFs (Unified Data Frames)
How to persist and restore data frames
Essential NOSQL access
How to integrate machine learning into Spark applications
How to use Spark Streaming and Kafka to create streaming applications
Next Level Power BI (TTDPB02)
What you'll learn
Identify and retrieve data from data sources and understand the different connection methods.
Optimize query performance
Profile and examine the data and apply data shape transformations
Develop a scalable and performance data model
Enhance the data model with DAX using measures, calculated columns and tables
Use variables and aggregations to optimize model performance
Design and create reports and dashboards
Select and add appropriate visualizations
Create paginated reports
Perform Advanced Analytics
Create and manage workspaces
Manage datasets and dataset refresh
Apply row-level security
Intermediate
55164-A: Quick Powerful Graphics with Power View, PowerPivot, Power Query, Power Map and Power BI
$1,590.00
55164-A: Quick Powerful Graphics with Power View, PowerPivot, Power Query, Power Map and Power BI
What you'll learn
Navigate the Power View interface.
Utilize Power View reports.
Work with tables.
Understand aggregations.
Utilize matrix.
Configure drill through.
Use cards as a visualization.
Apply filters.
Create charts.
Utilize tiles.
Add slicers to reports.
Utilize themes.
Navigate the PowerPivot interface.
Examine and configure relationships.
Configure calculated columns are calculated fields.
Create PivotTables.
Understand and utilize DAX.
Work with hierarchies.
Manage perspectives.
Navigate the Power Query interface.
Merge datasets.
Manage modifications.
Perform data cleaning.
Navigate the Power Map interface.
Use Bing maps.
Examine map data.
Configure tours, scenes, and layers.
Add time to a presentation.
Navigate the Power BI interface.
Utilize data sources.
Understand querying with natural language.
Successfully log into their virtual machine.
Have a full understanding of what the course intends to cover.
Apache Spark for Data Scientists
What you'll learn
The essentials of Spark architecture and applications
How to execute Spark Programs
How to create and manipulate both RDDs (Resilient Distributed Datasets) and UDFs (Unified Data Frames)
How to integrate machine learning into Spark applications
How to use Spark Streaming
Introduction to Power BI (TTDPB01)
What you'll learn
Perform Power BI desktop data transformation.
Describe Power BI desktop modelling.
Create a Power BI desktop visualization.
Implement the Power BI service.
Describe how to connect to Excel data.
Shape and Combine Data
Describe how to collaborate with Power BI data.
Connect directly to data stores.
Time Permitting: Explore the Power BI developer API.
Time Permitting: Describe the Power BI mobile app
Intermediate
55049-A: PowerPivot, Power View and SharePoint 2013 Business Intelligence Center for Analysts
$1,195.00
55049-A: PowerPivot, Power View and SharePoint 2013 Business Intelligence Center for Analysts
What you'll learn
Successfully log into their virtual machine.
Use PowerPivot 2013 in Excel.
Work with DAX.
Create Power View visualizations.
Understand data models.
Save to SharePoint.
Surface on SharePoint.
Work with the SharePoint Business Intelligence Center.
Create dedicated apps in SharePoint for PowerPivot and Power View.
Use PowerPivot within Excel to import a table from SQL Server.
Use PowerPivot within Excel to import a table from SQL Server Analysis Services.
Hide columns they don’t want reflected in the resulting PivotTable.
View the relationships existing within the imported tables from SQL Server and then import an additional table and configure a relationship between it and the existing.
Create a PivotTable within an existing worksheet.
Navigate and successfully use Power View.
Create a table.
Create a chart.
Save and share their work.
Create a BI semantic model.
Explore the options and settings available within the new SharePoint 2013 Central Administration and Excel Services.
Access and review the Secure Store.
Create a new web application and business intelligence site while exploring the features of both.
Create custom apps to store visualizations and/or workbooks in SharePoint 2013 Business Intelligence Center.
Enterprise Scala with Spark
What you'll learn
Essential Scala programming, leveraging your existing OO development experience
How to write essential Spark programs and perform exploratory data analysis in Scala and the Spark shell
Work with Spark Core
Work with NoSQL
How to write programs for Spark Streaming in Scala
55232-A: Writing Analytical Queries for Business Intelligence
What you'll learn
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.
Describe the purpose of analytical queries
Describe the function of TSQL data retrieval in an analytics/business intelligence environment
Describe the primary functions of the database engine
Discuss TSQL as a declarative language
Identify variables of interest in database tables
Write basic SELECT queries
Implement column expressions in SELECT queries
Implement column and table aliases
Describe data types and Implement data type conversions
Implement built-in functions
Use WHERE and ORDER BY clauses in SELECT queries
Discuss and describe the conceptual flow of JOIN operations
Implement INNER and OUTER JOIN operations on two or more tables
Describe the order of operations of SELECT clauses
Combine JOIN operations with WHERE and ORDER BY
Describe the row granularity of result sets
Discuss and implement aggregate functions to achieve required row granularity
Use GROUP BY to calculate aggregate values for groups
Use HAVING to filter records in the result set by aggregate value
Combine GROUP BY and HAVING with WHERE and ORDER BY
Describe and discuss the rationale of creating intermediate results sets within SELECT queries
Implement non-correlated and correlated subqueries
Implement derived tables
Implement Common Table Expressions
Create intermediate to advanced TSQL queries to retrieve result sets for analysis
Identify scenarios in which views, table-valued functions, and stored procedures simply data retrieval
Compare and contrast views, table-valued functions, and stored procedures
Create views, table-valued functions, and stored procedures
Describe the security requirement for creating database objects
Implement views, table-valued functions, and stored procedures for users with read-only access to source data
Describe the properties of database connection strings
Run queries from, and return results to, Excel, PowerBI, and RStudio
Export query results to external text files using the SSMS results pane, the bcp utility, and the Import/Export Wizard
Splunk Boot Camp
What you'll learn
Splunk essentials
Indexing in Splunk
Splunk architecture and components
Query and search your data
How to create dashboards and visualizations
How to apply alerts
Featured Courses
Featured
PL-300: Microsoft Power BI Data Analyst
This course will discuss the various methods and best practices …
Featured
CompTIA Data+
Course Description As the importance of data analytics grows, more …
CompTIA Data+
What you'll learn
CompTIA Data+ gives you the confidence to bring data analysis to life
Analyzing complex datasets while adhering to governance and quality standards throughout the entire data life cycle
Mining data
Manipulating data
Visualizing and reporting data
Applying basic statistical methods
All Analytics & BI Courses
Analytics & Business Intelligence Online Training Courses - Live
An organization’s analytics and data management initiatives require a broad range of skills across a broad range of technologies and processes. Our courses are taught by industry experts who bring real-life knowledge and experience to the classroom. They help students:
- visualize critical information
- discover new patterns and trends
- mine and integrate data from disparate sources
- optimize data models
Filter by Topic
Filter by Vendor
Introduction to Power BI (TTDPB01)
QuickStart to Power BI for Analysts and Users is a …
What you'll learn
Perform Power BI desktop data transformation.
Describe Power BI desktop modelling.
Create a Power BI desktop visualization.
Implement the Power BI service.
Describe how to connect to Excel data.
Shape and Combine Data
Describe how to collaborate with Power BI data.
Connect directly to data stores.
Time Permitting: Explore the Power BI developer API.
Time Permitting: Describe the Power BI mobile app
Next Level Power BI (TTDPB02)
Next Level Power BI for Experienced Users is a two-day …
What you'll learn
Identify and retrieve data from data sources and understand the different connection methods.
Optimize query performance
Profile and examine the data and apply data shape transformations
Develop a scalable and performance data model
Enhance the data model with DAX using measures, calculated columns and tables
Use variables and aggregations to optimize model performance
Design and create reports and dashboards
Select and add appropriate visualizations
Create paginated reports
Perform Advanced Analytics
Create and manage workspaces
Manage datasets and dataset refresh
Apply row-level security
Tableau Server Administration (TTDTAB005)
Tableau Server Administration is a two-day course that provides new …
What you'll learn
User interactions with Tableau Server
Tableau Server components
Single-server installation
Content administration
Authorization and permissions
Users, groups, and sites
Data sources and extracts
Schedules, tasks, and subscriptions
Monitoring server status
Command-line utilities and REST API
Upgrading a single-server installation to a new version
Modifying the authentication method
Tableau Desktop Fundamentals (TTDTAB006)
Tableau Desktop Fundamentals is a two-day, hands-on course designed for …
What you'll learn
Connect to your data, and Edit and save a data source.
Understand Tableau terminology.
Connect to your data, and Edit and save a data source.
Use the Tableau interface / paradigm to effectively create powerful visualizations.
Create basic calculations including string manipulation, basic arithmetic calculations, custom aggregations and ratios, date math, logic statements and quick table calculations.
Represent your data using the following visualization types: Cross Tabs, Geographic Maps, Heat Maps, Distribution Charts, Tree Maps, Pie Charts and Bar Charts, Dual Axis and Combo Charts with different mark types, Box Plots, Highlight Tables, Scatter Plots
Use Reference Lines to highlight elements of your data.
Use groups, bins, hierarchies, sorts, sets, and filters to create focused and effective visualizations
Use Measure Name and Measure Value fields to create visualizations with multiple measures and dimensions.
Handle changes in your data source such as field addition, deletion or name changes.
Share your visualizations with others.
Combine your visualizations into Interactive Dashboards and publish them to the web.
Tableau Desktop (TTDTAB007)
Geared for experienced Tableau, Tableau Desktop II / Intermediate Tableau …
What you'll learn
Use next-level features within the Tableau interface / paradigm to effectively create powerful, advanced level visualizations
Create advanced calculations including string manipulation, basic arithmetic calculations, custom aggregations and ratios, date math, logic statements and quick table calculations
Use groups, bins, hierarchies, sorts, sets, and filters to create focused, effective and advanced -level visualizations
Use Measure Name and Measure Value fields to create visualizations with multiple measures and dimensions
Share visualizations with others, combining visualizations into Interactive Dashboards and publish them to the web
Represent data visualization (emphasizing advanced skill areas only):
Cross tabs; Heat maps; Distribution charts; Tree maps; Pie charts and bar charts; Dual axis and combo charts with different mark types; Box plots; Highlight tables; Scatter plots
Advanced Tableau | Advanced Data Visualization, Calculations, Analytics, Integration with Hadoop (TTDTAB025)
Geared for experienced Tableau users with data analysis background and …
What you'll learn
Why Data Visualization is Needed?
Connecting to the databases and make basic charts and graphs.
How to make Advance Charts and Graphs.
Scripting functionality and organizing data for effective results
More advanced visualizations for various analytical requirements
Creating Time based calculations.
Using location analytics capabilities to put geographic and other spatial context to your analysis.
Blending and arranging data from multiple source systems for effective analysis.
How to Integrate Tableau with R and Hadoop, Statistical Analytics, and social media analytics.
Working in real time environment for Tableau Projects leveraging the course mini project.
The requirement and creating various dashboards, story boards, deploying your dashboards for the project.
Featured
PL-300: Microsoft Power BI Data Analyst
This course will discuss the various methods and best practices …
Featured
CompTIA Data+
Course Description As the importance of data analytics grows, more …
What you'll learn
CompTIA Data+ gives you the confidence to bring data analysis to life
Analyzing complex datasets while adhering to governance and quality standards throughout the entire data life cycle
Mining data
Manipulating data
Visualizing and reporting data
Applying basic statistical methods
