Analytics Redefined: Elevate Your Business Intelligence Game

Focused View

Arthur Fong

4:46:51

8 View

1 - Introduction

1 - Welcome Aboard.mp4

03:03

2 - Introduction.mp4

01:21

2 - Financial Reporting Data Load Editor

2 - Financial Reporting Data Load Editor.zip

3 - Understanding Requirements.mp4

03:29

4 - Folder Structure.mp4

02:11

5 - Loading Our First Raw Data.mp4

02:40

6 - Loading All Other Countries Data.mp4

07:09

7 - Loading Our Mapping Files.mp4

02:52

8 - Incremental Load.mp4

08:33

9 - Extracting Country from Incremental Key.mp4

03:30

10 - Matching Mapping File Headers with Left Join.mp4

07:06

11 - Matching Mapping File Headers with ApplyMap.mp4

06:47

12 - Creating Display Table in Excel Assets.mp4

06:07

13 - Creating Display Table in Excel Assets cont.mp4

04:05

14 - Creating Display Table in Excel Liabilities.mp4

03:24

15 - Creating Display Table in Excel Equity.mp4

02:32

16 - Creating Display Table in QlikView Scripts.mp4

01:44

17 - Creating the Display Table in QlikView ScriptsCont.mp4

06:19

18 - Creating the Display Table in QlikView ScriptsCont 2.mp4

06:53

19 - Concatenating tables into One.mp4

02:53

20 - Report Formatting.mp4

03:30

21 - Challenge 1.mp4

01:30

22 - Challenge 1 Solution.mp4

04:39

23 - Left Joining Display Table.mp4

05:56

24 - Link Key.mp4

03:41

25 - Master Calendar.mp4

08:10

3 - Financial Reporting Creating Our Visualizations

26 - 10.Visualization-1.zip

26 - Customizing Display Table.mp4

05:36

27 - Building Expression.mp4

02:45

28 - Expanding Dimensions.mp4

03:36

29 - Buttons MTDYTD.mp4

05:36

30 - Logics MTDYTD.mp4

02:18

31 - Report Table Formatting.mp4

04:33

32 - Challenge 2.mp4

01:20

4 - Financial Reporting Optimization

33 - 15.Optimization-Extending-the-report-2.zip

33 - Introduction to Optimization.mp4

05:37

34 - Autonumber.mp4

03:05

35 - Groupby.mp4

05:57

36 - Calendar.mp4

01:54

37 - Sort Script.mp4

03:16

38 - Sort Script Explained.mp4

04:11

39 - YTD Logic Script.mp4

07:45

40 - Expression Modification in Pivot Table.mp4

03:33

41 - Handling null values in load script.mp4

02:55

42 - Cleaning Up Our Final Pivot Table.mp4

05:52

43 - Month Across Report.mp4

03:40

5 - KPI Metrics Reporting KMR Load Script

44 - KMR Loading Data.mp4

04:28

45 - KMR Concatenate Tables.mp4

04:44

46 - KMR Crosstable.mp4

05:30

47 - KMR Adding Metrics Category Table.mp4

05:14

48 - KMR Left Join Metrics Category Table.mp4

04:30

49 - KMR Sort Order.mp4

04:00

50 - KMR Formula Table.mp4

02:53

51 - KMR Formula Table Cont.mp4

06:24

52 - Completing Display Table.mp4

05:25

53 - Adding formulas into Display Table.mp4

12:03

6 - KPI Metrics Reporting KMR Visualizations

54 - KMR Expressions.mp4

05:58

55 - KMR Metrics Sorting Bold.mp4

04:01

56 - KMR Metrics Formatting.mp4

05:01

57 - KMR Removing Synthetic Keys.mp4

07:24

58 - KMR Adding Target into same line as Revenue.mp4

09:55

59 - KMR Target Color.mp4

03:43

60 - KMR Line Chart.mp4

05:35

61 - KMR Trellis.mp4

05:21

7 - Conclusion

62 - Conclusion.mp4

01:09

Description

Charting your New Course in Mastering the Art of Business Intelligence

What You'll Learn?

Creating Financial Reporting from Scratch
Data Modelling in QlikView
Visualizations Format in QlikView
Optimizations in Data Model

Who is this for?

Beginner in BI

BI Developers

Data Specialist

Data Engineer

What You Need to Know?

Basic Knowledge on QlikView

More details

Description
In today's dynamic business landscape, the ability to design Key Performance Indicator (KPI) and financial metrics reporting is an invaluable skill. These reports serve as the compass guiding organizations toward their strategic goals. Understanding how to design them effectively not only fosters better decision-making but also facilitates the identification of critical insights that can fuel growth and efficiency.

Through our comprehensive course, conducted using QlikView as a learning platform, participants gain hands-on experience in crafting these essential reports. The knowledge acquired in this course is not limited to one tool; it's a transferrable skill that can be seamlessly applied to other Business Intelligence (BI) tools, ensuring professionals are well-equipped to excel in a variety of data-driven environments. Empower yourself with this expertise and embark on a journey of informed, data-backed decision-making that transcends the boundaries of technology platforms.

There are more and more companies or organizations that are emerging rapidly. Hence, a BI developer with little financial reporting knowledge is preferable and has a high chance of getting employed.
This course will provide details, starting from scratch till the end product.
Just spend 5 hours going through the course; this will save up a lot of time developing your project!

You will get to know more about QlikView load script editor, as we are going to perform all the heavy lifting in QlikView script editor.
Starting from how to Extract Data, Loading Data using Incremental Load, and also creating loops to iterate the Extract process.
Then begin transformation to match up the requirements for creating Financial Reporting.
And also to create a Master Calendar table for Periodic selections.

You will also learn how to create QlikView visualizations and expressions, including Set Analysis.
And also how to create buttons.Â Â
Lastly, we will go through the Financial report table created, and perform optimization to fine-tune the data model and report table we have created.
The content in this course can be applied in any other industry,Â not limited to creating Financial Reporting only.
We will be learning some of the fundamental transformation steps, up to the more advanced scripting techniques, including how to create periodic MTD and YTD tables at the script level.

Who this course is for:
Beginner in BI
BI Developers
Data Specialist
Data Engineer

User Reviews

Rating

average 0

Total votes0

Focused display

I have been in BI Industry for 7 years. In my past experience, I have being with a Qlik partner organization which helped me in gaining experience on developing some of the Qlik products, namely QlikView, Qlik Sense, and NPrinting. And I would like to share my knowledge as a developer with everyone here. Hopefully you will find my class informative for your learning.

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.