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

Homepage

https://www.udemy.com/course/sage-x3-microsoft-powerbi/