Saurabh Jain

During Excel online session, 

Today I started with If statemnets and > = was needed to compare the condition 

However the candidate was having French keyboard, I could not find the solution ar that very instaant 

though I asked him to copy paste the sign 

How do french users use these logocal operators ?

19 hours ago, Rasha Gouda said:

Can we post challenges that reflect the real business scenarios, a lot are complicated out there! 

keep connected - we will have more to come .... lets focus on this one   ....Do give a try 

Write a Formula or vba code or power query to calculate sum of digits 

All answers posted will be hidden for three days 

The idea is to learn how to participate in forums 

Hello every one , 

I am from Jaipur India.

1  Msgbok cannot be inside with and End with 

2  With has to be placed like this - all operations on B4

With Range("B4")

                 .Value = Farenhiet

                .Font.Size = 11

                .Font.Color = "2367"
    

End With

MsgBox "Farenhiet is" & " " & Farenhiet

Yellow Stone National park implemented the system 

 https://www.yellowstonepark.com/news/yellowstone-flood-june-2022/attachment/ys-graphic-alps-explainer-v20220620/

Write an Excel formula in Column B which gives Odd or Even as n output  , given plate number in Column A

Bhavana from Australia messaged me about the challenge and I thought let start for our members as well

All answer will be hidden for couple of days 

License Plate Challenge.xlsx

The enthusiasm & excitement of

• getting the result with complex nested formulas 
• preparing an awesome dashboard 
• Innovating the new way of consolidation 
• completing the ad Hoc task in no time with just few clicks 

Do you have such  Excel moments , Share your Excel story with us 

Roles and responsibilities of community members

Members

Members interact with each other sharing information, insights & experiences, participating in discussions and raising issues and concern regarding common needs and requirement. Their primary role is to participate actively, to learn and share their learnings.

Facilitators

The facilitator is responsible for clarifying communications, drawing out the reticent, ensuring that dissenting point of view are heard and understood, posing questions to further discussion and keeping discussion on topic- all subjects to the will of the group

Practice Leaders

The Practice leader is acknowledge leader of the community. His or her role is based on competence not rank or position. Leadership in community can be shift as the issues and concern of the Community shifts. Practice leaders always emerge.

Lets contribute and grow as Self organized community

All your suggestions will be highly appreciated in making this website an asset for all the members

Special thanks From all of us at

www.Bi-Analytics.org

Regular Expression - SQL
===================

• ◼A Regular Expression(RegEx) is used to match patterns with various sequences of characters.
• ◼A RegEx can be a combination of different data types such as integer, special characters, Strings, images, etc.
• ◼These patterns are used in String searching algorithms in order to perform find or find and replace operations on Strings, or for validating the input.
• ◼RegEx are not case sensitive

🔷Syntax for using SQL Regex:
=======================
SELECT
<column_name>...
from <table_name>
WHERE <col_name***>
REGEXP 'my_pattern';

<col_name***> : column on which the regular expression needs to be applied
 

The Quiz has 20 questions  and 5 Other questions Like Name , Location , Gender , email feedback 

Starting this quiz again  : dec 6 2022 

Last date to participate : dec 11, 2022  

max participants 2000

To Participate, click on the following link 

https://kahoot.it/challenge/04569949

or Enter Game PIN: 04569949 on Kahoot app or www.Kahoot.it

Start the Quiz by entering proper real nick name 

Once played, please share your feedback and experience in the comment below.

Thanks & Regards

Saurabh Jain

Note :

• pl do not leave the quiz in between, try all the questions. this is sure to give you some learning
• Only 2000 candidates can participate,  play the quiz only when you have at least ten minutes with you.  

Starting with SQL? Top class Venn Diagram game to learn SQLs! What are the most common difficulties you face in SQL?
Great work by Andreas Martinson to put this amazing visual together. 

Posted by Adi Polak on linkedin

Cheat sheet.pdf

Have you been a part of design sprint process.

Share your story

The idea is to track the progress : Actual VS Target

What will be your approach. Create a such chart or even better..

Do share your chart and the process by commenting below in the post

The 4–4–5 calendar is a method of managing accounting periods, and is a common calendar structure for some industries such as retail and manufacturing.

The 4–4–5 calendar divides a year into four quarters of 13 weeks grouped into two 4-week "months" and one 5-week "month". The grouping of 13 weeks may also be set up as 5–4–4 weeks or 4–5–4.

Which Fiscal Calendar does your company follow and how do you setup in Excel/ Google sheet  ?

You can also include 

pl also share

• Your location
• Your industry 
• Pros and cons  or Why your company has chosen the said fiscal year.

The idea is to interact and learn the practices followed all across the globe.

90-day quit rate: Or the 360-day quit rate. This is the number of hires that leave within 3 months or a year. A double-digit percentage is already very bad. It’s HR’s job to recruit the right people. Failing to do so will have a negative measurable impact on organizational effectiveness. This is a key recruitment KPI.

Training effectiveness: Training has to be effective to reach its goal(s).

Involuntary turnover rate: Not all turnover is voluntary. This is the number of employer-led resignations as a percentage of the total resignations.

• Turnover rate: Turnover is a very common metric and also an important KPI, as high turnover can be very costly.
• Involuntary turnover rate: Not all turnover is voluntary. This is the number of employer-led resignations as a percentage of the total resignations.
• Voluntary turnover rate: This is the number of employee-led resignations as a percentage of the total resignations.
• Unwanted turnover rate: Not all turnover is bad. It’s usually positive when bad performers leave. This is the number of good performers leaving as a percentage of all performers.
   

Quality of hire: The quality of hire is the percentage of new hires that are given a good rating by their manager during their performance review. Quality of hire indicates how effective HR is in recruiting and selecting candidates. Consistently maintaining a high quality of hire rating enables the organization to reach its strategic goals.

Percentage of cost of the workforce: This is a metric that takes the cost of the workforce and divides it by the total cost faced by the organization. This KPI, although not often employed, could be used for cost reduction purposes or to help improve automation/robotization in an organization.