Business Intelligence Analysis

Intermediate Excel When you need to crunch numbers for sales, inventory, IT, or other departments, the ability to get the right information to the right people at the right time can create a powerful competitive advantage. The knowledge on how to manage data and effectively present the information is extremely important. To have a competitive edge in today’s world market, you need to have the knowledge to produce reliable and actionable results from your data. Excel is a powerful, economical, and readily available tool that provides a way to extract the data to get the answers for you. This...

Overview of BI and Data Analysis As the amount of data companies collect continues to grow at a rapid rate, the ability to effectively transform that data into actionable information has become paramount for business growth and success. Business intelligence (BI) and data analytics enables businesses to make better decisions, improve processes, discover efficiencies, support customers, and reduce costs. In this course, students will learn the complete analytics cycle, from determining requirements to extracting and disseminating information. It will cover the process, technologies,...

Introduction to SQL Programming Learn how to use the Structured Query Language (SQL) to create, manipulate, and create reports from database tables. Important concepts associated with relational databases will be covered. You will run SQL commands to create database tables and define data element types. Single and multiple table queries will be created with simple and compound conditions using SQL operators such as: BETWEEN ​LIKE IN EXIST ALL ANY Basic and complex reports will be created based on data in a table or view. Database Administration features of SQL will be discussed. Course...

Advanced Excel for Analysis and Business Intelligence How the business world uses Excel is forever changing. Trying to keep up with it all can be intimidating, complex, and confusing given Excel’s ever-expanding library of functions and features. This course will give students a more cerebral and holistic understanding of Microsoft Excel which will help make all its advanced technical aspects much easier grasp and utilize at work as well as school and home. We will explore Excel’s advanced highlights through a combination of fun to read (yes really!) mind provoking lectures and discussion...

Dashboards and Data Visualization for Data Analysis With the growing amount of data available to businesses, decision-makers must translate strategy into accountability, measure progress against goals, and leverage data for business decision making. Dashboards are used to present and analyzing enterprise performance data, both strategic and operational, and to perform business analysis easily and quickly. This course will teach dashboards and data visualization technologies, using an approach that will include theory as well as a significant hands-on component. Students will learn how to...

Introduction to R Programming Statistical computing is employed within a diverse range of industries. In recent years, an open source project, R, has emerged as the preeminent statistical computing platform. With its unsurpassed library of freely available packages, R is capable of addressing almost every statistical inference problem. In this course, you will learn the most commonly-used (roughly 100) functions and operators from the R Base Package, which serves as the fundamental tools for accessing data from multiple sources, manipulating different types of R objects, performing...

Advanced Business Intelligence: Introduction to Predictive Analytics This course introduces the predictive modeling process and basics of predictive analytics for business applications, including hands-on introduction to data preparation, model identification and validation, model documentation, and interpretation of model results. Topics include: Explain predictive analytics key concepts and terms, benefits, and applications Understand the steps to creating and selecting a predictive model Comprehend the data mining process, including data collection or selection, data cleansing,...

Intermediate SQL Programming SQL is a language used in programming and designed for managing data held in a relational database management system (RDBMS), or for stream processing in a relational data stream management system (RDSMS). SQL allows you to access many records with one single command and it eliminates the need to specify how to reach a record, e.g. with or without an index. This intermediate course will be focused on using MS SQL Server and T-SQL. Topics include: Data aggregation using aggregate functions Writing sub-queries Recursive queries Common table expressions You will...

Python for Informatics Informatics is the study of structure, algorithms, behavior, and interactions of information systems. Its applications are powerful and broad, and include such fields as life sciences, data mining, business analytics, and social computing. This hands-on course introduces the Python programming language, and is targeted toward students without prior programming experience who are interested in how informatics can be employed to provide solutions to complex, data intensive problems in a variety of scientific and business domains. After learning the core syntax and...

According to the Bureau of Labor Statistics most recent figures, overall employment of mathematicians and statisticians is projected to grow 30 percent from 2018 to 2028 - much faster than the average for all occupations. Businesses will need these workers to analyze the increasing volume of digital and electronic data. With the explosion of data and analysts, it has become increasingly important for companies to hire managers capable of achieving business objectives by leveraging data best practices. This course will equip you with the knowledge and skills required to pivot your workplace...

Data Analytics Using Python In this course, you will learn the rich set of tools, libraries, and packages that comprise the highly popular and practical Python data analysis ecosystem. This course is primarily taught via screen sharing programming videos. Topics taught range from basic Python syntax all the way to more advanced topics like supervised and unsupervised machine learning techniques. Key topics: Installing Python/Jupyter/IPython on Windows and Mac Python Basics (variables, strings, simple math, conditional logic, for loops, lists, tuples, dictionaries, etc.) Using the Pandas...

Learn how to analyze data using SPSS Unravel the mysteries within data with SPSS software! SPSS is one of the most popular software packages used for statistical analysis and understanding data. Big data, prediction, and data mining all use SPSS. Academic courses that use SPSS include psychology, education, research methods, nursing, social research, engineering management, and, naturally, statistics. SPSS appears in a wide range of applications in the business world, too, such as, automotive, pharmaceutical, medical device, outsourcing, and project management. Data is generated from...

Take your SPSS knowledge to the next level. SPSS is one of the most popular and powerful statistical software packages. IBM SPSS Statistics is used in research, social sciences, arts and music, management, veterinary, medical, and many other academic disciplines. Using engaging and challenging data, this intermediate course teaches SPSS syntax programming, manipulation and combining of datasets, deep menu options, and statistical concepts. SPSS runs on Windows, Mac, and Linux operating systems. Course Highlights: Navigate the user’s manual, IBM SPSS Statistics Command Syntax Reference, for...

Data Science with R Data management and manipulation is an essential task for data scientists who deal with data on a day-to-day basis. In recent years, many R packages were developed to tackle a wide variety of data science challenges. The focus of this course is the tidyverse suite of packages, which contain a large variety of tools to efficiently manage complex and big data. The materials in this course are essential for developing robust and efficient R programs in the data science field. At the end of this course, students will be able to work independently to solve common data...

Learn to Create Regulatory Compliance Deliverables for Pharmaceutical Industry: SDTMs, ADaMs, Tables, Lists and Graphs Participants will gain comprehensive knowledge on common R packages (Tidyverse, DPLYR and Piping) and the R programming language. Attendees will learn how to access, create and process R data frames in data management, reporting and analysis. In addition, this course shows best practices in how to select, filter, derive, append and join data frames using SQL code. Ideal for the pharma industry, examples of both SDTM and ADaM datasets will be created, which are important in...