Sage X3-Microsoft Power Bi: Intelligent Reports & Dashboards

Learn how to create interactive dashboards and smart reports using Microsoft Power BI for Sage X3 within a week

What you'll learn

What is Microsoft Power BI

How to Download and Install for Free

How to Connect Different Data Sources to Power BI

How to Connect Sage X3 database With Power BI for Live Data Transfer

Create a Data Model & Transform Data

Create Intelligent Reports & Dashboards Using Power BI

Requirements

Microsoft Power BI Desktop (free download)

Basic knowledge about Sage X3

Understanding about the Data Model of Sage X3

Desire to Learn :)

Description

If you want to learn how to create interactive dashboards and reports for Sage X3 using a business intelligence tool, then you are in the right place. By using Microsoft Power BI you can create impressive data analysis reports, More interestingly Microsoft Power BI Desktop is completely free, you can download and play with it without any licensing.  Power BI is an interactive data visualization software product developed by Microsoft with a primary focus on business intelligence. Data may be input by reading directly from a database, webpage, or structured files such as spreadsheets, CSV, XML, and JSON.Concepts covered in this course are as follows:1. What is Microsoft Power BI2. How to download and install for free3. How to connect different data sources to Power BI4. How to connect Sage X3 database with power BI for live data transfer5. Create a data model & transform the data6. Create intelligent reports & Dashboards using Power BI1. What is Microsoft Power BI2. How to download and install for free3. How to connect different data sources to Power BI4. How to connect Sage X3 database with power BI for live data transfer5. Create a data model & transform the data6. Create intelligent reports & Dashboards using Power BIBy the end of this course, you will be able to create super cool reports and dashboards without any programming or SQL knowledge.

Overview

Section 1: Day 1 : Introduction & Installation

Lecture 1 Welcome to Day 1

Lecture 2 What is Microsoft Power BI?

Lecture 3 Downloading & Installing Power BI Desktop

Lecture 4 Walkthrough the User Interface

Lecture 5 Helpful Resources

Lecture 6 Understand Sage X3 Data Model

Section 2: Day 2 : Data sources & Connect Sage X3 database

Lecture 7 Welcome to Day 2

Lecture 8 Power BI data sources & Import data from Web

Lecture 9 Import data from Sage X3 using Excel/CSV

Lecture 10 Connect Sage X3 Database

Lecture 11 Configure SQL server to accept remote connections

Section 3: Day 3 : Data transformation

Lecture 12 Welcome to Day 3

Lecture 13 How to transform data ?

Lecture 14 Basic transformation in Power BI with Text, Number & Date and Time

Lecture 15 Create a data model & Table relationships

Lecture 16 Create first report using Matrix

Section 4: Day 4 : Introduction to DAX and create reports using DAX

Lecture 17 Welcome to Day 4

Lecture 18 Introduction of DAX

Lecture 19 Syntax and Functions

Lecture 20 Calculated Column

Lecture 21 What is DAX Measure

Lecture 22 Difference Between Calculated Column and Measure

Lecture 23 Understand Context

Section 5: Day 5 : Visualizing data with different objects

Lecture 24 Welcome to Day 5

Lecture 25 Insert Basic Chart & Visuals

Lecture 26 Filtering Data with Slicers

Lecture 27 Add Average Line to Graph

Lecture 28 Combine Tables (Merge Queries)

Lecture 29 How to Create Pie Chart & Donut Chart

Lecture 30 Card & KPI (Key Performance Indicators)

Section 6: Day 6 : Wrapping Up

Lecture 31 Learn More : Microsoft Power BI Quick Book

Lecture 32 Congratulations

Sage X3 Developers who want to learn a business intelligence tool,Sage X3 Consultants & End users,Students who want to learn data analytics