Microsoft Power BI for Sage X3 : A Complete Guide

Focused View

Shereef Neikkan

2:27:59

220 View

1 - Day 1 Introduction Installation

1 - Welcome to Day 1.mp4

01:00

2 - What is Microsoft Power BI.mp4

03:15

3 - Downloading Installing Power BI Desktop.mp4

02:59

4 - Walkthrough the User Interface.mp4

12:24

5 - Helpful Resources.mp4

04:02

6 - Understand Sage X3 Data Model.mp4

02:22

2 - Day 2 Data sources Connect Sage X3 database

7 - Welcome to Day 2.mp4

01:02

8 - Power BI data sources Import data from Web.mp4

07:44

9 - Import data from Sage X3 using ExcelCSV.mp4

04:35

10 - Connect Sage X3 Database.mp4

03:32

11 - Configure SQL server to accept remote connections.mp4

05:31

3 - Day 3 Data transformation

12 - Welcome to Day 3.mp4

00:37

13 - How to transform data.mp4

03:58

14 - Basic transformation in Power BI with Text Number Date and Time.mp4

05:57

15 - Create a data model Table relationships.mp4

09:52

16 - Create first report using Matrix.mp4

08:41

4 - Day 4 Introduction to DAX and create reports using DAX

17 - Welcome to Day 4.mp4

00:23

18 - Introduction of DAX.mp4

03:02

19 - Syntax and Functions.mp4

05:34

20 - Calculated Column.mp4

05:14

21 - What is DAX Measure.mp4

08:40

22 - Difference Between Calculated Column and Measure.mp4

01:46

23 - Understand Context.mp4

04:22

5 - Day 5 Visualizing data with different objects

24 - Welcome to Day 5.mp4

00:39

25 - Insert Basic Chart Visuals.mp4

10:38

26 - Filtering Data with Slicers.mp4

03:06

27 - Add Average Line to Graph.mp4

03:23

28 - Combine Tables Merge Queries.mp4

09:34

29 - How to Create Pie Chart Donut Chart.mp4

04:11

30 - Card KPI Key Performance Indicators.mp4

06:52

6 - Day 6 Wrapping Up

31 - Learn More Microsoft Power BI Quick Book.mp4

02:12

31 - Microsoft-Power-BI.pdf

32 - Congratulations.mp4

00:52

Description

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

Who is this for?

Sage X3 Developers who want to learn a business intelligence tool

Sage X3 Consultants & End users

Students who want to learn data analytics

More details

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 BI
2. How to download and install for free
3. How to connect different data sources to Power BI
4. How to connect Sage X3 database with power BI for live data transfer
5. Create a data model & transform the data
6. Create intelligent reports & Dashboards using Power BI
1. What is Microsoft Power BI
2. How to download and install for free
3. How to connect different data sources to Power BI
4. How to connect Sage X3 database with power BI for live data transfer
5. Create a data model & transform the data
6. Create intelligent reports & Dashboards using Power BI

By the end of this course, you will be able to create super cool reports and dashboards without any programming or SQL knowledge.
Who this course is for:
Sage X3 Developers who want to learn a business intelligence tool
Sage X3 Consultants & End users
Students who want to learn data analytics

User Reviews

Rating

average 0

Total votes0

Focused display

My self Shereef Neikkan, I am having 10+ Years of total work experience in the ERP domain. Focused on IT solutions like complex business software such as ERP, CRM, HRMS etc.My primary job is to helps companies to harness the potential benefits of planning IT strategies to embrace the value of ERP and other business applications.I have been working with Sage X3 for the last 6 years and completed many projects. I have expertise in the techno-functional side of Sage X3 ERP. I will try to explain the concepts of ERP in a simple and easy manner.Specialities-Sage X3 ERP, Microsoft Dynamics Nav ERP, Adempiere ERP, Idempiere ERP, WooCommerce, Openbravo Point of Sale (POS), Drupal CMS, WordPress CMS, Postgres SQL, Jasper Reporting, Crystal Reporting, Simple Web view Android Application development using Android studio, Website hosting into the server, Application deployment into the play store, Simple application development using Flutter, Search Engine Optimization(SEO).

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.