• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

310 Business Intelligence (BI) courses

🔥 Limited Time Offer 🔥

Get a 10% discount on your first order when you use this promo code at checkout: MAY24BAN3X

Microsoft Power BI Online

By Nexus Human

Duration 1 Days 6 CPD hours This course is intended for The student should be familiar with Excel and the concepts of datasets and basic reporting. Overview Understand and utilize Power BI Online. Understand and examine the differences between Power BI Desktop and Power BI Online. Understand and explore the Power BI Online interface. Understand and perform importing Excel worksheets, CSV, TXT, PBIX. Understand connecting to databases. Understand other forms of data. Understand data refresh. Understand and perform creating a new Power BI report. Understand and perform adding filters to a report. Understand and perform adding KPI's to a report. Understand and perform creating a Power BI dashboard. Understand and perform pinning tiles. Understand sharing reports and dashboards. Understand Power BI Mobile. This Logical Operations courseware is no longer available on the LO Store, but can be purchased by phone orderThis one-day course familiarizes the student with Power BI Online, which allows the student to intuitively discover and automate the import, transformation, and combination of data across a variety of data sources. COURSE OVERVIEW * Introduction * Course Materials * Facilities * Prerequisites * What We'll Be Discussing * INTRODUCTION TO POWER BI ONLINE * What is Power BI Online * Examining the Differences Between Power BI Desktop and Power BI Online * Exploring the Power BI Online Interface IMPORTING DATA * Utilizing Excel (.xlsx or .xlsm), Comma Separated Value (.csv), and Power BI Desktop (.pbix) Files * Connecting to Databases * Examining Other Forms of Data * Understanding Data Refresh * CREATING REPORTS * Creating a New Power BI Report * Adding Filters to a Power BI Report * Adding KPI?s to a Report * CONFIGURING DASHBOARDS * Creating a Power BI Dashboard * Pinning Tiles SHARING REPORTS AND DASHBOARDS * Sharing Reports and Dashboards * Exploring Power BI Mobile *

Microsoft Power BI Online
Delivered on-request, onlineDelivered Online
Price on Enquiry

Oracle BI 11g R1 - Build Repositories

By Nexus Human

Duration 5 Days 30 CPD hours This course is intended for Application DevelopersBusiness AnalystsBusiness Intelligence DeveloperData ModelersData Warehouse AdministratorData Warehouse AnalystReports DeveloperTechnical Consultant Overview Build and run analyses to test and validate a repositorySet up query logging for testing and debuggingSet up a multiuser development environmentUse the Administration Tool wizards and utilities to manage, maintain, and enhance repositoriesEnable usage tracking to track queries and database usage, and improve query performancePerform a patch merge in a development-to-production scenarioDescribe Exalytics machine and the Summary Advisor tool used in the machineBuild simple and calculated measures for a fact tableCreate logical dimension hierarchies and level-based measuresCheck the model and then model aggregate tables to speed query processingModel partitions and fragments to improve application performance and usabilityUse variables to streamline administrative tasks and modify metadata content dynamicallyUse time series functions to support historical time comparison analysesSet up security to authenticate users and assign appropriate permissions and privilegesBuild the Physical, Business Model and Mapping, and Presentation layers of a repositoryApply cache management techniques to maintain and enhance query performance This Oracle BI 11g R1: Build Repositories training is based on OBI EE release 11.1.1.7. Expert Oracle University instructors will teach you step-by-step procedures for building and verifying the three layers of an Oracle BI repository. This Oracle BI 11g R1: Build Repositories training is based on OBI EE release 11.1.1.7. Expert Oracle University instructors will teach you step-by-step procedures for building and verifying the three layers of an Oracle BI repository. ADDITIONAL COURSE DETAILS: Nexus Humans Oracle BI 11g R1 - Build Repositories 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 Oracle BI 11g R1 - Build Repositories 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 BI 11g R1 - Build Repositories
Delivered on-request, onlineDelivered Online
Price on Enquiry

Power BI - introduction to intermediate (2 days) (In-House)

By The In House Training Company

This course starts with the basics then moves seamlessly to an intermediate level. It includes a comprehensive yet balanced look at the four main components that make up Power BI Desktop: Report view, Data view, Model view, and the Power Query Editor. It also demonstrates how to use the online Power BI service. It looks at authoring tools that enables you to connect to and transform data from a variety of sources, allowing you to produce dynamic reports using a library of visualisations. Once you have those reports, the course looks at the seamless process of sharing those with your colleagues by publishing to the online Power BI service. The aim of this course is to provide a strong understanding of the Power BI analysis process, by working with real-world examples that will equip you with the necessary skills to start applying your knowledge straight away. 1 GETTING STARTED * The Power BI process * Launching Power BI Desktop * The four views of Power BI * Dashboard visuals 2 CONNECTING TO FILES * Connect to data sources * Connect to an Excel file * Connect to a CSV file * Connect to a database * Import vs. DirectQuery * Connect to a web source * Create a data table 3 TRANSFORMING DATA * The process of cleaning data * Column data types * Remove rows with filters * Add a custom column * Append data to a table * Fix error issues * Basic maths operations 4 BUILD A DATA MODEL * Table relationships * Manage table relationships 5 MERGE QUERIES * Table join kinds * Merging tables 6 CREATE REPORT VISUALISATIONS * Creating map visuals * Formatting maps * Creating chart visuals * Formatting chart * Tables, matrixes, and cards * Control formatting with themes * Filter reports with slicers * Reports for mobile devices * Custom online visuals * Export report data to Excel 7 THE POWER QUERY EDITOR * Fill data up and down * Split columns by delimiter * Add conditional columns * Merging columns 8 THE M FORMULA * Creating M functions * Create an IF function * Create a query group 9 PIVOT AND UNPIVOT TABLES * Pivot tables in the query editor * Pivot and append tables * Pivot but don't summarise * Unpivot tables * Append mismatched headers 10 DATA MODELLING REVISITED * Data model relationships * Mark a calendar as a date table 11 INTRODUCTION TO CALCULATED COLUMNS * New columns vs. measures * Creating a new column calculation * The SWITCH function 12 INTRODUCTION TO DAX MEASURES * Common measure categories * The SUM measure * Adding measures to visuals * COUNTROWS and DISINCTCOUNT functions * DAX rules 13 THE CALCULATE MEASURE * The syntax of CALCULATE * Things of note about CALCULATE 14 THE SUMX MEASURE * The SUMX measure * X iterator functions * Anatomy of SUMX 15 INTRODUCTION TO TIME INTELLIGENCE * Importance of a calendar table * A special lookup table * The TOTALYTD measure * Change year end in TOTALYTD 16 HIERARCHY, GROUPS AND FORMATTING * Create a hierarchy to drill data * Compare data in groups * Add conditional formatting 17 SHARE REPORTS ON THE WEB * Publish to the BI online service * Get quick insights * Upload reports from BI service * Exporting report data * What is Q&A? * Sharing your reports 18 APPLY YOUR LEARNING * Post training recap lesson

Power BI - introduction to intermediate (2 days) (In-House)
Delivered in-person, on-request, onlineDelivered Online & In-Person in Harpenden
Price on Enquiry

BCS International Diploma in Business Analysis - 12 Day Course, Live Training

5.0(12)

By Duco Digital Training

The 12 day live training course for BCS International Diploma in Business Analysis will help build your career as a business analyst, business architect, data analyst, enterprise analyst, management consultant...

BCS International Diploma in Business Analysis - 12 Day Course, Live Training
Delivered on-request, onlineDelivered Online
Price on Enquiry

BOE320 SAP BI Platform - Admin Servers (Win)

By Nexus Human

Duration 3 Days 18 CPD hours This course is intended for The primary audience for this course are System Administrators and System Architects. Overview Explain the architecture in SAP BusinessObjects Business Intelligence platformConfigure SAP BusinessObjects Business Intelligence platformPerform common server management and administrative tasks in SAP BusinessObjects Business Intelligence platform In this course, students learn how to explain the architecture in the SAP BusinessObjects Business Intelligence platform and perform common server management and administrative tasks in the SAP BusinessObjects Business Intelligence platform. SAP BUSINESSOBJECTS BUSINESS INTELLIGENCE PLATFORM * Describing the SAP BusinessObjects Business Intelligence Platform * Describing the SAP BusinessObjects Business Intelligence Platform Architecture INSTALLATION OF SAP BUSINESSOBJECTS BUSINESS INTELLIGENCE PLATFORM * Installing SAP BusinessObjects Business Intelligence Platform: Server-Side Installation * Installing SAP BusinessObjects Business Intelligence Platform: Client-Side Installation SERVER ADMINISTRATION AND MANAGEMENT * Using the Central Management Console (CMC) * Using the Central Configuration Manager (CCM) WEB APPLICATION SERVERS MANAGEMENT * Configuring Web Application Servers CENTRAL MANAGEMENT SERVER (CMS) DATABASE * Managing the Central Management Server (CMS) and System Database * Configuring Auditing FILE REPOSITORY SERVER MANAGEMENT * Managing the File Repository Server * Using the Repository Diagnostic Tool ADAPTIVE SERVERS * Managing the Adaptive Job Server * Managing the Adaptive Processing Server CRYSTAL REPORTS SERVERS * Demonstrating Information Flows in Crystal Reports * Configuring Crystal Reports * Managing Crystal Reports Servers WEB INTELLIGENCE SERVER * Managing Web Intelligence Document Schedules * Viewing Web Intelligence Documents * Configuring a Web Intelligence Processing Server * Configuring a Connection Server DASHBOARD SERVERS * Configuring Dashboard Servers * Managing Dashboard Design Servers EXPLORER SERVERS * Configuring Explorer Servers * Managing Information Spaces EVENT SERVERS * Configuring Event Servers * Managing Event Servers SAP BUSINESSOBJECTS BUSINESS INTELLIGENCE PLATFORM 4.1 MONITORING * Monitoring the SAP BusinessObjects Business Intelligence Platform 4.1 * Using the SAP BusinessObjects Business Intelligence Platform 4.1 Monitoring Dashboard ADDITIONAL COURSE DETAILS: Nexus Humans BOE320 SAP BI Platform - Admin Servers (Win) 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 BOE320 SAP BI Platform - Admin Servers (Win) 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.

BOE320 SAP BI Platform - Admin Servers (Win)
Delivered on-request, onlineDelivered Online
Price on Enquiry

MB-700T00 Microsoft Dynamics 365: Finance and Operations Apps Solution Architect

By Nexus Human

Duration 4 Days 24 CPD hours This course is intended for The audience for this course should have previous experience with functional or technical focus in Dynamics 365: Finance and Operations Applications. Primarily for those who are aspired to be and new to solution architect role Overview After completing this course, students will be able to: Understand the tasks expected to be completed by the solution architect for Dynamics implementation Complete the solution blueprint artifacts Know where to find technical information to address their customer's questions This course is developed for those aspired to be and new to the solution architect role. This course provides the technical information focusing on application architecture and technical skills to start their journey into this role. This course will not cover the industrial skills and delivery skills required for this role. THE ARCHITECT ROLE * The solution architect role MANAGE INTERACTIONS WITH FASTTRACK * Get to know FastTrack * Make the most of FastTrack templates SOLUTION BLUEPRINT * Solution blueprint definition and components * Project governance and timeline * Solution architecture and organizational structure * Working with business process catalog DEFINE ENVIRONMENTS, TOOLS, AND DEPLOYMENT STRATEGY * Understand environment planning * Application lifecycle management and deployment strategy * Using LCS and Azure DevOps DETERMINE DATA MANAGEMENT STRATEGY * Data management overview * Develop data migration strategy DETERMINE INTEGRATION AND INTERFACES STRATEGIES * Develop integration strategy * Integration options DEFINE SECURITY ARCHITECTURE * Important security aspects * Security framework * Define security strategy DEFINE TESTING STRATEGY * Testing strategy overview * Testing planning and execution DEFINE PERFORMANCE TESTING STRATEGY * Prepare for performance topics * Utilize performance testing tools BUSINESS INTELLIGENCE AND REPORTING * Implement business intelligence and reporting DETERMINE LICENSING AND SUPPORT * Understand licensing estimation * Understand support options PREPARE FOR GO-LIVE * Complete solution blueprint * Prepare for go-live * Class recap ADDITIONAL COURSE DETAILS: Nexus Humans MB-700T00 Microsoft Dynamics 365: Finance and Operations Apps Solution Architect 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 MB-700T00 Microsoft Dynamics 365: Finance and Operations Apps Solution Architect 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.

MB-700T00 Microsoft Dynamics 365: Finance and Operations Apps Solution Architect
Delivered on-request, onlineDelivered Online
Price on Enquiry

Cloudera Data Analyst Training - Using Pig, Hive, and Impala with Hadoop

By Nexus Human

Duration 4 Days 24 CPD hours This course is intended for This course is designed for data analysts, business intelligence specialists, developers, system architects, and database administrators. Overview Skills gained in this training include:The features that Pig, Hive, and Impala offer for data acquisition, storage, and analysisThe fundamentals of Apache Hadoop and data ETL (extract, transform, load), ingestion, and processing with HadoopHow Pig, Hive, and Impala improve productivity for typical analysis tasksJoining diverse datasets to gain valuable business insightPerforming real-time, complex queries on datasets Cloudera University?s four-day data analyst training course focusing on Apache Pig and Hive and Cloudera Impala will teach you to apply traditional data analytics and business intelligence skills to big data. HADOOP FUNDAMENTALS * The Motivation for Hadoop * Hadoop Overview * Data Storage: HDFS * Distributed Data Processing: YARN, MapReduce, and Spark * Data Processing and Analysis: Pig, Hive, and Impala * Data Integration: Sqoop * Other Hadoop Data Tools * Exercise Scenarios Explanation INTRODUCTION TO PIG * What Is Pig? * Pig?s Features * Pig Use Cases * Interacting with Pig BASIC DATA ANALYSIS WITH PIG * Pig Latin Syntax * Loading Data * Simple Data Types * Field Definitions * Data Output * Viewing the Schema * Filtering and Sorting Data * Commonly-Used Functions PROCESSING COMPLEX DATA WITH PIG * Storage Formats * Complex/Nested Data Types * Grouping * Built-In Functions for Complex Data * Iterating Grouped Data MULTI-DATASET OPERATIONS WITH PIG * Techniques for Combining Data Sets * Joining Data Sets in Pig * Set Operations * Splitting Data Sets PIG TROUBLESHOOT & OPTIMIZATION * Troubleshooting Pig * Logging * Using Hadoop?s Web UI * Data Sampling and Debugging * Performance Overview * Understanding the Execution Plan * Tips for Improving the Performance of Your Pig Jobs INTRODUCTION TO HIVE & IMPALA * What Is Hive? * What Is Impala? * Schema and Data Storage * Comparing Hive to Traditional Databases * Hive Use Cases QUERYING WITH HIVE & IMPALA * Databases and Tables * Basic Hive and Impala Query Language Syntax * Data Types * Differences Between Hive and Impala Query Syntax * Using Hue to Execute Queries * Using the Impala Shell DATA MANAGEMENT * Data Storage * Creating Databases and Tables * Loading Data * Altering Databases and Tables * Simplifying Queries with Views * Storing Query Results DATA STORAGE & PERFORMANCE * Partitioning Tables * Choosing a File Format * Managing Metadata * Controlling Access to Data RELATIONAL DATA ANALYSIS WITH HIVE & IMPALA * Joining Datasets * Common Built-In Functions * Aggregation and Windowing WORKING WITH IMPALA * How Impala Executes Queries * Extending Impala with User-Defined Functions * Improving Impala Performance ANALYZING TEXT AND COMPLEX DATA WITH HIVE * Complex Values in Hive * Using Regular Expressions in Hive * Sentiment Analysis and N-Grams * Conclusion HIVE OPTIMIZATION * Understanding Query Performance * Controlling Job Execution Plan * Bucketing * Indexing Data EXTENDING HIVE * SerDes * Data Transformation with Custom Scripts * User-Defined Functions * Parameterized Queries CHOOSING THE BEST TOOL FOR THE JOB * Comparing MapReduce, Pig, Hive, Impala, and Relational Databases * Which to Choose?

Cloudera Data Analyst Training - Using Pig, Hive, and Impala with Hadoop
Delivered on-request, onlineDelivered Online
Price on Enquiry

From Data to Insights with Google Cloud Platform

By Nexus Human

Duration 3 Days 18 CPD hours This course is intended for Data Analysts, Business Analysts, Business Intelligence professionals Cloud Data Engineers who will be partnering with Data Analysts to build scalable data solutions on Google Cloud Platform Overview This course teaches students the following skills: Derive insights from data using the analysis and visualization tools on Google Cloud Platform Interactively query datasets using Google BigQuery Load, clean, and transform data at scale Visualize data using Google Data Studio and other third-party platforms Distinguish between exploratory and explanatory analytics and when to use each approach Explore new datasets and uncover hidden insights quickly and effectively Optimizing data models and queries for price and performance Want to know how to query and process petabytes of data in seconds? Curious about data analysis that scales automatically as your data grows? Welcome to the Data Insights course! This four-course accelerated online specialization teaches course participants how to derive insights through data analysis and visualization using the Google Cloud Platform. The courses feature interactive scenarios and hands-on labs where participants explore, mine, load, visualize, and extract insights from diverse Google BigQuery datasets. The courses also cover data loading, querying, schema modeling, optimizing performance, query pricing, and data visualization. This specialization is intended for the following participants: Data Analysts, Business Analysts, Business Intelligence professionals Cloud Data Engineers who will be partnering with Data Analysts to build scalable data solutions on Google Cloud Platform To get the most out of this specialization, we recommend participants have some proficiency with ANSI SQL. INTRODUCTION TO DATA ON THE GOOGLE CLOUD PLATFORM * Highlight Analytics Challenges Faced by Data Analysts * Compare Big Data On-Premises vs on the Cloud * Learn from Real-World Use Cases of Companies Transformed through Analytics on the Cloud * Navigate Google Cloud Platform Project Basics * Lab: Getting started with Google Cloud Platform BIG DATA TOOLS OVERVIEW * Walkthrough Data Analyst Tasks, Challenges, and Introduce Google Cloud Platform Data Tools * Demo: Analyze 10 Billion Records with Google BigQuery * Explore 9 Fundamental Google BigQuery Features * Compare GCP Tools for Analysts, Data Scientists, and Data Engineers * Lab: Exploring Datasets with Google BigQuery EXPLORING YOUR DATA WITH SQL * Compare Common Data Exploration Techniques * Learn How to Code High Quality Standard SQL * Explore Google BigQuery Public Datasets * Visualization Preview: Google Data Studio * Lab: Troubleshoot Common SQL Errors GOOGLE BIGQUERY PRICING * Walkthrough of a BigQuery Job * Calculate BigQuery Pricing: Storage, Querying, and Streaming Costs * Optimize Queries for Cost * Lab: Calculate Google BigQuery Pricing CLEANING AND TRANSFORMING YOUR DATA * Examine the 5 Principles of Dataset Integrity * Characterize Dataset Shape and Skew * Clean and Transform Data using SQL * Clean and Transform Data using a new UI: Introducing Cloud Dataprep * Lab: Explore and Shape Data with Cloud Dataprep STORING AND EXPORTING DATA * Compare Permanent vs Temporary Tables * Save and Export Query Results * Performance Preview: Query Cache * Lab: Creating new Permanent Tables INGESTING NEW DATASETS INTO GOOGLE BIGQUERY * Query from External Data Sources * Avoid Data Ingesting Pitfalls * Ingest New Data into Permanent Tables * Discuss Streaming Inserts * Lab: Ingesting and Querying New Datasets DATA VISUALIZATION * Overview of Data Visualization Principles * Exploratory vs Explanatory Analysis Approaches * Demo: Google Data Studio UI * Connect Google Data Studio to Google BigQuery * Lab: Exploring a Dataset in Google Data Studio JOINING AND MERGING DATASETS * Merge Historical Data Tables with UNION * Introduce Table Wildcards for Easy Merges * Review Data Schemas: Linking Data Across Multiple Tables * Walkthrough JOIN Examples and Pitfalls * Lab: Join and Union Data from Multiple Tables ADVANCED FUNCTIONS AND CLAUSES * Review SQL Case Statements * Introduce Analytical Window Functions * Safeguard Data with One-Way Field Encryption * Discuss Effective Sub-query and CTE design * Compare SQL and Javascript UDFs * Lab: Deriving Insights with Advanced SQL Functions SCHEMA DESIGN AND NESTED DATA STRUCTURES * Compare Google BigQuery vs Traditional RDBMS Data Architecture * Normalization vs Denormalization: Performance Tradeoffs * Schema Review: The Good, The Bad, and The Ugly * Arrays and Nested Data in Google BigQuery * Lab: Querying Nested and Repeated Data MORE VISUALIZATION WITH GOOGLE DATA STUDIO * Create Case Statements and Calculated Fields * Avoid Performance Pitfalls with Cache considerations * Share Dashboards and Discuss Data Access considerations OPTIMIZING FOR PERFORMANCE * Avoid Google BigQuery Performance Pitfalls * Prevent Hotspots in your Data * Diagnose Performance Issues with the Query Explanation map * Lab: Optimizing and Troubleshooting Query Performance ADVANCED INSIGHTS * Introducing Cloud Datalab * Cloud Datalab Notebooks and Cells * Benefits of Cloud Datalab DATA ACCESS * Compare IAM and BigQuery Dataset Roles * Avoid Access Pitfalls * Review Members, Roles, Organizations, Account Administration, and Service Accounts

From Data to Insights with Google Cloud Platform
Delivered on-request, onlineDelivered Online
Price on Enquiry

Effective Data Visualisation

By Nexus Human

Duration 2 Days 12 CPD hours This course is intended for This course is aimed at anyone currently working with data who is interested in using data visualisation to more effectively communicate their results. Overview At completion, delegates will understand how data visualisations can be best used to communicate actionable insights from data and be competent with the tools required to do it. Visualising data, and analytics results, is one of the most effective ways to achieve this. This course will cover the theory of data visualisation along with practical skills for creating compelling visualisations from data. COURSE OUTLINE * The use of analytics, statistics and data science in business has grown massively in recent years. Harnessing the power of data is opening actionable insights in diverse industries from banking to horse breeding. The companies doing this most successfully understand that using sophisticated analytics approaches to unlock insights from data is only half the job. Communicating these insights to all of the different parts of an organisation is just as important as doing the actual analysis. Visualising data, and analytics results, is one of the most effective ways to achieve this. This course will cover the theory of data visualisation along with practical skills for creating compelling visualisations from data. To attend this course delegates should be competent in the use of data analysis tools such as reporting tools, spreadsheet software or business intelligence tools. The course will explore the following topics through a series of interactive workshop sessions: * Fundamentals of data visualisation * Data characteristics & dimensions * Mapping visual encodings to data dimensions * Colour theory * Graphical perception & communication * Interaction design * Visualisation different characteristics of data: trends, comparisons, correlations, maps, networks, hierarchies, text * Designing effective dashboards

Effective Data Visualisation
Delivered on-request, onlineDelivered Online
Price on Enquiry

M20778 Analyzing Data with Power BI

By Nexus Human

Duration 3 Days 18 CPD hours This course is intended for The course will likely be attended by SQL Server report creators who are interested in alternative methods of presenting data. Overview After completing this course, students will be able to: ? 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. ? Describe how to collaborate with Power BI data. ? Connect directly to data stores. ? Describe the Power BI developer API. ? Describe the Power BI mobile app. The main purpose of the course is to give students a good understanding of data analysis with Power BI. The course includes creating visualizations, the Power BI Service, and the Power BI Mobile App. INTRODUCTION TO SELF-SERVICE BI SOLUTIONS * Introduction to business intelligence * Introduction to data analysis * Introduction to data visualization * Overview of self-service BI * Considerations for self-service BI * Microsoft tools for self-service BI * Lab : Exploring an Enterprise BI solution INTRODUCING POWER BI * Power BI * The Power BI service * Lab : Creating a Power BI dashboard POWER BI * Using Excel as a data source for Power BI * The Power BI data model * Using databases as a data source for Power BI * The Power BI service * Lab : Importing data into Power BI SHAPING AND COMBINING DATA * Power BI desktop queries * Shaping data * Combining data * Lab : Shaping and combining data MODELLING DATA * Relationships * DAX queries * Calculations and measures * Lab : Modelling Data INTERACTIVE DATA VISUALIZATIONS * Creating Power BI reports * Managing a Power BI solution * Lab : Creating a Power BI report DIRECT CONNECTIVITY * Cloud data * Connecting to analysis services * Lab : Direct Connectivity DEVELOPER API * The developer API * Custom visuals * Lab : Using the developer API POWER BI MOBILE APP * The Power BI mobile app * Using the Power BI mobile app * Power BI embedded *

M20778 Analyzing Data with Power BI
Delivered on-request, onlineDelivered Online
Price on Enquiry