Saurabh Jain
-
Posts
1,726 -
Joined
-
Last visited
-
Days Won
61
Content Type
Profiles
Forums
Gallery
Downloads
Blogs
Events
Online Conference
The Excel dictionary
Power Query M function dictionary
Everything posted by Saurabh Jain
-
-
Tutorial 3 : Understanding Object Model : Properties and Methods
-
-
Before we start, please make sure the developer tab is active in your Excel If note please follow the steps Excel > Files > Options > Customize Ribbon Select Developer Tab Once Done , please reply - Yes Developer tab is active in my Excel
-
You can even apply addition, subtraction or division
-
Please comment if you want to be part of this course I am In Meanwhile : please do have a look on Excel tutorials https://bi-analytics.org/blogs/blog/6-excel-tutorials/
-
Free Advanced MS Excel course Download practice files
-
-
-
Download files from
-
The different types of Business Intelligence dashboards include: Strategic Dashboard Analytical Dashboards Operational Dashboards Tactical Dashboards How do you classify your dashboards ?
-
first click on join club.....once you are member you can download the same
-
In the era of self service BI Dashboards I seek your inputs .. How reports are transforming the decision making .....Please share how in your organizations the reporting pattern is transforming for better decision making ? Regards Saurabh
-
click on download button from the link https://bi-analytics.org/files/file/11-case-series-2-analyzing-sales-data-with-pivot-table/
-
Download practice file
-
-
-
Tutorial 7 : Mathematical operations commonly used in world of business analytics Download practice file
-
-
Tutorial 6 Applying Conditional Formatting : Free Advanced MS Excel course Download template
-
In this case, we will analyze sales data from two stores and answer the following questions What percentage of sales occur at each store ? What percentage of sales occur at each month ? How much revenue does each product generated? Which products generate 80 % of revenue? We will also learn the Use of Report Filters & Slicers Download data set
-
-
No you will not get any certificate.... but you can work on excel and build models after the course if just certificate is your requirement, this is not the place....
