SQL Scripting Essentials

This two-day, instructor-led SQL training class will give you the skills to write simple and complex queries using SQL (Structured Query Language) statements to retrieve results from a database. You will know how to query database tables and manipulate the results from a variety of databases like Microsoft Access, Oracle, SQL Server and MySQL.

– What is Structured Query Language (SQL)?
– Selecting Data
– Retrieving Data from Multiple Tables
– Using Criteria in SQL Statements
– Generating Totals Using SQL
– Generating Calculated Fields Using SQL
– Unions, Subqueries, and More Joins
– Action Queries
– Advanced SQL Functions
– Conditional Queries

Power BI Introduction – Reports and Dashboards

This one-day, instructor-led Microsoft Power BI class introduces you to data analysis and visualization using the Power BI dashboard and reporting features. You will understand how to work with various datasets and learn basic data scrubbing techniques.

– Introduction to the Power BI Desktop
– Introduction to Business Intelligence
– Introduction to Data Analysis
– Introduction to Data Visualization
– Working with Datasets
– Introduction to Reports
– Creating Dashboards

Power BI Advanced – Dashboards & Data Analysis

This two-day, instructor-led Power BI class gives participants the advanced knowledge how to build and service more sophisticated dashboards and reports. You will be able to manipulate data from different sources and present and share your analysis using visualization tools.

– Data Analysis Using Self-Service BI
– Connecting Data Sources
– Data Transformation
– Data Modeling and Shaping
– Creating Reports & Data Visualization
– Publishing, Sharing and Collaborating

Tableau Desktop Introduction (Part 1)

This two-day, instructor-led Tableau class teaches users how to connect to a wide range of data sources and allows users to quickly create visualizations of connected data to gain insights, show trends, and create reports. Tableau’s data connection capabilities and visualization features go far beyond those that can be found in spreadsheets, allowing users to create compelling and interactive worksheets, dashboards, and stories that bring data to life and turn data into thoughtful action.

– Tableau Fundamentals
– Connecting to and Preparing Data
– Exploring Data
– Managing, Sorting, and Grouping Data
– Saving, Publishing, and Sharing Data
– Filtering Data
– Customizing Visualizations
– Creating Dashboards in Tableau
– Creating Stories in Tableau

Tableau Desktop Advanced (Part 2)

This two-day, instructor-led Tableau class teaches students how to create more advanced data driven visualizations in Tableau. You will learn how to manipulate data with calculations to show insights, make visualizations interactive, and perform statistical analysis. You will walk away with the the ability to create and share stunning data driven insights with peers, executives, and clients.

– Blending Data from Multiple Sources
– Joining Data
– Accessing Data in PDFs
– Refining Visualizations with Sets and Parameters
– Analyzing Data with Calculations
– Visualizing Data with Advanced Calculations
– Performing Statistical Analysis and Forecasting
– Creating Geographic Visualizations
– Getting Answers with Ask and Explain

Automating with Python

This three-day, instructor-led Python class will show you how to use Python to write programs that do in minutes what would take you hours to do manually, and you can attend this class with no prior programming experience. You will learn the basics of Python and explore Python’s rich library of modules for performing specific tasks like scraping data off websites, input validation, reading PDF and Word documents, automating Excel and CSV files, automating Gmail and Google Sheets, and automating clicking and typing tasks.

– Search for text in a file or across multiple files
– Create, update, move, and rename files and folders
– Search the Web and download online content
– Update and format data in Excel spreadsheets of any size
– Split, merge, watermark, and encrypt PDFs
– Send email responses and text notifications
– Fill out online forms